cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC Driver

Former Member
0 Kudos

Dear experts,

my JAva application is using MYSQL database.when I am using the JDBC adapter can u send me which jdbc driver i need to go for?and JDBC sender/receiver Adapter configuration.

Thanks in advance.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

chk out these thread

and

If u are using an ORACLE database then put in the following values:

JDBC Driver: oracle.jdbc.driver.OracleDriver

Connection: jdbc:oracle:thin:@<server IP>:<port>:<DataSource name>

you can find jdbc drivers on this page:

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/winsoft.html

You can install as many JDBC drivers as you want as long as they have different classpaths. The issue is that the different versions of drivers from Oracle usually have the same classpath so you typicaly can't install more than 1 of them on the same J2EE Adapter Engine.

When trying to find a driver for Oracle check the following:

What versions of Oracle does the driver support.

http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm#02_02

What JDK version does the driver support.

http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm#02_03

If your XI instance is on JDK 1.3, use the Oracle 9.0.1 driver since it supports Oracle 7.3.4 - 10.1.0 and JDK 1.3.

If your XI instance is on JDK 1.4 you have a few options:

Try the Oracle driver (9.0.1) that support both Oracle 7 and 8 but doesn't support JDK 1.4. It may work fine.

Use an Oracle driver for the Oracle 7 version and a 3rd party driver for the Oracle 8 or vise versa. They will have different classpaths so you'll be fine. You can search for 3rd party Oracle (type 4) JDBC drivers at the following URL:

http://developers.sun.com/product/jdbc/drivers

I'd recommend i-net software (JVM 1.4 and Oracle 8.0.X - 10.X) or DataDirect (JVM 1.4 and Oracle 8.1.6 - 10.X).

http://www.inetsoftware.de/products/jdbc/

http://www.datadirect.com/products/jdbc/index.ssp

If you have 2 J2EE Adapter Engines, install one Oracle driver on one, and the other on the other. Specify which Adapter Engine to use in the communication channel. They have the same classpath but they'll be running on different JVMs so it's ok.

hope this help

Regards,

Surya

Yoiu can also refer this link

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/bdd6a690-0201-0010-238a-9c95a5fb...

Edited by: rama suryanarayana on Aug 8, 2008 11:42 AM

Answers (5)

Answers (5)

JaganMohan
Participant
0 Kudos

Dear Farrok,

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/jdbcTOJDBC&

/message/5467013#5467013 [original link is broken]

The above links solve your problem.

Regards,

Jagan.

Former Member
0 Kudos

u need to download MYSQL Driver available in Internet and then deploy the same in XI Server using SDM Tool.

check with ur basis for deploying the same

Former Member
0 Kudos

Hi,

For MySQL

Drivers is ::com.mysql.jdbc.Driver

Connection is ::jdbc:mysql://IP Address:3306/Database name

Regards

Seshagiri

Former Member
0 Kudos

Hi

Use MySQL Connector/J JDBC drivers

Use following jdbc parameters

JDBC URL --- jdbc:mysql://host_name:port/dbname

JDBC driver - com.mysql.jdbc.Driver

Refer following urls

http://www.stardeveloper.com/articles/display.html?article=2003090201&page=4

http://www.stardeveloper.com/articles/display.html?article=2003090401&page=1

Regards,

Vandana.