在Spring Boot Application中连接到Azure MS SQLSERVER

Question

我正在尝试连接到 azure ms sqlserver 数据库。我已经在 application.properties 文件中设置了这些属性，但我收到异常，连接超时。

spring.datasource.url=jdbc:jtds:sqlserver://xxxserver.database.windows.net:port;DatabaseName=xxxdb;user=xxxadmin@xxxserver;password=passwd;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;
spring.datasource.username=xxxadmin@xxxserver
spring.datasource.password=passwd
spring.datasource.driver-class-name=net.sourceforge.jtds.jdbc.Driver
spring.jpa.hibernate.ddl-auto=update

我得到这个异常：

2016-02-16 23:36:46.645 ERROR 7840 --- [           main] o.a.tomcat.jdbc.pool.ConnectionPool      : Unable to create initial connections of pool.
java.sql.SQLException: Login timed out.
    at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:433) ~[jtds-1.3.1.jar:1.3.1]
    at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184) ~[jtds-1.3.1.jar:1.3.1]
    at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:307) ~[tomcat-jdbc-8.0.30.jar:na]
    at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:200) ~[tomcat-jdbc-8.0.30.jar:na]
    at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:708) [tomcat-jdbc-8.0.30.jar:na]
    at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:642) [tomcat-jdbc-8.0.30.jar:na]
    at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:464) [tomcat-jdbc-8.0.30.jar:na]

Answer 1

过去，由于驱动程序在协商 SSL 加密握手时遇到问题，因此 jtds 驱动程序在 azure sql 中出现问题。推荐的驱动程序是Microsoft驱动程序。

更多信息在这里：https://azure.microsoft.com/nl-nl/documentation/articles/sql-database-develop-java-simple-windows/