Thursday, September 07, 2006

JDBC Driver names and connect url

MS SQL Server 2003 and earlier

com.microsoft.jdbc.sqlserver.SQLServerDriver
jdbc:microsoft:sqlserver://192.168.0.131


MS SQL Server 2005

com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc:sqlserver://192.168.0.131


Oracle

oracle.jdbc.driver.OracleDriver
jdbc:oracle:thin:@localhost:1521:testdb


MySQL

com.mysql.jdbc.Driver
jdbc:mysql://192.168.0.151/testdb


DB2 net

COM.ibm.db2.jdbc.net.DB2Driver
jdbc:db2://192.168.0.152/mrcdb

For version 8 and 9
com.ibm.db2.jcc.DB2Driver
jdbc:db2://192.168.0.120/mrctest


AS400 Remote

com.ibm.as400.access.AS400JDBCDriver
jdbc:as400://192.168.0.170;libraries=MYLIB;translate binary=true;naming=system


AS400 Local

com.ibm.db2.jdbc.app.DB2Driver
jdbc:db2://*LOCAL;translate binary=true;naming=system

0 Comments:

Post a Comment

<< Home