SAP Knowledge Base Article - Preview

2653103 - jConnect CallableStatement param fails when one param is named - SDK for SAP ASE

Symptom

jConnect driver using CallableStatement causes error when parameter is literal:

  • java.sql.SQLException: JZ0SG: A CallableStatement did not return as many output parameters as the application had registered for it. at com.sybase.jdbc4.jdbc.ErrorMessage.raiseError(ErrorMessage.java:832) at com.sybase.jdbc4.jdbc.ParamManager.nextResult(ParamManager.java:1128) at com.sybase.jdbc4.jdbc.ParamManager.doGetOutValueAt(ParamManager.java:877) at com.sybase.jdbc4.jdbc.ParamManager.getOutValueAt(ParamManager.java:848) at com.sybase.jdbc4.jdbc.SybCallableStatement.getInt(SybCallableStatement.java:947) at Test.main(Test.java:17)
  • java.sql.SQLException: JZ0SB: Parameter index out of range: 3. at com.sybase.jdbc4.jdbc.ErrorMessage.raiseError(ErrorMessage.java:800) at com.sybase.jdbc4.jdbc.ParamManager.checkIndex(ParamManager.java:376) at com.sybase.jdbc4.jdbc.ParamManager.doRegisterParam(ParamManager.java:796) at com.sybase.jdbc4.jdbc.ParamManager.registerParam(ParamManager.java:787) at com.sybase.jdbc4.jdbc.SybCallableStatement.registerOutParameter(SybCallableStatement.java:430) at Test.main(Test.java:15)


Read more...

Environment

  • SAP Sybase Software Developer Kit (SDK) 15.7
  • SAP Adaptive Server Enterprise (ASE) Software Developer Kit (SDK) 16.0

Product

SAP Adaptive Server Enterprise SDK 16.0 ; Sybase Software Developer Kit 15.7

Keywords

CR#815339, CR 815339, CR# 815339, java, jre, jconn4,  jconn4.jar, parameterized, param, parm, error, fail, , KBA , BC-SYB-SDK , SDK , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.