J'obtiens une erreur lorsque j'essaie de créer une connection de source de données au server MS SQL en utilisant le pilote JTDS dans ma configuration Spring. J'utilise l'authentification de domaine à partir d'une machine non Windows.
ERREUR:
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>
Je peux créer la connection manuellement et fonctionne parfaitement comme:
public static void main(Ssortingng[] args) { System.out.println("Starting Connection test"); Connection connection; Ssortingng 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(); } }
Toute suggestion serait appréciée
Essaye ça:-
<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>
Dépendance pour DBCP: –
<dependency> <groupId>commons-dbcp</groupId> <artifactId>commons-dbcp</artifactId> <version>1.4</version> </dependency>