Advertisement
Guest User

Untitled

a guest
Jul 19th, 2017
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.12 KB | None | 0 0
  1. import java.sql.DriverManager;
  2. import java.sql.Connection;
  3. import java.sql.PreparedStatement;
  4. import java.sql.ResultSet;
  5. import java.sql.SQLException;
  6. import java.sql.Statement;
  7.  
  8.  
  9. public class TestStored
  10. {
  11.  
  12.  
  13. public static void main(String[] args) throws SQLException, ClassNotFoundException
  14. {
  15. Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  16. Connection conn = DriverManager.getConnection("jdbc:sqlserver://IPSERVER\SQLINSTANCE;user=User;password=psw;database=DB");
  17. System.out.println("test");
  18. String SPsql = "EXEC INS_TEST ?"; // java.sql.Connection
  19. PreparedStatement ps = conn.prepareStatement(SPsql);
  20. ps.setEscapeProcessing(true);
  21. ps.setQueryTimeout(10000);
  22. ps.setInt(1, 99);
  23. boolean a = ps.execute();
  24. Statement sta = conn.createStatement();
  25. String Sql = "select * from tab_test";
  26. ResultSet rs = sta.executeQuery(Sql);
  27. while (rs.next())
  28. {
  29. System.out.println(rs.getString("num"));
  30. }
  31. }
  32.  
  33. }
  34.  
  35. java.nio.channels.NotYetConnectedException
  36.  
  37. SQLServerException: Connection reset by peer ClientConnectionId
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement