Re: JDBC Connection and Library List (I have code for testing)

What I saw on v5r3 showed successive requests to
"ADDLIBLE LIB(name)" via SQL CALL requests performed in a
QRWTSRVR job:
CALL QSYS/QCMDEXC('ADDLIBLE LIB(name)',
0000000018.00000)

Thus not only is that problematic for its failure to

the more appropriate QSYS/CHGLIBL, it is incorrectly using
*LIBL/ADDLIBLE and failing to ensure its assumption of
POSITION(*FIRST) is met.

The above implies two issues. First that the command
request is not library qualified. Second that the
assumption of *FIRST could become a *failed* assumption on
any system where the following customization has occurred
[a defect, more than just an 'issue']:
CHGCMDDFT QSYS/ADDLIBLE 'POSITION(*LAST)'

Because of the first error, you could get past the
problem by introducing a Trojan Horse command
BEFOREQSYS/ADDLIBLE which effects the desirable outcome of
library placement; e.g. using a CLP which monitors the
condition of CPF2103 and reacts by RMVLIBLE of the same
value for LIB(), and repeats the ADDLIBLE LIB()
POSITION(*FIRST)

Report those issues as defects and suggest the most
appropriate resolution would presumably be to use

in the other case probably also has the same coding issue
whereby it is not library qualified by *NLVLIBL or
*SYSTEM.

Regards, Chuck
--
All comments provided "as is" with no warranties of any
kind whatsoever and may not represent positions,
strategies, nor views of my employer

Ashish Kulkarni wrote:

I have pasted some java code below < >
Can someone run this program on AS400, < >

--
This is the Java Programming on and around the iSeries /
AS400 (JAVA400-L) mailing list To post a message email:
JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change
list options, visit:
http://lists.midrange.com/mailman/listinfo/java400-l or
email: JAVA400-L-request@xxxxxxxxxxxx Before posting,
please take a moment to review the archives at
http://archive.midrange.com/java400-l.