Hibernate is driving me crazy !

[Hussein Baghdadi]

Hi guys.
I'm using WebWork and Hibernate3.2 and MySQL4.X
I have a register form.
When filling the form and press submit, I got the following exception :
Duplicate key or integrity constraint violation,
Yes, I know what you are thinking, I'm dublicating a unique key.
No Sir, I'm not.
After a couple of tries, it saved the form !
Trying again to register another user, I got the exception.

[Paul Sturrock]

Duplicate key or integrity constraint violation,
Yes, I know what you are thinking, I'm dublicating a unique key.
No Sir, I'm not.

Unfortunately, you are. Exceptions like this are SQLExceptions which just report what the database error tells JDBC, Hibernate does not try to enforce any database constraints. If you can tell us a little more about what you are doing, perhaps someone can spot where you are going wrong.

[saranga rao]

hi,

Can You breif tell more about the Excepiton in hibrnate so that we can recognise that issues

[Mark Spritzler]

Here are a few reasons why you might get such an exception.

1. Your mapping is off just a bit, like there is a bi-directional mapping which doesn't have an inverser. Maybe the wrong generated type for the <id> field.

2. You are trying to add a detached object to a Session object that already has that object in the persistence context, and did mot merge the detached object but tried to save() it instead directly.

Can you post your mapping for this object and its related objects, and the code for saving of the object.

Thanks

Mark

[Hussein Baghdadi]

The database schema for the database is generated by Hibernate

CREATE TABLE `billing_details_table` (
  `ID` bigint(20) NOT NULL auto_increment,
  `BILLING_DETAILS_TYPE` varchar(255) NOT NULL default '',
  `VERSION` int(11) NOT NULL default '0',
  `OWNER_EMAIL` varchar(255) NOT NULL default '',
  `NUMBER` varchar(50) NOT NULL default '',
  `PROVIDER` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`ID`)
)
 
CREATE TABLE `user_table` (
  `ID` bigint(20) NOT NULL auto_increment,
  `VERSION` int(11) NOT NULL default '0',
  `FIRST_NAME` varchar(50) NOT NULL default '',
  `LAST_NAME` varchar(50) NOT NULL default '',
  `EMAIL` varchar(80) NOT NULL default '',
  `PASSWORD` tinyblob NOT NULL,
  `LAST_TIME_LOGGED` datetime default NULL,
  `STREET` text,
  `CITY` varchar(50) default NULL,
  `COUNTRY` varchar(255) default NULL,
  `credit_card_id` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `EMAIL` (`EMAIL`),
  UNIQUE KEY `credit_card_id` (`credit_card_id`),
  KEY `email_index` (`EMAIL`),
  KEY `FKC6DD463ACA6D4E40` (`credit_card_id`),
  CONSTRAINT `FKC6DD463ACA6D4E40` FOREIGN KEY (`credit_card_id`) REFERENCES `billing_details_table` (`ID`)
) 

The relationship between User and CreditCard is one-to-one.
The exception seems to origin from a duplicate value of email field of user_table.
No, I'm not entering a duplicate value.
user_table has only one row and I put logging statements to log each value I enter.

[Hussein Baghdadi]

BillingDetails.hbm.xml

<hibernate-mapping package="com.armada.persistence.model" default-access="field">
<class name="BillingDetails" table="BILLING_DETAILS_TABLE" discriminator-value="BD" lazy="true">
<id name="id" column="ID" unsaved-value="null">
<generator class="identity"/>
</id>
        <discriminator column="BILLING_DETAILS_TYPE" type="string"/>
        <version name="version" column="VERSION"/>
        <property name="ownerEmail" column="OWNER_EMAIL" not-null="true" type="string" />
        <subclass name="CreditCard" discriminator-value="CC" lazy="true">
<property name="number" column="NUMBER" type="string" length="50" not-null="true" update="false"/>
            <property name="provider" column="PROVIDER" type="string"
                not-null="true" update="false"/>
        </subclass>
    </class>
/* some named queries

User.hbm.xml

<hibernate-mapping package="com.armada.persistence.model" default-access="field">
<class name="User" table="USER_TABLE" lazy="true">
<id name="id" column="ID" unsaved-value="null">
<generator class="identity"/>
</id>
<version name="version" column="VERSION"/>
<property name="firstName" column="FIRST_NAME" length="50" not-null="true" type="string"/>
<property name="lastName" column="LAST_NAME" length="50" not-null="true" type="string"/>
<property name="email" column="EMAIL" length="80" not-null="true" type="string" update="false"
                  unique="true" index="email_index"/>
        <property name="password" column="PASSWORD" not-null="true" />
        <property name="lastTimeLogged" column="LAST_TIME_LOGGED" type="timestamp"/>
        <component name="address" class="Address">
<property name="street" column="STREET" length="300"/>
<property name="city" column="CITY" length="50"/>
<property name="country" column="COUNTRY" length="255"/>
</component>
<many-to-one name="creditCard" class="CreditCard" cascade="all" unique="true" not-null="true" column="credit_card_id"/>
<set name="orders" table="ORDER_TABLE" cascade="all,delete-orphan" lazy="true" batch-size="5"
             inverse="true">
<key>
<column name="USER_ID" not-null="true"/>
</key>
<one-to-many class="Order"/>
</set>
</class>
/* some named queries

WebWork execute( ) method :

System.out.println("EMAIL: " + user.getEmail( ));
System.out.println("FN: " + user.getFirstName( ));
System.out.println("LN: " + user.getLastName( ));
System.out.println("P: " + user.getPassword( ));
user.getCreditCard( ).setOwnerEmail(user.getEmail( ));
System.out.println("PR: " + user.getCreditCard().getProvider());
System.out.println("NUM: " + user.getCreditCard().getNumber());
System.out.println("EMAIL: " + user.getCreditCard().getOwnerEmail());
generalFacade.register(user);
return Action.SUCCESS;

GeneralFacade Spring bean:

    <bean id="generalFacade" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
        <property name="transactionManager" ref="txManager"/>
        <property name="target" ref="generalFacadeTarget"/>
        <property name="transactionAttributes">
            <props>
                <prop key="get*">PROPAGATION_REQUIRED,readOnly</prop>
                <prop key="register">PROPAGATION_REQUIRED</prop>
            </props>
        </property>
    </bean>

The first time I fill the form, I got an exception from WebWork.
The second time, every thing is perfect.
Trying to add a new user after that, I always got the duplicate value exception.
I'm really tired, I have been trying to solve this for the last 48 hours.

[tom collin]

I want to collect more information about your Exceptions so that I may recognise the problem which you have.
Can you post the detail of your Exceptions?
You could copy the Exceptions in here!

[Hussein Baghdadi]

I solve it !
Hibernate is not guilty, it is my stubidity :roll:
To integerate WebWork with Spring, you have to declare action instances as singleton.
Well, I was not doing so.
So, every time the action executed, there is a User object and it will ask the facade to try to save it to the database again.
Sorry Hibernate.
And hearty thanks for you all.