File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Object Relational Mapping and the fly likes Exception on DB2 query with Hibernate JPA2 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Exception on DB2 query with Hibernate JPA2" Watch "Exception on DB2 query with Hibernate JPA2" New topic

Exception on DB2 query with Hibernate JPA2

Sib Pete

Joined: Apr 27, 2009
Posts: 26
0 down vote favorite

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

I agree. Here's the link:
subject: Exception on DB2 query with Hibernate JPA2
It's not a secret anymore!