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


  • 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(
            at com.sybase.jdbc4.tds.Tds.nextResult(
            at com.sybase.jdbc4.jdbc.ResultGetter.nextResult(
            at com.sybase.jdbc4.jdbc.SybStatement.nextResult(
            at com.sybase.jdbc4.jdbc.SybStatement.nextResult(
            at com.sybase.jdbc4.jdbc.SybStatement.updateLoop(
            at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate( 
            at com.sybase.jdbc4.jdbc.SybPreparedStatement.executeUpdate(
            at com.sybase.jdbc4.tds.Tds.setOption(



  • 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 )
  • java


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


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.