I am trying to create a web application with ICEFaces 2.0 as front end on GlassFish v3 with Hibernate 3.6 as JPA 2 provider talking to DB2 v9 on the Mainframe. I am using NetBeans 6.9.1 IDE for this.
I was able to successfully test and configure JDBC connection pool on GlassFish using the DB2 jdbc drivers (db2jcc4.jar and db2jcc_license_cu.jar). I was also able to successfully query DB2 from a standard java application using RESOURCE_LOCAL in persistence.xml.
However, I am not able to query DB2 using Glassfish datasource even though I am able to ping it from the Admin Console. I keep getting the following exception:
Any help would be truly appreciated. I am going nuts trying to figure this thing out. I tried the default EclipseLink that comes with NetBeans and get the same result.
Here is my persistence.xml
subject: Exception on DB2 query with Hibernate JPA2