Specifying more than one library when using the Toolbox driver to connect to DB2 on iSeries from WebSphere Application Server version 4.0.x
 Technote (FAQ)
 
Problem
Problems might occur when you try to specify more than one value for the libraries custom property on an iSeries DB2® datasource from WebSphere® Application Server version 4.0.x. At run time, it appears that only the first library specified in the custom property gets picked up by the JDBC™ driver.

The datasource in question uses either of the following implementation classes and is contained in the jt400.jar driver file:
com.ibm.as400.access.AS400JDBCConnectionPoolDataSource
com.ibm.as400.access.AS400JDBCXADataSource
 
Cause
The naming custom property on the iSeries datasource is set incorrectly.
 
Solution

To be able to specify more than one library in the libraries custom property, the naming custom property must be set to system. By default, no value is specified for the naming custom property, which corresponds to a value of sql.

The following explains the properties and their uses:

libraries
type="java.lang.String"
value=" "
description="Specifies one or more libraries that you want to add to or replace the library list of the server job, and optionally sets the default library (default schema). The server uses specified libraries to resolve unqualified stored procedure names, and stored procedures use
them to resolve unqualified names."

To specify multiple libraries, use commas or spaces to separate individual entries.

You can use *LIBL as a placeholder for the current library list of the server job using the following rules:
  1. When the first entry is *LIBL, the specified libraries are added to the current library list of the server job.
  2. When you do not use *LIBL, the specified libraries replace the current library list of the server job.

Setting of the default schema depends on whether you use sql or system for the naming property.

For sql naming, the following rules apply:
  1. The first entry (unless it is *LIBL) becomes the default schema.

  2. When the first entry is *LIBL, the second entry becomes the default schema.

  3. When you do not set this property, or when it contains only *LIBL, the user profile becomes the default schema.

For system naming, the following rules apply:
  1. The server uses the specified libraries to search for unqualified names.

  2. When you do not set this property, or when it contains only *LIBL, the server uses the current library list of the server job to search for unqualified names.
naming
type="java.lang.String"
value="sql"
description="This property allows you to use either the traditional iSeries naming syntax or the standard sql naming syntax. 'system' naming means that you should use a '/' character to separate collection and table values, and 'sql' naming means that you should use a '.' character to separate the values. The setting of this value has ramifications for what the default library is also. See the 'libraries' property for further information on this. The default is to use 'sql' naming."


Refer to the iSeries Information Center for more information on the libraries and naming Connection properties.
 
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > DB Connections/Connection Pooling
Operating system(s): Windows
Software version: 4.0
Software edition:
Reference #: 1162882
IBM Group: Software Group
Modified date: Mar 31, 2006