"Experience sharing" common JDBC driver names and URLs list

ODBC Driver

Sun.jdbc.odbc.JdbcOdbcDriver

Jdbc:odbc:name

Connecting to the DB2 database with COM.ibm.db2.jdbc.net.DB2Driver

An example of a DB2 URL:

Jdbc:db2://aserver.mycompany.com:50002/name

Connecting to the Sybase database with Com.sybase.jdbc.SybDriver

An example of a Sybase URL:

jdbc:sybase:tds:aserver.mycompany.com:2025

MySQL Driver

Com.mysql.jdbc.Driver

Jdbc:mysql://hostname:3306/dbname?useunicode=true&characterencoding=gbk

Microsoft SQL Server Driver

Com.microsoft.jdbc.sqlserver.SQLServerDriver

Jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=wapsvc; User=sa; Password=pwd

Informix

Com.informix.jdbc.IfxDriver

Jdbc:informix-sqli://hostname:1526/dbname:informixserver=informixservername;user=username;password=password

Oracle

Oracle.jdbc.driver.OracleDriver

Jdbc:oracle:thin: @hostname:1521:<sid>

Postgresql

Org.postgresql.Driver

Jdbc:postgresql://localhost/soft

Apache Derby/java DB

Org.apache.derby.jdbc.ClientDriver

Jdbc:derby://localhost:1527/databasename;create=true

Access is connected through ODBC. Excel can also. You can even construct a connection string dynamically:

This allows you to connect directly to an Access database file.

Jdbc:odbc:driver={microsoft Access DRIVER (*.mdb)};D Bq=c:\mydata.mdb

Similar Excel files can be used in similar ways:

Jdbc:odbc:driver={microsoft Excel Driver (*.xls)};D Bq=.\mydata.xls

This article is from "Programming with the Old Wangxue" blog, please be sure to keep this source http://imentors.blog.51cto.com/10946447/1735434

"Experience sharing" common JDBC driver names and URLs list