常用数据库驱动及链接字符串
整理了一下，做了记录MySql
JdbcDriver = com.mysql.jdbc.Driver
JdbcUrl = jdbc:mysql://localhost:3306/TEST
MSSQL Server[使用Microsoft驱动]
JdbcDriver = com.microsoft.jdbc.sqlserver.SQLServerDriver
JdbcUrl=jdbc:microsoft:sqlserver://localhost:1433;databasename=TEST;SelectMethod=cursor
MSSQL Server[使用jtds驱动]
JdbcDriver = net.sourceforge.jtds.jdbc.Driver
JdbcUrl = jdbc:jtds:sqlserver://localhost:1433/TEST
Oracle
JdbcDriver = oracle.jdbc.driver.OracleDriver
JdbcUrl = jdbc:oracle:thin:@localhost:1521:TEST
DB2
JdbcDriver = com.ibm.db2.jcc.DB2Driver
JdbcUrl = jdbc:db2://localhost:50000/TEST
Sybase
JdbcDriver = com.sybase.jdbc2.jdbc.SybDriver
JdbcUrl = jdbc:sybase:Tds:localhost:4488/TEST
postgres
JdbcDriver = org.postgresql.Driver
JdbcUrl = jdbc:postgresql://localhost:5432/jmdatacenter
HSql
JdbcDriver = org.hsqldb.jdbcDriver
JdbcUrl = jdbc:hsqldb:hsql://localhost:9092
页:
[1]