Syntax for JDBC Driver and Connection

[Former Member]

Hi All,

I would like to know the exact syntax for JDBC Driver and Connection for configuring JDBC Sender Adapter.

Reagrds

Pavan

[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

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 Member · Accepted solution]

Refer this blog to get more Idea how to connect with MSAccess...

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

Thanks

farooq.

[Former Member]

Hi

Driver name are nothing but the Java class that is provided by the Vendor.

Connection: is the connection URL that will connect with the target database.

Suppose u want to connect it with Oracle then this will be the parameters:

Driver : oracle.jdbc.driver.OracleDriver

Connection : jdbc:oracle:thin:@hostname:1526:orcl

Also the driver need to be deply in the XI server need to communicate with the target database...(drivers are vendor specific and provided by vendor itself)

If u want to connect it with any other BD then search on Google

databasename + JDBC u will get the lot of things

Thanks

Farooq.

[nisarkhan_n]

what's your Databsase?

for SQLserver 2000

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

Connection: jdbc:microsoft:sqlserver://10.94.22.99:1433;DatabaseName=COS

Check this URL for details on JDBC drivers support list -

[Former Member]

Did you check these:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/9aedca11-0d01-0010-3b90-9ea...

http://help.sap.com/saphelp_nw2004s/helpdata/en/1d/756b3c0d592c7fe10000000a11405a/frameset.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/b0/676b3c255b1475e10000000a114084/frameset.htm