-
Notifications
You must be signed in to change notification settings - Fork 19
Open
Description
For a mixed requests in xmlserver input with requests that call both PASE(/usr/lib/start32) and JVM(QSYS/QSQSTPJC) in a job, SQL query failed later. As start32 is not recommended to be called with security feature enabled anymore, thinking of only use JVM to wake PASE up. Main changes are in plugpase.rpgle.
Currently in parm ctl, *JAVA/*SQLJAVA is used to start JVM.
1. <sh> triggers start32. *java triggers JVM. FAILED on db2_query().
call qxmlserv.iPlug32k('*na',
'*here*sqljava',
'<?xml version=''1.0''?>
<myscript>
<sh> ps -ef </sh>
<sql>
<options options=''opt1'' autocommit=''off'' commit=''none''/>
<connect conn=''local'' options=''opt1''/>
<query>
SELECT * FROM QUSRSYS.QATOCHOST
</query>
<fetch block=''all'' desc=''on''/>
</sql>
</myscript>
',
'?');
2. WORKS. After *java start JVM to have PASE up as well, won't trigger calling start32.
call qxmlserv.iPlug32k('*na',
'*here*sqljava',
'<?xml version=''1.0''?>
<myscript>
<sql>
<options options=''opt1'' autocommit=''off'' commit=''none''/>
<connect conn=''local'' options=''opt1''/>
<query>
SELECT * FROM QUSRSYS.QATOCHOST
</query>
<fetch block=''all'' desc=''on''/>
</sql>
<sh> ps -ef </sh>
</myscript>
',
'?');
Metadata
Metadata
Assignees
Labels
No labels