Common database JDBC URL format

Reprinted blog: http://blog.csdn.net/ring0hx/article/details/6152528

Microsoft SQL Servermicrosoft SQL Server JDBC Driver (typically used to connect to Server 2000)

Driver package Name:Msbase.jar Mssqlserver.jar Msutil.jar
Driver class Name: com.microsoft.jdbc.sqlserver.SQLServerDriver
JDBC URL: jdbc:microsoft:sqlserver://<server_name>:<port>
Default port 1433, port can be omitted if the server uses the default port

Microsoft SQL Server 2005 JDBC Driver

Driver package Name:Sqljdbc.jar
Driver class Name: com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBC URL: jdbc:sqlserver://<server_name>:<port>
Default port 1433, port can be omitted if the server uses the default port

Oracleoracle Thin JDBC Driver

Driver package Name:Ojdbc14.jar
Driver class Name: Oracle.jdbc.driver.OracleDriver
JDBC URL:
Jdbc:oracle:thin:@//Or
Jdbc:oracle:thin:@

IBM db2ibm DB2 Universal Driver Type 4

Driver package Name:Db2jcc.jar Db2jcc_license_cu.jar
Driver class Name: com.ibm.db2.jcc.DB2Driver
JDBC URL: jdbc:db2://

IBM DB2 Universal Driver Type 2

Driver package Name:Db2jcc.jar Db2jcc_license_cu.jar
Driver class Name: com.ibm.db2.jcc.DB2Driver
JDBC URL: jdbc:db2:<database_name>

Mysqlmysql connector/j Driver

Driver package Name: Mysql-connector-java-x.x.xx-bin.jar
Driver class Name: com.mysql.jdbc.Driver
JDBC URL: jdbc:mysql://Default Port 3306, port can be omitted if the server uses the default port
MySQL connector/j Driver allows additional connection properties to be added to the URL jdbc:mysql://

Informixinformix JDBC Driver

Driver package Name:Ifxjdbc.jar
Driver class Name: com.informix.jdbc.IfxDriver
JDBC URL: jdbc:informix-sqli://{<ip-address>|

Sybasesybase Adaptive Server Enterprise JDBC Driver

Driver package Name:Jconn2.jar or Jconn3.jar
Driver class Name: com.sybase.jdbc2.jdbc.SybDriver (Com.sybase.jdbc3.jdbc.SybDriver)
JDBC URL: jdbc:sybase:tds:

Sybase Adaptive Server Anywhere or Sybase IQ JDBC Driver

Driver package Name:Jconn2.jar or Jconn3.jar
Driver class Name: com.sybase.jdbc2.jdbc.SybDriver (Com.sybase.jdbc3.jdbc.SybDriver)
JDBC URL: jdbc:sybase:tds:Default Port 2638

Postgresqlpostgresql Native JDBC Driver

Driver Package Name: Driver class Name: org.postgresql.Driver
JDBC URL: jdbc:postgresql://Default Port 5432

Teradatateradata Driver for the JDBC Interface

Driver package Name:Terajdbc4.jar Tdgssjava.jar Gui.jar
Driver class Name: com.ncr.teradata.TeraDriver
JDBC URL:
Type 4:jdbc:teradata://databaseservername/param1,param2,...
Type 3:jdbc:teradata://gatewayservername:portnumber
/databaseservername/param1,param2,...

Netezzanetezza JDBC Driver

Driver package Name:Terajdbc4.jar Tdgssjava.jar Gui.jar
Driver class Name: org.netezza.Driver
JDBC URL: jdbc:netezza://

Common database JDBC URL format