Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.DriverManager;
- import java.sql.Connection;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- public class TestStored
- {
- public static void main(String[] args) throws SQLException, ClassNotFoundException
- {
- Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
- Connection conn = DriverManager.getConnection("jdbc:sqlserver://IPSERVER\SQLINSTANCE;user=User;password=psw;database=DB");
- System.out.println("test");
- String SPsql = "EXEC INS_TEST ?"; // java.sql.Connection
- PreparedStatement ps = conn.prepareStatement(SPsql);
- ps.setEscapeProcessing(true);
- ps.setQueryTimeout(10000);
- ps.setInt(1, 99);
- boolean a = ps.execute();
- Statement sta = conn.createStatement();
- String Sql = "select * from tab_test";
- ResultSet rs = sta.executeQuery(Sql);
- while (rs.next())
- {
- System.out.println(rs.getString("num"));
- }
- }
- }
- java.nio.channels.NotYetConnectedException
- SQLServerException: Connection reset by peer ClientConnectionId
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement