After I solved the problem with the informix-db, I try to use glassfish with out mainframe-db. Therefore I wrote a test-ds-programm, which runs very well:
private void testDatasourceDB2(){
Connection con = null;
try {
com.ibm.db2.jcc.DB2DataSource ds = new com.ibm.db2.jcc.DB2DataSource();
ds.setUser("b270308");
ds.setPassword("pass");
ds.setDatabaseName("ldbeg");
ds.setDeferPrepares(false);
con = ds.getConnection();
System.out.println("Datasource und Connection erzeugt: " + ds.toString());
} catch (SQLException ex) {
ex.printStackTrace();
} finally{
if (con != null){
try {
con.close();
} catch (SQLException ex) {
ex.printStackTrace();
}
}
}
}
Now, I try to configure a datasource within glassfish:
<jdbc-connection-pool allow-non-component-callers="false" associate-with-thread="false" connection-creation-retry-attempts="0" connection-creation-retry-interval-in-seconds="10" connection-leak-reclaim="false" connection-leak-timeout-in-seconds="0" connection-validation-method="auto-commit" datasource-classname="com.ibm.db2.jcc.DB2DataSource" fail-all-connections="false" idle-timeout-in-seconds="300" is-connection-validation-required="false" is-isolation-level-guaranteed="false" lazy-connection-association="false" lazy-connection-enlistment="false" match-connections="false" max-connection-usage-count="0" max-pool-size="32" max-wait-time-in-millis="60000" name="DB2Pool" non-transactional-connections="false" pool-resize-quantity="2" res-type="javax.sql.DataSource" statement-timeout-in-seconds="-1" steady-pool-size="8" validate-atmost-once-period-in-seconds="0" wrap-jdbc-objects="false">
<description>DB2 Mainframe</description>
<property name="user" value="b270308"/>
<property name="password" value="pass"/>
<property name="databaseName" value="ldbeg"/>
<property name="deferPrepares" value="false"/>
</jdbc-connection-pool>
But: I got an exception:
com.ibm.db2.jcc.a.SqlException: Failure in loading T2 native library db2jcct2
at com.ibm.db2.jcc.t2.a.a(a.java:31)
at com.ibm.db2.jcc.t2.T2Configuration.<clinit>(T2Configuration.java:74)
at com.ibm.db2.jcc.DB2DataSource.getSimpleConnection(DB2DataSource.java:96)
at com.ibm.db2.jcc.DB2DataSource.getConnection(DB2DataSource.java:65)
at com.ibm.db2.jcc.DB2DataSource.getConnection(DB2DataSource.java:47)
at com.sun.gjc.spi.DSManagedConnectionFactory.createManagedConnection(DSManagedConnectionFactory.java:107)
at com.sun.enterprise.connectors.ConnectorConnectionPoolAdminServiceImpl.getUnpooledConnection(ConnectorConnectionPoolAdminServiceImpl.java:1220)
at com.sun.enterprise.connectors.ConnectorConnectionPoolAdminServiceImpl.testConnectionPool(ConnectorConnectionPoolAdminServiceImpl.java:551)
at com.sun.enterprise.connectors.ConnectorRuntime.testConnectionPool(ConnectorRuntime.java:499)
at com.sun.enterprise.admin.mbeans.ResourcesMBean.pingConnectionPool(ResourcesMBean.java:2339)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
I tryed to set the missing env-vars in the start-script:
set LD_LIBRARY_PATH=C:\Programme\IBM\DB2\SQLLIB;D:\home\270308\prg\glassfish\lib
set VWSPATH=C:\Programme\IBM\DB2\SQLLIB
set THREADS_FLAG=native
but without success.
Is there somebody, who can help me?
Peter
[Message sent by forum member 'pecabo' (pecabo)]
http://forums.java.net/jive/thread.jspa?messageID=231980