MS SQL SERVER prepareCall
Bonjour,
Je rencontre quelques difficultés concernant l'utilisation d'une procédure stockée
qui ne retourne rien hormis via un select (Procédure stockée):
Code:
1 2 3
|
.....
SELECT @ErrorType,@ErrorMess; |
Servlet:
Code:
1 2 3 4 5 6 7 8 9 10
| cS = cnx.prepareCall("{Call Read_File(?,?,?)}");
cS.setString(1, filePath);
cS.setInt(2, idp);//Program id
cS.setString(3, desc);
out.print("TATA");
rs = cS.executeQuery();
out.print("TOTO");
//Check error status
errorType = rs.getInt("ErrorType");
errorMessage = rs.getString("ErrorMess"); |
Et lors de l'exécution du prepareCall, netbeans affiche:
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
| L'instruction n'a pas renvoyé le jeu de résultat.
com.microsoft.sqlserver.jdbc.SQLServerException: L'instruction n'a pas renvoyé le jeu de résultat.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(Unknown Source)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at com.mucoma.servlet.ImportManager.processRequest(ImportManager.java:187)
at com.mucoma.servlet.ImportManager.doPost(ImportManager.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:595) |
PS: Je tiens à préciser que la proc est bien executée (SQL server profiler me l'indique)
Merci par avance pour vos réponses.
Cordialement,
Daniel