JDBC connection string

[Former Member]

I have to connect SQL Server 2008 R2 database from PO 7.4 system. I know regarding updation of jdbc adapter by driver files of database.

I have already downloaded sqljdbc4.jar file.

I would like to know is there any format in which connection string needs to be formed? Also, in ID while configuring the jdbc receiver adapter to send data to SQL Server 2008 R2 database from PO, what should be specified in Database connection in JDBC Driver and Connection?

Pls tell. thx.

[Former Member · Accepted solution]

The connection string goes something like:

jdbc:JSQLConnect://[sql server hostname]:1433;databaseName=[database name]

You might also like to add parameter on the Advanced Tab / Advanced Mode to log the SQL statement:

logSQLStatement | true

Check the JDBC FAQ 831162 for more info.

[Former Member · Accepted solution]

My scenario is proxy sync to PI to JDBC sync

On Database, stored procedure is called with 3 input and 1 output parameter.

I defined request JDBC msg structure for stored procedure

How to define the response JDBC data type for getting back the stored procedure response from database in PI?

Any ideas, plz. Thx.

[Former Member · Accepted solution]

Your response message structure can be like:

MT_[your naming convention]_response

     row          (unbounded)

          [stored proc recordset field 1]

          [stored proc recordset field 2]

          etc..

Have you tried already, what part are you stuck, or what error message do you see?

Here is a thread which may help you...

http://scn.sap.com/thread/3348826

[former_member184619]

Hi Stewart,

It goes like this:

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

Connection:

jdbc:sqlserver://<IP of SQL Server>;user=<username of SQL Server>;password=<Password>;databaseName=<Database Name>

SAP note used to test FTPJDBC connection - 1085539

How to test JDBC scenario in SAP PI

Regards,

Sachin Dhingra