存储过程的问题,请帮忙
部分语句:
conn = DriverManager.getConnection(sConnStr,sUser,sPass);
CallableStatement stmt = conn.prepareCall("{call test(?,?,?,?,?,?,?,?,?,?,?,?)}");
stmt.setString(1,CADRE_NO);
stmt.setString(2,PAYER_ID);
stmt.registerOutParameter(3,java.sql.Types.VARCHAR);
stmt.registerOutParameter(4,java.sql.Types.VARCHAR);
stmt.registerOutParameter(5,java.sql.Types.VARCHAR);
stmt.registerOutParameter(6,java.sql.Types.VARCHAR);
stmt.registerOutParameter(7,java.sql.Types.VARCHAR);
stmt.registerOutParameter(8,java.sql.Types.VARCHAR);
stmt.registerOutParameter(9,java.sql.Types.VARCHAR);
stmt.registerOutParameter(10,java.sql.Types.VARCHAR);
stmt.registerOutParameter(9,java.sql.Types.INTEGER);
stmt.registerOutParameter(10,java.sql.Types.INTEGER);
stmt.registerOutParameter(11,java.sql.Types.INTEGER);
stmt.registerOutParameter(12,java.sql.Types.VARCHAR);
//执行该存储过程并返回结果集
sqlRst = stmt.executeQuery();
执行时产生
500 Servlet Exception
com.sybase.jdbc.SybSQLException: Internal Ct-Lib/Cs-Lib error 4002: 'Login
failed.
'.
at com.sybase.tds.Tds.processEed(Tds.java)
at com.sybase.tds.Tds.nextResult(Tds.java)
at com.sybase.jdbc.ResultGetter.nextResult(ResultGetter.java)
at com.sybase.jdbc.SybStatement.nextResult(SybStatement.java)
at com.sybase.jdbc.SybStatement.queryLoop(SybStatement.java)
at com.sybase.jdbc.SybCallableStatement.executeQuery(SybCallableStatement.java)
at _sbb._jsp._sybase__jsp._jspService(/sbb/jsp/sybase.jsp:97)
at com.caucho.jsp.JavaPage.service(JavaPage.java:87)
at com.caucho.jsp.JavaPage.subservice(JavaPage.java:81)
at com.caucho.jsp.Page.service(Page.java:474)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:166)
at com.caucho.server.http.Invocation.service(Invocation.java:277)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:129)
at com.caucho.server.http.RunnerRequest.handleRequest(RunnerRequest.java:334)
at com.caucho.server.http.RunnerRequest.handleConnection(RunnerRequest.java:266)
at com.caucho.server.TcpConnection.run(TcpConnection.java:140)
at java.lang.Thread.run(Thread.java:579)
--------------------------------------------------------------------------
Resin 2.0.2 (built Mon Aug 27 16:52:49 PDT 2001)
我用的jdk1.3+resin2.0.2
不知为什么??