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