[IQUG] Executing Java from IQ 16
Patrick.Doherty at fidessa.com
Tue Mar 3 05:47:34 MST 2015
I finally got to the bottom of this so am posting it here for future reference if anybody else has this issue.
The upgrade maintained the SYSTEM PROCEDURE INVOKER model.
So following the upgrade instructions I explicitly regranted the EXECUTE privilege to the following system procedures (this is in the documentation but takes some finding!):
sa_audit_string, sa_checkpoint_execute, sa_disable_auditing_type, sa_disk_free_space, sa_enable_auditing_type, sa_external_library_unload, sa_flush_cache, sa_list_external_library, sa_flush_cache, sa_list_external_library, sa_server_option,sa_procedure_profile, sa_procedure_profile_summary, sa_table_page_usage and sa_validate.
This still didn't solve the problem!
I also had to explicitly regrant the EXECUTE privilege to these system procedures as well (which is not documented anywhere that I could find):
Hope this is of some use to somebody else in the future.
From: Patrick Doherty
Sent: 24 February 2015 17:04
To: iqug at iqug.org
Subject: Executing Java from IQ 16
I've got a problem with running Java code under IQ16. The code ran fine with IQ 15.4 but with IQ16
I'm getting this is:
I. 02/24 13:41:08. CONNECTION: ConnectionId=114 IPAddress= UserName=EXTENV_WORKER
I. 02/24 13:41:08. java.sql.SQLException: [Sybase][ODBC Driver][SQL Anywhere]Permission denied: you do not have permission to execute
the procedure "sajvm_JavaWorker_FillArgs"
I. 02/24 13:41:08. at sybase.jdbc4.sqlanywhere.IIStatement.execute(Native Method)
I. 02/24 13:41:08. at sybase.jdbc4.sqlanywhere.IStatement.execute(IStatement.java:327)
I. 02/24 13:41:08. at ianywhere.sa.jvm.SAJvmFortify.checkedExecute(SAJvmFortify.java:251)
I. 02/24 13:41:08. at ianywhere.sa.jvm.SAJvm.getMethodArgs(SAJvm.java:671)
I. 02/24 13:41:08. at ianywhere.sa.jvm.SAJvm.executeMethod(SAJvm.java:1398)
I. 02/24 13:41:08. at ianywhere.sa.jvm.SAJvm.run(SAJvm.java:315)
The only thing I can think of is that as the user permissioning/role functionality has changed from IQ15.4 to 16 then I need to assign some additional
roles/permissions to the user but I can't figure this out from the documentation. Has anyone seen this before or have some ideas?
This message is intended only for the stated addressee(s) and may be confidential. Access to this email by anyone else is unauthorised. Any opinions expressed in this email do not necessarily reflect the opinions of Fidessa. Any unauthorised disclosure, use or dissemination, either whole or in part is prohibited. If you are not the intended recipient of this message, please notify the sender immediately.
Fidessa plc registered in England and Wales no. 3781700. VAT registration no. GB688900878. Registered office - Dukes Court, Duke Street, Woking, Surrey, GU21 5BH, UK
Fidessa buy-side ltd registered in England and Wales no. 3656437. VAT registration no. GB688900878. Registered office - Dukes Court, Duke Street, Woking, Surrey, GU21 5BH, UK
Fidessa group plc registered in England and Wales no. 3234176. VAT registration no. GB688900878. Registered office - Dukes Court, Duke Street, Woking, Surrey, GU21 5BH, UK
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the IQUG