Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
agg_rachna@yahoo.co.in
Starting Member
1 Post |
 Posted - 2007-01-12 : 07:35:44
|
| Hi,Can anybody please let me know if we can call an Extended Stored Procedure through JDBC.We are working on MS SQL SERVER 2000 and we are able to call Extended Stored Procedure through Query Analyzer. But we are unable to call it through JDBC. We are able to call a simple Stored Procedure through CallableStatement correctly. But when we call an extended stored procedure in this stored procedure we are getting an exception:com.microsoft.sqlserver.jdbc.SQLServerException: Parameter '1' is NULL. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source) at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getPrepExecResponse(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PreparedStatementExecutionRequest.executeStatement(Unknown Source) at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(Unknown Source) at com.nubridges.datasecure.admintool.test.cases.TestCallableStatement.main(TestCallableStatement.java:101)Is it possible to call extended stored procedure directly through JDBC or by calling another stored procedure that calls this extended one?Regards,Rachna |
|
|
|
|
|
Calling Extended Stored Procedure from Java