PQ59975: TEST CONECTION GETS UNSATISFIED LINK ERROR WHEN USED MORE THAN ONCE

APAR status
Closed as program error.

Error description
When using the test connection button from the advanced tab in t
he datasource, the 1st time works ok but any subsequent call fai
ls with a unsatisifiedlinkerror: Native Library all ready loaded
in another classloader.
 Defect 114841 has been opened for this problem and I am creatin
g the apar.
 This appears to happen when the repository is a different DB th
an what is being used for the datasource.
Local fix Problem summary
****************************************************************
* USERS AFFECTED: WebSphere Application Server Users 4.0.3     *
*                 and below using DataSource Test Connection   *
****************************************************************
* PROBLEM DESCRIPTION: Test Connection button fails when       *
*                      used more than once.                    *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
Test Connection button from Datasource fails with Unsatisfied
Link Error when accessed more than once throwing the following
error: 360 CEST  22c2a897 ConnectionPoo W testConnectionTo
DataSource- failed: java.sql.SQLException: java.lang.Unsatisfied
Link Error: Native Library /usr/lpp/db2_07_01/lib/libdb2jdbc.so
already loaded in another classloader
at COM.ibm.db2.jdbc.DB2BaseDataSource.loadDLL(DB2BaseDataSource.
java:308)
Problem conclusion
This problem was caused because the JDBC driver is getting
loaded by a different classloader everytime the Test Connection
Button is clicked. Cached the classloader object to prevent it
from being loaded twice and keep using the same instance.
Temporary fix
EFIX is provided
Comments
APAR information
APAR number PQ59975
Reported component name WEBSPHERE AE NT
Reported component ID 5630A2201
Reported release 400
Status CLOSED PER
PE NoPE
HIPER NoHIPER
Submitted date 2002-04-10
Closed date 2002-05-22
Last modified date 2002-05-22

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Modules/Macros
JDBC          

Fix information
Fixed component name WEBSPHERE AE NT
Fixed component ID 5630A2201

Applicable component levels
R400 PSY    UP


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > General
Operating system(s):
Software version: 400
Software edition:
Reference #: PQ59975
IBM Group: Software Group
Modified date: May 22, 2002