multiple table name in JDBC adapter

[Former Member]

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.

[Former Member]

Hi,

Thanks for your help, now the problem solved.

Thanks,

Venkat

[Former Member]

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

[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.

[Former Member]

Hi,

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

Regards,

Prakasu

[Former Member]

Hi prakeshu,

I did't get you, could you pls explain me where i need to create duplicate the Statement structure,

i have create the structure like this pls suggest me am i doing wrong here?

dt_jdbc_req

STATMENT

TABLENAME

ACTION -

---

Attribute

TABLE -

---

Need to give the multiple tables

ACCESS -

---

here i am passing the SQLstatment

KEY

Thanks,

Venkat.

[Former Member]

Hi,

you should pass the table names in

STATMENT

TABLENAME

ACTION -

---

Attribute

TABLE--Table Names

For Request structure refer the help link..

[http://help.sap.com/saphelp_nw70/helpdata/EN/2e/96fd3f2d14e869e10000000a155106/content.htm]

Regards,

Prakasu

[Former Member]

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

[Former Member]

HI,

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

Thanks,

Tuhin