-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 
Author Message
 Post subject: Saving a cleared map
PostPosted: Fri Jun 27, 2008 7:28 pm 
Newbie

Joined: Thu May 08, 2008 7:07 am
Posts: 5
This is a new post of an issue I mentioned previously. This time, I have bit the bullet and decided to show more code.

Hibernate version:

3.2.6.ga (according to the POM file)

Mapping documents:

Code:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="au.com.tt.ccm.beans">

   <class name="Brand" table="brand" schema="public" lazy="false">

      <id name="brandId" column="brand_id">
         <generator class="assigned" />
      </id>
            <!-- other properties deleted -->

      
      <map name="typeFldVals" table="type_value" lazy="false" cascade="save-update,delete-orphan">
        <key column="brand"/>
        <map-key column="type_fld" type="string"/>
        <one-to-many class="TypeFldVal"/>
      </map>      
   </class>
</hibernate-mapping>


Code:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="au.com.tt.ccm.beans">

   <class name="BrandType" table="brand_type"  schema="public">
      <id name="brandTypeId" type="string" column="brand_type_id">
      </id>         
      
       <property name="position"   column="pos"      type="integer"/>
       <property name="hasLinks"   column="has_links"   type="boolean"/>
       <property name="hasBanner"   column="has_banner"   type="boolean"/>
       <property name="xsltFolderLocn"   column="xslt_folder_locn"   type="string"/>
       <property name="description"   column="description"      type="string"/>
       <property name="previewUrl"      column="preview_url"       type="string"/>
      
       <bag name="typeFlds" order-by="pos ASC" lazy="false">
        <key column="brand_type"/>
        <one-to-many class="TypeFld"/>       
      </bag>            
   </class>
</hibernate-mapping>


Code:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="au.com.tt.ccm.beans">

   <class name="TypeFld" table="type_fld"  schema="public">
      <id name="typeFldId" type="string" column="type_fld_id">
      </id>         
       <property name="fldType"    column="fld_type"   type="string"/>
       <property name="position"   column="pos"      type="integer"/>
       <property name="label"      column="label"      type="string"/>
       <property name="help"      column="help"      type="string"/>
       <property name="regexVal"   column="regex_val"   type="string"/>
       <property name="xmlElem"   column="xml_elem"   type="string"/>
       <property name="isRequired"   column="is_required" type="boolean"/>
       <property name="groupParam"   column="group_param" type="string"/>
   </class>
</hibernate-mapping>



Code:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="au.com.tt.ccm.beans">

   <class name="TypeFldValBase" table="type_value"  schema="public">
      <id name="typeFldId" column="type_fld">
         <generator class="assigned" />
      </id>    
      
       <property name="value" column="value"/>
   </class>
</hibernate-mapping>



Code:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="au.com.tt.ccm.beans">

   <class name="TypeFldVal" table="type_value"  schema="public">
      <id name="typeFldId" column="type_fld">
         <generator class="assigned" />
      </id>      
      
       <property name="value" column="value"/>
      
       <many-to-one name="typeFld" class="TypeFld" insert="false" update="false" column="type_fld" lazy="false"/>
   </class>
</hibernate-mapping>


Code:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="au.com.tt.ccm.beans">

   <class name="TypeFldWithVals" table="type_fld"  schema="public">
      <id name="typeFldId" type="string" column="type_fld_id">
      </id>         
       <property name="fldType"    column="fld_type"   type="string"/>
       <property name="position"   column="pos"      type="integer"/>
       <property name="label"      column="label"      type="string"/>
       <property name="help"      column="help"      type="string"/>
       <property name="regexVal"   column="regex_val"   type="string"/>
       <property name="xmlElem"   column="xml_elem"   type="string"/>
       <property name="isRequired"   column="is_required" type="boolean"/>
       <property name="groupParam"   column="group_param" type="string"/>
      
      <set name="typeFldVals" table="type_value" lazy="false">
        <key column="type_fld"/>
        <one-to-many class="TypeFldValBase"/>
      </set>         
   </class>
</hibernate-mapping>


Code:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
   <session-factory>
      <mapping resource="hibernate/Brand.hbm.xml" />
      <mapping resource="hibernate/ExtraEnqField.hbm.xml" />
      <mapping resource="hibernate/BrandType.hbm.xml" />      
      <mapping resource="hibernate/TypeFld.hbm.xml" />
      <mapping resource="hibernate/TypeFldVal.hbm.xml" />
      <mapping resource="hibernate/TypeFldValBase.hbm.xml" />
      <mapping resource="hibernate/TypeFldWithVal.hbm.xml" />
   </session-factory>
</hibernate-configuration>


Code between sessionFactory.openSession() and session.close():

How I get the brand:

Code:
   Session retrieveSession = null;
   Transaction tx = null;   
   Brand result = null;
   
   try
   {
       retrieveSession = mSessionFactory.openSession();
       tx = retrieveSession.beginTransaction();

       result = (Brand) retrieveSession.get(Brand.class, inBrandId, LockMode.NONE);

       tx.commit();   
   }
   catch (RuntimeException e)
   {
       onRuntimeException(tx);
   }
   finally
   {
       retrieveSession.close();
   }
   
   if (result != null)
       result.setBrandTypes(getAllBrandTypes(result));   
   
        return (result);


Code:
  public List<BrandType> getAllBrandTypes(Brand inBrand) throws DAOException
    {
   Session brandTypeSession = null;
   List<BrandType> brandTypeList;
   try
   {
       brandTypeSession = mSessionFactory.openSession();
       Criteria crit = brandTypeSession.createCriteria(BrandType.class).
                        setFetchMode("typeFlds", FetchMode.SELECT).
                        addOrder( Order.asc("position") );

       brandTypeList = (List<BrandType>) crit.list();
       Map<String, TypeFldVal> brandTypeFldValues = inBrand.getTypeFldVals();

       if (inBrand.getBrandId() != null && brandTypeFldValues.size() > 0)
       {
      BrandType currentBrandType = getCurrentBrandType(brandTypeList, inBrand.getCurrentType());

      for (TypeFld typeFld : currentBrandType.getTypeFlds())
      {
          TypeFldVal value = ((TypeFldVal)brandTypeFldValues.get(typeFld.getTypeFldId()));
          if (value != null && value.getValue().length() > 0)
         typeFld.setValue(value.getValue());
      }
       }
   }
   finally
   {
       if (brandTypeSession != null)
      brandTypeSession.close();
   }

   return(brandTypeList);   
    }



How I save the brand

Code:
    public void getNewTypeFlds(Brand inBrand) throws DAOException
    {
   BrandType currentBrandType = getCurrentBrandType(inBrand.getBrandTypes(), inBrand.getCurrentType());
   inBrand.getTypeFldVals().clear();

   for (TypeFld typeFld : currentBrandType.getTypeFlds())
   {
       if (!StringUtils.isBlank(typeFld.getValue()))
       {
      TypeFldVal typeFldVal = new TypeFldVal(typeFld, typeFld.getValue());
      inBrand.getTypeFldVals().put(typeFld.getTypeFldId(), typeFldVal);
       }
   }
    }
   
    BrandType getCurrentBrandType(List<BrandType> inBrandTypes, String inCurrentType) throws DAOException
    {
   if (inCurrentType == null)
       throw new DAOException("Brand Type not specified");
   for (BrandType brandType : inBrandTypes)
   {
       if (brandType.getBrandTypeId().equals(inCurrentType))
      return(brandType);
   }
   
   throw new DAOException("Brand Type " + inCurrentType + " does not exist");
    }



Full stack trace of any exception that occurs:

SEVERE: Exception executing batch:
org.hibernate.jdbc.BatchedTooManyRowsAffectedException: Batch update returned unexpected row count from update [0]; actual row count: 5; expected: 1
at org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:71)
at org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:46)
at org.hibernate.jdbc.BatchingBatcher.checkRowCounts(BatchingBatcher.java:68)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at au.com.tt.ccm.dao.BrandDAO.save(BrandDAO.java:129)
at au.com.tt.ccm.dao.BrandDAOTest.testSavingOfTypeFldsWithCurrentTypeChangedToBrandTypeWithValues(BrandDAOTest.java:293)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.testng.internal.MethodHelper.invokeMethod(MethodHelper.java:580)
at org.testng.internal.Invoker.invokeMethod(Invoker.java:478)
at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:617)
at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:885)
at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:126)
at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:110)
at org.testng.TestRunner.runWorkers(TestRunner.java:712)
at org.testng.TestRunner.privateRun(TestRunner.java:582)
at org.testng.TestRunner.run(TestRunner.java:477)
at org.testng.SuiteRunner.runTest(SuiteRunner.java:324)
at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:319)
at org.testng.SuiteRunner.privateRun(SuiteRunner.java:292)
at org.testng.SuiteRunner.run(SuiteRunner.java:198)
at org.testng.TestNG.createAndRunSuiteRunners(TestNG.java:823)
at org.testng.TestNG.runSuitesLocally(TestNG.java:790)
at org.testng.TestNG.run(TestNG.java:708)
at org.testng.remote.RemoteTestNG.run(RemoteTestNG.java:73)
at org.testng.remote.RemoteTestNG.main(RemoteTestNG.java:124)
28/06/2008 09:13:24 org.hibernate.event.def.AbstractFlushingEventListener performExecutions
SEVERE: Could not synchronize database state with session
org.hibernate.jdbc.BatchedTooManyRowsAffectedException: Batch update returned unexpected row count from update [0]; actual row count: 5; expected: 1
at org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:71)
at org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:46)
at org.hibernate.jdbc.BatchingBatcher.checkRowCounts(BatchingBatcher.java:68)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at au.com.tt.ccm.dao.BrandDAO.save(BrandDAO.java:129)
at au.com.tt.ccm.dao.BrandDAOTest.testSavingOfTypeFldsWithCurrentTypeChangedToBrandTypeWithValues(BrandDAOTest.java:293)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.testng.internal.MethodHelper.invokeMethod(MethodHelper.java:580)
at org.testng.internal.Invoker.invokeMethod(Invoker.java:478)
at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:617)
at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:885)
at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:126)
at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:110)
at org.testng.TestRunner.runWorkers(TestRunner.java:712)
at org.testng.TestRunner.privateRun(TestRunner.java:582)
at org.testng.TestRunner.run(TestRunner.java:477)
at org.testng.SuiteRunner.runTest(SuiteRunner.java:324)
at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:319)
at org.testng.SuiteRunner.privateRun(SuiteRunner.java:292)
at org.testng.SuiteRunner.run(SuiteRunner.java:198)
at org.testng.TestNG.createAndRunSuiteRunners(TestNG.java:823)
at org.testng.TestNG.runSuitesLocally(TestNG.java:790)
at org.testng.TestNG.run(TestNG.java:708)
at org.testng.remote.RemoteTestNG.run(RemoteTestNG.java:73)
at org.testng.remote.RemoteTestNG.main(RemoteTestNG.java:124)

Occurs when I change the brand types.

Name and version of the database you are using:

Testing on HSQL, intended functionality will be on postgresql.

The generated SQL (show_sql=true):

Hibernate:
select
brand0_.brand_id as brand1_12_0_,
brand0_.brand_name as brand2_12_0_,
brand0_.is_active as is3_12_0_,
brand0_.is_bookable as is4_12_0_,
brand0_.agency_code as agency5_12_0_,
brand0_.consultant_id as consultant6_12_0_,
brand0_.webbook_locn as webbook7_12_0_,
brand0_.model_itin as model8_12_0_,
brand0_.bkg_company as bkg9_12_0_,
brand0_.is_agweb_bookable as is10_12_0_,
brand0_.agweb_locn as agweb11_12_0_,
brand0_.is_cdp_bookable as is12_12_0_,
brand0_.cdp_agency_code as cdp13_12_0_,
brand0_.cdp_password as cdp14_12_0_,
brand0_.cdp_locn as cdp15_12_0_,
brand0_.cdp_company as cdp16_12_0_,
brand0_.current_type as current17_12_0_,
brand0_.brand_banner as brand18_12_0_,
brand0_.to_email_addr as to19_12_0_,
brand0_.from_email_addr as from20_12_0_,
brand0_.cc_email_addr as cc21_12_0_
from
public.brand brand0_
where
brand0_.brand_id=?
Hibernate:
select
typefldval0_.brand as brand1_,
typefldval0_.type_fld as type1_1_,
typefldval0_.type_fld as type1_16_0_,
typefldval0_.value as value16_0_
from
public.type_value typefldval0_
where
typefldval0_.brand=?
Hibernate:
select
typefld0_.type_fld_id as type1_15_0_,
typefld0_.fld_type as fld2_15_0_,
typefld0_.pos as pos15_0_,
typefld0_.label as label15_0_,
typefld0_.help as help15_0_,
typefld0_.regex_val as regex6_15_0_,
typefld0_.xml_elem as xml7_15_0_,
typefld0_.is_required as is8_15_0_,
typefld0_.group_param as group9_15_0_
from
public.type_fld typefld0_
where
typefld0_.type_fld_id=?
Hibernate:
select
typefld0_.type_fld_id as type1_15_0_,
typefld0_.fld_type as fld2_15_0_,
typefld0_.pos as pos15_0_,
typefld0_.label as label15_0_,
typefld0_.help as help15_0_,
typefld0_.regex_val as regex6_15_0_,
typefld0_.xml_elem as xml7_15_0_,
typefld0_.is_required as is8_15_0_,
typefld0_.group_param as group9_15_0_
from
public.type_fld typefld0_
where
typefld0_.type_fld_id=?
Hibernate:
select
extraenqfi0_.brand as brand1_,
extraenqfi0_.id as id1_,
extraenqfi0_.id as id13_0_,
extraenqfi0_.label as label13_0_,
extraenqfi0_.display_type as display3_13_0_
from
public.extra_enq_field extraenqfi0_
where
extraenqfi0_.brand=?
Hibernate:
select
this_.brand_type_id as brand1_14_0_,
this_.pos as pos14_0_,
this_.has_links as has3_14_0_,
this_.has_banner as has4_14_0_,
this_.xslt_folder_locn as xslt5_14_0_,
this_.description as descript6_14_0_,
this_.preview_url as preview7_14_0_
from
public.brand_type this_
order by
this_.pos asc
Hibernate:
select
typeflds0_.brand_type as brand10_1_,
typeflds0_.type_fld_id as type1_1_,
typeflds0_.type_fld_id as type1_15_0_,
typeflds0_.fld_type as fld2_15_0_,
typeflds0_.pos as pos15_0_,
typeflds0_.label as label15_0_,
typeflds0_.help as help15_0_,
typeflds0_.regex_val as regex6_15_0_,
typeflds0_.xml_elem as xml7_15_0_,
typeflds0_.is_required as is8_15_0_,
typeflds0_.group_param as group9_15_0_
from
public.type_fld typeflds0_
where
typeflds0_.brand_type=?
order by
typeflds0_.pos ASC
Hibernate:
select
typeflds0_.brand_type as brand10_1_,
typeflds0_.type_fld_id as type1_1_,
typeflds0_.type_fld_id as type1_15_0_,
typeflds0_.fld_type as fld2_15_0_,
typeflds0_.pos as pos15_0_,
typeflds0_.label as label15_0_,
typeflds0_.help as help15_0_,
typeflds0_.regex_val as regex6_15_0_,
typeflds0_.xml_elem as xml7_15_0_,
typeflds0_.is_required as is8_15_0_,
typeflds0_.group_param as group9_15_0_
from
public.type_fld typeflds0_
where
typeflds0_.brand_type=?
order by
typeflds0_.pos ASC
Hibernate:
select
typeflds0_.brand_type as brand10_1_,
typeflds0_.type_fld_id as type1_1_,
typeflds0_.type_fld_id as type1_15_0_,
typeflds0_.fld_type as fld2_15_0_,
typeflds0_.pos as pos15_0_,
typeflds0_.label as label15_0_,
typeflds0_.help as help15_0_,
typeflds0_.regex_val as regex6_15_0_,
typeflds0_.xml_elem as xml7_15_0_,
typeflds0_.is_required as is8_15_0_,
typeflds0_.group_param as group9_15_0_
from
public.type_fld typeflds0_
where
typeflds0_.brand_type=?
order by
typeflds0_.pos ASC
Hibernate:
select
typeflds0_.brand_type as brand10_1_,
typeflds0_.type_fld_id as type1_1_,
typeflds0_.type_fld_id as type1_15_0_,
typeflds0_.fld_type as fld2_15_0_,
typeflds0_.pos as pos15_0_,
typeflds0_.label as label15_0_,
typeflds0_.help as help15_0_,
typeflds0_.regex_val as regex6_15_0_,
typeflds0_.xml_elem as xml7_15_0_,
typeflds0_.is_required as is8_15_0_,
typeflds0_.group_param as group9_15_0_
from
public.type_fld typeflds0_
where
typeflds0_.brand_type=?
order by
typeflds0_.pos ASC
Hibernate:
select
brand_.brand_id,
brand_.brand_name as brand2_12_,
brand_.is_active as is3_12_,
brand_.is_bookable as is4_12_,
brand_.agency_code as agency5_12_,
brand_.consultant_id as consultant6_12_,
brand_.webbook_locn as webbook7_12_,
brand_.model_itin as model8_12_,
brand_.bkg_company as bkg9_12_,
brand_.is_agweb_bookable as is10_12_,
brand_.agweb_locn as agweb11_12_,
brand_.is_cdp_bookable as is12_12_,
brand_.cdp_agency_code as cdp13_12_,
brand_.cdp_password as cdp14_12_,
brand_.cdp_locn as cdp15_12_,
brand_.cdp_company as cdp16_12_,
brand_.current_type as current17_12_,
brand_.brand_banner as brand18_12_,
brand_.to_email_addr as to19_12_,
brand_.from_email_addr as from20_12_,
brand_.cc_email_addr as cc21_12_
from
public.brand brand_
where
brand_.brand_id=?
Hibernate:
select
extraenqfi_.id,
extraenqfi_.label as label13_,
extraenqfi_.display_type as display3_13_
from
public.extra_enq_field extraenqfi_
where
extraenqfi_.id=?
Hibernate:
select
extraenqfi_.id,
extraenqfi_.label as label13_,
extraenqfi_.display_type as display3_13_
from
public.extra_enq_field extraenqfi_
where
extraenqfi_.id=?
Hibernate:
select
extraenqfi_.id,
extraenqfi_.label as label13_,
extraenqfi_.display_type as display3_13_
from
public.extra_enq_field extraenqfi_
where
extraenqfi_.id=?
Hibernate:
select
extraenqfi_.id,
extraenqfi_.label as label13_,
extraenqfi_.display_type as display3_13_
from
public.extra_enq_field extraenqfi_
where
extraenqfi_.id=?
Hibernate:
select
typefldval_.type_fld,
typefldval_.value as value16_
from
public.type_value typefldval_
where
typefldval_.type_fld=?
Hibernate:
select
typefldval_.type_fld,
typefldval_.value as value16_
from
public.type_value typefldval_
where
typefldval_.type_fld=?
Hibernate:
select
typefld_.type_fld_id,
typefld_.fld_type as fld2_15_,
typefld_.pos as pos15_,
typefld_.label as label15_,
typefld_.help as help15_,
typefld_.regex_val as regex6_15_,
typefld_.xml_elem as xml7_15_,
typefld_.is_required as is8_15_,
typefld_.group_param as group9_15_
from
public.type_fld typefld_
where
typefld_.type_fld_id=?
Hibernate:
select
typefldval_.type_fld,
typefldval_.value as value16_
from
public.type_value typefldval_
where
typefldval_.type_fld=?
Hibernate:
select
typefld_.type_fld_id,
typefld_.fld_type as fld2_15_,
typefld_.pos as pos15_,
typefld_.label as label15_,
typefld_.help as help15_,
typefld_.regex_val as regex6_15_,
typefld_.xml_elem as xml7_15_,
typefld_.is_required as is8_15_,
typefld_.group_param as group9_15_
from
public.type_fld typefld_
where
typefld_.type_fld_id=?
Hibernate:
update
public.brand
set
brand_name=?,
is_active=?,
is_bookable=?,
agency_code=?,
consultant_id=?,
webbook_locn=?,
model_itin=?,
bkg_company=?,
is_agweb_bookable=?,
agweb_locn=?,
is_cdp_bookable=?,
cdp_agency_code=?,
cdp_password=?,
cdp_locn=?,
cdp_company=?,
current_type=?,
brand_banner=?,
to_email_addr=?,
from_email_addr=?,
cc_email_addr=?
where
brand_id=?
Hibernate:
update
public.type_value
set
value=?
where
type_fld=?

Debug level Hibernate log excerpt:


Top
 Profile  
 
 Post subject:
PostPosted: Fri Jul 04, 2008 10:28 am 
Expert
Expert

Joined: Tue May 13, 2008 3:42 pm
Posts: 919
Location: Toronto & Ajax Ontario www.hibernatemadeeasy.com
You're hitting multiple rows when you should only be hitting one. Are you sure this should be a multi-row query?

_________________
Cameron McKenzie - Author of "Hibernate Made Easy" and "What is WebSphere?"
http://www.TheBookOnHibernate.com Check out my 'easy to follow' Hibernate & JPA Tutorials


Top
 Profile  
 
 Post subject:
PostPosted: Fri Jul 04, 2008 9:35 pm 
Newbie

Joined: Thu May 08, 2008 7:07 am
Posts: 5
Cameron McKenzie wrote:
You're hitting multiple rows when you should only be hitting one. Are you sure this should be a multi-row query?


Sorry, I don't follow.


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.