|
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:
- When the first entry is *LIBL, the specified libraries are added to
the current library list of the server job.
- 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:
- The first entry (unless it is *LIBL) becomes the default schema.
- When the first entry is *LIBL, the second entry becomes the default
schema.
- 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:
- The server uses the specified libraries to search for unqualified
names.
- 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. |
|
|
|
|
|
|