Common jdbc url connection database formats and drivers

Source: Internet
Author: User
Tags db2 ibm db2 informix microsoft sql server microsoft sql server 2005 postgresql sybase

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: //

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.