-->
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.  [ 2 posts ] 
Author Message
 Post subject: Referential Integrity Problem when try to save
PostPosted: Mon May 12, 2008 12:32 pm 
Newbie

Joined: Mon May 12, 2008 12:16 pm
Posts: 7
Hi

I am new to this tech, I am trying to save a relation Customer, Cust_Contact
where Cust_Contact has got Cust_ID as FK. I am trying to save the relation but getting Parent Key not found error;

Below are the files and error log, please suggest;

Contact.hbm.xml
--------------------

<?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>
<class
name="com.wonder.common.Contact"
entity-name="EmpContacts"
table="EMP_CONTACT">
<id
name="id"
type="long"
column="CONTACT_ID">
<generator class="sequence">
<param name="sequence">ID_SEQ</param>
</generator>
</id>
<property name="homePhone">
<column name="HOME" />
</property>
<property name="officePhone">
<column name="OFFICE" />
</property>
<property name="mobile">
<column name="MOBILE" />
</property>
<property name="fax">
<column name="FAX" />
</property>
<property name="email">
<column name="EMAIL" />
</property>
</class>

<class
name="com.wonder.common.Contact"
entity-name="CustContacts"
table="CUST_CONTACT">
<id
name="id"
type="long"
column="CONTACT_ID">
<generator class="sequence">
<param name="sequence">ID_SEQ</param>
</generator>
</id>
<property name="homePhone">
<column name="HOME" />
</property>
<property name="officePhone">
<column name="OFFICE" />
</property>
<property name="mobile">
<column name="MOBILE" />
</property>
<property name="fax">
<column name="FAX" />
</property>
<property name="email">
<column name="EMAIL" />
</property>
</class>
</hibernate-mapping>

----------------------------------------------------------------------------------

Customer.hbm.xml
----------------------

<?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>
<class
name="com.wonder.common.Customer"
table="CUSTOMER">
<id
name="id"
type="long"
column="CUST_ID">
<generator class="sequence">
<param name="sequence">ID_SEQ</param>
</generator>
</id>
<property name="fName">
<column name="FIRST_NAME" />
</property>
<property name="lName">
<column name="LAST_NAME" />
</property>
<property name="gender">
<column name="GENDER" />
</property>
<property name="businessTitle">
<column name="BUSINESS_TITLE" />
</property>
<property name="customerNumber">
<column name="CUST_NO" />
</property>
<property name="regDate">
<column name="REG_DATE" />
</property>
<set
name="contact"
cascade="save-update,persist">
<key
column="CUST_ID"
not-null="true" />
<one-to-many
class="com.wonder.common.Contact"
entity-name="CustContacts" />
</set>
<set
name="address"
table="CUST_ADDRESS"
cascade="save-update,persist">
<key column="CUST_ID" />
<many-to-many
column="ADDRESS_ID"
class="com.wonder.common.Address" />
</set>
<!-- <one-to-one name="account class= com.wonder.common.Account"></one-to-one> -->
</class>
</hibernate-mapping>


---------------------------------------------------------------------------------

Error Log
-----------

0 [main] DEBUG com.wonder.settings.HibernateUtil - Initializing Hibernate
47 [main] INFO org.hibernate.cfg.Environment - Hibernate 3.2.0
47 [main] INFO org.hibernate.cfg.Environment - hibernate.properties not found
63 [main] INFO org.hibernate.cfg.Environment - Bytecode provider name : cglib
63 [main] INFO org.hibernate.cfg.Environment - using JDK 1.4 java.sql.Timestamp handling
172 [main] INFO org.hibernate.cfg.Configuration - configuring from resource: /hibernate.cfg.xml
172 [main] INFO org.hibernate.cfg.Configuration - Configuration resource: /hibernate.cfg.xml
594 [main] DEBUG org.hibernate.util.DTDEntityResolver - trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd]
594 [main] DEBUG org.hibernate.util.DTDEntityResolver - recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
594 [main] DEBUG org.hibernate.util.DTDEntityResolver - located [http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd] in classpath
657 [main] DEBUG org.hibernate.cfg.Configuration - connection.url=jdbc:oracle:thin:@localhost:1521:XE
657 [main] DEBUG org.hibernate.cfg.Configuration - connection.driver_class=oracle.jdbc.driver.OracleDriver
657 [main] DEBUG org.hibernate.cfg.Configuration - connection.username=wonder
657 [main] DEBUG org.hibernate.cfg.Configuration - connection.password=wonder
657 [main] DEBUG org.hibernate.cfg.Configuration - connection.autocommit=true
657 [main] DEBUG org.hibernate.cfg.Configuration - dialect=org.hibernate.dialect.OracleDialect
672 [main] DEBUG org.hibernate.cfg.Configuration - show_sql=true
672 [main] DEBUG org.hibernate.cfg.Configuration - format_sql=true
672 [main] DEBUG org.hibernate.cfg.Configuration - use_sql_comments=true
672 [main] DEBUG org.hibernate.cfg.Configuration - null<-org.dom4j.tree.DefaultAttribute@157c2bd [Attribute: name resource value "customer.hbm.xml"]
672 [main] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: customer.hbm.xml
672 [main] DEBUG org.hibernate.util.DTDEntityResolver - trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd]
672 [main] DEBUG org.hibernate.util.DTDEntityResolver - recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
672 [main] DEBUG org.hibernate.util.DTDEntityResolver - located [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd] in classpath
860 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: com.wonder.common.Customer -> CUSTOMER
860 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: id -> CUST_ID
922 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: fName -> FIRST_NAME
922 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: lName -> LAST_NAME
922 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: gender -> GENDER
922 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: businessTitle -> BUSINESS_TITLE
922 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: customerNumber -> CUST_NO
922 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: regDate -> REG_DATE
938 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: contact
938 [main] INFO org.hibernate.cfg.HbmBinder - Mapping collection: com.wonder.common.Customer.address -> CUST_ADDRESS
938 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: address
938 [main] DEBUG org.hibernate.cfg.Configuration - null<-org.dom4j.tree.DefaultAttribute@f6438d [Attribute: name resource value "employee.hbm.xml"]
938 [main] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: employee.hbm.xml
938 [main] DEBUG org.hibernate.util.DTDEntityResolver - trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd]
938 [main] DEBUG org.hibernate.util.DTDEntityResolver - recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
938 [main] DEBUG org.hibernate.util.DTDEntityResolver - located [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd] in classpath
985 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: com.wonder.common.Employee -> EMPLOYEE
1000 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: id -> EMP_ID
1000 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: fName -> FIRST_NAME
1000 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: lName -> LAST_NAME
1000 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: gender -> GENDER
1000 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: age -> AGE
1000 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: dob -> DOB
1000 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: niNumber -> NI_NO
1000 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: empNumber -> EMP_NO
1000 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: department -> DEPT
1000 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: startDate -> START_DATE
1000 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: designation -> DESIGNATION
1000 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: extNumber -> EXT_NO
1000 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: contact
1000 [main] INFO org.hibernate.cfg.HbmBinder - Mapping collection: com.wonder.common.Employee.address -> EMP_ADDRESS
1000 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: address
1000 [main] DEBUG org.hibernate.cfg.Configuration - null<-org.dom4j.tree.DefaultAttribute@1632847 [Attribute: name resource value "address.hbm.xml"]
1000 [main] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: address.hbm.xml
1000 [main] DEBUG org.hibernate.util.DTDEntityResolver - trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd]
1000 [main] DEBUG org.hibernate.util.DTDEntityResolver - recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
1000 [main] DEBUG org.hibernate.util.DTDEntityResolver - located [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd] in classpath
1063 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: com.wonder.common.Address -> ADDRESS
1063 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: id -> ADDRESS_ID
1063 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: Type -> TYPE
1063 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: Street -> STREET
1063 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: Road -> ROAD
1063 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: City -> CITY
1063 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: Postcode -> POSTCODE
1063 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: Country -> COUNTRY
1063 [main] DEBUG org.hibernate.cfg.Configuration - null<-org.dom4j.tree.DefaultAttribute@18b81e3 [Attribute: name resource value "contact.hbm.xml"]
1063 [main] INFO org.hibernate.cfg.Configuration - Reading mappings from resource: contact.hbm.xml
1063 [main] DEBUG org.hibernate.util.DTDEntityResolver - trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd]
1063 [main] DEBUG org.hibernate.util.DTDEntityResolver - recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
1063 [main] DEBUG org.hibernate.util.DTDEntityResolver - located [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd] in classpath
1094 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: EmpContacts -> EMP_CONTACT
1094 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: id -> CONTACT_ID
1094 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: homePhone -> HOME
1094 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: officePhone -> OFFICE
1094 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: mobile -> MOBILE
1094 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: fax -> FAX
1094 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: email -> EMAIL
1094 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: CustContacts -> CUST_CONTACT
1094 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: id -> CONTACT_ID
1094 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: homePhone -> HOME
1094 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: officePhone -> OFFICE
1094 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: mobile -> MOBILE
1094 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: fax -> FAX
1094 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: email -> EMAIL
1094 [main] INFO org.hibernate.cfg.Configuration - Configured SessionFactory: null
1094 [main] DEBUG org.hibernate.cfg.Configuration - properties: {hibernate.connection.password=wonder, java.runtime.name=Java(TM) SE Runtime Environment, sun.boot.library.path=C:\Program Files\Java\jre1.6.0_03\bin, java.vm.version=1.6.0_03-b05, hibernate.connection.username=wonder, 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=US, sun.java.launcher=SUN_STANDARD, sun.os.patch.level=Service Pack 2, java.vm.specification.name=Java Virtual Machine Specification, user.dir=H:\eclipseProjects\workspace\WonderSales, java.runtime.version=1.6.0_03-b05, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Program Files\Java\jre1.6.0_03\lib\endorsed, os.arch=x86, hibernate.connection.autocommit=true, java.io.tmpdir=C:\DOCUME~1\KASHIF~1\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows XP, use_sql_comments=true, sun.jnu.encoding=Cp1252, java.library.path=C:\Program Files\Java\jre1.6.0_03\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;E:\oraclexe\app\oracle\product\10.2.0\server\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\QuickTime\QTSystem\;H:\JavaSoftwares\ant-1.6.5\bin;C:\Program Files\Java\jdk1.6.0\bin, java.specification.name=Java Platform API Specification, java.class.version=50.0, sun.management.compiler=HotSpot Client Compiler, os.version=5.1, connection.password=wonder, user.home=C:\Documents and Settings\Kashif Mughal, user.timezone=, connection.username=wonder, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.6, hibernate.format_sql=true, hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver, show_sql=true, user.name=Kashif Mughal, java.class.path=H:\eclipseProjects\workspace\WonderSales\build\classes;H:\JavaSoftwares\jBossAS\jboss-4.0.4.GA\client\jboss-j2ee.jar;H:\JavaSoftwares\jBossAS\jboss-4.0.4.GA\client\jbossall-client.jar;H:\JavaSoftwares\jBossAS\jboss-4.0.4.GA\server\default\lib\javax.servlet.jar;H:\JavaSoftwares\jBossAS\jboss-4.0.4.GA\server\default\lib\javax.servlet.jsp.jar;H:\JavaSoftwares\jBossAS\jboss-4.0.4.GA\server\default\lib\activation.jar;H:\JavaSoftwares\jBossAS\jboss-4.0.4.GA\server\default\lib\mail.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\activation.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\ant-1.6.5.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\ant-antlr-1.6.5.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\ant-junit-1.6.5.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\ant-launcher-1.6.5.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\ant-swing-1.6.5.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\antlr-2.7.6.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\antlr-2.7.6rc1.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\asm-attrs.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\asm.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\c3p0-0.9.0.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\cglib-2.1.3.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\checkstyle-all.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\classes12.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\cleanimports.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\commons-beanutils-1.7.0.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\commons-collections-2.1.1.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\commons-lang-2.1.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\commons-logging-1.0.4.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\concurrent-1.3.2.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\connector.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\displaytag-1.1.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\displaytag-export-poi-1.1.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\dom4j-1.6.1.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\dom4j.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\ehcache-1.1.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\ehcache-1.2.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\hibernate-annotations.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\hibernate3.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\hsqldb.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\itext-1.3.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\jaas.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\jacc-1_0-fr.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\javassist.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\javax.servlet.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\jaxen-1.1-beta-7.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\jboss-cache.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\jboss-common.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\jboss-jmx.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\jboss-system.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\jdbc2_0-stdext.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\jgroups-2.2.8.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\jstl.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\jta.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\junit-3.8.1.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\junit.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\log4j-1.2.11.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\mail.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\mm.mysql-2.0.1-bin.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\oscache-2.1.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\proxool-0.8.3.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\quartz-1.5.1.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\servlet-api.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\spring-hibernate3.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\spring-mock.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\spring.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\standard.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\swarmcache-1.0rc2.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\syndiag2.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\versioncheck.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\xdoclet-base-locale-1.2.3.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\xerces-2.6.2.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\xml-apis.jar;H:\JavaSoftwares\eclipse\plugins\org.junit4_4.1.0.1\junit-4.1.jar;H:\JavaSoftwares\hibernate-3.2\hibernate3.jar;H:\JavaSoftwares\springFramework\spring-framework-2.0.6\dist\spring.jar;/H:/JavaSoftwares/eclipse/configuration/org.eclipse.osgi/bundles/696/1/.cp/;/H:/JavaSoftwares/eclipse/plugins/org.eclipse.jdt.junit_3.2.1.r321_v20060810/junitsupport.jar;/H:/JavaSoftwares/eclipse/plugins/org.eclipse.jdt.junit.runtime_3.2.1.r321_v20060721/junitruntime.jar, format_sql=true, hibernate.bytecode.use_reflection_optimizer=false, hibernate.use_sql_comments=true, hibernate.show_sql=true, java.vm.specification.version=1.0, java.home=C:\Program Files\Java\jre1.6.0_03, sun.arch.data.model=32, hibernate.dialect=org.hibernate.dialect.OracleDialect, hibernate.connection.url=jdbc:oracle:thin:@localhost:1521:XE, user.language=en, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, java.version=1.6.0_03, java.ext.dirs=C:\Program Files\Java\jre1.6.0_03\lib\ext;C:\WINDOWS\Sun\Java\lib\ext, sun.boot.class.path=C:\Program Files\Java\jre1.6.0_03\lib\resources.jar;C:\Program Files\Java\jre1.6.0_03\lib\rt.jar;C:\Program Files\Java\jre1.6.0_03\lib\sunrsasign.jar;C:\Program Files\Java\jre1.6.0_03\lib\jsse.jar;C:\Program Files\Java\jre1.6.0_03\lib\jce.jar;C:\Program Files\Java\jre1.6.0_03\lib\charsets.jar;C:\Program Files\Java\jre1.6.0_03\classes, java.vendor=Sun Microsystems Inc., connection.driver_class=oracle.jdbc.driver.OracleDriver, file.separator=\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, connection.autocommit=true, sun.desktop=windows, connection.url=jdbc:oracle:thin:@localhost:1521:XE, dialect=org.hibernate.dialect.OracleDialect, sun.cpu.isalist=}
1110 [main] DEBUG com.wonder.settings.HibernateUtil - Rebuilding the SessionFactory from given Configuration
1110 [main] DEBUG com.wonder.settings.HibernateUtil - Holding SessionFactory in static variable
1110 [main] DEBUG org.hibernate.cfg.Configuration - Preparing to build session factory with filters : {}
1110 [main] DEBUG org.hibernate.cfg.Configuration - processing extends queue
1110 [main] DEBUG org.hibernate.cfg.Configuration - processing collection mappings
1110 [main] DEBUG org.hibernate.cfg.CollectionSecondPass - Second pass for collection: com.wonder.common.Customer.contact
1110 [main] INFO org.hibernate.cfg.HbmBinder - Mapping collection: com.wonder.common.Customer.contact -> CUST_CONTACT
1110 [main] DEBUG org.hibernate.cfg.CollectionSecondPass - Mapped collection key: CUST_ID, one-to-many: CustContacts
1110 [main] DEBUG org.hibernate.cfg.CollectionSecondPass - Second pass for collection: com.wonder.common.Customer.address
1235 [main] DEBUG org.hibernate.cfg.CollectionSecondPass - Mapped collection key: CUST_ID, element: ADDRESS_ID
1235 [main] DEBUG org.hibernate.cfg.CollectionSecondPass - Second pass for collection: com.wonder.common.Employee.contact
1235 [main] INFO org.hibernate.cfg.HbmBinder - Mapping collection: com.wonder.common.Employee.contact -> EMP_CONTACT
1235 [main] DEBUG org.hibernate.cfg.CollectionSecondPass - Mapped collection key: EMP_ID, one-to-many: EmpContacts
1235 [main] DEBUG org.hibernate.cfg.CollectionSecondPass - Second pass for collection: com.wonder.common.Employee.address
1235 [main] DEBUG org.hibernate.cfg.CollectionSecondPass - Mapped collection key: EMP_ID, element: ADDRESS_ID
1235 [main] DEBUG org.hibernate.cfg.Configuration - processing native query and ResultSetMapping mappings
1235 [main] DEBUG org.hibernate.cfg.Configuration - processing association property references
1235 [main] DEBUG org.hibernate.cfg.Configuration - processing foreign key constraints
1235 [main] DEBUG org.hibernate.cfg.Configuration - resolving reference to class: com.wonder.common.Address
1235 [main] DEBUG org.hibernate.cfg.Configuration - resolving reference to class: com.wonder.common.Customer
1235 [main] DEBUG org.hibernate.cfg.Configuration - resolving reference to class: com.wonder.common.Customer
1235 [main] DEBUG org.hibernate.cfg.Configuration - resolving reference to class: com.wonder.common.Employee
1235 [main] DEBUG org.hibernate.cfg.Configuration - resolving reference to class: com.wonder.common.Address
1235 [main] DEBUG org.hibernate.cfg.Configuration - resolving reference to class: com.wonder.common.Employee
1250 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - Using Hibernate built-in connection pool (not for production use!)
1250 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - Hibernate connection pool size: 20
1250 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - autocommit mode: true
1266 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - using driver: oracle.jdbc.driver.OracleDriver at URL: jdbc:oracle:thin:@localhost:1521:XE
1266 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - connection properties: {user=wonder, password=wonder, autocommit=true}
1266 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider - total checked-out connections: 0
1266 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider - opening new JDBC connection
1594 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider - created connection to: jdbc:oracle:thin:@localhost:1521:XE, Isolation Level: 2
1610 [main] INFO org.hibernate.cfg.SettingsFactory - RDBMS: Oracle, version: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
1610 [main] INFO org.hibernate.cfg.SettingsFactory - JDBC driver: Oracle JDBC driver, version: 10.1.0.5.0
1610 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider - returning connection to pool, pool size: 1
1641 [main] INFO org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.OracleDialect
1641 [main] INFO org.hibernate.transaction.TransactionFactoryFactory - Using default transaction strategy (direct JDBC transactions)
1641 [main] INFO org.hibernate.transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
1641 [main] INFO org.hibernate.cfg.SettingsFactory - Automatic flush during beforeCompletion(): disabled
1641 [main] INFO org.hibernate.cfg.SettingsFactory - Automatic session close at end of transaction: disabled
1641 [main] INFO org.hibernate.cfg.SettingsFactory - JDBC batch size: 15
1641 [main] INFO org.hibernate.cfg.SettingsFactory - JDBC batch updates for versioned data: disabled
1641 [main] INFO org.hibernate.cfg.SettingsFactory - Scrollable result sets: enabled
1641 [main] DEBUG org.hibernate.cfg.SettingsFactory - Wrap result sets: disabled
1641 [main] INFO org.hibernate.cfg.SettingsFactory - JDBC3 getGeneratedKeys(): disabled
1641 [main] INFO org.hibernate.cfg.SettingsFactory - Connection release mode: auto
1657 [main] INFO org.hibernate.cfg.SettingsFactory - Default batch fetch size: 1
1657 [main] INFO org.hibernate.cfg.SettingsFactory - Generate SQL with comments: enabled
1657 [main] INFO org.hibernate.cfg.SettingsFactory - Order SQL updates by primary key: disabled
1657 [main] INFO org.hibernate.cfg.SettingsFactory - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
1657 [main] INFO org.hibernate.hql.ast.ASTQueryTranslatorFactory - Using ASTQueryTranslatorFactory
1657 [main] INFO org.hibernate.cfg.SettingsFactory - Query language substitutions: {}
1657 [main] INFO org.hibernate.cfg.SettingsFactory - JPA-QL strict compliance: disabled
1657 [main] INFO org.hibernate.cfg.SettingsFactory - Second-level cache: enabled
1657 [main] INFO org.hibernate.cfg.SettingsFactory - Query cache: disabled
1657 [main] INFO org.hibernate.cfg.SettingsFactory - Cache provider: org.hibernate.cache.NoCacheProvider
1657 [main] INFO org.hibernate.cfg.SettingsFactory - Optimize cache for minimal puts: disabled
1657 [main] INFO org.hibernate.cfg.SettingsFactory - Structured second-level cache entries: disabled
1657 [main] DEBUG org.hibernate.exception.SQLExceptionConverterFactory - Using dialect defined converter
1657 [main] INFO org.hibernate.cfg.SettingsFactory - Echoing all SQL to stdout
1657 [main] INFO org.hibernate.cfg.SettingsFactory - Statistics: disabled
1657 [main] INFO org.hibernate.cfg.SettingsFactory - Deleted entity synthetic identifier rollback: disabled
1657 [main] INFO org.hibernate.cfg.SettingsFactory - Default entity-mode: pojo
1719 [main] INFO org.hibernate.impl.SessionFactoryImpl - building session factory
1719 [main] DEBUG org.hibernate.impl.SessionFactoryImpl - Session factory constructed with filter configurations : {}
1719 [main] DEBUG org.hibernate.impl.SessionFactoryImpl - instantiating session factory with properties: {java.runtime.name=Java(TM) SE Runtime Environment, hibernate.connection.password=wonder, sun.boot.library.path=C:\Program Files\Java\jre1.6.0_03\bin, java.vm.version=1.6.0_03-b05, hibernate.connection.username=wonder, 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=US, sun.java.launcher=SUN_STANDARD, sun.os.patch.level=Service Pack 2, java.vm.specification.name=Java Virtual Machine Specification, user.dir=H:\eclipseProjects\workspace\WonderSales, java.runtime.version=1.6.0_03-b05, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Program Files\Java\jre1.6.0_03\lib\endorsed, os.arch=x86, hibernate.connection.autocommit=true, java.io.tmpdir=C:\DOCUME~1\KASHIF~1\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows XP, use_sql_comments=true, sun.jnu.encoding=Cp1252, java.library.path=C:\Program Files\Java\jre1.6.0_03\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;E:\oraclexe\app\oracle\product\10.2.0\server\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\QuickTime\QTSystem\;H:\JavaSoftwares\ant-1.6.5\bin;C:\Program Files\Java\jdk1.6.0\bin, 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\Kashif Mughal, connection.password=wonder, user.timezone=, java.awt.printerjob=sun.awt.windows.WPrinterJob, connection.username=wonder, java.specification.version=1.6, file.encoding=Cp1252, hibernate.format_sql=true, hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver, show_sql=true, java.class.path=H:\eclipseProjects\workspace\WonderSales\build\classes;H:\JavaSoftwares\jBossAS\jboss-4.0.4.GA\client\jboss-j2ee.jar;H:\JavaSoftwares\jBossAS\jboss-4.0.4.GA\client\jbossall-client.jar;H:\JavaSoftwares\jBossAS\jboss-4.0.4.GA\server\default\lib\javax.servlet.jar;H:\JavaSoftwares\jBossAS\jboss-4.0.4.GA\server\default\lib\javax.servlet.jsp.jar;H:\JavaSoftwares\jBossAS\jboss-4.0.4.GA\server\default\lib\activation.jar;H:\JavaSoftwares\jBossAS\jboss-4.0.4.GA\server\default\lib\mail.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\activation.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\ant-1.6.5.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\ant-antlr-1.6.5.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\ant-junit-1.6.5.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\ant-launcher-1.6.5.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\ant-swing-1.6.5.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\antlr-2.7.6.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\antlr-2.7.6rc1.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\asm-attrs.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\asm.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\c3p0-0.9.0.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\cglib-2.1.3.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\checkstyle-all.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\classes12.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\cleanimports.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\commons-beanutils-1.7.0.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\commons-collections-2.1.1.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\commons-lang-2.1.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\commons-logging-1.0.4.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\concurrent-1.3.2.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\connector.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\displaytag-1.1.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\displaytag-export-poi-1.1.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\dom4j-1.6.1.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\dom4j.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\ehcache-1.1.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\ehcache-1.2.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\hibernate-annotations.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\hibernate3.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\hsqldb.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\itext-1.3.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\jaas.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\jacc-1_0-fr.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\javassist.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\javax.servlet.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\jaxen-1.1-beta-7.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\jboss-cache.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\jboss-common.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\jboss-jmx.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\jboss-system.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\jdbc2_0-stdext.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\jgroups-2.2.8.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\jstl.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\jta.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\junit-3.8.1.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\junit.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\log4j-1.2.11.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\mail.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\mm.mysql-2.0.1-bin.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\oscache-2.1.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\proxool-0.8.3.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\quartz-1.5.1.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\servlet-api.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\spring-hibernate3.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\spring-mock.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\spring.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\standard.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\swarmcache-1.0rc2.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\syndiag2.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\versioncheck.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\xdoclet-base-locale-1.2.3.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\xerces-2.6.2.jar;H:\eclipseProjects\workspace\WonderSales\WebContent\WEB-INF\lib\xml-apis.jar;H:\JavaSoftwares\eclipse\plugins\org.junit4_4.1.0.1\junit-4.1.jar;H:\JavaSoftwares\hibernate-3.2\hibernate3.jar;H:\JavaSoftwares\springFramework\spring-framework-2.0.6\dist\spring.jar;/H:/JavaSoftwares/eclipse/configuration/org.eclipse.osgi/bundles/696/1/.cp/;/H:/JavaSoftwares/eclipse/plugins/org.eclipse.jdt.junit_3.2.1.r321_v20060810/junitsupport.jar;/H:/JavaSoftwares/eclipse/plugins/org.eclipse.jdt.junit.runtime_3.2.1.r321_v20060721/junitruntime.jar, user.name=Kashif Mughal, hibernate.bytecode.use_reflection_optimizer=false, format_sql=true, hibernate.show_sql=true, hibernate.use_sql_comments=true, java.vm.specification.version=1.0, sun.arch.data.model=32, java.home=C:\Program Files\Java\jre1.6.0_03, hibernate.connection.url=jdbc:oracle:thin:@localhost:1521:XE, hibernate.dialect=org.hibernate.dialect.OracleDialect, java.specification.vendor=Sun Microsystems Inc., user.language=en, awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, java.version=1.6.0_03, java.ext.dirs=C:\Program Files\Java\jre1.6.0_03\lib\ext;C:\WINDOWS\Sun\Java\lib\ext, sun.boot.class.path=C:\Program Files\Java\jre1.6.0_03\lib\resources.jar;C:\Program Files\Java\jre1.6.0_03\lib\rt.jar;C:\Program Files\Java\jre1.6.0_03\lib\sunrsasign.jar;C:\Program Files\Java\jre1.6.0_03\lib\jsse.jar;C:\Program Files\Java\jre1.6.0_03\lib\jce.jar;C:\Program Files\Java\jre1.6.0_03\lib\charsets.jar;C:\Program Files\Java\jre1.6.0_03\classes, java.vendor=Sun Microsystems Inc., file.separator=\, connection.driver_class=oracle.jdbc.driver.OracleDriver, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.cpu.endian=little, sun.io.unicode.encoding=UnicodeLittle, connection.autocommit=true, sun.desktop=windows, connection.url=jdbc:oracle:thin:@localhost:1521:XE, sun.cpu.isalist=, dialect=org.hibernate.dialect.OracleDialect}
2157 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Static SQL for entity: EmpContacts
2157 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Version select: /* get version EmpContacts */ select CONTACT_ID from EMP_CONTACT where CONTACT_ID =?
2157 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Snapshot select: /* get current state EmpContacts */ select empcontact_.CONTACT_ID, empcontact_.HOME as HOME5_, empcontact_.OFFICE as OFFICE5_, empcontact_.MOBILE as MOBILE5_, empcontact_.FAX as FAX5_, empcontact_.EMAIL as EMAIL5_ from EMP_CONTACT empcontact_ where empcontact_.CONTACT_ID=?
2157 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Insert 0: /* insert EmpContacts */ insert into EMP_CONTACT (HOME, OFFICE, MOBILE, FAX, EMAIL, EMP_ID, CONTACT_ID) values (?, ?, ?, ?, ?, ?, ?)
2157 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Update 0: /* update EmpContacts */ update EMP_CONTACT set HOME=?, OFFICE=?, MOBILE=?, FAX=?, EMAIL=? where CONTACT_ID=?
2157 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Delete 0: /* delete EmpContacts */ delete from EMP_CONTACT where CONTACT_ID=?
2172 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Static SQL for entity: com.wonder.common.Address
2172 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Version select: /* get version com.wonder.common.Address */ select ADDRESS_ID from ADDRESS where ADDRESS_ID =?
2172 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Snapshot select: /* get current state com.wonder.common.Address */ select address_.ADDRESS_ID, address_.TYPE as TYPE4_, address_.STREET as STREET4_, address_.ROAD as ROAD4_, address_.CITY as CITY4_, address_.POSTCODE as POSTCODE4_, address_.COUNTRY as COUNTRY4_ from ADDRESS address_ where address_.ADDRESS_ID=?
2172 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Insert 0: /* insert com.wonder.common.Address */ insert into ADDRESS (TYPE, STREET, ROAD, CITY, POSTCODE, COUNTRY, ADDRESS_ID) values (?, ?, ?, ?, ?, ?, ?)
2172 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Update 0: /* update com.wonder.common.Address */ update ADDRESS set TYPE=?, STREET=?, ROAD=?, CITY=?, POSTCODE=?, COUNTRY=? where ADDRESS_ID=?
2172 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Delete 0: /* delete com.wonder.common.Address */ delete from ADDRESS where ADDRESS_ID=?
2204 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Static SQL for entity: com.wonder.common.Employee
2204 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Version select: /* get version com.wonder.common.Employee */ select EMP_ID from EMPLOYEE where EMP_ID =?
2204 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Snapshot select: /* get current state com.wonder.common.Employee */ select employee_.EMP_ID, employee_.FIRST_NAME as FIRST2_2_, employee_.LAST_NAME as LAST3_2_, employee_.GENDER as GENDER2_, employee_.AGE as AGE2_, employee_.DOB as DOB2_, employee_.NI_NO as NI7_2_, employee_.EMP_NO as EMP8_2_, employee_.DEPT as DEPT2_, employee_.START_DATE as START10_2_, employee_.DESIGNATION as DESIGNA11_2_, employee_.EXT_NO as EXT12_2_ from EMPLOYEE employee_ where employee_.EMP_ID=?
2204 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Insert 0: /* insert com.wonder.common.Employee */ insert into EMPLOYEE (FIRST_NAME, LAST_NAME, GENDER, AGE, DOB, NI_NO, EMP_NO, DEPT, START_DATE, DESIGNATION, EXT_NO, EMP_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2204 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Update 0: /* update com.wonder.common.Employee */ update EMPLOYEE set FIRST_NAME=?, LAST_NAME=?, GENDER=?, AGE=?, DOB=?, NI_NO=?, EMP_NO=?, DEPT=?, START_DATE=?, DESIGNATION=?, EXT_NO=? where EMP_ID=?
2204 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Delete 0: /* delete com.wonder.common.Employee */ delete from EMPLOYEE where EMP_ID=?
2204 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Static SQL for entity: CustContacts
2204 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Version select: /* get version CustContacts */ select CONTACT_ID from CUST_CONTACT where CONTACT_ID =?
2204 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Snapshot select: /* get current state CustContacts */ select custcontac_.CONTACT_ID, custcontac_.HOME as HOME6_, custcontac_.OFFICE as OFFICE6_, custcontac_.MOBILE as MOBILE6_, custcontac_.FAX as FAX6_, custcontac_.EMAIL as EMAIL6_ from CUST_CONTACT custcontac_ where custcontac_.CONTACT_ID=?
2204 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Insert 0: /* insert CustContacts */ insert into CUST_CONTACT (HOME, OFFICE, MOBILE, FAX, EMAIL, CUST_ID, CONTACT_ID) values (?, ?, ?, ?, ?, ?, ?)
2204 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Update 0: /* update CustContacts */ update CUST_CONTACT set HOME=?, OFFICE=?, MOBILE=?, FAX=?, EMAIL=? where CONTACT_ID=?
2204 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Delete 0: /* delete CustContacts */ delete from CUST_CONTACT where CONTACT_ID=?
2235 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Static SQL for entity: com.wonder.common.Customer
2235 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Version select: /* get version com.wonder.common.Customer */ select CUST_ID from CUSTOMER where CUST_ID =?
2235 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Snapshot select: /* get current state com.wonder.common.Customer */ select customer_.CUST_ID, customer_.FIRST_NAME as FIRST2_0_, customer_.LAST_NAME as LAST3_0_, customer_.GENDER as GENDER0_, customer_.BUSINESS_TITLE as BUSINESS5_0_, customer_.CUST_NO as CUST6_0_, customer_.REG_DATE as REG7_0_ from CUSTOMER customer_ where customer_.CUST_ID=?
2235 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Insert 0: /* insert com.wonder.common.Customer */ insert into CUSTOMER (FIRST_NAME, LAST_NAME, GENDER, BUSINESS_TITLE, CUST_NO, REG_DATE, CUST_ID) values (?, ?, ?, ?, ?, ?, ?)
2235 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Update 0: /* update com.wonder.common.Customer */ update CUSTOMER set FIRST_NAME=?, LAST_NAME=?, GENDER=?, BUSINESS_TITLE=?, CUST_NO=?, REG_DATE=? where CUST_ID=?
2235 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Delete 0: /* delete com.wonder.common.Customer */ delete from CUSTOMER where CUST_ID=?
2250 [main] DEBUG org.hibernate.persister.collection.AbstractCollectionPersister - Static SQL for collection: com.wonder.common.Employee.address
2250 [main] DEBUG org.hibernate.persister.collection.AbstractCollectionPersister - Row insert: /* insert collection row com.wonder.common.Employee.address */ insert into EMP_ADDRESS (EMP_ID, ADDRESS_ID) values (?, ?)
2250 [main] DEBUG org.hibernate.persister.collection.AbstractCollectionPersister - Row update: /* update collection row com.wonder.common.Employee.address */ update EMP_ADDRESS set ADDRESS_ID=? where EMP_ID=? and ADDRESS_ID=?
2329 [main] DEBUG org.hibernate.persister.collection.AbstractCollectionPersister - Row delete: /* delete collection row com.wonder.common.Employee.address */ delete from EMP_ADDRESS where EMP_ID=? and ADDRESS_ID=?
2329 [main] DEBUG org.hibernate.persister.collection.AbstractCollectionPersister - One-shot delete: /* delete collection com.wonder.common.Employee.address */ delete from EMP_ADDRESS where EMP_ID=?
2329 [main] DEBUG org.hibernate.persister.collection.AbstractCollectionPersister - Static SQL for collection: com.wonder.common.Customer.address
2329 [main] DEBUG org.hibernate.persister.collection.AbstractCollectionPersister - Row insert: /* insert collection row com.wonder.common.Customer.address */ insert into CUST_ADDRESS (CUST_ID, ADDRESS_ID) values (?, ?)
2329 [main] DEBUG org.hibernate.persister.collection.AbstractCollectionPersister - Row update: /* update collection row com.wonder.common.Customer.address */ update CUST_ADDRESS set ADDRESS_ID=? where CUST_ID=? and ADDRESS_ID=?
2329 [main] DEBUG org.hibernate.persister.collection.AbstractCollectionPersister - Row delete: /* delete collection row com.wonder.common.Customer.address */ delete from CUST_ADDRESS where CUST_ID=? and ADDRESS_ID=?
2329 [main] DEBUG org.hibernate.persister.collection.AbstractCollectionPersister - One-shot delete: /* delete collection com.wonder.common.Customer.address */ delete from CUST_ADDRESS where CUST_ID=?
2329 [main] DEBUG org.hibernate.persister.collection.AbstractCollectionPersister - Static SQL for collection: com.wonder.common.Customer.contact
2329 [main] DEBUG org.hibernate.persister.collection.AbstractCollectionPersister - Row insert: /* create one-to-many row com.wonder.common.Customer.contact */ update CUST_CONTACT set CUST_ID=? where CONTACT_ID=?
2329 [main] DEBUG org.hibernate.persister.collection.AbstractCollectionPersister - Row delete: /* delete one-to-many row com.wonder.common.Customer.contact */ update CUST_CONTACT set CUST_ID=null where CUST_ID=? and CONTACT_ID=?
2329 [main] DEBUG org.hibernate.persister.collection.AbstractCollectionPersister - One-shot delete: /* delete one-to-many com.wonder.common.Customer.contact */ update CUST_CONTACT set CUST_ID=null where CUST_ID=?
2329 [main] DEBUG org.hibernate.persister.collection.AbstractCollectionPersister - Static SQL for collection: com.wonder.common.Employee.contact
2329 [main] DEBUG org.hibernate.persister.collection.AbstractCollectionPersister - Row insert: /* create one-to-many row com.wonder.common.Employee.contact */ update EMP_CONTACT set EMP_ID=? where CONTACT_ID=?
2329 [main] DEBUG org.hibernate.persister.collection.AbstractCollectionPersister - Row delete: /* delete one-to-many row com.wonder.common.Employee.contact */ update EMP_CONTACT set EMP_ID=null where EMP_ID=? and CONTACT_ID=?
2329 [main] DEBUG org.hibernate.persister.collection.AbstractCollectionPersister - One-shot delete: /* delete one-to-many com.wonder.common.Employee.contact */ update EMP_CONTACT set EMP_ID=null where EMP_ID=?
2360 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity EmpContacts: /* load EmpContacts */ select empcontact0_.CONTACT_ID as CONTACT1_5_0_, empcontact0_.HOME as HOME5_0_, empcontact0_.OFFICE as OFFICE5_0_, empcontact0_.MOBILE as MOBILE5_0_, empcontact0_.FAX as FAX5_0_, empcontact0_.EMAIL as EMAIL5_0_ from EMP_CONTACT empcontact0_ where empcontact0_.CONTACT_ID=?
2360 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity EmpContacts: /* load EmpContacts */ select empcontact0_.CONTACT_ID as CONTACT1_5_0_, empcontact0_.HOME as HOME5_0_, empcontact0_.OFFICE as OFFICE5_0_, empcontact0_.MOBILE as MOBILE5_0_, empcontact0_.FAX as FAX5_0_, empcontact0_.EMAIL as EMAIL5_0_ from EMP_CONTACT empcontact0_ where empcontact0_.CONTACT_ID=?
2360 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity EmpContacts: /* load EmpContacts */ select empcontact0_.CONTACT_ID as CONTACT1_5_0_, empcontact0_.HOME as HOME5_0_, empcontact0_.OFFICE as OFFICE5_0_, empcontact0_.MOBILE as MOBILE5_0_, empcontact0_.FAX as FAX5_0_, empcontact0_.EMAIL as EMAIL5_0_ from EMP_CONTACT empcontact0_ where empcontact0_.CONTACT_ID=? for update
2360 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity EmpContacts: /* load EmpContacts */ select empcontact0_.CONTACT_ID as CONTACT1_5_0_, empcontact0_.HOME as HOME5_0_, empcontact0_.OFFICE as OFFICE5_0_, empcontact0_.MOBILE as MOBILE5_0_, empcontact0_.FAX as FAX5_0_, empcontact0_.EMAIL as EMAIL5_0_ from EMP_CONTACT empcontact0_ where empcontact0_.CONTACT_ID=? for update nowait
2360 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity EmpContacts: /* load EmpContacts */ select empcontact0_.CONTACT_ID as CONTACT1_5_0_, empcontact0_.HOME as HOME5_0_, empcontact0_.OFFICE as OFFICE5_0_, empcontact0_.MOBILE as MOBILE5_0_, empcontact0_.FAX as FAX5_0_, empcontact0_.EMAIL as EMAIL5_0_ from EMP_CONTACT empcontact0_ where empcontact0_.CONTACT_ID=? for update nowait
2407 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for action ACTION_MERGE on entity EmpContacts: /* load EmpContacts */ select empcontact0_.CONTACT_ID as CONTACT1_5_0_, empcontact0_.HOME as HOME5_0_, empcontact0_.OFFICE as OFFICE5_0_, empcontact0_.MOBILE as MOBILE5_0_, empcontact0_.FAX as FAX5_0_, empcontact0_.EMAIL as EMAIL5_0_ from EMP_CONTACT empcontact0_ where empcontact0_.CONTACT_ID=?
2407 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for action ACTION_REFRESH on entity EmpContacts: /* load EmpContacts */ select empcontact0_.CONTACT_ID as CONTACT1_5_0_, empcontact0_.HOME as HOME5_0_, empcontact0_.OFFICE as OFFICE5_0_, empcontact0_.MOBILE as MOBILE5_0_, empcontact0_.FAX as FAX5_0_, empcontact0_.EMAIL as EMAIL5_0_ from EMP_CONTACT empcontact0_ where empcontact0_.CONTACT_ID=?
2407 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity com.wonder.common.Address: /* load com.wonder.common.Address */ select address0_.ADDRESS_ID as ADDRESS1_4_0_, address0_.TYPE as TYPE4_0_, address0_.STREET as STREET4_0_, address0_.ROAD as ROAD4_0_, address0_.CITY as CITY4_0_, address0_.POSTCODE as POSTCODE4_0_, address0_.COUNTRY as COUNTRY4_0_ from ADDRESS address0_ where address0_.ADDRESS_ID=?
2407 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity com.wonder.common.Address: /* load com.wonder.common.Address */ select address0_.ADDRESS_ID as ADDRESS1_4_0_, address0_.TYPE as TYPE4_0_, address0_.STREET as STREET4_0_, address0_.ROAD as ROAD4_0_, address0_.CITY as CITY4_0_, address0_.POSTCODE as POSTCODE4_0_, address0_.COUNTRY as COUNTRY4_0_ from ADDRESS address0_ where address0_.ADDRESS_ID=?
2407 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity com.wonder.common.Address: /* load com.wonder.common.Address */ select address0_.ADDRESS_ID as ADDRESS1_4_0_, address0_.TYPE as TYPE4_0_, address0_.STREET as STREET4_0_, address0_.ROAD as ROAD4_0_, address0_.CITY as CITY4_0_, address0_.POSTCODE as POSTCODE4_0_, address0_.COUNTRY as COUNTRY4_0_ from ADDRESS address0_ where address0_.ADDRESS_ID=? for update
2407 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity com.wonder.common.Address: /* load com.wonder.common.Address */ select address0_.ADDRESS_ID as ADDRESS1_4_0_, address0_.TYPE as TYPE4_0_, address0_.STREET as STREET4_0_, address0_.ROAD as ROAD4_0_, address0_.CITY as CITY4_0_, address0_.POSTCODE as POSTCODE4_0_, address0_.COUNTRY as COUNTRY4_0_ from ADDRESS address0_ where address0_.ADDRESS_ID=? for update nowait
2422 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity com.wonder.common.Address: /* load com.wonder.common.Address */ select address0_.ADDRESS_ID as ADDRESS1_4_0_, address0_.TYPE as TYPE4_0_, address0_.STREET as STREET4_0_, address0_.ROAD as ROAD4_0_, address0_.CITY as CITY4_0_, address0_.POSTCODE as POSTCODE4_0_, address0_.COUNTRY as COUNTRY4_0_ from ADDRESS address0_ where address0_.ADDRESS_ID=? for update nowait
2422 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for action ACTION_MERGE on entity com.wonder.common.Address: /* load com.wonder.common.Address */ select address0_.ADDRESS_ID as ADDRESS1_4_0_, address0_.TYPE as TYPE4_0_, address0_.STREET as STREET4_0_, address0_.ROAD as ROAD4_0_, address0_.CITY as CITY4_0_, address0_.POSTCODE as POSTCODE4_0_, address0_.COUNTRY as COUNTRY4_0_ from ADDRESS address0_ where address0_.ADDRESS_ID=?
2422 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for action ACTION_REFRESH on entity com.wonder.common.Address: /* load com.wonder.common.Address */ select address0_.ADDRESS_ID as ADDRESS1_4_0_, address0_.TYPE as TYPE4_0_, address0_.STREET as STREET4_0_, address0_.ROAD as ROAD4_0_, address0_.CITY as CITY4_0_, address0_.POSTCODE as POSTCODE4_0_, address0_.COUNTRY as COUNTRY4_0_ from ADDRESS address0_ where address0_.ADDRESS_ID=?
2422 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity com.wonder.common.Employee: /* load com.wonder.common.Employee */ select employee0_.EMP_ID as EMP1_2_0_, employee0_.FIRST_NAME as FIRST2_2_0_, employee0_.LAST_NAME as LAST3_2_0_, employee0_.GENDER as GENDER2_0_, employee0_.AGE as AGE2_0_, employee0_.DOB as DOB2_0_, employee0_.NI_NO as NI7_2_0_, employee0_.EMP_NO as EMP8_2_0_, employee0_.DEPT as DEPT2_0_, employee0_.START_DATE as START10_2_0_, employee0_.DESIGNATION as DESIGNA11_2_0_, employee0_.EXT_NO as EXT12_2_0_ from EMPLOYEE employee0_ where employee0_.EMP_ID=?
2422 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity com.wonder.common.Employee: /* load com.wonder.common.Employee */ select employee0_.EMP_ID as EMP1_2_0_, employee0_.FIRST_NAME as FIRST2_2_0_, employee0_.LAST_NAME as LAST3_2_0_, employee0_.GENDER as GENDER2_0_, employee0_.AGE as AGE2_0_, employee0_.DOB as DOB2_0_, employee0_.NI_NO as NI7_2_0_, employee0_.EMP_NO as EMP8_2_0_, employee0_.DEPT as DEPT2_0_, employee0_.START_DATE as START10_2_0_, employee0_.DESIGNATION as DESIGNA11_2_0_, employee0_.EXT_NO as EXT12_2_0_ from EMPLOYEE employee0_ where employee0_.EMP_ID=?
2422 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity com.wonder.common.Employee: /* load com.wonder.common.Employee */ select employee0_.EMP_ID as EMP1_2_0_, employee0_.FIRST_NAME as FIRST2_2_0_, employee0_.LAST_NAME as LAST3_2_0_, employee0_.GENDER as GENDER2_0_, employee0_.AGE as AGE2_0_, employee0_.DOB as DOB2_0_, employee0_.NI_NO as NI7_2_0_, employee0_.EMP_NO as EMP8_2_0_, employee0_.DEPT as DEPT2_0_, employee0_.START_DATE as START10_2_0_, employee0_.DESIGNATION as DESIGNA11_2_0_, employee0_.EXT_NO as EXT12_2_0_ from EMPLOYEE employee0_ where employee0_.EMP_ID=? for update
2422 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity com.wonder.common.Employee: /* load com.wonder.common.Employee */ select employee0_.EMP_ID as EMP1_2_0_, employee0_.FIRST_NAME as FIRST2_2_0_, employee0_.LAST_NAME as LAST3_2_0_, employee0_.GENDER as GENDER2_0_, employee0_.AGE as AGE2_0_, employee0_.DOB as DOB2_0_, employee0_.NI_NO as NI7_2_0_, employee0_.EMP_NO as EMP8_2_0_, employee0_.DEPT as DEPT2_0_, employee0_.START_DATE as START10_2_0_, employee0_.DESIGNATION as DESIGNA11_2_0_, employee0_.EXT_NO as EXT12_2_0_ from EMPLOYEE employee0_ where employee0_.EMP_ID=? for update nowait
2422 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity com.wonder.common.Employee: /* load com.wonder.common.Employee */ select employee0_.EMP_ID as EMP1_2_0_, employee0_.FIRST_NAME as FIRST2_2_0_, employee0_.LAST_NAME as LAST3_2_0_, employee0_.GENDER as GENDER2_0_, employee0_.AGE as AGE2_0_, employee0_.DOB as DOB2_0_, employee0_.NI_NO as NI7_2_0_, employee0_.EMP_NO as EMP8_2_0_, employee0_.DEPT as DEPT2_0_, employee0_.START_DATE as START10_2_0_, employee0_.DESIGNATION as DESIGNA11_2_0_, employee0_.EXT_NO as EXT12_2_0_ from EMPLOYEE employee0_ where employee0_.EMP_ID=? for update nowait
2422 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for action ACTION_MERGE on entity com.wonder.common.Employee: /* load com.wonder.common.Employee */ select employee0_.EMP_ID as EMP1_2_0_, employee0_.FIRST_NAME as FIRST2_2_0_, employee0_.LAST_NAME as LAST3_2_0_, employee0_.GENDER as GENDER2_0_, employee0_.AGE as AGE2_0_, employee0_.DOB as DOB2_0_, employee0_.NI_NO as NI7_2_0_, employee0_.EMP_NO as EMP8_2_0_, employee0_.DEPT as DEPT2_0_, employee0_.START_DATE as START10_2_0_, employee0_.DESIGNATION as DESIGNA11_2_0_, employee0_.EXT_NO as EXT12_2_0_ from EMPLOYEE employee0_ where employee0_.EMP_ID=?
2422 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for action ACTION_REFRESH on entity com.wonder.common.Employee: /* load com.wonder.common.Employee */ select employee0_.EMP_ID as EMP1_2_0_, employee0_.FIRST_NAME as FIRST2_2_0_, employee0_.LAST_NAME as LAST3_2_0_, employee0_.GENDER as GENDER2_0_, employee0_.AGE as AGE2_0_, employee0_.DOB as DOB2_0_, employee0_.NI_NO as NI7_2_0_, employee0_.EMP_NO as EMP8_2_0_, employee0_.DEPT as DEPT2_0_, employee0_.START_DATE as START10_2_0_, employee0_.DESIGNATION as DESIGNA11_2_0_, employee0_.EXT_NO as EXT12_2_0_ from EMPLOYEE employee0_ where employee0_.EMP_ID=?
2422 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity com.wonder.common.Customer: /* load com.wonder.common.Customer */ select customer0_.CUST_ID as CUST1_0_0_, customer0_.FIRST_NAME as FIRST2_0_0_, customer0_.LAST_NAME as LAST3_0_0_, customer0_.GENDER as GENDER0_0_, customer0_.BUSINESS_TITLE as BUSINESS5_0_0_, customer0_.CUST_NO as CUST6_0_0_, customer0_.REG_DATE as REG7_0_0_ from CUSTOMER customer0_ where customer0_.CUST_ID=?
2422 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity com.wonder.common.Customer: /* load com.wonder.common.Customer */ select customer0_.CUST_ID as CUST1_0_0_, customer0_.FIRST_NAME as FIRST2_0_0_, customer0_.LAST_NAME as LAST3_0_0_, customer0_.GENDER as GENDER0_0_, customer0_.BUSINESS_TITLE as BUSINESS5_0_0_, customer0_.CUST_NO as CUST6_0_0_, customer0_.REG_DATE as REG7_0_0_ from CUSTOMER customer0_ where customer0_.CUST_ID=?
2422 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity com.wonder.common.Customer: /* load com.wonder.common.Customer */ select customer0_.CUST_ID as CUST1_0_0_, customer0_.FIRST_NAME as FIRST2_0_0_, customer0_.LAST_NAME as LAST3_0_0_, customer0_.GENDER as GENDER0_0_, customer0_.BUSINESS_TITLE as BUSINESS5_0_0_, customer0_.CUST_NO as CUST6_0_0_, customer0_.REG_DATE as REG7_0_0_ from CUSTOMER customer0_ where customer0_.CUST_ID=? for update
2422 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity com.wonder.common.Customer: /* load com.wonder.common.Customer */ select customer0_.CUST_ID as CUST1_0_0_, customer0_.FIRST_NAME as FIRST2_0_0_, customer0_.LAST_NAME as LAST3_0_0_, customer0_.GENDER as GENDER0_0_, customer0_.BUSINESS_TITLE as BUSINESS5_0_0_, customer0_.CUST_NO as CUST6_0_0_, customer0_.REG_DATE as REG7_0_0_ from CUSTOMER customer0_ where customer0_.CUST_ID=? for update nowait
2422 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity com.wonder.common.Customer: /* load com.wonder.common.Customer */ select customer0_.CUST_ID as CUST1_0_0_, customer0_.FIRST_NAME as FIRST2_0_0_, customer0_.LAST_NAME as LAST3_0_0_, customer0_.GENDER as GENDER0_0_, customer0_.BUSINESS_TITLE as BUSINESS5_0_0_, customer0_.CUST_NO as CUST6_0_0_, customer0_.REG_DATE as REG7_0_0_ from CUSTOMER customer0_ where customer0_.CUST_ID=? for update nowait
2422 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for action ACTION_MERGE on entity com.wonder.common.Customer: /* load com.wonder.common.Customer */ select customer0_.CUST_ID as CUST1_0_0_, customer0_.FIRST_NAME as FIRST2_0_0_, customer0_.LAST_NAME as LAST3_0_0_, customer0_.GENDER as GENDER0_0_, customer0_.BUSINESS_TITLE as BUSINESS5_0_0_, customer0_.CUST_NO as CUST6_0_0_, customer0_.REG_DATE as REG7_0_0_ from CUSTOMER customer0_ where customer0_.CUST_ID=?
2422 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for action ACTION_REFRESH on entity com.wonder.common.Customer: /* load com.wonder.common.Customer */ select customer0_.CUST_ID as CUST1_0_0_, customer0_.FIRST_NAME as FIRST2_0_0_, customer0_.LAST_NAME as LAST3_0_0_, customer0_.GENDER as GENDER0_0_, customer0_.BUSINESS_TITLE as BUSINESS5_0_0_, customer0_.CUST_NO as CUST6_0_0_, customer0_.REG_DATE as REG7_0_0_ from CUSTOMER customer0_ where customer0_.CUST_ID=?
2422 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity CustContacts: /* load CustContacts */ select custcontac0_.CONTACT_ID as CONTACT1_6_0_, custcontac0_.HOME as HOME6_0_, custcontac0_.OFFICE as OFFICE6_0_, custcontac0_.MOBILE as MOBILE6_0_, custcontac0_.FAX as FAX6_0_, custcontac0_.EMAIL as EMAIL6_0_ from CUST_CONTACT custcontac0_ where custcontac0_.CONTACT_ID=?
2422 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity CustContacts: /* load CustContacts */ select custcontac0_.CONTACT_ID as CONTACT1_6_0_, custcontac0_.HOME as HOME6_0_, custcontac0_.OFFICE as OFFICE6_0_, custcontac0_.MOBILE as MOBILE6_0_, custcontac0_.FAX as FAX6_0_, custcontac0_.EMAIL as EMAIL6_0_ from CUST_CONTACT custcontac0_ where custcontac0_.CONTACT_ID=?
2422 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity CustContacts: /* load CustContacts */ select custcontac0_.CONTACT_ID as CONTACT1_6_0_, custcontac0_.HOME as HOME6_0_, custcontac0_.OFFICE as OFFICE6_0_, custcontac0_.MOBILE as MOBILE6_0_, custcontac0_.FAX as FAX6_0_, custcontac0_.EMAIL as EMAIL6_0_ from CUST_CONTACT custcontac0_ where custcontac0_.CONTACT_ID=? for update
2422 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity CustContacts: /* load CustContacts */ select custcontac0_.CONTACT_ID as CONTACT1_6_0_, custcontac0_.HOME as HOME6_0_, custcontac0_.OFFICE as OFFICE6_0_, custcontac0_.MOBILE as MOBILE6_0_, custcontac0_.FAX as FAX6_0_, custcontac0_.EMAIL as EMAIL6_0_ from CUST_CONTACT custcontac0_ where custcontac0_.CONTACT_ID=? for update nowait
2422 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity CustContacts: /* load CustContacts */ select custcontac0_.CONTACT_ID as CONTACT1_6_0_, custcontac0_.HOME as HOME6_0_, custcontac0_.OFFICE as OFFICE6_0_, custcontac0_.MOBILE as MOBILE6_0_, custcontac0_.FAX as FAX6_0_, custcontac0_.EMAIL as EMAIL6_0_ from CUST_CONTACT custcontac0_ where custcontac0_.CONTACT_ID=? for update nowait
2422 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for action ACTION_MERGE on entity CustContacts: /* load CustContacts */ select custcontac0_.CONTACT_ID as CONTACT1_6_0_, custcontac0_.HOME as HOME6_0_, custcontac0_.OFFICE as OFFICE6_0_, custcontac0_.MOBILE as MOBILE6_0_, custcontac0_.FAX as FAX6_0_, custcontac0_.EMAIL as EMAIL6_0_ from CUST_CONTACT custcontac0_ where custcontac0_.CONTACT_ID=?
2422 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Sta

_________________
Thanks in Advance
Kashif


Top
 Profile  
 
 Post subject:
PostPosted: Mon May 12, 2008 12:38 pm 
Newbie

Joined: Mon May 12, 2008 12:16 pm
Posts: 7
Error Log continue ...
----------------------------

2954 [main] DEBUG org.hibernate.SQL -
/* insert com.wonder.common.Customer
*/ insert
into
CUSTOMER
(FIRST_NAME, LAST_NAME, GENDER, BUSINESS_TITLE, CUST_NO, REG_DATE, CUST_ID)
values
(?, ?, ?, ?, ?, ?, ?)
Hibernate:
/* insert com.wonder.common.Customer
*/ insert
into
CUSTOMER
(FIRST_NAME, LAST_NAME, GENDER, BUSINESS_TITLE, CUST_NO, REG_DATE, CUST_ID)
values
(?, ?, ?, ?, ?, ?, ?)
2954 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - preparing statement
2954 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Dehydrating entity: [com.wonder.common.Customer#384]
2954 [main] DEBUG org.hibernate.type.StringType - binding 'Ali' to parameter: 1
2954 [main] DEBUG org.hibernate.type.StringType - binding 'Khokhar' to parameter: 2
2954 [main] DEBUG org.hibernate.type.StringType - binding 'Male' to parameter: 3
2954 [main] DEBUG org.hibernate.type.StringType - binding 'Ali Traders' to parameter: 4
2954 [main] DEBUG org.hibernate.type.StringType - binding 'Cust-100' to parameter: 5
2954 [main] DEBUG org.hibernate.type.StringType - binding '25-JUN-2007' to parameter: 6
2954 [main] DEBUG org.hibernate.type.LongType - binding '384' to parameter: 7
2954 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Inserting entity: [CustContacts#385]
2954 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - Executing batch size: 1
2969 [main] DEBUG org.hibernate.jdbc.Expectations - success of batch update unknown: 0
2969 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2969 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - closing statement
2969 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2969 [main] DEBUG org.hibernate.SQL -
/* insert CustContacts
*/ insert
into
CUST_CONTACT
(HOME, OFFICE, MOBILE, FAX, EMAIL, CUST_ID, CONTACT_ID)
values
(?, ?, ?, ?, ?, ?, ?)
Hibernate:
/* insert CustContacts
*/ insert
into
CUST_CONTACT
(HOME, OFFICE, MOBILE, FAX, EMAIL, CUST_ID, CONTACT_ID)
values
(?, ?, ?, ?, ?, ?, ?)
2969 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - preparing statement
2969 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Dehydrating entity: [CustContacts#385]
2969 [main] DEBUG org.hibernate.type.StringType - binding '123456' to parameter: 1
2969 [main] DEBUG org.hibernate.type.StringType - binding '654321' to parameter: 2
2969 [main] DEBUG org.hibernate.type.StringType - binding '98765432' to parameter: 3
2969 [main] DEBUG org.hibernate.type.StringType - binding '6543211' to parameter: 4
2969 [main] DEBUG org.hibernate.type.StringType - binding 'ali.khokhar@gmail.com' to parameter: 5
2969 [main] DEBUG org.hibernate.type.LongType - binding '384' to parameter: 6
2969 [main] DEBUG org.hibernate.type.LongType - binding '385' to parameter: 7
2969 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Inserting entity: [com.wonder.common.Address#386]
2969 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - Executing batch size: 1
3016 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
3016 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - closing statement
3016 [main] DEBUG org.hibernate.util.JDBCExceptionReporter - Could not execute JDBC batch update [/* insert CustContacts */ insert into CUST_CONTACT (HOME, OFFICE, MOBILE, FAX, EMAIL, CUST_ID, CONTACT_ID) values (?, ?, ?, ?, ?, ?, ?)]
java.sql.BatchUpdateException: ORA-02291: integrity constraint (WONDER.CUST_CONTACT_FK) violated - parent key not found

at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:367)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9118)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:218)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2159)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2595)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
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 com.wonder.dataaccesstier.CustomerDAO.insert(CustomerDAO.java:29)
at com.wonder.dataaccesstier.DataAccessFacade.insert(DataAccessFacade.java:59)
at com.wonder.businesstier.AddCustomer.execute(AddCustomer.java:37)
at com.wonder.businesstier.BusinessFacade.addCustomer(BusinessFacade.java:63)
at com.wonder.common.Manager.addCustomer(Manager.java:45)
at com.wonder.tests.TestCustomerDAO.testInsertCustomer(TestCustomerDAO.java:67)
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:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
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:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at org.junit.internal.runners.OldTestClassRunner.run(OldTestClassRunner.java:35)
at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:38)
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)
3032 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 2291, SQLState: 23000
3032 [main] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-02291: integrity constraint (WONDER.CUST_CONTACT_FK) violated - parent key not found

3032 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 2291, SQLState: 23000
3032 [main] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-02291: integrity constraint (WONDER.CUST_CONTACT_FK) violated - parent key not found

3032 [main] ERROR org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:218)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2159)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2595)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
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 com.wonder.dataaccesstier.CustomerDAO.insert(CustomerDAO.java:29)
at com.wonder.dataaccesstier.DataAccessFacade.insert(DataAccessFacade.java:59)
at com.wonder.businesstier.AddCustomer.execute(AddCustomer.java:37)
at com.wonder.businesstier.BusinessFacade.addCustomer(BusinessFacade.java:63)
at com.wonder.common.Manager.addCustomer(Manager.java:45)
at com.wonder.tests.TestCustomerDAO.testInsertCustomer(TestCustomerDAO.java:67)
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:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
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:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at org.junit.internal.runners.OldTestClassRunner.run(OldTestClassRunner.java:35)
at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:38)
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)
Caused by: java.sql.BatchUpdateException: ORA-02291: integrity constraint (WONDER.CUST_CONTACT_FK) violated - parent key not found

at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:367)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9118)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)
... 39 more
3079 [main] DEBUG org.hibernate.jdbc.ConnectionManager - registering flush end
Could not execute JDBC batch update
3079 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener - flushing session
3079 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener - processing flush-time cascades
3079 [main] DEBUG org.hibernate.engine.Cascade - processing cascade ACTION_SAVE_UPDATE for: com.wonder.common.Customer
3079 [main] DEBUG org.hibernate.engine.Cascade - cascade ACTION_SAVE_UPDATE for collection: com.wonder.common.Customer.contact
3079 [main] DEBUG org.hibernate.engine.CascadingAction - cascading to saveOrUpdate: CustContacts
3079 [main] DEBUG org.hibernate.event.def.AbstractSaveEventListener - persistent instance of: CustContacts
3079 [main] DEBUG org.hibernate.event.def.DefaultSaveOrUpdateEventListener - ignoring persistent instance
3079 [main] DEBUG org.hibernate.event.def.DefaultSaveOrUpdateEventListener - object already associated with session: [CustContacts#385]
3079 [main] DEBUG org.hibernate.engine.Cascade - done cascade ACTION_SAVE_UPDATE for collection: com.wonder.common.Customer.contact
3079 [main] DEBUG org.hibernate.engine.Cascade - cascade ACTION_SAVE_UPDATE for collection: com.wonder.common.Customer.address
3079 [main] DEBUG org.hibernate.engine.CascadingAction - cascading to saveOrUpdate: com.wonder.common.Address
3079 [main] DEBUG org.hibernate.event.def.AbstractSaveEventListener - persistent instance of: com.wonder.common.Address
3079 [main] DEBUG org.hibernate.event.def.DefaultSaveOrUpdateEventListener - ignoring persistent instance
3079 [main] DEBUG org.hibernate.event.def.DefaultSaveOrUpdateEventListener - object already associated with session: [com.wonder.common.Address#386]
3079 [main] DEBUG org.hibernate.engine.Cascade - done cascade ACTION_SAVE_UPDATE for collection: com.wonder.common.Customer.address
3079 [main] DEBUG org.hibernate.engine.Cascade - done processing cascade ACTION_SAVE_UPDATE for: com.wonder.common.Customer
3079 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener - dirty checking collections
3079 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener - Flushing entities and processing referenced collections
3079 [main] DEBUG org.hibernate.engine.Collections - Collection found: [com.wonder.common.Customer.contact#384], was: [<unreferenced>] (initialized)
3079 [main] DEBUG org.hibernate.engine.Collections - Collection found: [com.wonder.common.Customer.address#384], was: [<unreferenced>] (initialized)
3079 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener - Processing unreferenced collections
3079 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener - Scheduling collection removes/(re)creates/updates
3079 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener - Flushed: 3 insertions, 0 updates, 0 deletions to 3 objects
3079 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener - Flushed: 4 (re)creations, 0 updates, 0 removals to 2 collections
3079 [main] DEBUG org.hibernate.pretty.Printer - listing entities:
3079 [main] DEBUG org.hibernate.pretty.Printer - com.wonder.common.Address{Postcode=RM8 2LD, id=386, Street=Venice Street, Type=home, Country=UK, Road=Rich Road, City=London}
3079 [main] DEBUG org.hibernate.pretty.Printer - com.wonder.common.Customer{id=384, businessTitle=Ali Traders, address=[com.wonder.common.Address#386], regDate=25-JUN-2007, customerNumber=Cust-100, gender=Male, lName=Khokhar, contact=[CustContacts#385], fName=Ali}
3079 [main] DEBUG org.hibernate.pretty.Printer - com.wonder.common.Contact
3079 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener - executing flush
3079 [main] DEBUG org.hibernate.jdbc.ConnectionManager - registering flush begin
3079 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Inserting entity: [com.wonder.common.Customer#384]
3079 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
3079 [main] DEBUG org.hibernate.SQL -
/* insert com.wonder.common.Customer
*/ insert
into
CUSTOMER
(FIRST_NAME, LAST_NAME, GENDER, BUSINESS_TITLE, CUST_NO, REG_DATE, CUST_ID)
values
(?, ?, ?, ?, ?, ?, ?)
Hibernate:
/* insert com.wonder.common.Customer
*/ insert
into
CUSTOMER
(FIRST_NAME, LAST_NAME, GENDER, BUSINESS_TITLE, CUST_NO, REG_DATE, CUST_ID)
values
(?, ?, ?, ?, ?, ?, ?)
3079 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - preparing statement
3079 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Dehydrating entity: [com.wonder.common.Customer#384]
3079 [main] DEBUG org.hibernate.type.StringType - binding 'Ali' to parameter: 1
3079 [main] DEBUG org.hibernate.type.StringType - binding 'Khokhar' to parameter: 2
3079 [main] DEBUG org.hibernate.type.StringType - binding 'Male' to parameter: 3
3079 [main] DEBUG org.hibernate.type.StringType - binding 'Ali Traders' to parameter: 4
3079 [main] DEBUG org.hibernate.type.StringType - binding 'Cust-100' to parameter: 5
3079 [main] DEBUG org.hibernate.type.StringType - binding '25-JUN-2007' to parameter: 6
3079 [main] DEBUG org.hibernate.type.LongType - binding '384' to parameter: 7
3079 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Inserting entity: [CustContacts#385]
3079 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - Executing batch size: 1
3079 [main] DEBUG org.hibernate.jdbc.Expectations - success of batch update unknown: 0
3079 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
3079 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - closing statement
3079 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
3079 [main] DEBUG org.hibernate.SQL -
/* insert CustContacts
*/ insert
into
CUST_CONTACT
(HOME, OFFICE, MOBILE, FAX, EMAIL, CUST_ID, CONTACT_ID)
values
(?, ?, ?, ?, ?, ?, ?)
Hibernate:
/* insert CustContacts
*/ insert
into
CUST_CONTACT
(HOME, OFFICE, MOBILE, FAX, EMAIL, CUST_ID, CONTACT_ID)
values
(?, ?, ?, ?, ?, ?, ?)
3079 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - preparing statement
3079 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Dehydrating entity: [CustContacts#385]
3079 [main] DEBUG org.hibernate.type.StringType - binding '123456' to parameter: 1
3079 [main] DEBUG org.hibernate.type.StringType - binding '654321' to parameter: 2
3079 [main] DEBUG org.hibernate.type.StringType - binding '98765432' to parameter: 3
3079 [main] DEBUG org.hibernate.type.StringType - binding '6543211' to parameter: 4
3094 [main] DEBUG org.hibernate.type.StringType - binding 'ali.khokhar@gmail.com' to parameter: 5
3094 [main] DEBUG org.hibernate.type.LongType - binding '384' to parameter: 6
3094 [main] DEBUG org.hibernate.type.LongType - binding '385' to parameter: 7
3094 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister - Inserting entity: [com.wonder.common.Address#386]
3094 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - Executing batch size: 1
3125 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
3125 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - closing statement
3125 [main] DEBUG org.hibernate.util.JDBCExceptionReporter - Could not execute JDBC batch update [/* insert CustContacts */ insert into CUST_CONTACT (HOME, OFFICE, MOBILE, FAX, EMAIL, CUST_ID, CONTACT_ID) values (?, ?, ?, ?, ?, ?, ?)]
java.sql.BatchUpdateException: ORA-02291: integrity constraint (WONDER.CUST_CONTACT_FK) violated - parent key not found

at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:367)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9118)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:218)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2159)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2595)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
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 com.wonder.dataaccesstier.CustomerDAO.insert(CustomerDAO.java:34)
at com.wonder.dataaccesstier.DataAccessFacade.insert(DataAccessFacade.java:59)
at com.wonder.businesstier.AddCustomer.execute(AddCustomer.java:37)
at com.wonder.businesstier.BusinessFacade.addCustomer(BusinessFacade.java:63)
at com.wonder.common.Manager.addCustomer(Manager.java:45)
at com.wonder.tests.TestCustomerDAO.testInsertCustomer(TestCustomerDAO.java:67)
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:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
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:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at org.junit.internal.runners.OldTestClassRunner.run(OldTestClassRunner.java:35)
at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:38)
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)
3125 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 2291, SQLState: 23000
3125 [main] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-02291: integrity constraint (WONDER.CUST_CONTACT_FK) violated - parent key not found

3125 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 2291, SQLState: 23000
3125 [main] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-02291: integrity constraint (WONDER.CUST_CONTACT_FK) violated - parent key not found

3125 [main] ERROR org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:218)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2159)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2595)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
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 com.wonder.dataaccesstier.CustomerDAO.insert(CustomerDAO.java:34)
at com.wonder.dataaccesstier.DataAccessFacade.insert(DataAccessFacade.java:59)
at com.wonder.businesstier.AddCustomer.execute(AddCustomer.java:37)
at com.wonder.businesstier.BusinessFacade.addCustomer(BusinessFacade.java:63)
at com.wonder.common.Manager.addCustomer(Manager.java:45)
at com.wonder.tests.TestCustomerDAO.testInsertCustomer(TestCustomerDAO.java:67)
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:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
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:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at org.junit.internal.runners.OldTestClassRunner.run(OldTestClassRunner.java:35)
at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:38)
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)
Caused by: java.sql.BatchUpdateException: ORA-02291: integrity constraint (WONDER.CUST_CONTACT_FK) violated - parent key not found

at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:367)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9118)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)
... 37 more
3141 [main] DEBUG org.hibernate.jdbc.ConnectionManager - registering flush end

_________________
Thanks in Advance
Kashif


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