Common Database drivers and JDBC + URL

Microsoft SQL ServerMicrosoft SQL Server JDBC Driver (usually used to connect to SQLServer 2000)

1. Driver package name: msbase. jar mssqlserver. jar msutil. jar
2. Driver Class Name: com. microsoft. jdbc. sqlserver. SQLServerDriver
3. Jdbc url: jdbc: microsoft: sqlserver:// <Server_name >:< port>
4. Default port1433If the server uses the default port, the port can be omitted.

Microsoft SQL Server 2005 JDBC Driver

1. Driver package name: sqljdbc. jar
2. Driver Class Name: com. microsoft. sqlserver. jdbc. SQLServerDriver
3. Jdbc url: jdbc: sqlserver ://<Server_name>:<Port>
4. The default port is 1433. If the server uses the default port, the port can be omitted.

OracleOracle Thin JDBC Driver

1. Driver package name: ojdbc14.jar
2. Driver Class Name: oracle. jdbc. driver. OracleDriver
3. Jdbc url:
4. Jdbc: oracle: thin :@//<Host>:<Port>/ServiceName
5. Or
6. Jdbc: oracle: thin :@<Host>:<Port>:<SID>

IBM DB2IBM DB2 Universal Driver Type 4

1. Driver package name: db2jcc. jar db2jcc_license_cu.jar
2. Driver Class Name: com. ibm. db2.jcc. DB2Driver
3. Jdbc url: jdbc: db2:// <Host> [: <port>]/<database_name>

IBM DB2 Universal Driver Type 2

1. Driver package name: db2jcc. jar db2jcc_license_cu.jar
2. Driver Class Name: com. ibm. db2.jcc. DB2Driver
3. Jdbc url: jdbc: db2 ://<Host>[:<Port>]/<Database_name>

MySQLMySQL Connector/J Driver

1. Driver package name: mysql-connector-java-x.x.xx-bin.jar
2. Driver Class Name: com. mysql. jdbc. Driver
3. Jdbc url: jdbc: mysql:// <Host>: <port>/<database_name>
4. Default port3306If the server uses the default port, the port can be omitted.
5. MySQL Connector/J Driver allows you to add additional connection attributes to the URL: jdbc: mysql:// <Host>: <port>/<database_name>? Property1 = value1 & property2 = value2

InformixInformix JDBC Driver

1. Driver package name: ifxjdbc. jar
2. Driver Class Name: com. informix. jdbc. IfxDriver
3. Jdbc url: jdbc: informix-sqli:// {<Ip-address >|< host-name >}: <port-number> [/<dbname>]: INFORMIXSERVER = <server-name>

SybaseSybase Adaptive Server Enterprise JDBC Driver

1. Driver package name: jconn2.jar or jconn3.jar
2. Driver Class Name: com. sybase. jdbc2.jdbc. SybDriver (com. sybase. jdbc3.jdbc. SybDriver)
3. Jdbc url: jdbc: sybase: Tds: 5000

Sybase Adaptive Server Anywhere or Sybase iq jdbc Driver

1. Driver package name: jconn2.jar or jconn3.jar
2. Driver Class Name: com. sybase. jdbc2.jdbc. SybDriver (com. sybase. jdbc3.jdbc. SybDriver)
3. Jdbc url: jdbc: sybase: Tds:
4. Default port2638

PostgreSQLPostgreSQL Native JDBC Driver

1. Driver package name: Driver Class Name: org. postgresql. Driver
2. Jdbc url: jdbc: postgresql:// <Host>: <port>/<database_name>
3. Default port5432

TeradataTeradata Driver for the JDBC Interface

1. Driver package name: terajdbc4.jar tdgssjava. jar gui. jar
2. Driver Class Name: com. ncr. teradata. TeraDriver
3. Jdbc url:
4. Type4: Jdbc: teradata:// DatabaseServerName/Param1, Param2 ,...
5. Type3: Jdbc: teradata:// GatewayServerName: PortNumber
6. /DatabaseServerName/Param1, Param2 ,...

NetezzaNetezza JDBC Driver

1. Driver package name: terajdbc4.jar tdgssjava. jar gui. jar
2. Driver Class Name: org. netezza. Driver
3. Jdbc url: jdbc: netezza:// <Host>: <port>/<database_name>