i'm trying to configure DB2 connection pool using glassfish admin interface.
under "Common Tasks > Application server > JVM Settings > Path
Settings" i've added "/opt/ibm/db2exc/V9.5/java" under "System
Classpath", "Server Classpath" and "Native Library Path Prefix".
root_at_server:/opt/ibm/db2exc/V9.5/java# pwd
/opt/ibm/db2exc/V9.5/java
root_at_server:/opt/ibm/db2exc/V9.5/java# ls
Common.jar db2java.zip db2jcc.jar db2policy.jar
db2umplugin.jar jdk32
db2dbgm.jar db2jcc4.jar db2jcc_license_cu.jar db2qgjava.jar
itmagent.jar sqlj.zip
i've created new connection pool with params:
Name: DB2
Resource Type: javax.sql.DataSource
Database Vendor: DB2
clicked next, entered under Datasource Classname:
"com.ibm.db2.jcc.DB2DataSource" and clicked finish
when i click ping i get this error:
javax.resource.ResourceException: "Class name is wrong or classpath is
not set for : com.ibm.db2.jcc.DB2DataSource"
com.sun.gjc.common.DataSourceObjectBuilder.getDataSourceObject(DataSourceObjectBuilder.java:258)
com.sun.gjc.common.DataSourceObjectBuilder.constructDataSourceObject(DataSourceObjectBuilder.java:106)
com.sun.gjc.spi.ManagedConnectionFactory.getDataSource(ManagedConnectionFactory.java:967)
com.sun.gjc.spi.DSManagedConnectionFactory.getDataSource(DSManagedConnectionFactory.java:135)
...
where do i need to put /opt/ibm/db2exc/V9.5/java so that glassfish
will include it in path?
Aljosa Mohorovic