SAP Knowledge Base Article - Preview

1853943 - Connection.setClientInfo generate java.sql.SQLException , java.sql.SQLClientInfoException for Jconnect Driver 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.5 ESD xxx
  • SAP Sybase Software Developer Kit (SDK) 15.7 ESD xxx
  • jConnect from version  JDBC 7.07 ESD#4 onwards

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.