尝试在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();
}
}
任何建议，将不胜感激
尝试这个：-
<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>
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句