on 08-08-2008 10:31 AM
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.
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
Edited by: rama suryanarayana on Aug 8, 2008 11:42 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
For MySQL
Drivers is ::com.mysql.jdbc.Driver
Connection is ::jdbc:mysql://IP Address:3306/Database name
Regards
Seshagiri
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
chech this links
JDBC Driver for Oracle
http://help.sap.com/saphelp_nw04/helpdata/en/80/4f34c587f05048adee640f4c346417/frameset.htm----Deplo... and Removing JDBC Drivers
http://help.sap.com/saphelp_nw04s/helpdata/en/43/313c13198d0d26e10000000a1553f7/frameset.htm---JDBC Driver
http://developers.sun.com/product/jdbc/drivers
regards
srinivas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.