Skip to Content
author's profile photo Former Member
Former Member

urgent help needed in jdbc

Hi Experts,

I am getting the following error while trying to send a request from HTTP test client to my database, inspite of giving the defining the select query perfectly,

Please help me out in this regard, it is a urgent requirement.

<SAP:Error><SAP:Category>XIAdapterFramework</SAP:Category><SAP:Code>MESSAGE.GENERAL</SAP:Code><SAP:AdditionalText>com.sap.aii.af.ra.ms.api.DeliveryException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'tdsp_esiid' (structure 'STATEMENT'): java.sql.SQLException: ORA-00923: FROM keyword not found where expected

</SAP:AdditionalText></SAP:Error>

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 03:28 PM

    basically im' trying to select following fields for which i have written the following query in my jdbc adapter,

    SELECT tdsp,esiid,address,city,state,zipcode,status FROM tdsp_esiid WHERE tdsp ='CPL_ENERGY'

    i get the message mapping structure,

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

    http://reliant.com/xi/BMFSync">

    <STATEMENT><tdsp_esiid ACTION="&quot;SELECT&quot;"><TABLE>&apos;tdsp_esiid&apos;

    </TABLE>

    <ACCESS>

    <tdsp></tdsp>

    <address></address>

    <city></city>

    <state></state>

    <zipcode></zipcode>

    <status></status>

    <esiid></esiid>

    <KEY><tdsp compareOperation="=">CPL_ENERGY</tdsp></KEY></ACCESS>

    </tdsp_esiid>

    </STATEMENT></ns0:mt_tdsp_jdbc_select_jdbc_req>

    Is there any wrong with structure definition?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 04, 2007 at 02:35 PM

    Hi Pravin,

    Can you please check your Stored procedure 'tdsp_esiid' for some insert, select, delete or update? Somewhere you havn't provided the FROM keyword...

    Please check it out. its missing.

    regards

    Aashish Sinha

    PS : reward points if helpful

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 04, 2007 at 02:53 PM

    It seems that the XML mapping is not complete. As you know, the message have a define structure that you must implement for JDBC messages.

    Is posible that the structure is wrong respect this structure.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 03:37 PM

    Hi VJ,

    Im executing the same query in the database and it is working fine.

    Can you please elaborate on the term 'Attribute', based on that i need to fetch the values.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.