cancel
Showing results for 
Search instead for 
Did you mean: 

How to select the appropriate JDBC driver

Former Member
0 Kudos

Hi All,

We are using SAP MII 12.1 SP04 and SQL 2005. I have deployed two differend JDBC drivers. Now when i want to define a data server, how to i specify which JDBC driver i want to use to connect to the DB.

Thanks for your help!

Prabhjot

Accepted Solutions (1)

Accepted Solutions (1)

jcgood25
Active Contributor
0 Kudos

The data server settings must match the desired driver class path and appropriate connection string, but if you have 2 jdbc drivers with the same java class structure it is randomly used by the server (no way to swap back and forth). If you have a need for two, then uploading one into MII as a native jdbc data server and the other one uploaded into NW as a data source (and corresponding MII data source connection) will give you control.

Former Member
0 Kudos

Thanks for the information Jeremy!

Regards,

Prabhjot

Answers (0)