MIDRANGE dot COM Mailing List Archive



Home » JAVA400-L » February 2008

Re: JDBC Connection and Library List



fixed

"libraries": Specifies one or more libraries that you want to add to *or replace* _the library list_ of the server job; List of server libraries, separated by _commas_ or _spaces_; default: "*LIBL"; When you do not use *LIBL, the specified libraries *replace* the current library list of the server job;
http://publib.boulder.ibm.com/infocenter/iadthelp/v7r0/index.jsp?topic=/com.ibm.etools.iseries.toolbox.doc/jdbcliblistproperty.htm

I was not aware of the implied behavior as noted in the last statement above about *replace*.
As far as I know, the comma-separated list is used to prepend the list with a single comma, to effect the *replace*. See also:
7. Library property specified, _list starts with a comma_; System Naming: No default schema, all libraries on list searched, list replaces job's library list.
http://publib.boulder.ibm.com/infocenter/iadthelp/v7r0/topic/com.ibm.etools.iseries.toolbox.doc/jdbcliblistproperty.htm#jdbcliblistproperty

As such, I suggest trying to replace the current attempt:
libraries=,QTEMP,MYLIB,QGPL,MYLIB2

IMO the documentation is very poor. I find it disturbing that something as simple as the concept of a library list, is described in a JDBC FAQ as "complicated." Implying that the "behavior of library lists on an i5/OS system is quite complicated." To me, the complication is in their poor implementation and *very vague* documentation. So unclear, they have to have a long entry in a separate FAQ document; http://www-03.ibm.com/systems/i/software/toolbox/faqjdbc.html Even more disturbing, is that the FAQ is basically just a repeat of the already poorly worded documentation.

I would open a defect issue with your service provider. Given the stated results, the "libraries" property appears not to work as it is documented: "When you do not use *LIBL, the specified libraries replace the current library list of the server job." If that quoted documentation is correct, then the traced results should not show any ADDLIBLE errors, because the implementation should be, instead of any ADDLIBLE activity, one request to:
*SYSTEM/CHGLIBL ( QTEMP MYLIB QGPL MYLIB2 ) CURLIB(*SAME)

Regards, Chuck





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact