Oracle 11g « Oracle « JPA Q&A

1. oracle 11g hibernate problem

I am changing my database from PostgreSQL to Oracle 11g. I am using hibernate 3.0 with Java and Struts. Everything is working fine with PostgreSQL. I have changed following in hibernate.cfg.xml file.

<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>

2. Method to implement audit trail per row

I want to add two columns to all my tables [Create Time] & [Modify Time] to capture audit trail .In the future these fields might be used in partitioning the table. ...

3. getting incorrect result from Hibernate\Oracle

Tomcat: 5.5
Oracle: 11G(
JDK: 1.6
Hibernate: 3.0.5 The context
We are using Hibernate to get rowcount on a view. The view is written in a way that it will always get at least one ...

4. hibernate 3.6.7 with oracle 11g wrong

I am using hibernate 3.6.7 with oracle 11g It always stuck at get hibernate session. But if the database is empty, hibernate could successfully create table and insert data ...

5. is Hibernate 2.1.7 compatible with Oracle 11g

6. Oracle 11g reconnection?

I'm evaluating Hibernate as a potential JPA solution for a custom application. We would like the application to automatically reconnect cleanly in the case where our Oracle 11g database is restarted. For the sample application I wrote, I get a "recv failed" error when the application attempts to contact the restarted database. If I use c3p0 as follows: props.put("hibernate.c3p0.min_size", "1"); props.put("hibernate.c3p0.max_size", ...