SAP Knowledge Base Article - Preview

2428312 - Stored procedures do not display with sp_jdbc_stored_procedures used by Java based Apps - SDK for SAP ASE

Symptom

  • Stored procedures having execute permissions using Roles do not display when using sp_jdbc_stored_procedures.
  • The stored procedures are displayed when using sp_stored_procedures
  • com.sybase.jdbc4.jdbc.SybSQLException: SET CHAINED command not allowed within multi-statement transaction.
            at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4119)
            at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3235)
            at com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:78)
            at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:302)
            at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:284)
            at com.sybase.jdbc4.jdbc.SybStatement.updateLoop(SybStatement.java:2762)
            at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:2746) 
            at com.sybase.jdbc4.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStatement.java:330)
            at com.sybase.jdbc4.tds.Tds.setOption(Tds.java:1969)


Read more...

Environment

  • SAP Sybase Software Developer Kit (SDK) 15.7
  • SAP Adaptive Server Enterprise (ASE) Software Developer Kit (SDK) 16.0
  • JDBC 7.0
  • JDBC 7.07
  • JDBC 16 ( is version JDBC 7.07 )
  • DBISQL
  • java

Product

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

Keywords

CR#805566, CR805566, jConnect, java, jconn4, jconn4.jar , 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.