Home > Database > Mysql Tutorial > [MySQL 03] Jar packages, driver class names and URL formats corresponding to various databases

[MySQL 03] Jar packages, driver class names and URL formats corresponding to various databases

黄舟
Release: 2017-02-04 11:43:56
Original
1586 people have browsed it

1. Jar packages corresponding to various databases

Database type Corresponding Jar files
Oracle 8i classes12.zip or ojdbc14.jar
Sybase jconn2.jar or jconn3.jar
Mysql mysql-connector-java-3.1.1-alpha-bin.jar or mysql-connector-java-5.0.2-beta-bin.jar
SQLServer 2000 msbase.jar, msutil.jar, mssqlserver.jar
SQLServer 2005 sqljdbc.jar
SQLServer 7.0 jtds-1.2.2.jar
Informix ifxjdbc.jar
DB2 db2jcc.jar, db2jcc_license_cu.jar

2. Driver class names and URL formats corresponding to various databases

##DB2 com.ibm.db2.jcc.DB2Driverjdbc:db2://hostip:50000/dbnameInformixcom.informix.jdbc .IfxDriverjdbc:informix-sqli://hostip:port/dbname:informixserver=
Database Drive class name URL format
Oracle oracle.jdbc.driver.OracleDriver jdbc:oracle:thin:@hostip:1521:dbname
Sybase com.sybase.jdbc2.jdbc.SybDriver jdbc:sybase:Tds:hostip:4100/dbname
Mysql com.mysql.jdbc.Driver jdbc:mysql://hostip:3306/dbname?useUnicode=true&characterEncoding=GB
SQLServer 2000 com.microsoft.jdbc.sqlserver.SQLServerDriver jdbc:microsoft:sqlserver://hostip:1433;Databas
SQLServer 2005 com.microsoft.sqlserver.jdbc.SQLServerDriver jdbc:sqlserver://hostip:1433;DatabaseName=d
SQLServer 7.0 net.sourceforge.jtds.jdbc.Driver jdbc:jtds:sqlserver://hostip:1433/dbname
The above is [MySQL 03] various The contents of the jar package, driver class name and URL format corresponding to the database. For more related content, please pay attention to the PHP Chinese website (www.php.cn)!


source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template