I'm trying to get Sun One App 7 to work with DB2.
I get the following error when I try and access Enity beans mapped to the DB2 database.
WARNING: Cannot get database metadata: database product name.
java.lang.ClassCastException at com.sun.enterprise.resource.JdbcUrlAllocator.createResource(JdbcUrlAl
locator.java:80)
...
...
...
Here is the pool properties:
<jdbc-connection-pool steady-pool-size="8" max-pool-size="32" max-wait-time-in-millis="60000" pool-resize-quantity="2" idle-timeout-in-seconds="300" is-isolation-level-guaranteed="true" is-connection-validation-required="false" connection-validation-method="auto-commit" fail-all-connections="false" datasource-classname="COM.ibm.db2.jdbc.DB2ConnectionPoolDataSource" name="DB2Pool" validation-table-name="TAB_NAME" res-type="javax.sql.DataSource">
<property value="db2admin" name="User"/>
<property value="db2admin" name="Password"/>
<property value="jdbc:db2:TIMETRAC" name="DatabaseName"/>
</jdbc-connection-pool>
The Persistence Manager tagged to the CMP beans uses this DB pool, but since I get the strange error, the rest fails and I get JDO in findByPrimKey.
Does anyone have the settings for using DB2 8.1 with Sun App server, or have seen a similar problem with another vendor? If I use the COM.ibm.db2.jdbc.app.DB2Driver I get another error about db2jdbc blah blah. What gives, rivalry?
db2java.zip is in class path
Beans work fine with the bundled Pointbase btw....
Please help, can't find anything on Google.