How do I execute a MS SQL Server stored procedure in java/jsp, returning table data?

by

Our server calls stored procs from Java like so – works on both SQL Server 2000 & 2008:

String SPsql = "EXEC <sp_name> ?,?";   // for stored proc taking 2 parameters
Connection con = SmartPoolFactory.getConnection();   // java.sql.Connection
PreparedStatement ps = con.prepareStatement(SPsql);
ps.setEscapeProcessing(true);
ps.setQueryTimeout(<timeout value>);
ps.setString(1, <param1>);
ps.setString(2, <param2>);
ResultSet rs = ps.executeQuery();

More Related Contents:

  1. Call stored procedure with table-valued parameter from java
  2. How to SELECT FROM stored procedure
  3. Function vs. Stored Procedure in SQL Server
  4. SQL Server Insert if not exists
  5. SQL Server – How to lock a table until a stored procedure finishes
  6. Stored procedure or function expects parameter which is not supplied
  7. How to assign an exec result to a sql variable?
  8. Search text in stored procedure in SQL Server
  9. SQL Server SELECT into existing table
  10. How do I execute a stored procedure once for each row returned by query?
  11. How to check if a stored procedure exists before creating it
  12. SQL: Select dynamic column name based on variable
  13. SQL : in clause in stored procedure:how to pass values
  14. How to return the output of stored procedure into a variable in sql server
  15. SQL Server silently truncates varchar’s in stored procedures
  16. Split values over multiple rows [duplicate]
  17. Must declare the scalar variable
  18. Why execute stored procedures is faster than SQL query from a script?
  19. Stored procedure that exports data into csv files only exports to one file
  20. Custom Date/Time formatting in SQL Server
  21. Could not find stored procedure ‘dbo.aspnet_CheckSchemaVersion’
  22. Insert Update stored proc on SQL Server
  23. SQL Server: should I use information_schema tables over sys tables?
  24. Inserting rows into a table with one IDENTITY column only [duplicate]
  25. UNION the results of multiple stored procedures
  26. How to pass a temp table as a parameter into a separate stored procedure
  27. Eliminate and reduce overlapping date ranges
  28. Functions vs Stored Procedures
  29. How to execute a stored procedure inside a select query
  30. Dynamic order direction

Leave a Comment