users@glassfish.java.net

RE: conn. pool for DB2

From: Alex Sherwin <alex.sherwin_at_acadiasoft.com>
Date: Mon, 21 Jul 2008 10:53:09 -0400

Sorry, there is a typo... should be: /path/to/glassfish/domains/domain_name/lib/ext

Also, I forgot to mention, check: glassfish/lib/install/templates/resources/jdbc .. It contains samples of the properties required to make a DataSource work for various db vendors; very thoughtful of the glassfish devs to include :)


Alex Sherwin
alex.sherwin_at_acadiasoft.com


-----Original Message-----
From: Alex Sherwin [mailto:alex.sherwin_at_acadiasoft.com]
Sent: Monday, July 21, 2008 10:49 AM
To: users_at_glassfish.dev.java.net
Subject: RE: conn. pool for DB2

/path/to/glassfish/domain/lib/ext

I believe /path/to/glassfish/lib/ext works for all domains, but I've always used the domain specific folder myself


Alex Sherwin
alex.sherwin_at_acadiasoft.com

-----Original Message-----
From: Aljosa Mohorovic [mailto:aljosa.mohorovic_at_gmail.com]
Sent: Monday, July 21, 2008 10:44 AM
To: users_at_glassfish.dev.java.net
Subject: conn. pool for DB2

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

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
For additional commands, e-mail: users-help_at_glassfish.dev.java.net



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
For additional commands, e-mail: users-help_at_glassfish.dev.java.net