Trying to connect my java web application with MS-SQL server using sqljdbc41
for jdk 1.8
. Here is the database connection code-
Connection connection;
String url = "jdbc:sqlserver://localhost:1433;databaseName=Lista;integratedSecurity=true";
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
connection = DriverManager.getConnection(url);
when i am trying to insert some values to the database like-
PreparedStatement ps = connection.prepareStatement("INSERT INTO user_informations VALUES(?,?,?)");
ps.setString(1, "value");
ps.setString(2, "value");
ps.setString(3, "value");
ps.executeUpdate();
getting the following error each time-
com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication
Here are some informations about what i have tried yet-
sqljdbc41
in the path variable.sqljdbc_auth.dll
in the path variable.sqljdbc41.jar
into my Nebeans
project library.sqljdbc_auth.dll
into both bin folder under jdk
and jre
.jdk
is 64 bit
under program files folder not in program file(x86).Edit
Now i experiencing a new thing-after restarting my pc when i deploy the project for the first time then it is working perfectly but when i make any change in my code and re-run the project it's not working!
I solved my problem!
The error (described in my question above) i was getting because the glassfish
server had not any access on sqljdbc42.jar
file. so i have placed the sqljdbc42.jar
file into my glassfish
server in this location-
glassfish-4.1\glassfish\domains\domain1\lib
And it's now working perfectly.
Thank you everyone!