常见JDBC驱动加载

18 Jul 2016

Reading time ~1 minute

常见JDBC驱动加载

MySQL

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url="jdbc:mysql://localhost:3306/DatabaseName?useUnicode=true&characterEncoding=GBK"
jdbc.username=
jdbc.password=

PostgreSQL

jdbc.driverClassName=org.postgresql.Driver
jdbc.url="jdbc:postgresql://localhost:5432/DatabaseName"
jdbc.username=
jdbc.password=

Oracle

jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
jdbc.url="jdbc:oracle:thin:@192.168.1.250:1521:DatabaseName"
jdbc.username=
jdbc.password=

DB2

jdbc.driverClassName=com.ibm.db2.jdbc.app.DB2Driver
jdbc.url="jdbc:db2://localhost:5000/DatabaseName"
jdbc.username=
jdbc.password=

HSQLDB

jdbc.driverClassName=org.hsqldb.jdbcDriver
jdbc.url="jdbc:hsqldb:hsql://localhost:9001/DatabaseName"
jdbc.username=
jdbc.password=

MS SQL Server 2000 (JTDS)

jdbc.driverClassName=net.sourceforge.jtds.jdbc.Driver
jdbc.url="jdbc:jtds:sqlserver://localhost:1433/DatabaseName"
jdbc.username=
jdbc.password=

MS SQL Server 2000 (Microsoft)

jdbc.driverClassName=com.microsoft.jdbc.sqlserver.SQLServerDriver
jdbc.url="jdbc:sqlserver://192.168.1.130:1433;database=ahos;user=sa;password=ahtec"
jdbc.username=sa
jdbc.password=sa

ODBC

jdbc.driverClassName=sun.jdbc.odbc.JdbcOdbcDriver
jdbc.url="jdbc:odbc:DatabaseName"
jdbc.username=
jdbc.password=