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