New Topic/Question
This topic is locked
IDE: Eclipse (eclipse-jee-juno-win32)
Database: SQL Server 2012
JDK: jdk1.6.0_24
SQL Server JDBC Driver: sqljdbc_4.0.2206.100_enu.tar
Extracted the JDBC files and added sqljdbc4.jar in my project Build Path/library.
I get this connection error while running the test code. I can access the database/table in SQL Server management Studio using the windows authentication.
Please suggest the error in code to establish the connection. Please suggest.
01 [u]1st way:-[/u]
02 System.out.println("Execution Started");
03 String url = "jdbc:sqlserver:seleniumdsn";
04 //localhost:1434;databaseName=SeleniumAutomation;integratedSecurity=true";
05
06
07 Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
08 Connection conn = DriverManager.getConnection(url);
09 Statement st=conn.createStatement();
10 ResultSet rs=st.executeQuery("SELECT * FROM dbo.Credentials");
11 while (rs.next())
12 {
13 String l1=rs.getString("UserID");
14 String l2=rs.getString("Password");
15 System.out.println("UserID:"+l1+" Password: "+l2);
16
17 [u]Exception Details:[/u]
18 Execution Started
19 java.sql.SQLException: No suitable driver found for jdbc:sqlserver:seleniumdsn
20 at java.sql.DriverManager.getConnection(Unknown Source)
21 at java.sql.DriverManager.getConnection(Unknown Source)
22 at com.swift.pac.gat.Driver.main(Driver.java:75)
01 2nd way of :
02
03 System.out.println("Execution Started");
04 String url = "jdbc:sqlserver://localhost:1434;databaseName=SeleniumAutomation;integratedSecurity=true";
05
06
07 Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
08 Connection conn = DriverManager.getConnection(url);
09 Statement st=conn.createStatement();
10 ResultSet rs=st.executeQuery("SELECT * FROM dbo.Credentials");
11 while (rs.next())
12 {
13 String l1=rs.getString("UserID");
14 String l2=rs.getString("Password");
15 System.out.println("UserID:"+l1+" Password: "+l2);
16 }
17
18 [u]Displayed Error:[/u]
19 Execution Started
20 com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset ClientConnectionId:b6bac095-6d8e-48ee-9c49-3a04769fa5b8
21 at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1667)
22 at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1654)
23 at com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:1789)
24 at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(IOBuffer.java:4838)
25 at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:6154)
26 at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:6106)
27 at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2907)
28 at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2234)
29 at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)
30 at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2220)
31 at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
32 at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
33 at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1326)
34 at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)
35 at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)
36 at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)
37 at java.sql.DriverManager.getConnection(Unknown Source)
38 at java.sql.DriverManager.getConnection(Unknown Source)
39 at com.swift.pac.gat.Driver.main(Driver.java:74)
Netstat details:
Netstat -an details:
TCP 0.0.0.0:2869 0.0.0.0:0 LISTENING
TCP 0.0.0.0:3938 0.0.0.0:0 LISTENING
TCP 0.0.0.0:5357 0.0.0.0:0 LISTENING
TCP 0.0.0.0:5520 0.0.0.0:0 LISTENING
TCP 0.0.0.0:10048 0.0.0.0:0 LISTENING
TCP 0.0.0.0:10243 0.0.0.0:0 LISTENING
TCP 127.0.0.1:1029 127.0.0.1:5354 ESTABLISHED
TCP 127.0.0.1:1033 0.0.0.0:0 LISTENING
TCP 127.0.0.1:1035 0.0.0.0:0 LISTENING
TCP 127.0.0.1:1040 127.0.0.1:1521 ESTABLISHED
TCP 127.0.0.1:1083 0.0.0.0:0 LISTENING
TCP 127.0.0.1:1434 0.0.0.0:0 LISTENING
TCP 127.0.0.1:1521 0.0.0.0:0 LISTENING
TCP 127.0.0.1:1521 127.0.0.1:1040 ESTABLISHED
TCP 127.0.0.1:1521 127.0.0.1:31035 TIME_WAIT
TCP 127.0.0.1:1521 127.0.0.1:31039 TIME_WAIT
TCP 127.0.0.1:1521 127.0.0.1:31042 TIME_WAIT
TCP 127.0.0.1:1521 127.0.0.1:31044 TIME_WAIT
TCP 127.0.0.1:1677 127.0.0.1:27015 ESTABLISHED
TCP 127.0.0.1:2869 127.0.0.1:31047 TIME_WAIT
TCP 127.0.0.1:2869 127.0.0.1:31048 ESTABLISHED
TCP 127.0.0.1:5354 0.0.0.0:0 LISTENING
TCP 127.0.0.1:5354 127.0.0.1:1029 ESTABLISHED
TCP 127.0.0.1:5357 127.0.0.1:31046 TIME_WAIT
TCP 127.0.0.1:7860 127.0.0.1:7861 ESTABLISHED
TCP 127.0.0.1:7861 127.0.0.1:7860 ESTABLISHED
TCP 127.0.0.1:10000 0.0.0.0:0 LISTENING
TCP 127.0.0.1:27015 0.0.0.0:0 LISTENING
TCP 127.0.0.1:27015 127.0.0.1:1677 ESTABLISHED
TCP 127.0.0.1:29521 127.0.0.1:29522 ESTABLISHED
TCP 127.0.0.1:29522 127.0.0.1:29521 ESTABLISHED
TCP 127.0.0.1:31036 127.0.0.1:1521 TIME_WAIT
TCP 127.0.0.1:31038 127.0.0.1:1521 TIME_WAIT
TCP 127.0.0.1:31041 127.0.0.1:1521 TIME_WAIT
TCP 127.0.0.1:31048 127.0.0.1:2869 ESTABLISHED
MultiQuote
| 