OpenEdge 10.2B JDBC and Hibernate

We're a Progress shop and we're doing a development with Sonic 8.5. We need a database to support the Sonic application and have opted to use Hibernate (3.6) for entity persistance.

The jury is still out on which DB we'll use. There are distinct advantages in using OpenEdge because it will allow access to the ESB database directly from our ERP application but we've left the options open to use PostgreSQL as well.

Earlier this year we got Hibernate working with OpenEdge and all looked sweet. We specifically worked to ensure that we could seamlessly switch between PostgreSQL and OpenEdge and opted to use PostgreSQL during develpment because the SQL tools were better than for OpenEdge.

Now we've done most of the development we want to make the decision about whether to use OpenEdge or PostgreSQL. The decision critera are basically:
- Does OpenEdge work with JDBC and Hibernate?
- Does OpenEdge in this environment give us acceptable performance in comparison to PostgreSQL
If we get a "yes" to both of these we'll use OpenEdge.

I'm having trouble getting the application working with OpenEdge and the problem appears to be related to the managing sessions. In the Container Log I see errors like:

ID=dev_ESBTest (warning) [] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1d54d9a -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception: java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver]OE Broker fails to find a server available for connecting .

We're using C3PO for Connection Pooling.

The JDBC Drivers are openedge.jar and pool.jar from the <OpenEdgeRoot>/java directory.

Fathom reports: Progress Version 10.2B0200 1334

I've attached an extract from the Container Log and our Hibernate configuration properties.

Can anyone suggest how we can get OpenEdge to play the game?

I'd also be interested in any feedback relating to OpenEdge SQL performance, noting that this is mainly a "write" database and tables are not highly volatile.

Thanks

Steve

OpenEdgeHibernate.zip