SAP Knowledge Base Article - Preview

3395910 - jConnect: RETURN_GENERATED_KEYS and getGeneratedKeys fails with insert into...select syntax - SDK for SAP ASE

Symptom

Gathering generated identity keys from insert fails with:
java.sql.SQLException: JZ0NK: Generated keys are not available because either the Statement.NO_GENERATED_KEYS was used or no keys were automatically generated. at com.sybase.jdbc4.jdbc.ErrorMessage.raiseError(ErrorMessage.java:832) at com.sybase.jdbc4.jdbc.SybStatement.getGeneratedKeys(SybStatement.java:1324) at Test.main(Test.java:24)


Read more...

Environment

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

Keywords

CR828652, CR 828652, CR#828652 , KBA , BC-SYB-SDK , SDK , Known Error

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.