-->
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.  [ 7 posts ] 
Author Message
 Post subject: Problem : can't add new one after remove the old collection
PostPosted: Wed Oct 24, 2007 8:30 am 
Newbie

Joined: Wed Oct 24, 2007 6:55 am
Posts: 4
hi, all, I'm a newbie of Hibernate framework. Now I have a problem with my code.
In my design, I use parent-child relation to bind the Club and the Female.
When I wanna do an update with the Club (remove an old one and add an new one),
hibernate always throws an HibernateException (it has showed below),
could someone tell me if there is any wrong with my code or mapping file?
thanks for your help ~~


Hibernate version: Hibernate3.2

Mapping documents:
Code:
  <class name="Club" table="club" schema="test">
     <id name="id" type="long">
        <column name="id" precision="22" scale="0"/>
        <generator class="increment"/>
     </id>
     <property name="name" type="string">
        <column name="name" />
     </property>
     <set name="mbrs" lazy="false" inverse="true" cascade="all-delete-orphan">
        <key column="club_id" not-null="true" />        
        <one-to-many class="com.lienyu.test.Female"/>
     </set>
  </class>

Code:
  <class name="Female" table="female" schema="test">
     <id name="id" type="long">
        <column name="id" precision="22" scale="0"/>
        <generator class="increment"></generator>
     </id>
     <property name="name" type="string" >
        <column name="name"/>
     </property>
     <many-to-one name="club" column="club_id" class="com.lienyu.test.Club" not-null="true" insert="false" update="false" fetch="select"/>
  </class>


Club Table

Code:
CREATE TABLE  `test`.`club` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `name` varchar(45) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


Female Table
Code:
CREATE TABLE  `test`.`female` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `name` varchar(45) NOT NULL,
  `club_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `FK_female_2` (`club_id`),
  CONSTRAINT `FK_female_2` FOREIGN KEY (`club_id`) REFERENCES `club` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Club Class code

Code:
public class Club implements Serializable {

   private static final long serialVersionUID = 2058777410065654772L;
   
   private long id;
   private String name;
   private Set<Female> mbrs = new HashSet<Female>();
   public long getId() {
      return id;
   }
   public void setId(long id) {
      this.id = id;
   }
   public Set<Female> getMbrs() {
      return mbrs;
   }
   public void setMbrs(Set<Female> mbrs) {
      this.mbrs = mbrs;
      for(Iterator<Female> it=mbrs.iterator();it.hasNext();) {
         Female f = it.next();
         f.setClub(this);
      }
   }
   
   public void removeMbrs() {
      for(Iterator<Female> it=mbrs.iterator();it.hasNext();) {
         Female f = it.next();
         it.remove();
         f.setClub(null);
      }
   }
   public String getName() {
      return name;
   }
   public void setName(String name) {
      this.name = name;
   }


Female Class code
Code:
public class Female implements Serializable {

   private static final long serialVersionUID = -7292269537458248759L;
   private long id;
   private String name;
   //private Male husband;
   private Club club;
   public Club getClub() {
      return club;
   }
   public void setClub(Club club) {
      this.club = club;
   }
   public long getId() {
      return id;
   }
   public void setId(long id) {
      this.id = id;
   }
   public String getName() {
      return name;
   }
   public void setName(String name) {
      this.name = name;
   }
}


DAO Code
Code:
public class CourseDAO implements ICourseDAO {
   private TransactionTemplate transactionTemplate;
   private HibernateTemplate hibernateTemplate;
      
   public void setSessionFactory(SessionFactory sessionFactory) {     
      this.transactionTemplate = new TransactionTemplate(new HibernateTransactionManager(sessionFactory)); 
      this.hibernateTemplate = new HibernateTemplate(sessionFactory);
   }
   
   @Override
   public void testClubMbrs() {
      transactionTemplate.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED);
      transactionTemplate.execute(
            new TransactionCallbackWithoutResult() {
               protected void doInTransactionWithoutResult(TransactionStatus status) { 
                  Club c = (Club)hibernateTemplate.load(Club.class, new Long(1));
                  Female f = new Female();
                  f.setName("test");
                  
                  c.removeMbrs();
                  HashSet<Female> mb = new HashSet<Female>();
                  
                  mb.add(f);
                  c.setMbrs(mb);
                  hibernateTemplate.saveOrUpdate(c);
               }
            }
      );            
   }
}


Full stack trace of any exception that occurs:
Quote:
org.springframework.orm.hibernate3.HibernateSystemException: A collection with cascade="all-delete-orphan" was no longer referenced by the owning entity instance: com.lienyu.test.Club.mbrs; nested exception is org.hibernate.HibernateException: A collection with cascade="all-delete-orphan" was no longer referenced by the owning entity instance: com.lienyu.test.Club.mbrs
org.hibernate.HibernateException: A collection with cascade="all-delete-orphan" was no longer referenced by the owning entity instance: com.lienyu.test.Club.mbrs
at org.hibernate.engine.Collections.processDereferencedCollection(Collections.java:96)
at org.hibernate.engine.Collections.processUnreachableCollection(Collections.java:39)
at org.hibernate.event.def.AbstractFlushingEventListener.flushCollections(AbstractFlushingEventListener.java:218)
at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:77)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:26)
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 org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:584)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:500)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:473)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:126)
at com.lienyu.test.dao.CourseDAO.removeClubMbrs(CourseDAO.java:101)
at com.lienyu.test.junit.TestCourseDAO.testDeleteCourse(TestCourseDAO.java:40)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at junit.framework.TestCase.runTest(TestCase.java:164)
at junit.framework.TestCase.runBare(TestCase.java:130)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:120)
at junit.framework.TestSuite.runTest(TestSuite.java:230)
at junit.framework.TestSuite.run(TestSuite.java:225)
at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130)
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)


Name and version of the database you are using:
MySQL 5 Community

The generated SQL (show_sql=true):
Quote:
Hibernate: select club0_.id as id2_0_, club0_.name as name2_0_ from test.club club0_ where club0_.id=?
Hibernate: select mbrs0_.club_id as club3_1_, mbrs0_.id as id1_, mbrs0_.id as id4_0_, mbrs0_.name as name4_0_, mbrs0_.club_id as club3_4_0_ from test.female mbrs0_ where mbrs0_.club_id=?
Hibernate: select max(id) from female


Debug level Hibernate log excerpt:

[quote]DEBUG-2007/10/24 20:14:35- [main] (ClassName:SessionFactoryImpl.java;RolS:177) - instantiating session factory with properties: {java.runtime.name=Java(TM) SE Runtime Environment, sun.boot.library.path=C:\Program Files\Java\jre1.6.0_01\bin, java.vm.version=1.6.0_01-b06, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, user.country=TW, sun.java.launcher=SUN_STANDARD, sun.os.patch.level=Service Pack 2, java.vm.specification.name=Java Virtual Machine Specification, user.dir=D:\CMI\TestBean, java.runtime.version=1.6.0_01-b06, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Program Files\Java\jre1.6.0_01\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\KENNYC~1\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows XP, sun.jnu.encoding=MS950, java.library.path=C:\Program Files\Java\jre1.6.0_01\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\Java\jre1.6.0_02\bin\client;C:\Program Files\Java\jre1.6.0_02\bin;C:\Perl\site\bin;C:\Perl\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Inventec\Dreye\DreyeSA\DreyeTTs\eTTS;C:\Program Files\Common Files\Teleca Shared;C:\Program Files\Ringz Studio\Storm Codec\QTSystem\;C:\Program Files\Common Files\Ulead Systems\MPEG;C:\Program Files\jadnt158, java.specification.name=Java Platform API Specification, java.class.version=50.0, sun.management.compiler=HotSpot Client Compiler, os.version=5.1, user.home=C:\Documents and Settings\kennychen, user.timezone=Asia/Taipei, hibernate.connection.release_mode=on_close, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=MS950, java.specification.version=1.6, java.class.path=D:\CMI\TestBean\build\classes;C:\apache-tomcat-5.5.17\common\lib\commons-el.jar;C:\apache-tomcat-5.5.17\common\lib\jasper-compiler-jdt.jar;C:\apache-tomcat-5.5.17\common\lib\jasper-compiler.jar;C:\apache-tomcat-5.5.17\common\lib\jasper-runtime.jar;C:\apache-tomcat-5.5.17\common\lib\jsp-api.jar;C:\apache-tomcat-5.5.17\common\lib\naming-factory-dbcp.jar;C:\apache-tomcat-5.5.17\common\lib\naming-factory.jar;C:\apache-tomcat-5.5.17\common\lib\naming-resources.jar;C:\apache-tomcat-5.5.17\common\lib\servlet-api.jar;C:\apache-tomcat-5.5.17\common\lib\mysql-connector-java-5.0.4-bin.jar;D:\CMI\TestBean\WebContent\WEB-INF\lib\ant-1.6.5.jar;D:\CMI\TestBean\WebContent\WEB-INF\lib\ant-antlr-1.6.5.jar;D:\CMI\TestBean\WebContent\WEB-INF\lib\ant-junit-1.6.5.jar;D:\CMI\TestBean\WebContent\WEB-INF\lib\ant-launcher-1.6.5.jar;D:\CMI\TestBean\WebContent\WEB-INF\lib\ant-swing-1.6.5.jar;D:\CMI\TestBean\WebContent\WEB-INF\lib\antlr-2.7.6.jar;D:\CMI\TestBean\WebContent\WEB-INF\lib\asm.jar;D:\CMI\TestBean\WebContent\WEB-INF\lib\c3p0-0.9.1.jar;D:\CMI\TestBean\WebContent\WEB-INF\lib\cglib-2.1.3.jar;D:\CMI\TestBean\WebContent\WEB-INF\lib\commons-collections-2.1.1.jar;D:\CMI\TestBean\WebContent\WEB-INF\lib\commons-logging-1.0.4.jar;D:\CMI\TestBean\WebContent\WEB-INF\lib\dom4j-1.6.1.jar;D:\CMI\TestBean\WebContent\WEB-INF\lib\ejb3-persistence.jar;D:\CMI\TestBean\WebContent\WEB-INF\lib\hibernate-annotations.jar;D:\CMI\TestBean\WebContent\WEB-INF\lib\hibernate-commons-annotations.jar;D:\CMI\TestBean\WebContent\WEB-INF\lib\hibernate-entitymanager.jar;D:\CMI\TestBean\WebContent\WEB-INF\lib\hibernate-tools.jar;D:\CMI\TestBean\WebContent\WEB-INF\lib\hibernate-validator.jar;D:\CMI\TestBean\WebContent\WEB-INF\lib\hibernate3.jar;D:\CMI\TestBean\WebContent\WEB-INF\lib\javassist.jar;D:\CMI\TestBean\WebContent\WEB-INF\lib\jboss-archive-browsing.jar;D:\CMI\TestBean\WebContent\WEB-INF\lib\jta.jar;D:\CMI\TestBean\WebContent\WEB-INF\lib\log4j-1.2.11.jar;D:\CMI\TestBean\WebContent\WEB-INF\lib\mysql-connector-java-5.0.4-bin.jar;D:\CMI\TestBean\WebContent\WEB-INF\lib\ojdbc14.jar;D:\CMI\TestBean\WebContent\WEB-INF\lib\spring-mock.jar;D:\CMI\TestBean\WebContent\WEB-INF\lib\spring.jar;C:\eclipse3.3\plugins\org.junit_3.8.2.v200706111738\junit.jar;/C:/eclipse3.3/configuration/org.eclipse.osgi/bundles/206/1/.cp/;/C:/eclipse3.3/configuration/org.eclipse.osgi/bundles/204/1/.cp/, user.name=kennychen, hibernate.bytecode.use_reflection_optimizer=false, hibernate.show_sql=true, java.vm.specification.version=1.0, sun.arch.data.model=32, java.home=C:\Program Files\Java\jre1.6.0_01, hibernate.dialect=org.hibernate.dialect.MySQLDialect, java.specification.vendor=Sun Microsystems Inc., user.language=zh, awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, java.version=1.6.0_01, java.ext.dirs=C:\Program Files\Java\jre1.6.0_01\lib\ext;C:\WINDOWS\Sun\Java\lib\ext, sun.boot.class.path=C:\Program Files\Java\jre1.6.0_01\lib\resources.jar;C:\Program Files\Java\jre1.6.0_01\lib\rt.jar;C:\Program Files\Java\jre1.6.0_01\lib\sunrsasign.jar;C:\Program Files\Java\jre1.6.0_01\lib\jsse.jar;C:\Program Files\Java\jre1.6.0_01\lib\jce.jar;C:\Program Files\Java\jre1.6.0_01\lib\charsets.jar;C:\Program Files\Java\jre1.6.0_01\classes, java.vendor=Sun Microsystems Inc., file.separator=\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, hibernate.connection.provider_class=org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider, sun.cpu.endian=little, sun.io.unicode.encoding=UnicodeLittle, sun.desktop=windows, sun.cpu.isalist=pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86}
DEBUG-2007/10/24 20:14:35- [main] (ClassName:AbstractEntityPersister.java;RolS:2738) - Static SQL for entity: com.lienyu.test.Female
DEBUG-2007/10/24 20:14:35- [main] (ClassName:AbstractEntityPersister.java;RolS:2743) - Version select: select id from test.female where id =?
DEBUG-2007/10/24 20:14:35- [main] (ClassName:AbstractEntityPersister.java;RolS:2746) - Snapshot select: select female_.id, female_.name as name1_ from test.female female_ where female_.id=?
DEBUG-2007/10/24 20:14:35- [main] (ClassName:AbstractEntityPersister.java;RolS:2749) - Insert 0: insert into test.female (name, id) values (?, ?)
DEBUG-2007/10/24 20:14:35- [main] (ClassName:AbstractEntityPersister.java;RolS:2750) - Update 0: update test.female set name=? where id=?
DEBUG-2007/10/24 20:14:35- [main] (ClassName:AbstractEntityPersister.java;RolS:2751) - Delete 0: delete from test.female where id=?
DEBUG-2007/10/24 20:14:35- [main] (ClassName:AbstractEntityPersister.java;RolS:2738) - Static SQL for entity: com.lienyu.test.Club
DEBUG-2007/10/24 20:14:35- [main] (ClassName:AbstractEntityPersister.java;RolS:2743) - Version select: select id from test.club where id =?
DEBUG-2007/10/24 20:14:35- [main] (ClassName:AbstractEntityPersister.java;RolS:2746) - Snapshot select: select club_.id, club_.name as name0_ from test.club club_ where club_.id=?
DEBUG-2007/10/24 20:14:35- [main] (ClassName:AbstractEntityPersister.java;RolS:2749) - Insert 0: insert into test.club (name, id) values (?, ?)
DEBUG-2007/10/24 20:14:35- [main] (ClassName:AbstractEntityPersister.java;RolS:2750) - Update 0: update test.club set name=? where id=?
DEBUG-2007/10/24 20:14:35- [main] (ClassName:AbstractEntityPersister.java;RolS:2751) - Delete 0: delete from test.club where id=?
DEBUG-2007/10/24 20:14:35- [main] (ClassName:AbstractCollectionPersister.java;RolS:548) - Static SQL for collection: com.lienyu.test.Club.mbrs
DEBUG-2007/10/24 20:14:35- [main] (ClassName:AbstractCollectionPersister.java;RolS:550) - Row insert: update test.female set club_id=? where id=?
DEBUG-2007/10/24 20:14:35- [main] (ClassName:AbstractCollectionPersister.java;RolS:556) - Row delete: update test.female set club_id=null where club_id=? and id=?
DEBUG-2007/10/24 20:14:35- [main] (ClassName:AbstractCollectionPersister.java;RolS:559) - One-shot delete: update test.female set club_id=null where club_id=?
DEBUG-2007/10/24 20:14:35- [main] (ClassName:EntityLoader.java;RolS:79) - Static select for entity com.lienyu.test.Female: select female0_.id as id1_0_, female0_.name as name1_0_, female0_.club_id as club3_1_0_ from test.female female0_ where female0_.id=?
DEBUG-2007/10/24 20:14:35- [main] (ClassName:EntityLoader.java;RolS:79) - Static select for entity com.lienyu.test.Female: select female0_.id as id1_0_, female0_.name as name1_0_, female0_.club_id as club3_1_0_ from test.female female0_ where female0_.id=?
DEBUG-2007/10/24 20:14:35- [main] (ClassName:EntityLoader.java;RolS:79) - Static select for entity com.lienyu.test.Female: select female0_.id as id1_0_, female0_.name as name1_0_, female0_.club_id as club3_1_0_ from test.female female0_ where female0_.id=? for update
DEBUG-2007/10/24 20:14:35- [main] (ClassName:EntityLoader.java;RolS:79) - Static select for entity com.lienyu.test.Female: select female0_.id as id1_0_, female0_.name as name1_0_, female0_.club_id as club3_1_0_ from test.female female0_ where female0_.id=? for update
DEBUG-2007/10/24 20:14:35- [main] (ClassName:EntityLoader.java;RolS:79) - Static select for entity com.lienyu.test.Female: select female0_.id as id1_0_, female0_.name as name1_0_, female0_.club_id as club3_1_0_ from test.female female0_ where female0_.id=? for update
DEBUG-2007/10/24 20:14:35- [main] (ClassName:CascadeEntityLoader.java;RolS:34) - Static select for action ACTION_MERGE on entity com.lienyu.test.Female: select female0_.id as id1_0_, female0_.name as name1_0_, female0_.club_id as club3_1_0_ from test.female female0_ where female0_.id=?
DEBUG-2007/10/24 20:14:35- [main] (ClassName:CascadeEntityLoader.java;RolS:34) - Static select for action ACTION_REFRESH on entity com.lienyu.test.Female: select female0_.id as id1_0_, female0_.name as name1_0_, female0_.club_id as club3_1_0_ from test.female female0_ where female0_.id=?
DEBUG-2007/10/24 20:14:35- [main] (ClassName:EntityLoader.java;RolS:79) - Static select for entity com.lienyu.test.Club: select club0_.id as id0_0_, club0_.name as name0_0_ from test.club club0_ where club0_.id=?
DEBUG-2007/10/24 20:14:35- [main] (ClassName:EntityLoader.java;RolS:79) - Static select for entity com.lienyu.test.Club: select club0_.id as id0_0_, club0_.name as name0_0_ from test.club club0_ where club0_.id=?
DEBUG-2007/10/24 20:14:35- [main] (ClassName:EntityLoader.java;RolS:79) - Static select for entity com.lienyu.test.Club: select club0_.id as id0_0_, club0_.name as name0_0_ from test.club club0_ where club0_.id=? for update
DEBUG-2007/10/24 20:14:35- [main] (ClassName:EntityLoader.java;RolS:79) - Static select for entity com.lienyu.test.Club: select club0_.id as id0_0_, club0_.name as name0_0_ from test.club club0_ where club0_.id=? for update
DEBUG-2007/10/24 20:14:35- [main] (ClassName:EntityLoader.java;RolS:79) - Static select for entity com.lienyu.test.Club: select club0_.id as id0_0_, club0_.name as name0_0_ from test.club club0_ where club0_.id=? for update
DEBUG-2007/10/24 20:14:35- [main] (ClassName:CascadeEntityLoader.java;RolS:34) - Static select for action ACTION_MERGE on entity com.lienyu.test.Club: select club0_.id as id0_1_, club0_.name as name0_1_, mbrs1_.club_id as club3_3_, mbrs1_.id as id3_, mbrs1_.id as id1_0_, mbrs1_.name as name1_0_, mbrs1_.club_id as club3_1_0_ from test.club club0_ left outer join test.female mbrs1_ on club0_.id=mbrs1_.club_id where club0_.id=?
DEBUG-2007/10/24 20:14:35- [main] (ClassName:CascadeEntityLoader.java;RolS:34) - Static select for action ACTION_REFRESH on entity com.lienyu.test.Club: select club0_.id as id0_1_, club0_.name as name0_1_, mbrs1_.club_id as club3_3_, mbrs1_.id as id3_, mbrs1_.id as id1_0_, mbrs1_.name as name1_0_, mbrs1_.club_id as club3_1_0_ from test.club club0_ left outer join test.female mbrs1_ on club0_.id=mbrs1_.club_id where club0_.id=?
DEBUG-2007/10/24 20:14:35- [main] (ClassName:OneToManyLoader.java;RolS:64) - Static select for one-to-many com.lienyu.test.Club.mbrs: select mbrs0_.club_id as club3_1_, mbrs0_.id as id1_, mbrs0_.id as id1_0_, mbrs0_.name as name1_0_, mbrs0_.club_id as club3_1_0_ from test.female mbrs0_ where mbrs0_.club_id=?
DEBUG-2007/10/24 20:14:35- [main] (ClassName:SessionFactoryObjectFactory.java;RolS:39) - initializing class SessionFactoryObjectFactory
DEBUG-2007/10/24 20:14:35- [main] (ClassName:SessionFactoryObjectFactory.java;RolS:76) - registered: 4028814615d1ef820115d1ef83a10000 (unnamed)
INFO-2007/10/24 20:14:35- [main] (ClassName:SessionFactoryObjectFactory.java;RolS:82) - Not binding factory to JNDI, no JNDI name configured
DEBUG-2007/10/24 20:14:35- [main] (ClassName:SessionFactoryImpl.java;RolS:308) - instantiated session factory
DEBUG-2007/10/24 20:14:35- [main] (ClassName:SessionFactoryImpl.java;RolS:392) - Checking 0 named HQL queries
DEBUG-2007/10/24 20:14:35- [main] (ClassName:SessionFactoryImpl.java;RolS:412) - Checking 0 named SQL queries
DEBUG-2007/10/24 20:14:35- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:291) - Invoking BeanPostProcessors after initialization of bean 'sessionFactory'
DEBUG-2007/10/24 20:14:35- [main] (ClassName:AbstractBeanFactory.java;RolS:835) - Calling code asked for FactoryBean instance for name 'sessionFactory'
DEBUG-2007/10/24 20:14:35- [main] (ClassName:AbstractBeanFactory.java;RolS:189) - Returning cached instance of singleton bean 'sessionFactory'
DEBUG-2007/10/24 20:14:35- [main] (ClassName:AbstractBeanFactory.java;RolS:818) - Bean with name 'sessionFactory' is a factory bean
DEBUG-2007/10/24 20:14:35- [main] (ClassName:AbstractBeanFactory.java;RolS:229) - Creating shared instance of singleton bean 'courseDAO'
DEBUG-2007/10/24 20:14:35- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:324) - Creating instance of bean 'courseDAO' with merged definition [Root bean: class [com.lienyu.test.dao.CourseDAO]; abstract=false; singleton=true; lazyInit=false; autowire=0; dependencyCheck=0; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in file [D:\CMI\TestBean\WebContent\WEB-INF\spring.xml]]
DEBUG-2007/10/24 20:14:35- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:253) - Invoking BeanPostProcessors before instantiation of bean 'courseDAO'
DEBUG-2007/10/24 20:14:35- [main] (ClassName:CachedIntrospectionResults.java;RolS:148) - Getting BeanInfo for class [com.lienyu.test.dao.CourseDAO]
DEBUG-2007/10/24 20:14:35- [main] (ClassName:CachedIntrospectionResults.java;RolS:164) - Caching PropertyDescriptors for class [com.lienyu.test.dao.CourseDAO]
DEBUG-2007/10/24 20:14:35- [main] (ClassName:CachedIntrospectionResults.java;RolS:172) - Found property 'class' of type [java.lang.Class]
DEBUG-2007/10/24 20:14:35- [main] (ClassName:CachedIntrospectionResults.java;RolS:172) - Found property 'sessionFactory' of type [org.hibernate.SessionFactory]
DEBUG-2007/10/24 20:14:35- [main] (ClassName:CachedIntrospectionResults.java;RolS:90) - Class [com.lienyu.test.dao.CourseDAO] is cache-safe
DEBUG-2007/10/24 20:14:35- [main] (ClassName:CollectionFactory.java;RolS:122) - Falling back to [java.util.HashMap] for linked map
DEBUG-2007/10/24 20:14:35- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:370) - Eagerly caching bean with name 'courseDAO' to allow for resolving potential circular references
DEBUG-2007/10/24 20:14:35- [main] (ClassName:BeanDefinitionValueResolver.java;RolS:169) - Resolving reference from property 'bean property 'sessionFactory'' in bean 'courseDAO' to bean 'sessionFactory'
DEBUG-2007/10/24 20:14:35- [main] (ClassName:CollectionFactory.java;RolS:98) - Falling back to [java.util.HashSet] for linked set
DEBUG-2007/10/24 20:14:35- [main] (ClassName:AbstractBeanFactory.java;RolS:189) - Returning cached instance of singleton bean 'sessionFactory'
DEBUG-2007/10/24 20:14:35- [main] (ClassName:AbstractBeanFactory.java;RolS:818) - Bean with name 'sessionFactory' is a factory bean
DEBUG-2007/10/24 20:14:35- [main] (ClassName:BeanWrapperImpl.java;RolS:701) - About to invoke write method [public void com.lienyu.test.dao.CourseDAO.setSessionFactory(org.hibernate.SessionFactory)] on object of class [com.lienyu.test.dao.CourseDAO]
INFO-2007/10/24 20:14:36- [main] (ClassName:HibernateTransactionManager.java;RolS:396) - Using DataSource [org.springframework.jdbc.datasource.DriverManagerDataSource@1b94ea2] of Hibernate SessionFactory for HibernateTransactionManager
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:709) - Invoked write method [public void com.lienyu.test.dao.CourseDAO.setSessionFactory(org.hibernate.SessionFactory)] with value of type [org.hibernate.SessionFactory]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:272) - Invoking BeanPostProcessors before initialization of bean 'courseDAO'
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:291) - Invoking BeanPostProcessors after initialization of bean 'courseDAO'
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractApplicationContext.java;RolS:215) - Publishing event in context [org.springframework.context.support.FileSystemXmlApplicationContext;hashCode=29103856]: org.springframework.context.event.ContextRefreshedEvent[source=org.springframework.context.support.FileSystemXmlApplicationContext: display name [org.springframework.context.support.FileSystemXmlApplicationContext;hashCode=29103856]; startup date [Wed Oct 24 20:14:34 CST 2007]; root of context hierarchy]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractBeanFactory.java;RolS:189) - Returning cached instance of singleton bean 'courseDAO'
INFO-2007/10/24 20:14:36- [main] (ClassName:JdbcTransactionObjectSupport.java;RolS:60) - JDBC 3.0 Savepoint class is available
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractPlatformTransactionManager.java;RolS:254) - Using transaction object [org.springframework.orm.hibernate3.HibernateTransactionManager$HibernateTransactionObject@1bca1c3]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractPlatformTransactionManager.java;RolS:281) - Creating new transaction with name [null]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:SessionImpl.java;RolS:220) - opened session at timestamp: 11932280760
DEBUG-2007/10/24 20:14:36- [main] (ClassName:HibernateTransactionManager.java;RolS:449) - Opened new Session [org.hibernate.impl.SessionImpl@b11164] for Hibernate transaction
DEBUG-2007/10/24 20:14:36- [main] (ClassName:HibernateTransactionManager.java;RolS:462) - Preparing JDBC Connection of Hibernate Session [org.hibernate.impl.SessionImpl@b11164]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:JDBCTransaction.java;RolS:54) - begin
DEBUG-2007/10/24 20:14:36- [main] (ClassName:ConnectionManager.java;RolS:421) - opening JDBC connection
DEBUG-2007/10/24 20:14:36- [main] (ClassName:DriverManagerDataSource.java;RolS:289) - Creating new JDBC Connection to [jdbc:mysql://localhost:3306/test]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:JDBCTransaction.java;RolS:59) - current autocommit status: true
DEBUG-2007/10/24 20:14:36- [main] (ClassName:JDBCTransaction.java;RolS:62) - disabling autocommit
DEBUG-2007/10/24 20:14:36- [main] (ClassName:JDBCContext.java;RolS:210) - after transaction begin
DEBUG-2007/10/24 20:14:36- [main] (ClassName:HibernateTransactionManager.java;RolS:534) - Exposing Hibernate transaction as JDBC transaction [com.mysql.jdbc.Connection@82c23d]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:TransactionSynchronizationManager.java;RolS:162) - Bound value [org.springframework.jdbc.datasource.ConnectionHolder@9e4585] for key [org.springframework.jdbc.datasource.DriverManagerDataSource@1b94ea2] to thread [main]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:TransactionSynchronizationManager.java;RolS:162) - Bound value [org.springframework.orm.hibernate3.SessionHolder@8917a2] for key [org.hibernate.impl.SessionFactoryImpl@6e9e64] to thread [main]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:TransactionSynchronizationManager.java;RolS:214) - Initializing transaction synchronization
DEBUG-2007/10/24 20:14:36- [main] (ClassName:CollectionFactory.java;RolS:122) - Falling back to [java.util.HashMap] for linked map
INFO-2007/10/24 20:14:36- [main] (ClassName:XmlBeanDefinitionReader.java;RolS:163) - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:XmlBeanDefinitionReader.java;RolS:219) - Using JAXP implementation [com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderFactoryImpl@1ad6c98]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeansDtdResolver.java;RolS:50) - Trying to resolve XML entity with public ID [-//SPRING//DTD BEAN//EN] and system ID [http://www.springframework.org/dtd/spring-beans.dtd]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeansDtdResolver.java;RolS:56) - Trying to locate [spring-beans.dtd] in Spring jar
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeansDtdResolver.java;RolS:64) - Found beans DTD [http://www.springframework.org/dtd/spring-beans.dtd] in classpath
DEBUG-2007/10/24 20:14:36- [main] (ClassName:DefaultXmlBeanDefinitionParser.java;RolS:186) - Loading bean definitions
DEBUG-2007/10/24 20:14:36- [main] (ClassName:DefaultXmlBeanDefinitionParser.java;RolS:191) - Default lazy init 'false'
DEBUG-2007/10/24 20:14:36- [main] (ClassName:DefaultXmlBeanDefinitionParser.java;RolS:192) - Default autowire 'no'
DEBUG-2007/10/24 20:14:36- [main] (ClassName:DefaultXmlBeanDefinitionParser.java;RolS:193) - Default dependency check 'none'
DEBUG-2007/10/24 20:14:36- [main] (ClassName:DefaultXmlBeanDefinitionParser.java;RolS:199) - Found 8 <bean> elements in class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:CollectionFactory.java;RolS:122) - Falling back to [java.util.HashMap] for linked map
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractBeanFactory.java;RolS:229) - Creating shared instance of singleton bean 'DB2'
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:324) - Creating instance of bean 'DB2' with merged definition [Root bean: class [org.springframework.jdbc.support.SQLErrorCodes]; abstract=false; singleton=true; lazyInit=false; autowire=0; dependencyCheck=0; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [org/springframework/jdbc/support/sql-error-codes.xml]]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:253) - Invoking BeanPostProcessors before instantiation of bean 'DB2'
DEBUG-2007/10/24 20:14:36- [main] (ClassName:CachedIntrospectionResults.java;RolS:148) - Getting BeanInfo for class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:CachedIntrospectionResults.java;RolS:164) - Caching PropertyDescriptors for class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:CachedIntrospectionResults.java;RolS:172) - Found property 'badSqlGrammarCodes' of type [[Ljava.lang.String;]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:CachedIntrospectionResults.java;RolS:172) - Found property 'cannotAcquireLockCodes' of type [[Ljava.lang.String;]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:CachedIntrospectionResults.java;RolS:172) - Found property 'cannotSerializeTransactionCodes' of type [[Ljava.lang.String;]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:CachedIntrospectionResults.java;RolS:172) - Found property 'class' of type [java.lang.Class]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:CachedIntrospectionResults.java;RolS:172) - Found property 'customTranslations' of type [[Lorg.springframework.jdbc.support.CustomSQLErrorCodesTranslation;]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:CachedIntrospectionResults.java;RolS:172) - Found property 'dataAccessResourceFailureCodes' of type [[Ljava.lang.String;]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:CachedIntrospectionResults.java;RolS:172) - Found property 'dataIntegrityViolationCodes' of type [[Ljava.lang.String;]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:CachedIntrospectionResults.java;RolS:172) - Found property 'databaseProductName' of type [java.lang.String]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:CachedIntrospectionResults.java;RolS:172) - Found property 'databaseProductNames' of type [[Ljava.lang.String;]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:CachedIntrospectionResults.java;RolS:172) - Found property 'deadlockLoserCodes' of type [[Ljava.lang.String;]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:CachedIntrospectionResults.java;RolS:172) - Found property 'invalidResultSetAccessCodes' of type [[Ljava.lang.String;]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:CachedIntrospectionResults.java;RolS:172) - Found property 'useSqlStateForTranslation' of type [boolean]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:CachedIntrospectionResults.java;RolS:90) - Class [org.springframework.jdbc.support.SQLErrorCodes] is cache-safe
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:370) - Eagerly caching bean with name 'DB2' to allow for resolving potential circular references
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:701) - About to invoke write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDatabaseProductName(java.lang.String)] on object of class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:709) - Invoked write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDatabaseProductName(java.lang.String)] with value of type [java.lang.String]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:877) - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@d1e07c]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:701) - About to invoke write method [public void org.springframework.jdbc.support.SQLErrorCodes.setBadSqlGrammarCodes(java.lang.String[])] on object of class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:709) - Invoked write method [public void org.springframework.jdbc.support.SQLErrorCodes.setBadSqlGrammarCodes(java.lang.String[])] with value of type [[Ljava.lang.String;]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:877) - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@d1e07c]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:701) - About to invoke write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDataAccessResourceFailureCodes(java.lang.String[])] on object of class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:709) - Invoked write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDataAccessResourceFailureCodes(java.lang.String[])] with value of type [[Ljava.lang.String;]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:877) - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@d1e07c]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:701) - About to invoke write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDataIntegrityViolationCodes(java.lang.String[])] on object of class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:709) - Invoked write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDataIntegrityViolationCodes(java.lang.String[])] with value of type [[Ljava.lang.String;]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:877) - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@d1e07c]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:701) - About to invoke write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDeadlockLoserCodes(java.lang.String[])] on object of class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:709) - Invoked write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDeadlockLoserCodes(java.lang.String[])] with value of type [[Ljava.lang.String;]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:272) - Invoking BeanPostProcessors before initialization of bean 'DB2'
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:291) - Invoking BeanPostProcessors after initialization of bean 'DB2'
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractBeanFactory.java;RolS:229) - Creating shared instance of singleton bean 'HSQL'
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:324) - Creating instance of bean 'HSQL' with merged definition [Root bean: class [org.springframework.jdbc.support.SQLErrorCodes]; abstract=false; singleton=true; lazyInit=false; autowire=0; dependencyCheck=0; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [org/springframework/jdbc/support/sql-error-codes.xml]]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:253) - Invoking BeanPostProcessors before instantiation of bean 'HSQL'
DEBUG-2007/10/24 20:14:36- [main] (ClassName:CachedIntrospectionResults.java;RolS:101) - Using cached introspection results for class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:370) - Eagerly caching bean with name 'HSQL' to allow for resolving potential circular references
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:701) - About to invoke write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDatabaseProductName(java.lang.String)] on object of class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:709) - Invoked write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDatabaseProductName(java.lang.String)] with value of type [java.lang.String]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:877) - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@112d7ae]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:701) - About to invoke write method [public void org.springframework.jdbc.support.SQLErrorCodes.setBadSqlGrammarCodes(java.lang.String[])] on object of class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:709) - Invoked write method [public void org.springframework.jdbc.support.SQLErrorCodes.setBadSqlGrammarCodes(java.lang.String[])] with value of type [[Ljava.lang.String;]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:877) - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@112d7ae]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:701) - About to invoke write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDataAccessResourceFailureCodes(java.lang.String[])] on object of class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:709) - Invoked write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDataAccessResourceFailureCodes(java.lang.String[])] with value of type [[Ljava.lang.String;]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:877) - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@112d7ae]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:701) - About to invoke write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDataIntegrityViolationCodes(java.lang.String[])] on object of class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:709) - Invoked write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDataIntegrityViolationCodes(java.lang.String[])] with value of type [[Ljava.lang.String;]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:272) - Invoking BeanPostProcessors before initialization of bean 'HSQL'
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:291) - Invoking BeanPostProcessors after initialization of bean 'HSQL'
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractBeanFactory.java;RolS:229) - Creating shared instance of singleton bean 'MS-SQL'
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:324) - Creating instance of bean 'MS-SQL' with merged definition [Root bean: class [org.springframework.jdbc.support.SQLErrorCodes]; abstract=false; singleton=true; lazyInit=false; autowire=0; dependencyCheck=0; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [org/springframework/jdbc/support/sql-error-codes.xml]]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:253) - Invoking BeanPostProcessors before instantiation of bean 'MS-SQL'
DEBUG-2007/10/24 20:14:36- [main] (ClassName:CachedIntrospectionResults.java;RolS:101) - Using cached introspection results for class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:370) - Eagerly caching bean with name 'MS-SQL' to allow for resolving potential circular references
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:701) - About to invoke write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDatabaseProductName(java.lang.String)] on object of class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:709) - Invoked write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDatabaseProductName(java.lang.String)] with value of type [java.lang.String]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:877) - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@a8a314]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:701) - About to invoke write method [public void org.springframework.jdbc.support.SQLErrorCodes.setBadSqlGrammarCodes(java.lang.String[])] on object of class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:709) - Invoked write method [public void org.springframework.jdbc.support.SQLErrorCodes.setBadSqlGrammarCodes(java.lang.String[])] with value of type [[Ljava.lang.String;]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:877) - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@a8a314]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:701) - About to invoke write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDataIntegrityViolationCodes(java.lang.String[])] on object of class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:709) - Invoked write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDataIntegrityViolationCodes(java.lang.String[])] with value of type [[Ljava.lang.String;]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:877) - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@a8a314]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:701) - About to invoke write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDeadlockLoserCodes(java.lang.String[])] on object of class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:709) - Invoked write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDeadlockLoserCodes(java.lang.String[])] with value of type [[Ljava.lang.String;]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:272) - Invoking BeanPostProcessors before initialization of bean 'MS-SQL'
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:291) - Invoking BeanPostProcessors after initialization of bean 'MS-SQL'
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractBeanFactory.java;RolS:229) - Creating shared instance of singleton bean 'MySQL'
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:324) - Creating instance of bean 'MySQL' with merged definition [Root bean: class [org.springframework.jdbc.support.SQLErrorCodes]; abstract=false; singleton=true; lazyInit=false; autowire=0; dependencyCheck=0; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [org/springframework/jdbc/support/sql-error-codes.xml]]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:253) - Invoking BeanPostProcessors before instantiation of bean 'MySQL'
DEBUG-2007/10/24 20:14:36- [main] (ClassName:CachedIntrospectionResults.java;RolS:101) - Using cached introspection results for class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:370) - Eagerly caching bean with name 'MySQL' to allow for resolving potential circular references
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:877) - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@1786b98]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:701) - About to invoke write method [public void org.springframework.jdbc.support.SQLErrorCodes.setBadSqlGrammarCodes(java.lang.String[])] on object of class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:709) - Invoked write method [public void org.springframework.jdbc.support.SQLErrorCodes.setBadSqlGrammarCodes(java.lang.String[])] with value of type [[Ljava.lang.String;]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:877) - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@1786b98]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:701) - About to invoke write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDataAccessResourceFailureCodes(java.lang.String[])] on object of class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:709) - Invoked write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDataAccessResourceFailureCodes(java.lang.String[])] with value of type [[Ljava.lang.String;]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:877) - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@1786b98]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:701) - About to invoke write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDataIntegrityViolationCodes(java.lang.String[])] on object of class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:709) - Invoked write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDataIntegrityViolationCodes(java.lang.String[])] with value of type [[Ljava.lang.String;]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:877) - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@1786b98]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:701) - About to invoke write method [public void org.springframework.jdbc.support.SQLErrorCodes.setCannotAcquireLockCodes(java.lang.String[])] on object of class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:709) - Invoked write method [public void org.springframework.jdbc.support.SQLErrorCodes.setCannotAcquireLockCodes(java.lang.String[])] with value of type [[Ljava.lang.String;]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:877) - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@1786b98]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:701) - About to invoke write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDeadlockLoserCodes(java.lang.String[])] on object of class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:709) - Invoked write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDeadlockLoserCodes(java.lang.String[])] with value of type [[Ljava.lang.String;]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:272) - Invoking BeanPostProcessors before initialization of bean 'MySQL'
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:291) - Invoking BeanPostProcessors after initialization of bean 'MySQL'
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractBeanFactory.java;RolS:229) - Creating shared instance of singleton bean 'Oracle'
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:324) - Creating instance of bean 'Oracle' with merged definition [Root bean: class [org.springframework.jdbc.support.SQLErrorCodes]; abstract=false; singleton=true; lazyInit=false; autowire=0; dependencyCheck=0; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [org/springframework/jdbc/support/sql-error-codes.xml]]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:253) - Invoking BeanPostProcessors before instantiation of bean 'Oracle'
DEBUG-2007/10/24 20:14:36- [main] (ClassName:CachedIntrospectionResults.java;RolS:101) - Using cached introspection results for class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:370) - Eagerly caching bean with name 'Oracle' to allow for resolving potential circular references
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:877) - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@111ae04]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:701) - About to invoke write method [public void org.springframework.jdbc.support.SQLErrorCodes.setBadSqlGrammarCodes(java.lang.String[])] on object of class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:709) - Invoked write method [public void org.springframework.jdbc.support.SQLErrorCodes.setBadSqlGrammarCodes(java.lang.String[])] with value of type [[Ljava.lang.String;]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:877) - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@111ae04]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:701) - About to invoke write method [public void org.springframework.jdbc.support.SQLErrorCodes.setInvalidResultSetAccessCodes(java.lang.String[])] on object of class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:709) - Invoked write method [public void org.springframework.jdbc.support.SQLErrorCodes.setInvalidResultSetAccessCodes(java.lang.String[])] with value of type [[Ljava.lang.String;]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:877) - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@111ae04]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:701) - About to invoke write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDataAccessResourceFailureCodes(java.lang.String[])] on object of class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:709) - Invoked write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDataAccessResourceFailureCodes(java.lang.String[])] with value of type [[Ljava.lang.String;]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:877) - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@111ae04]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:701) - About to invoke write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDataIntegrityViolationCodes(java.lang.String[])] on object of class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:709) - Invoked write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDataIntegrityViolationCodes(java.lang.String[])] with value of type [[Ljava.lang.String;]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:877) - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@111ae04]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:701) - About to invoke write method [public void org.springframework.jdbc.support.SQLErrorCodes.setCannotAcquireLockCodes(java.lang.String[])] on object of class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:709) - Invoked write method [public void org.springframework.jdbc.support.SQLErrorCodes.setCannotAcquireLockCodes(java.lang.String[])] with value of type [[Ljava.lang.String;]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:877) - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@111ae04]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:701) - About to invoke write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDeadlockLoserCodes(java.lang.String[])] on object of class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:709) - Invoked write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDeadlockLoserCodes(java.lang.String[])] with value of type [[Ljava.lang.String;]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:272) - Invoking BeanPostProcessors before initialization of bean 'Oracle'
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:291) - Invoking BeanPostProcessors after initialization of bean 'Oracle'
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractBeanFactory.java;RolS:229) - Creating shared instance of singleton bean 'Informix'
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:324) - Creating instance of bean 'Informix' with merged definition [Root bean: class [org.springframework.jdbc.support.SQLErrorCodes]; abstract=false; singleton=true; lazyInit=false; autowire=0; dependencyCheck=0; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [org/springframework/jdbc/support/sql-error-codes.xml]]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:253) - Invoking BeanPostProcessors before instantiation of bean 'Informix'
DEBUG-2007/10/24 20:14:36- [main] (ClassName:CachedIntrospectionResults.java;RolS:101) - Using cached introspection results for class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:370) - Eagerly caching bean with name 'Informix' to allow for resolving potential circular references
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:701) - About to invoke write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDatabaseProductName(java.lang.String)] on object of class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:709) - Invoked write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDatabaseProductName(java.lang.String)] with value of type [java.lang.String]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:877) - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@fe30af]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:701) - About to invoke write method [public void org.springframework.jdbc.support.SQLErrorCodes.setBadSqlGrammarCodes(java.lang.String[])] on object of class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:709) - Invoked write method [public void org.springframework.jdbc.support.SQLErrorCodes.setBadSqlGrammarCodes(java.lang.String[])] with value of type [[Ljava.lang.String;]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:877) - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@fe30af]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:701) - About to invoke write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDataIntegrityViolationCodes(java.lang.String[])] on object of class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:709) - Invoked write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDataIntegrityViolationCodes(java.lang.String[])] with value of type [[Ljava.lang.String;]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:272) - Invoking BeanPostProcessors before initialization of bean 'Informix'
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:291) - Invoking BeanPostProcessors after initialization of bean 'Informix'
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractBeanFactory.java;RolS:229) - Creating shared instance of singleton bean 'PostgreSQL'
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:324) - Creating instance of bean 'PostgreSQL' with merged definition [Root bean: class [org.springframework.jdbc.support.SQLErrorCodes]; abstract=false; singleton=true; lazyInit=false; autowire=0; dependencyCheck=0; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [org/springframework/jdbc/support/sql-error-codes.xml]]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:253) - Invoking BeanPostProcessors before instantiation of bean 'PostgreSQL'
DEBUG-2007/10/24 20:14:36- [main] (ClassName:CachedIntrospectionResults.java;RolS:101) - Using cached introspection results for class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:AbstractAutowireCapableBeanFactory.java;RolS:370) - Eagerly caching bean with name 'PostgreSQL' to allow for resolving potential circular references
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:877) - Converting String to [boolean] using property editor [org.springframework.beans.propertyeditors.CustomBooleanEditor@188f506]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:701) - About to invoke write method [public void org.springframework.jdbc.support.SQLErrorCodes.setUseSqlStateForTranslation(boolean)] on object of class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:709) - Invoked write method [public void org.springframework.jdbc.support.SQLErrorCodes.setUseSqlStateForTranslation(boolean)] with value of type [boolean]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:877) - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@8e85b5]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:701) - About to invoke write method [public void org.springframework.jdbc.support.SQLErrorCodes.setBadSqlGrammarCodes(java.lang.String[])] on object of class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:709) - Invoked write method [public void org.springframework.jdbc.support.SQLErrorCodes.setBadSqlGrammarCodes(java.lang.String[])] with value of type [[Ljava.lang.String;]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:877) - Converting String to [class [Ljava.lang.String;] using property editor [org.springframework.beans.propertyeditors.StringArrayPropertyEditor@8e85b5]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanWrapperImpl.java;RolS:701) - About to invoke write method [public void org.springframework.jdbc.support.SQLErrorCodes.setDataIntegrityViolationCodes(java.lang.String[])] on object of class [org.springframework.jdbc.support.SQLErrorCodes]
DEBUG-2007/10/24 20:14:36- [main] (ClassName:BeanW


Top
 Profile  
 
 Post subject:
PostPosted: Wed Oct 24, 2007 5:05 pm 
Newbie

Joined: Mon Apr 30, 2007 12:27 pm
Posts: 18
I think you have to specify one end in the relation. You do that by either putting invere='true' in your set or insert="false" update="false" in your many-to-one, but not in both.

Try changing it, but you have to decide which end you want to set as inverse, because 'Changes made only to the inverse end of the association are not persisted'

Read
http://www.hibernate.org/hib_docs/reference/en/html/associations.html#assoc-bidirectional
http://www.hibernate.org/hib_docs/reference/en/html/collections.html#collections-bidirectional


Top
 Profile  
 
 Post subject:
PostPosted: Thu Oct 25, 2007 12:17 am 
Newbie

Joined: Wed Oct 24, 2007 6:55 am
Posts: 4
Thanks for moving to dublin's help, I've read those 2 paragraphs you recommended and also changed my mapping file like this, see below. But this change was still working fine as I wished. I did a simple experiment on seperating the steps(remove and add) into 2 steps, I found that even removing was executed alone, it couldn't worked fine. >.<...I've been confused by this problem for couple of days...=.=
Club.hbm.xml
Code:
  <class name="Club" table="club" schema="test">
     <id name="id" type="long">
        <column name="id" precision="22" scale="0"/>
        <generator class="increment"/>
     </id>
     <property name="name" type="string">
        <column name="name" />
     </property>
     <set name="mbrs" lazy="false" inverse="true" cascade="all-delete-orphan">
        <key column="club_id" not-null="true" />         
        <one-to-many class="com.lienyu.test.Female"/>
     </set>
  </class>


Female.hbm.xml
Code:
  <class name="Female" table="female" schema="test">
     <id name="id" type="long">
        <column name="id" precision="22" scale="0"/>
        <generator class="increment"></generator>
     </id>
     <property name="name" type="string" >
        <column name="name"/>
     </property>
     <many-to-one name="club" column="club_id" class="com.lienyu.test.Club" not-null="true" fetch="select"/>
  </class>


Top
 Profile  
 
 Post subject:
PostPosted: Thu Oct 25, 2007 12:20 am 
Newbie

Joined: Wed Oct 24, 2007 6:55 am
Posts: 4
Thanks for moving to dublin's help, I've read those 2 paragraphs you recommended and also changed my mapping file like this, see below. But this change still didn't work fine as I wished. I did a simple experiment on seperating the steps(remove and add) into 2 steps, I found that even removing was executed alone, it couldn't worked fine. >.<...I've been confused by this problem for couple of days...=.=
Club.hbm.xml
Code:
  <class name="Club" table="club" schema="test">
     <id name="id" type="long">
        <column name="id" precision="22" scale="0"/>
        <generator class="increment"/>
     </id>
     <property name="name" type="string">
        <column name="name" />
     </property>
     <set name="mbrs" lazy="false" inverse="true" cascade="all-delete-orphan">
        <key column="club_id" not-null="true" />         
        <one-to-many class="com.lienyu.test.Female"/>
     </set>
  </class>


Female.hbm.xml
Code:
  <class name="Female" table="female" schema="test">
     <id name="id" type="long">
        <column name="id" precision="22" scale="0"/>
        <generator class="increment"></generator>
     </id>
     <property name="name" type="string" >
        <column name="name"/>
     </property>
     <many-to-one name="club" column="club_id" class="com.lienyu.test.Club" not-null="true" fetch="select"/>
  </class>


Top
 Profile  
 
 Post subject:
PostPosted: Thu Oct 25, 2007 3:40 pm 
Newbie

Joined: Mon Apr 30, 2007 12:27 pm
Posts: 18
Sorry, I never looked at your DAO, I just saw that error in the mapping and never kept reading.

Try to merge, instead saveOrUpdate and see if that works.

I think it has to do with the state of the objects. I don't know if you are using any transaction manager with your spring managed hibernateTemplate, but if you load the object, and close the session (default behaviour), this object will be detached.

So, you kinda have to merge the object with the session, so the state of the object is propagated.

My guess, switch saveOrUpdate to merge and see how it goes.


Top
 Profile  
 
 Post subject:
PostPosted: Thu Oct 25, 2007 3:47 pm 
Newbie

Joined: Mon Apr 30, 2007 12:27 pm
Posts: 18
By the way, if this doesnt work, try the update method.
(I don't know how the hibernateTemplate really works, even though I use it at all times :) )

I also recommend you this reading:
http://www.hibernate.org/hib_docs/reference/en/html/objectstate.html#objectstate-detached


Top
 Profile  
 
 Post subject:
PostPosted: Thu Oct 25, 2007 10:21 pm 
Newbie

Joined: Wed Oct 24, 2007 6:55 am
Posts: 4
thanks moving to dublin,
I finally found the solution, that problem is my POJO. I just change the setter of collection like this.
from
Code:
   public void setMbrs(Set<Female> mbrs) {
      this.mbrs = mbrs;
      for(Iterator<Female> it=mbrs.iterator();it.hasNext();) {
         Female f = it.next();
         f.setClub(this);
      }
   }


to
Code:
   public void setMbrs(Set<Female> mbrs) {
   this.mbrs = mbrs;
   }

I found this solution from Google, but I don't know why ~~ =.=....


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 7 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.