SAP Knowledge Base Article - Preview

1853943 - jConnect: Connection.setClientInfo generate java.sql.SQLClientInfoException: EXECUTE permission denied on object sp_jdbc_set_client_info or You must have the following role(s) to execute this command/procedure: 'sa_role'- SAP SDK for ASE

Symptom

  • Use jdbc method Connection.setClientInfo on Jconnect Driver generate java.sql.SQLException, java.sql.SQLClientInfoException:
    java.sql.SQLClientInfoException: java.sql.SQLException: EXECUTE permission denied on object sp_jdbc_set_client_info, database sybsystemprocs, owner dbo
  • when updating you can get this error:
    JZ006: Caught IOException: You must have the following role(s) to execute this command/procedure: 'sa_role'. Please contact a user with the appropriate role for help.


Read more...

Environment

  • SAP Sybase Software Developer Kit (SDK) 15.7 ESD#4
  • jConnect
    • JDBC 7.07
  • java

Product

Sybase SDK 15.7

Keywords

jConnect, java, execute permissions, sa_role, jconn4.jar, jconn3.jar, CR738697, CR##738697 , KBA , BC-SYB-SDK , SDK , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.