Hi,

I am new to Hibernate. I am developing a domain model in which the inheritance type we are using is JOINED. I have defined unique constraints on the derived class entity.
When I create an object of the derived class and persist it twice, the second persist operation throwing unique constraint violation as expected. So I did not see the second record in the derived entity table. But surprisingly the parent entity table has got two rows.

I used transactions also, but at the time of transaction commit, it is detecting the constraint violation and rolling back only the derived entity changes but not the parent table.

Could someone please explain why this strange behavior?

thanks in advance.
-Madan

I suggest you to log all jdbc-activities using p6spy, and then please report the output.
It will help to analyze what's happening...

Thanks for the help. I tried to set the p6spy in my Jboss 7, but did not work properly. Getting the error saying that could not load the driver com.p6spy.engine.spy.P6SpyDriver.
I copied the p6spa.jar in to the JBOSS_HOME/standalone/lib directory. Also update the spy.properties. But no luck.

Could you please help in setting up the p6spy or any other alternate way to for SQL log.

thanks
Madan

here is my data source definition settings

<datasources>
<datasource jta="false" jndi-name="java:jboss/datasources/oracleDS" pool-name="java:jboss/datasources/oracleDS" use-ccm="false">
<connection-url>jdbc:oracle:thin:@ogo:1521:sioraprd</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<driver>ojdbc6.jar</driver>
<security>
<user-name>bollm1</user-name>
<password>bollm1</password>
</security>
<validation>
<validate-on-match>false</validate-on-match>
<background-validation>false</background-validation>
<background-validation-millis>0</background-validation-millis>
</validation>
<statement>
<prepared-statement-cache-size>0</prepared-statement-cache-size>
<share-prepared-statements>false</share-prepared-statements>
</statement>
</datasource>

I replace the oracle driver class with p6spy driver, it is as follows:

<datasources>
<datasource jta="false" jndi-name="java:jboss/datasources/oracleDS" pool-name="java:jboss/datasources/oracleDS" use-ccm="false">
<connection-url>jdbc:oracle:thin:@ogo:1521:sioraprd</connection-url>
<driver-class>com.p6spy.engine.spy.P6SpyDriver</driver-class>
<driver>ojdbc6.jar</driver>
<security>
<user-name>bollm1</user-name>
<password>bollm1</password>
</security>
<validation>
<validate-on-match>false</validate-on-match>
<background-validation>false</background-validation>
<background-validation-millis>0</background-validation-millis>
</validation>
<statement>
<prepared-statement-cache-size>0</prepared-statement-cache-size>
<share-prepared-statements>false</share-prepared-statements>
</statement>
</datasource>

Can you please check, in which directories ojdbc6.jar is placed ?
The first thing I would do, is to copy p6spy.jar into all directories where there is also a ojdbc6.jar

I copied the p6spy.jar into $JBOSS_HOME/standalone/deployments/
That where I found ojdbc6.jar too.

Hi,
I am having same problem. I have a unique constraint on derived table. Hibernate Save() method still inserts data parent table. I used session.currentTransaction.rollBack(). However this is deleting all the records which got created for that user session.
Can any one suggest a solution.

Thanks
Madhan