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

multiple table name in JDBC adapter

Hi All,

I am doing FiletoJDBC synchronous mode. in my JDBC resquest how can i pass multiple table names.bcaz i am selecting values from different tables with nested big where calues. i am passing the sql queary through Action, not sure how multiple tables we can assing. In mapting i have passed only one table while i check in SXMB_MONI i am getting mapping exception error.

Pls suggest on this.

Thanks,

Venkat.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 23, 2009 at 01:19 PM

    HI,

    Just create multiple statment(each statement for one table action) below root node of JDBC receiver datatype.

    Thanks,

    Tuhin

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 23, 2009 at 01:25 PM

    Hi ,

    Thanks for your help.

    I have 5 tables so i need to create the Table 5 times and assign table names?

    Example :

    <table>Table 1</table>

    <table>Table 2</table>

    <table>Table 3</table>

    <table>Table 4</table>

    <table>Table 4</table> like this pls suggest me.

    Thanks,

    Venkat

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 23, 2009 at 01:26 PM

    Hi,

    Just right click and duplicate the Statement structure.For each you can give the different table names.

    Regards,

    Prakasu

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 23, 2009 at 01:53 PM

    Hi,

    Thanks for your reply,

    i have gone through this link with this link help i have create like this

    STATMENT

    TABLENAME

    ACTION -


    Attribute

    TABLE--Table Names

    but i am bit confuse where i need to pass the multiple table names.

    you meen create duplicate Statement structure

    Table 1:

    STATMENT

    TABLENAME

    ACTION -


    Attribute

    TABLE--Table Names

    Table 2:

    STATMENT

    TABLENAME

    ACTION -


    Attribute

    TABLE--Table Names

    Table 3:

    STATMENT

    TABLENAME

    ACTION -


    Attribute

    TABLE--Table Names

    Table 4:

    STATMENT

    TABLENAME

    ACTION -


    Attribute

    TABLE--Table Names

    Table 5:

    STATMENT

    TABLENAME

    ACTION -


    Attribute

    TABLE--Table Names

    like this for every ACTION and ACCESS we need to pass the same SQL qurary. Pls suggest me.

    Thanks,

    Venkat

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi All,

      I am still getting Mapping Error can you pls help me reslove this. i am using like this in JDBC request

      This is how i am passing SQL qurey in action

      <MT_Base_JDBC_REQ>

      <STATEMENT>

      <TABLENAME anyName action=u201DSQL_QUERYu201D>

      <ACCESS> here is my SQL Qurary</ACCESS> </anyName></TABLENAME></STATMENT></MT_Base_JDBC_REQ>

      This is i am passing the table name: i have multiple tables so i have create the duplicate Statement structure

      in mappting and i am giving sql statment for every structure and after i am passing the table name

      <STATEMENT>

      <TABLENAME action=u201DSQL_QUERYu201D>

      <table>Table 1</table>

      <access></access>

      </TABLENAME></STATMENT>

      <STATEMENT>

      <TABLENAME action=u201DSQL_QUERYu201D>

      <table>Table 2</table>

      <access></access>

      </TABLENAME></STATMENT>

      like this i have mapped while i have treid to execute the scenario i am getting error in Mapping

      a com.sap.aii.utilxi.misc.api.BaseRuntimeException was thrown: RuntimeException in Message-Mapping transformatio

      Can any one help me to reslove this problem.

      Thanks,

      Venkat.

  • author's profile photo Former Member
    Former Member
    Posted on Mar 18, 2009 at 07:51 AM

    Hi,

    Thanks for your help, now the problem solved.

    Thanks,

    Venkat

    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.