Skip to Content
avatar image
Former Member

Problem with receiver jdbc CC

Hi,

Iam doing RFC to JDBC scenario..

The receiver JDBC adapte which i configured is giving me an error saying that "Unable to execute statement for table or stored procedure. 'HR_Employee' (Structure 'Statement') due to com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ')'."

Please help me to make out as what does this error mean and how to overcome it.

The message protocol i used is he XML SQL String and i have specified "NULL Value" in the field "interpretation of empty string values".

Helpful answers will definitely be rewarded.

Regards

Madhu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Jul 02, 2008 at 05:28 AM

    Check if you have defined your structure properly, I guess there is some problem with the query that is generatred.

    Doucment formaty of the message - which is input to JDBC Receiver adapter may be incorrect.

    Check out this-

    http://help.sap.com/saphelp_erp2005vp/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

    Also check that, JDBC driver is installed correctly- for this

    https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-9644e49f1a10

    Check out these links

    http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

    http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

    Check if you have created and populated the target structure correctly.

    regards

    kummari

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 02, 2008 at 05:29 AM

    HI Madhu,

    Your syntax for Update /Insert statement or to call stored procedure is not appropriate.

    In the case of synchronous queries, results from database queries or return values of stored procedures can also be transferred.

    Refer below format of payload in mapping

    http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

    Thanks

    Swarup

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 02, 2008 at 05:37 AM

    hi madhulatha

    check this note

    831162 - for frequently occuring problems with JDBC adapter

    regards

    kummari

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      hi madhulata....

      Statement is missing in ur receiver structure thats y its givin error.

      ur receiver should be like this.

      <?xml version="1.0" encoding="UTF-8" ?>

      <ns1:MT_HR_Employee xmlns:ns1="urn:csc-com:india:saphr:to:bwdfile">

      <Statement>

      <tablename action="INSERT">

      <table>HR_Employee</table>

      </tablename>

      <access>

      <CompanyCode />

      <EffectiveDate />

      <ActionType />

      <EmployeeID />

      <RegionalID />

      <BusinessArea />

      <CostCenter />

      <Source />

      <LastName />

      <FirstName />

      <MiddleName />

      <EmployeeGroup />

      <EmployeeSubGroup />

      <Position />

      <PositionTitle />

      <VendorID />

      <AlternateID />

      <ShortName />

      <GUID />

      <EmploymentStatus />

      <LaborCategory />

      <PersonnelArea />

      <PersonnelSubArea />

      <OrganizatioalUnit />

      <OrgUnitManager_1 />

      <OrgUnitManager_2 />

      <OrgUnitManager_3 />

      <JobCode />

      <GlobalTitleCode />

      <JobTitle />

      <PayscaleGroup />

      <HIreDate />

      <TerminationDate />

      <ServiceDate />

      <FileDate />

      <DateOfBirth />

      <Gender />

      <PreviousExp />

      </access>

      </Statement>

      </ns1:MT_HR_Employee>

      Insert Statement node in ur structure.

      Sreedhar Goud L

  • avatar image
    Former Member
    Jul 02, 2008 at 07:02 AM

    Hi Madhulatha,

    The structure for the rcvr JDBC adapter should always be in this fashion

    DT_TRG

    Statement for the select/SQL statement

    TableName(Node)

    Action (Attribute)

    Table (name of the table)

    Access

    DB Field1 Col names to be selected from table

    Check this blog by Bhavesh

    JDBC Receiver Adapter -- Synchronous Select – Step by Step

    Hope this helps u out 😊

    Edited by: Mohd Tauseef Ibrahim on Jul 2, 2008 9:02 AM

    Edited by: Mohd Tauseef Ibrahim on Jul 2, 2008 9:03 AM

    Edited by: Mohd Tauseef Ibrahim on Jul 2, 2008 9:05 AM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 01, 2008 at 10:30 AM

    Hi Madhulatha,

    R u able to solve this error? If yes can you please share the solution. I am getting similalr kind of error.

    Error processing request in sax parser: Error when executing statement for table/stored proc. 'UWCT' (structure 'statement3'): com.microsoft.sqlserver.jdbc.SQLServerException: Line 1: Incorrect syntax near ','.

    In my case, I am updating data in 3 tables. But only for 3rd Table I am getting this error.

    And Strange part is with different Interface with same structure I am able to insert the data in UWCT table.

    Dear All,

    Can you please suggest?

    -Gouri

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      yes the error got resolved...

      in receiver JDBC adpater i have mentioned the values as below:

      Persistence : Database

      DB Table Name : XIException

      Key Column Name: XIExceptionCol1

      Value Column Name : XIExceptionCol2

      Regards

      Madhu