xmlservice
xmlservice copied to clipboard
Drop calling /usr/lib/start32 to bring PASE up
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,
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>
',
'?');