You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user-java@ibatis.apache.org by Waheed Rahuman <wa...@gmail.com> on 2007/06/19 06:00:58 UTC

A CallableStatement did not return as many output parameters

 Hello Crew,

Hope you doing well and wish you the same.



I am using EAServer 5.3 with jConnect 5.5



*Driver Class: com.sybase.jdbc2.jdbc.SybDriver Version: 5.5*



When i invoke a RPC, procedure.I am getting the error as below.I got this
below message from Jaguar.log .

But,the exception does not stop the execution of the RPC.



The RPC Procedure is invoked in EAServer Component *WebComponent  *in method
name *tcc_rp_process_mied_info*

I have some other RPC procedures, they are working fine and no exception.





*Jaguar.log*

Jun 17 12:26:56 2007: Java VM loaded. Version: 1.4.2_06, Vendor: Sun
Microsystems Inc.

Jun 17 12:26:58 2007: java.sql.SQLException: JZ0SG: A CallableStatement did
not return as many output parameters as the application had registered for
it.

Jun 17 12:26:58 2007: at com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(
ErrorMessage.java:542)

Jun 17 12:26:58 2007: at com.sybase.jdbc2.jdbc.ParamManager.nextResult(
ParamManager.java:689)

Jun 17 12:26:58 2007: at com.sybase.jdbc2.jdbc.ParamManager.getOutValueAt(
ParamManager.java:482)

Jun 17 12:26:58 2007: at com.sybase.jdbc2.jdbc.SybCallableStatement.getShort
(SybCallableStatement.java :287)

Jun 17 12:26:58 2007: at
com.sybase.powerbuilder.jdbc.PbjdbcCommand.GetParmShort(PbjdbcCommand.java:708)


Jun 17 12:26:58 2007: at com.sybase.CORBA.local.Socket.call(Native Method)

Jun 17 12:26:58 2007: at com.sybase.CORBA.local.OutputStream.write(
OutputStream.java:29)

Jun 17 12:26:58 2007: at com.sybase.CORBA.iiop.Connection.invoke(
Connection.java:3269)

Jun 17 12:26:58 2007: at
WebComponent._st_uo_appeon_rpc_master.tcc_rp_process_mied_info(_st_uo_appeon_rpc_master.java:4958)


Jun 17 12:26:58 2007: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)

Jun 17 12:26:58 2007: at sun.reflect.NativeMethodAccessorImpl.invoke(
NativeMethodAccessorImpl.java:39)

Jun 17 12:26:58 2007: at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java :25)

Jun 17 12:26:58 2007: at java.lang.reflect.Method.invoke(Method.java:324)

Jun 17 12:26:58 2007: at
com.appeon.server.command.CallNvoCommand.executeNvoComponent(
CallNvoCommand.java :203)

Jun 17 12:26:58 2007: at com.appeon.server.command.CallNvoCommand.execute(
CallNvoCommand.java:88)

Jun 17 12:26:58 2007: at
com.appeon.server.services.transactionservice.AbstractTransactionService.executeAX(
AbstractTransactionService.java:236)

Jun 17 12:26:58 2007: at
com.appeon.server.services.transactionservice.AbstractTransactionService.execute(
AbstractTransactionService.java:142)

Jun 17 12:26:58 2007: at
com.appeon.server.services.controller.JRouterImpl.executeInTransaction(
JRouterImpl.java :575)

Jun 17 12:26:58 2007: at
com.appeon.server.services.controller.JRouterImpl.executeCommand(
JRouterImpl.java :500)

Jun 17 12:26:58 2007: at
com.appeon.server.services.controller.JRouterImpl.call(JRouterImpl.java:459)

Jun 17 12:26:58 2007: at
com.appeon.server.services.controller.JRouterImpl.call(JRouterImpl.java:181)

Jun 17 12:26:58 2007: at appeon.weblibrary.EONUtil.doAXPost(EONUtil.java
:273)

Jun 17 12:26:58 2007: at appeon.weblibrary.AXDispatcher.doPost(
AXDispatcher.java:54)

Jun 17 12:26:58 2007: at javax.servlet.http.HttpServlet.service(
HttpServlet.java:760)

Jun 17 12:26:58 2007: at javax.servlet.http.HttpServlet.service(
HttpServlet.java:853)

Jun 17 12:26:58 2007: at com.sybase.jaguar.servlet.JagServlet.service(
JagServlet.java:718)

Jun 17 12:26:58 2007: at
com.sybase.jaguar.servlet.JagRequestDispatcher.service(
JagRequestDispatcher.java :958)

Jun 17 12:26:58 2007: at com.sybase.jaguar.servlet.JagWebResource.service(
JagWebResource.java:90)

Jun 17 12:26:58 2007: at com.sybase.jaguar.servlet.JagFilterChain.doFilter(
JagFilterChain.java:133)

Jun 17 12:26:58 2007: at com.sybase.jaguar.servlet.ServletEngine._service(
ServletEngine.java:867)

Jun 17 12:26:58 2007: at com.sybase.jaguar.servlet.ServletEngine.service(
ServletEngine.java:365)

Jun 17 12:26:58 2007: at
com.sybase.jaguar.servlet.ServletServiceImpl.doService(
ServletServiceImpl.java :58)

Jun 17 12:26:58 2007: at
com.sybase.jaguar.servlet._sk_JaguarServlet_ServletService.remoteInvoke(_sk_JaguarServlet_ServletService.java:218)


Jun 17 12:26:58 2007: at
com.sybase.jaguar.servlet._sk_JaguarServlet_ServletService.invoke(_sk_JaguarServlet_ServletService.java:125)


Anticipating your reply,



Best Regards

Waheed

+971 50 815 0115

Re: A CallableStatement did not return as many output parameters

Posted by Saeed Iqbal <sa...@gmail.com>.

Waheed:

I think the error was pretty clear. number of return params you look for in
your code is less than what the query is returning?
A CallableStatement did not return as many output parameters as the
application had registered for it.


Can you show the call ?

Thanks,
-saeed
Sybase Inc.,
Dublin CA.

On 6/18/07, Waheed Rahuman <wa...@gmail.com> wrote:
>
> Hello Crew,
>
> Hope you doing well and wish you the same.
>
>
>
> I am using EAServer 5.3 with jConnect 5.5
>
>
>
> *Driver Class: com.sybase.jdbc2.jdbc.SybDriver Version: 5.5*
>
>
>
> When i invoke a RPC, procedure.I am getting the error as below.I got this
> below message from Jaguar.log .
>
> But,the exception does not stop the execution of the RPC.
>
>
>
> The RPC Procedure is invoked in EAServer Component *WebComponent  * in
> method name *tcc_rp_process_mied_info*
>
> I have some other RPC procedures, they are working fine and no exception.
>
>
>
>
>
> *Jaguar.log*
>
> Jun 17 12:26:56 2007: Java VM loaded. Version: 1.4.2_06, Vendor: Sun
> Microsystems Inc.
>
> Jun 17 12:26:58 2007: java.sql.SQLException: JZ0SG: A CallableStatement
> did not return as many output parameters as the application had registered
> for it.
>
> Jun 17 12:26:58 2007: at com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(
> ErrorMessage.java:542)
>
> Jun 17 12:26:58 2007: at com.sybase.jdbc2.jdbc.ParamManager.nextResult(
> ParamManager.java:689)
>
> Jun 17 12:26:58 2007: at com.sybase.jdbc2.jdbc.ParamManager.getOutValueAt(
> ParamManager.java:482)
>
> Jun 17 12:26:58 2007: at
> com.sybase.jdbc2.jdbc.SybCallableStatement.getShort(
> SybCallableStatement.java :287)
>
> Jun 17 12:26:58 2007: at
> com.sybase.powerbuilder.jdbc.PbjdbcCommand.GetParmShort(PbjdbcCommand.java:708)
>
>
> Jun 17 12:26:58 2007: at com.sybase.CORBA.local.Socket.call(Native Method)
>
> Jun 17 12:26:58 2007: at com.sybase.CORBA.local.OutputStream.write(
> OutputStream.java:29)
>
> Jun 17 12:26:58 2007: at com.sybase.CORBA.iiop.Connection.invoke(
> Connection.java:3269)
>
> Jun 17 12:26:58 2007: at
> WebComponent._st_uo_appeon_rpc_master.tcc_rp_process_mied_info(_st_uo_appeon_rpc_master.java:4958)
>
>
> Jun 17 12:26:58 2007: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> Method)
>
> Jun 17 12:26:58 2007: at sun.reflect.NativeMethodAccessorImpl.invoke(
> NativeMethodAccessorImpl.java:39)
>
> Jun 17 12:26:58 2007: at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java :25)
>
> Jun 17 12:26:58 2007: at java.lang.reflect.Method.invoke(Method.java:324)
>
> Jun 17 12:26:58 2007: at
> com.appeon.server.command.CallNvoCommand.executeNvoComponent(
> CallNvoCommand.java :203)
>
> Jun 17 12:26:58 2007: at com.appeon.server.command.CallNvoCommand.execute(
> CallNvoCommand.java:88)
>
> Jun 17 12:26:58 2007: at
> com.appeon.server.services.transactionservice.AbstractTransactionService.executeAX(
> AbstractTransactionService.java :236)
>
> Jun 17 12:26:58 2007: at
> com.appeon.server.services.transactionservice.AbstractTransactionService.execute(
> AbstractTransactionService.java :142)
>
> Jun 17 12:26:58 2007: at
> com.appeon.server.services.controller.JRouterImpl.executeInTransaction(
> JRouterImpl.java :575)
>
> Jun 17 12:26:58 2007: at
> com.appeon.server.services.controller.JRouterImpl.executeCommand(
> JRouterImpl.java :500)
>
> Jun 17 12:26:58 2007: at
> com.appeon.server.services.controller.JRouterImpl.call(JRouterImpl.java
> :459)
>
> Jun 17 12:26:58 2007: at
> com.appeon.server.services.controller.JRouterImpl.call(JRouterImpl.java
> :181)
>
> Jun 17 12:26:58 2007: at appeon.weblibrary.EONUtil.doAXPost(EONUtil.java
> :273)
>
> Jun 17 12:26:58 2007: at appeon.weblibrary.AXDispatcher.doPost(
> AXDispatcher.java:54)
>
> Jun 17 12:26:58 2007: at javax.servlet.http.HttpServlet.service(
> HttpServlet.java:760)
>
> Jun 17 12:26:58 2007: at javax.servlet.http.HttpServlet.service(
> HttpServlet.java:853)
>
> Jun 17 12:26:58 2007: at com.sybase.jaguar.servlet.JagServlet.service(
> JagServlet.java:718)
>
> Jun 17 12:26:58 2007: at
> com.sybase.jaguar.servlet.JagRequestDispatcher.service(
> JagRequestDispatcher.java :958)
>
> Jun 17 12:26:58 2007: at com.sybase.jaguar.servlet.JagWebResource.service(
> JagWebResource.java:90)
>
> Jun 17 12:26:58 2007: at com.sybase.jaguar.servlet.JagFilterChain.doFilter
> (JagFilterChain.java:133)
>
> Jun 17 12:26:58 2007: at com.sybase.jaguar.servlet.ServletEngine._service(
> ServletEngine.java:867)
>
> Jun 17 12:26:58 2007: at com.sybase.jaguar.servlet.ServletEngine.service(
> ServletEngine.java:365)
>
> Jun 17 12:26:58 2007: at
> com.sybase.jaguar.servlet.ServletServiceImpl.doService(
> ServletServiceImpl.java :58)
>
> Jun 17 12:26:58 2007: at
> com.sybase.jaguar.servlet._sk_JaguarServlet_ServletService.remoteInvoke(_sk_JaguarServlet_ServletService.java:218)
>
>
> Jun 17 12:26:58 2007: at
> com.sybase.jaguar.servlet._sk_JaguarServlet_ServletService.invoke(_sk_JaguarServlet_ServletService.java:125)
>
>
> Anticipating your reply,
>
>
>
> Best Regards
>
> Waheed
>
> +971 50 815 0115
>
>
>