Common database drivers, driver classes and URLs

Oracle Database :

Driver package Name: Ojdbc14.jar

name of the driver class: Oracle.jdbc.driver.OracleDriver

JDBC URL : Jdbc:oracle:thin: @dbip:p ort:databasename

Description: The driver package name may change

JDBC URL the meanings of each part are as follows:

Dbip – for the database server IP address, if it is locally writable: localhost or 127.0.0.1 .

Port – for the database listening port, you need to look at the installation of the configuration, the default is 1521 .

DatabaseName – for the database SID , usually the name of the global database.

SQL Server Database

Driver package name:msbase.jar Mssqlserver.jar Msutil.jar

name of the driver class: Com.microsoft.jdbc.sqlserver.SQLServerDriver

JDBC URL : Jdbc:microsoft:sqlserver://dbip:port;databasename=databasename

Description: The driver package name may change

JDBC URL the meanings of each part are as follows:

Dbip – for the database server IP address, if it is locally writable: localhost or 127.0.0.1 .

Port – for the database listening port, you need to look at the installation of the configuration, the default is 1433 .

DatabaseName – The name of the database.

MySQL Database

Driver package Name: Mysql-connector-java-3.1.11-bin.jar

name of the driver class: Com.mysql.jdbc.Driver

JDBC URL : Jdbc:mysql://dbip:port/databasename

Description: The driver package name may change

JDBC URL The meanings of each part are as follows:

Dbip – for the database server IP address, if it is locally writable: localhost or 127.0.0.1 .

Port – for the database listening port, you need to look at the installation of the configuration, the default is 3306 .

DatabaseName – The name of the database.

Common database drivers, driver classes and URLs