xmlservice icon indicating copy to clipboard operation
xmlservice copied to clipboard

Drop calling /usr/lib/start32 to bring PASE up

Open jimoibm opened this issue 3 years ago • 0 comments

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>
',
'?');

jimoibm avatar Apr 01 '21 02:04 jimoibm