I've just moved an application from Apple's Enterprise Objects to Hibernate. I'm very pleased so far.

99% of the app is using the ORM facilities. However, I have one class that needs to create and populate a table. That is, I'd like to use java.sql.Statement.executeUpdate() to create the table and then perform inserts.

1) Is there some alternative Hibernate API that accomdates raw JDBC calls? (esp. DDL statements)

2) If not, is there hibernate API that would allow me to check out a connection from Hibernate's connection pool?

3) Or, do I need to set up a separate connection pooling mechanism for this one method?

4) In order to configure pooling only once, should I not take advantage of the pooling abstraction in Hibernate, use an external pooling API and pass connections to Hibernate's SessionFactory?

Note: I tried creating a Session and then using its Connection but got "aborted transaction" exceptions (even after calling connection().commit()). It seemed an unwise approach as I don't know what Hibernate does to the connection.

Thanks!,
- Chris

Session.connection() ?

>Note: I tried creating a Session and then using its Connection (with
>session.connection()) but got "aborted transaction" exceptions (even
>after calling session.connection().commit()). It seemed an unwise
>approach as I don't know what Hibernate does to the connection.

Is there a proper way to use a Session's connection with java.sql.Statments? Do I need to worry about the Transaction API?

For the moment I'm using a second connection pool. I would very much prefer to have only one.

Thanks,
- Chris

Use it exactly the way you would for hibernate persisent object just for JDBC get the connection and perform your operation(s). It will still be wrapped by the same transaction and sundry code.

Any idea why I'm getting "Transaction Aborted" messages with code like the following:

Use the hibernate API for transaction and session manage, ie, only get the connection from the session and do your basic JDBC operations. Other than the data access JDBC operation treat it just as if you are using the hibernate API.