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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.