Problem using Hibernate CompositeUserType

[aum sharma]

Hi All,

I am trying to use HibernateCompositeUser type to handle i18n specific data in my application. i am trying to use the below approach.

I have a table named master table which contains all locale independent data while i have created another table master_translation which contains all locale sensitive information. Master table contains a reference to the master_translation.here is the detailed table structure

master
 ---ID
 ---master_translation
 ---Other locale independent fields.

master_translation
 ---ID
 ---language_id
 ---Other locale sensitive fields

now i am using HibernateCompositeUser type to handle this internal process. here is the mapping for master class.

<hibernate-mapping>
    <class name="Master"
        table="MASTER">
        <id name="uuid" type="java.lang.String">
            <column name="UUID" />
            <generator class="uuid" />
        </id>

        <property name="master_i18n" type="masteri18n">
           <column name="NAME"/>
           <column name="SHORTDESCRIPTION"/>
           <column name="LONGDESCRIPTION"/>
    </class>
</hibernate-mapping>

where type="masteri18n" is hibernate CompositeUserType.now when i am fetching the master content it is correctly fetching the data based on the language and my Master class contain a reference to the Master_translation which holding locale specific data. Problem getting started when i am trying to insert the data in to the respectice tables.Here is a code snap shot from the CompositeUserType

@Override
    public void nullSafeSet(PreparedStatement ps, Object arg1, int index,
            SessionImplementor arg3) throws HibernateException, SQLException {

        if(arg1==null){
            //need to handle this case
        }
        else{
             Master_i18n mas=(Master_i18n)arg1;
             //ps.setString(index,mas.getName());
             mas=dao.saveMaster_i18n(mas);
             Hibernate.STRING.nullSafeSet(ps, mas.getUuid(), index);
            //ps.setString(index+1, mas.getShortDescription());
            //ps.setString(index+2, mas.getLongDescription());
            //ps.setString(index+3, mas.getLanguage_id());

        }
    }

what i am trying to do is first saving my Master_i18n and den set it reference in to the Master Though Master_i18n getting saved properly but when it comes to the Master itself hibernate is creating SQL for all the fields which are defined in the Master_i18n

insert 
        into
            poc.Master
            (NAME, SHORTDESCRIPTION, LONGDESCRIPTION, UUID) 
        values
            (?, ?, ?, ?)

and finally its throwing the following exception

Caused by: java.sql.SQLException: No value specified for parameter 2
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:929)
    at com.mysql.jdbc.PreparedStatement.checkAllParametersSet(PreparedStatement.java:2560)
    at com.mysql.jdbc.PreparedStatement.addBatch(PreparedStatement.java:1015)
    at org.hibernate.jdbc.BatchingBatcher.addToBatch(BatchingBatcher.java:53)

i have just started getting familiar with Custom mapping type so not sure what exactly i am doing wrong. Any help/pointer in this regard will be much helpful.