1853943 - Connection.setClientInfo generate java.sql.SQLException , java.sql.SQLClientInfoException for Jconnect Driver. | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1853943 - Connection.setClientInfo generate java.sql.SQLException , java.sql.SQLClientInfoException for Jconnect Driver.

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

jConnect from version 7.07 ESD#4 onwards

Product

Sybase SDK 15.7

Keywords

jConnect, java, execute permissions, sa_role, jconn4.jar, jconn3.jar , 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.