我在Spring Config中尝试使用JTDS驱动程序创建到MS SQL server的数据源连接时遇到错误。我正在使用来自非windows计算机的域身份验证。
错误:
Caused by: java.sql.SQLException: Login failed.
The login is from an untrusted domain and cannot be used with Windows authentication.Spring-Datasource.xml:
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="net.sourceforge.jtds.jdbc.Driver"/>
<property name="url" value="jdbc:jtds:sqlserver://MS_SERVER/ms_db;domain=myDomain;integrated security=false"/>
<property name="username" value="myUser"/>
<property name="password" value="myPassword"/>
</bean>我可以手动创建连接,工作方式如下:
public static void main(String[] args) {
System.out.println("Starting Connection test");
Connection connection;
String url = "jdbc:jtds:sqlserver://MS_SERVER/ms_db;domain=myDomain;integrated security=false";
try {
Class.forName("net.sourceforge.jtds.jdbc.Driver");
connection = DriverManager.getConnection(url, "myUser","myPassword"));
System.out.println("Connection successful");
}
catch (Exception e) {
System.err.println("Cannot connect to database server");
e.printStackTrace();
}
}如有任何建议,我们将不胜感激
发布于 2014-01-10 04:43:55
试试这个:-
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName" value="net.sourceforge.jtds.jdbc.Driver"/>
<property name="url" value="jdbc:jtds:sqlserver://MS_SERVER/ms_db;domain=myDomain;integrated security=false"/>
<property name="username" value="myUser"/>
<property name="password" value="myPassword"/>
</bean>DBCP的依赖关系:-
<dependency>
<groupId>commons-dbcp</groupId>
<artifactId>commons-dbcp</artifactId>
<version>1.4</version>
</dependency>发布于 2020-11-30 01:40:30
根据http://jtds.sourceforge.net/faq.html,您需要传递useNTLMv2=true和domain=yourdomain。
尝试此连接字符串
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName" value="net.sourceforge.jtds.jdbc.Driver"/>
<property name="url" value="jdbc:jtds:sqlserver://MS_SERVER/ms_db;USENTLMV2=true;domain=myDomain"/>
<property name="username" value="myUser"/>
<property name="password" value="myPassword"/>
</bean>https://stackoverflow.com/questions/21029797
复制相似问题