[JAVA]JDBC Driver整理

jTDS Driver


Microsoft SQL Server (6.5, 7, 2000, 2005, 2008 and 2012) and Sybase Adaptive Server Enterprise (10, 11, 12 and 15)

Drive Class: net.sourceforge.jtds.jdbc.Driver

Drive Location: http://jtds.sourceforge.net/

JDBC Url Format: jdbc:jtds:sqlserver://<host>:<port>/<database_name>

MsSQL Server預設port為1433

Examples:

jdbc:jtds:sqlserver://blog.yslifes.com:1433/test

jdbc:jtds:sqlserver://127.0.0.1:1433/test

 

Microsoft SQL Server 2005 JDBC Driver


語法是Microsoft SQL Server 2005使用的,不過Driver好像是在一起的(未測)

Drive Class: com.microsoft.sqlserver.jdbc.SQLServerDriver

Drive Location: http://www.microsoft.com/zh-TW/download/details.aspx?id=11774

JDBC Url Format: jdbc:sqlserver://<server_name>:<port>

MsSQL Server預設port為1433

Examples:

jdbc:sqlserver://blog.yslifes.com:1433

jdbc:sqlserver://127.0.0.1:1433

 

 

Microsoft SQL Server JDBC Driver


 

Drive Class: com.microsoft.jdbc.sqlserver.SQLServerDriver

Drive Location: http://www.microsoft.com/zh-TW/download/details.aspx?id=11774

JDBC Url Format: jdbc:microsoft:sqlserver://<server_name>:<port>

MsSQL Server預設port為1433

Examples:

jdbc:microsoft:sqlserver://blog.yslifes.com:1433

jdbc:microsoft:sqlserver://127.0.0.1:1433

 

 

My SQL


可用於MariaDB跟My SQL Server

詳細參數說明

http://dev.mysql.com/doc/connector-j/en/connector-j-reference-configuration-properties.html

Drive Class: com.mysql.jdbc.Driver

Drive Location: http://www.mysql.com/products/connector/

JDBC Url Format: jdbc:mysql://<host><:port>/<database>

My Server預設port為3306

Examples:

jdbc:mysql://blog.yslifes.com:3306/test

jdbc:mysql://127.0.0.1:3306/test

 

發表迴響