OpenEdge 10.2B JDBC and Hibernate

Posted by sedge on 10-Nov-2011 20:55

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.



All Replies

Posted by nuk2002uk on 10-Nov-2011 22:18

I don't know hibernate but as you are trying to connect to the openedge database, could you include the database log, the details (startup parameters) of the openedge broker/servers you have configured to accept a JDBC request, ie are you running 4GL only brokers? have you got the ruight port number? etc

having no openedge artifacts makes it kind of hard to help on an openedge connection issue.

Lots of work on SQL performance in Opendge, I think on the read side, not aware of issues with write.



This thread is closed