Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
jimoibm opened this issue Apr 1, 2021 · 0 comments
Open

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

jimoibm opened this issue Apr 1, 2021 · 0 comments

Comments

@jimoibm
Copy link
Contributor

jimoibm commented Apr 1, 2021

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>
',
'?');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant