Where to specify table name in JDBC receiver communication channel

[Former Member]

Hi

I am usig java client proxy scenario:

JSP<->XI<->Database.

In my JDBC receiver communication channel->

where to specify table name that stores the data that i send in my JSP page. Actually JSP page sends username and password and role is resturned as response. where this info is stored in my database. How to create table in database and how and where to specify the same table name in receiver JDBC communication channel:

These are the params that am giving in my receiver JDBC communication channel:

Adapter Type:JDBC --Receiver

Transport protocol: JDBC2.0

Message Protocol: XML SQL FOrmat

Adapter Engine: Integration Server

JDBC Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection: jdbc:microsoft:sqlserver://sapep:1433;DatabaseName=SAPXI(how to specifiy table-----is it here?)

User name:xx

Password: xx

[Former Member · Accepted solution]

<b>How to create table in database and how and where to specify the same table name in receiver JDBC communication channel:</b>

How to create tables is a database dependent thing and you should refer the db documentation of sql server in your case.

The name of the table is specified in the XML message that goes as an input to the JDBC reciever channel.i.e. the destination message type which follows a typical structure. Search sdn for more on this.