JDBC

[Former Member]

HI all

for JDBC adapter from where can we find JDBC driver and connection ?

Regards,

Komik Shah

[Former Member · Accepted solution]

Hi

Which DB are you using??

The exact specification varies according to the JDBC driver

Similarly for the Connection url also you need to specify the address with which you can establish a database connection using the JDBC driver.Again the exact format of the address can vary

Driver name is the Java class that is provided by the Vendor.

Connection is the connection URL that will connect to the target database.

Examples:

I used MaxDB, so

JDBC Driver Class: com.sap.dbtech.jdbc.DriverSapDB

Connection url : jdbc:sapdb://DBServer/DBName

Similarly for MSAccess

JDBC Driver Class: jdbc.odbc.JdbcOdbcDriver

Connection url : jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=//xiserver/xitemp/db/TestDB.mdb

Thanks

[former_member184619]

hi komik,

JDBC driver for the database are product-specific and must be obtained from the database vendor.

check sap note - 831162

/people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

/people/siva.maranani/blog/2005/09/16/xi-how-to-on-jdbc-receiver-response

/people/alessandro.berta/blog/2005/10/04/save-time-with-generalized-jdbc-datatypes

Sachin

[Former Member]

JDBC driver are Vendor specific.

Example: If XI want to communicate with Oracle, then Oracle base drivers need to be load into J2EE engine.

Thanks

Farooq.