Common jdbc url connection database formats and drivers

MySQL
MySQL 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: // The default port is 3306. If the server uses the default port, the port can be omitted.
MySQL Connector/J Driver allows you to add additional connection attributes to the URL: jdbc: mysql: //

PostgreSQL
PostgreSQL Native JDBC Driver
Driver Package name: Driver class name: org. postgresql. Driver
Jdbc url: jdbc: postgresql: // Default Port 5432

Microsoft SQL Server
Microsoft SQL Server JDBC Driver (used to connect to SQLServer 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>
The default port is 1433. If the server uses the default port, the port can be omitted.

Microsoft SQL Server 2005 JDBC Driver (used to connect to SQLServer 2005 or a later version)
Driver Package name: sqljdbc. jar
Driver class name: com. microsoft. sqlserver. jdbc. SQLServerDriver
Jdbc url: jdbc: sqlserver: // <server_name >:< port>
The default port is 1433. If the server uses the default port, the port can be omitted.

Oracle
Oracle Thin JDBC Driver
Driver Package name: ojdbc14.jar
Driver class name: oracle. jdbc. driver. OracleDriver
Jdbc url:
Jdbc: oracle: thin: @ // Or
Jdbc: oracle: thin :@< host >:< port >:< SID>

IBM DB2
IBM 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>

Informix
Informix JDBC Driver
Driver Package name: ifxjdbc. jar
Driver class name: com. informix. jdbc. IfxDriver
Jdbc url: jdbc: informix-sqli: // {<ip-address >|< host-name >}: <port-number> [/<dbname>]: INFORMIXSERVER = <server-name>

Sybase
Sybase 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

Teradata
Teradata 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 ,...

Netezza
Netezza JDBC Driver
Driver Package name: terajdbc4.jar tdgssjava. jar gui. jar
Driver class name: org. netezza. Driver
Jdbc url: jdbc: netezza: //