JDBC SCENARIO

[Former Member]

Hi

I am about to try JDBC Scenario where data will be

picked from mssql server and posted to R/3.

I have installed jdbc drivers for the same.

Now i have to specify jdbc driver & connection

information

where can I look for this info.

Besides my sql server is here in delhi and my XI is mumbai.

Is it even possible ?

Regards,

deepak

Sharma

[Former Member · Accepted solution]

Hi,

Ur scenario is jdbc to r/3.

The sender adapter should have the message format:

<resultset>

<row>

<column-name1>column-value</ column-name1>

<column-name2>column-value</ column-name2>

<column-name3>column-value</ column-name3>

</row>

</resultset>

driver for SQL is:

com.microsoft.jdbc.sqlserver.SQLServerDriver

connection is:

jdbc:microsoft:sqlserver://<dbservername>:1433;DatabaseName=<tablename>

regards

priyanka

[Former Member · Accepted solution]

Hi,

Priyanka thank you fror your quick reply.

I am a little bit confused about as to

what should my interface look like in jdbc sender side.

I mean where should my select statement

in adapter...

should it like this

jdbcsender

statementname

test

action

TABLE

access

EmployeeID

Lastname

Firstname

Regards,

deepak

[Former Member · Accepted solution]

Hi Deepak,

When doing a JDBC sender scenario, the select statement is written in the configuration of sender JDBC Adapter.

thanks & Regards,

Varun Joshi

[Former Member · Accepted solution]

Hi Deepak,

For the JDBC sender system , you have to create an outbound message interface and you need to create the message type for some datatype and datatype structure should be look like as follows:

<resultset>

<row>

<column-name1>column-value</ column-name1>

<column-name2>column-value</ column-name2>

<column-name3>column-value</ column-name3>

</row>

</resultset>

But you need to be careful while creating the datatype that , copy and paste the column names from the database table for the safty purpose because in XI these element names are case sensitive. e.g. if some database table column name is "City" in your db then you should use "City" and if it is "CITY" then you should use "CITY".

You need to take care of some more things that do not forget to specify the values for the mandatory parameters of the processing parameters of the sender jdbc adapter.

Hope this will help you. You are most welcome for further query.

Regards

Gopesh

[Former Member · Accepted solution]

Hi Gopesh,

I have a scenario where i have to select multiple rows with some columns in it and i have to post it in the R/3.how can i go about the mappings?

Thanks and Regards,

Jishi

[Former Member · Accepted solution]

hi jishi,

you can change ur occurances of row to 1..unbounded.

priyanka

[Former Member · Accepted solution]

Hi,

Bur while doindg the Message mappings,do i have to do any additional mappings so that the receiver structure understands that there are multiple rows?

Thanks and Regards,

Jishi

[Former Member · Accepted solution]

The receiver structure should have have occurance 1..unbounded.nothing else needed.

regards

priyanka

[former_member187339]

Hi deepak,

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

Connection = jdbc:microsoft:sqlserver://<sqlserver>:1433;DatabaseName=<dbname>

<i>>>Is it even possible ?</i>

Yes..

Regards

Suraj