When I run the below code snippet, the two individuals object get saved, but the PARENT_ID and PARENT_POS do not get updated when the asset is saved. Please help or point me to the doc that I missed. Thank you.
Hibernate version: 2.1.4
Mapping documents:
AssetImpl.hbm.xml
Code:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class name="defaultprofile.impl.AssetImpl" table="ASSET" dynamic-update="false" dynamic-insert="false">
<id name="assetId" type="int" unsaved-value="-1">
<column name="ASSET_ID" not-null="true" />
<generator class="sequence">
<param name="sequence">ID_SEQUENCE</param>
</generator>
</id>
<property name="name" type="string" update="true" insert="true" access="property">
<column name="NAME" length="255" not-null="true" />
</property>
<property name="id" type="string" update="true" insert="true" access="property">
<column name="ID" length="255" not-null="true" />
</property>
<property name="date" type="string" update="true" insert="true" access="property">
<column name="DATE" length="255" not-null="false" />
</property>
<property name="state" type="string" update="true" insert="true" access="property">
<column name="STATE" length="255" not-null="false" />
</property>
<property name="version" type="string" update="true" insert="true" access="property">
<column name="VERSION" length="255" not-null="false" />
</property>
<property name="accessRights" type="string" update="true" insert="true" access="property">
<column name="ACCESS_RIGHTS" length="255" not-null="false" />
</property>
<property name="shortDescription" type="string" update="true" insert="true" access="property">
<column name="SHORT_DESC" length="255" not-null="false" />
</property>
<many-to-one name="classification" class="defaultprofile.impl.ClassificationImpl" cascade="all" outer-join="auto" update="true" insert="true" access="property" column="CLASSIFICATION_ID" />
<many-to-one name="solution" class="defaultprofile.impl.SolutionImpl" cascade="all" outer-join="auto" update="true" insert="true" access="property" column="SOLUTION_ID" />
<many-to-one name="usage" class="defaultprofile.impl.UsageImpl" cascade="all" outer-join="auto" update="true" insert="true" access="property" column="USAGE_ID" />
<list name="relatedAsset" lazy="false" inverse="false" cascade="all">
<key column="PARENT_ID"></key>
<index column="PARENT_POS" />
<one-to-many class="defaultprofile.impl.RelatedAssetImpl" />
</list>
<many-to-one name="profile" class="defaultprofile.impl.ProfileImpl" cascade="none" outer-join="auto" update="true" insert="true" access="property" column="PROFILE_ID" />
<many-to-one name="description" class="defaultprofile.impl.DescriptionImpl" cascade="none" outer-join="auto" update="true" insert="true" access="property" column="DESCRIPTION_ID" />
<!--
To add non XDoclet property mappings, create a file named
hibernate-properties-AssetImpl.xml
containing the additional properties and place it in your merge dir.
-->
</class>
</hibernate-mapping>
RelatedAssetImpl.hbm.xml
Code:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class name="defaultprofile.impl.RelatedAssetImpl" table="RELATED_ASSET" dynamic-update="false" dynamic-insert="false">
<id name="id" type="int" unsaved-value="-1">
<column name="RELATED_ASSET_ID" not-null="true" />
<column name="RELATED_ASSET_ID" not-null="true" />
<generator class="sequence">
<param name="sequence">ID_SEQUENCE</param>
<param name="sequence">ID_SEQUENCE</param>
</generator>
</id>
<property name="name" type="string" update="true" insert="true" access="property">
<column name="NAME" length="255" not-null="true" />
</property>
<property name="relationshipType" type="string" update="true" insert="true" access="property">
<column name="RELATIONSHIP_TYPE" length="255" not-null="true" />
</property>
<property name="assetId" type="string" update="true" insert="true" access="property">
<column name="ASSET_ID" length="255" />
</property>
<many-to-one name="description" class="defaultprofile.impl.DescriptionImpl" cascade="none" outer-join="auto" update="true" insert="true" access="property" column="DESCRIPTION_ID" />
<many-to-one name="reference" class="defaultprofile.impl.ArtifactImpl" cascade="none" outer-join="auto" update="true" insert="true" access="property" column="ARTIFACT_ID" />
<!--
To add non XDoclet property mappings, create a file named
hibernate-properties-RelatedAssetImpl.xml
containing the additional properties and place it in your merge dir.
-->
</class>
</hibernate-mapping>
Code between sessionFactory.openSession() and session.close():Code:
// Ask for a session using the JDBC information we've configured
Session session = sessionFactory.openSession();
Transaction tx = null;
try
{
tx = session.beginTransaction();
// Create some data
Asset asset = DefaultprofileFactory.eINSTANCE.createAsset();
asset.setId("XXXXX");
asset.setAccessRights("*");
asset.setShortDescription("Short Description");
asset.setName("Asset Name");
RelatedAsset related = DefaultprofileFactory.eINSTANCE.createRelatedAsset();
related.setAssetId("XXXXXXX");
related.setName("Related Asset");
related.setRelationshipType("child");
asset.getRelatedAsset().add(related);
// Persist to DB2
session.save(related);
session.save(asset);
// We're done; make our changes permanent
tx.commit();
}
catch (Exception e)
{
if (tx != null)
{
// Something went wrong; discard all partial changes
tx.rollback();
}
throw e;
}
finally
{
// No matter what, close the session
session.close();
}
Full stack trace of any exception that occurs: No exceptions
Name and version of the database you are using: DB2 8.1
Debug level Hibernate log excerpt:Code:
16:43:25,024 INFO Environment:462 - Hibernate 2.1.4
16:43:25,034 INFO Environment:491 - hibernate.properties not found
16:43:25,034 INFO Environment:522 - using CGLIB reflection optimizer
16:43:25,034 INFO Environment:533 - JVM does not support Statement.getGeneratedKeys()
16:43:25,044 INFO Environment:544 - JVM does not support LinkedHasMap, LinkedHashSet - ordered maps and sets disabled
16:43:25,054 INFO Environment:547 - using workaround for JVM bug in java.sql.Timestamp
16:43:25,054 INFO Configuration:872 - configuring from resource: /hibernate.cfg.xml
16:43:25,054 INFO Configuration:844 - Configuration resource: /hibernate.cfg.xml
16:43:25,445 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd in classpath under net/sf/hibernate/
16:43:25,445 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd in classpath
16:43:25,515 DEBUG Configuration:830 - connection.url=jdbc:db2:ECBA_T
16:43:25,515 DEBUG Configuration:830 - connection.driver_class=COM.ibm.db2.jdbc.app.DB2Driver
16:43:25,515 DEBUG Configuration:830 - connection.username=db2inst1
16:43:25,515 DEBUG Configuration:830 - connection.password=XXXXXXXX
16:43:25,525 DEBUG Configuration:830 - show_sql=true
16:43:25,525 DEBUG Configuration:830 - dialect=net.sf.hibernate.dialect.DB2Dialect
.......
16:43:27,658 DEBUG Configuration:989 - null<-org.dom4j.tree.DefaultAttribute@21134ed2 [Attribute: name resource value "defaultprofile/impl/AssetImpl.hbm.xml"]
16:43:27,658 INFO Configuration:328 - Mapping resource: defaultprofile/impl/AssetImpl.hbm.xml
16:43:27,678 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
16:43:27,698 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
16:43:27,728 INFO Binder:229 - Mapping class: defaultprofile.impl.AssetImpl -> ASSET
16:43:27,728 DEBUG Binder:475 - Mapped property: assetId -> ASSET_ID, type: integer
16:43:27,748 DEBUG Binder:475 - Mapped property: name -> NAME, type: string
16:43:27,748 DEBUG Binder:475 - Mapped property: id -> ID, type: string
16:43:27,748 DEBUG Binder:475 - Mapped property: date -> DATE, type: string
16:43:27,748 DEBUG Binder:475 - Mapped property: state -> STATE, type: string
16:43:27,748 DEBUG Binder:475 - Mapped property: version -> VERSION, type: string
16:43:27,748 DEBUG Binder:475 - Mapped property: accessRights -> ACCESS_RIGHTS, type: string
16:43:27,748 DEBUG Binder:475 - Mapped property: shortDescription -> SHORT_DESC, type: string
16:43:27,748 DEBUG Binder:475 - Mapped property: classification -> CLASSIFICATION_ID, type: defaultprofile.impl.ClassificationImpl
16:43:27,758 DEBUG Binder:475 - Mapped property: solution -> SOLUTION_ID, type: defaultprofile.impl.SolutionImpl
16:43:27,768 DEBUG Binder:475 - Mapped property: usage -> USAGE_ID, type: defaultprofile.impl.UsageImpl
16:43:27,768 DEBUG Binder:475 - Mapped property: relatedAsset, type: java.util.List
16:43:27,778 DEBUG Binder:475 - Mapped property: profile -> PROFILE_ID, type: defaultprofile.impl.ProfileImpl
16:43:27,778 DEBUG Binder:475 - Mapped property: description -> DESCRIPTION_ID, type: defaultprofile.impl.DescriptionImpl
......
16:43:28,429 DEBUG Configuration:989 - null<-org.dom4j.tree.DefaultAttribute@21a2ced2 [Attribute: name resource value "defaultprofile/impl/RelatedAssetImpl.hbm.xml"]
16:43:28,429 INFO Configuration:328 - Mapping resource: defaultprofile/impl/RelatedAssetImpl.hbm.xml
16:43:28,449 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
16:43:28,449 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
16:43:28,469 INFO Binder:229 - Mapping class: defaultprofile.impl.RelatedAssetImpl -> RELATED_ASSET
16:43:28,469 DEBUG Binder:475 - Mapped property: id -> RELATED_ASSET_ID, type: integer
16:43:28,469 DEBUG Binder:475 - Mapped property: name -> NAME, type: string
16:43:28,469 DEBUG Binder:475 - Mapped property: relationshipType -> RELATIONSHIP_TYPE, type: string
16:43:28,469 DEBUG Binder:475 - Mapped property: assetId -> ASSET_ID, type: string
16:43:28,469 DEBUG Binder:475 - Mapped property: description -> DESCRIPTION_ID, type: defaultprofile.impl.DescriptionImpl
16:43:28,469 DEBUG Binder:475 - Mapped property: reference -> ARTIFACT_ID, type: defaultprofile.impl.ArtifactImpl
......
16:43:29,120 INFO Configuration:1030 - Configured SessionFactory: null
16:43:29,130 DEBUG Configuration:1031 - properties: {java.assistive=ON, hibernate.connection.password=XXXXX, java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, sun.boot.library.path=C:\Program Files\IBM\WebSphere Studio\Application Developer\v5.1.2\eclipse\jre\bin, java.vm.version=1.3.1, hibernate.connection.username=db2inst1, java.vm.vendor=IBM Corporation, java.vendor.url=http://www.ibm.com/, path.separator=;, java.vm.name=Classic VM, file.encoding.pkg=sun.io, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile, java.runtime.version=1.3.1, java.fullversion=J2RE 1.3.1 IBM Windows 32 build cn131-20031021 (JIT enabled: jitc), java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., java.awt.fonts=, os.name=Windows XP, java.library.path=C:\Program Files\IBM\WebSphere Studio\Application Developer\v5.1.2\eclipse\jre\bin;.;C:\WINDOWS\System32;C:\WINDOWS;C:\Program Files\IBM\WebSphere Studio\Application Developer\v5.1.2\eclipse\jre\bin;C:\PROGRAM FILES\THINKPAD\UTILITIES;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\IBM\Infoprint Select;C:\Utilities;C:\Notes;C:\Program Files\IBM\Trace Facility\;C:\Program Files\IBM\Personal Communications\;C:\Program Files\XLView\;C:\lotus\compnent\;C:\WINDOWS\Downloaded Program Files;C:\PROGRA~1\ULTRAE~1;C:\PROGRA~1\IBM\SQLLIB\BIN;C:\PROGRA~1\IBM\SQLLIB\FUNCTION;C:\PROGRA~1\IBM\SQLLIB\SAMPLES\REPL;C:\Program Files\Rational\common;C:\Program Files\IBM\Java142\bin;C:\Infoprint;, java.specification.name=Java Platform API Specification, java.class.version=46.0, invokedviajava=, os.version=5.1, connection.password=XXXXX, user.home=C:\Documents and Settings\Administrator, user.timezone=America/New_York, connection.username=db2inst1, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.3, hibernate.connection.driver_class=COM.ibm.db2.jdbc.app.DB2Driver, show_sql=true, user.name=jyellis, java.class.path=C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\runtime;C:\Program Files\IBM\WebSphere Studio\Application Developer\v5.1.2\eclipse\plugins\org.apache.xerces_4.0.13\xmlParserAPIs.jar;C:\Program Files\IBM\WebSphere Studio\Application Developer\v5.1.2\eclipse\plugins\org.apache.xerces_4.0.13\xercesImpl.jar;C:\Program Files\IBM\WebSphere Studio\Application Developer\v5.1.2\eclipse\plugins\org.eclipse.core.runtime_2.1.1\runtime.jar;C:\Program Files\IBM\WebSphere Studio\Application Developer\v5.1.2\eclipse\plugins\org.eclipse.core.resources_2.1.1\resources.jar;C:\Program Files\IBM\WebSphere Studio\Application Developer\v5.1.2\eclipse\plugins\org.eclipse.emf.common_1.1.1\runtime\common.jar;C:\Program Files\IBM\WebSphere Studio\Application Developer\v5.1.2\eclipse\plugins\org.eclipse.emf.ecore_1.1.1\runtime\ecore.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\ant-1.5.3.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\ant-optional-1.5.3.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\c3p0-0.8.4.5.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\cglib-full-2.0.1.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\commons-collections-2.0.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\commons-collections-2.1.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\commons-dbcp-1.1.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\commons-lang-1.0.1.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\commons-logging.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\commons-logging-1.0.3.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\commons-pool-1.1.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\concurrent-1.3.2.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\connector.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\db2java.zip;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\dom4j-1.4.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\ehcache-0.7.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\hibernate2.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\hibernate-tools.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\hsqldb.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\jaas.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\jboss-cache.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\jboss-common.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\jboss-jmx.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\jboss-system.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\jcs-1.0-dev.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\jdbc2_0-stdext.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\jdom.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\jgroups-2.2.1.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\jta.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\junit-3.8.1.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\log4j.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\log4j-1.2.8.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\odmg-3.0.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\oscache-2.0.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\proxool-0.8.3.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\swarmcache-1.0rc2.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\velocity-1.3.1.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\xalan-2.4.0.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\xdoclet-1.2.1.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\xdoclet-hibernate-module-1.2.1.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\xdoclet-xdoclet-module-1.2.1.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\xerces-2.4.0.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\xjavadoc-1.0.3.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\xml-apis.jar;C:\Program Files\IBM\WebSphere Studio\Application Developer\v5.1.2\eclipse\plugins\org.eclipse.emf.ecore.xmi_1.1.1\runtime\ecore.xmi.jar, hibernate.show_sql=true, java.vm.specification.version=1.0, java.home=C:\Program Files\IBM\WebSphere Studio\Application Developer\v5.1.2\eclipse\jre, hibernate.dialect=net.sf.hibernate.dialect.DB2Dialect, hibernate.connection.url=jdbc:db2:ECBA_T, user.language=en, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, hibernate.cglib.use_reflection_optimizer=true, java.vm.info=J2RE 1.3.1 IBM Windows 32 build cn131-20031021 (JIT enabled: jitc), java.version=1.3.1, java.ext.dirs=C:\Program Files\IBM\WebSphere Studio\Application Developer\v5.1.2\eclipse\jre\lib\ext, sun.boot.class.path=C:\Program Files\IBM\WebSphere Studio\Application Developer\v5.1.2\eclipse\jre\lib\rt.jar;C:\Program Files\IBM\WebSphere Studio\Application Developer\v5.1.2\eclipse\jre\lib\i18n.jar;C:\Program Files\IBM\WebSphere Studio\Application Developer\v5.1.2\eclipse\jre\classes, java.vendor=IBM Corporation, connection.driver_class=COM.ibm.db2.jdbc.app.DB2Driver, file.separator=\, java.vendor.url.bug=, java.compiler=jitc, sun.io.unicode.encoding=UnicodeLittle, user.region=US, connection.url=jdbc:db2:ECBA_T, dialect=net.sf.hibernate.dialect.DB2Dialect}
16:43:29,140 INFO Configuration:613 - processing one-to-many association mappings
.....
16:43:29,160 DEBUG Binder:1340 - Second pass for collection: defaultprofile.impl.AssetImpl.relatedAsset
16:43:29,160 INFO Binder:1168 - Mapping collection: defaultprofile.impl.AssetImpl.relatedAsset -> RELATED_ASSET
16:43:29,160 DEBUG Binder:1355 - Mapped collection key: PARENT_ID, index: PARENT_POS, one-to-many: defaultprofile.impl.RelatedAssetImpl
.....
16:43:29,230 INFO Dialect:82 - Using dialect: net.sf.hibernate.dialect.DB2Dialect
16:43:29,230 INFO SettingsFactory:62 - Use outer join fetching: true
16:43:29,240 INFO DriverManagerConnectionProvider:42 - Using Hibernate built-in connection pool (not for production use!)
16:43:29,250 INFO DriverManagerConnectionProvider:43 - Hibernate connection pool size: 20
16:43:29,471 INFO DriverManagerConnectionProvider:77 - using driver: COM.ibm.db2.jdbc.app.DB2Driver at URL: jdbc:db2:ECBA_T
16:43:29,471 INFO DriverManagerConnectionProvider:78 - connection properties: {user=db2inst1, password=XXXXXX}
16:43:29,481 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of process level read-write cache is not recommended)
16:43:29,481 DEBUG DriverManagerConnectionProvider:84 - total checked-out connections: 0
16:43:29,481 DEBUG DriverManagerConnectionProvider:100 - opening new JDBC connection
16:43:29,611 DEBUG DriverManagerConnectionProvider:106 - created connection to: jdbc:db2:ECBA_T, Isolation Level: 2
16:43:29,611 DEBUG DriverManagerConnectionProvider:120 - returning connection to pool, pool size: 1
16:43:29,611 INFO SettingsFactory:102 - Use scrollable result sets: true
16:43:29,611 INFO SettingsFactory:105 - Use JDBC3 getGeneratedKeys(): false
16:43:29,611 INFO SettingsFactory:108 - Optimize cache for minimal puts: false
16:43:29,611 INFO SettingsFactory:114 - echoing all SQL to stdout
16:43:29,611 INFO SettingsFactory:117 - Query language substitutions: {}
16:43:29,611 INFO SettingsFactory:128 - cache provider: net.sf.ehcache.hibernate.Provider
16:43:29,621 INFO Configuration:1093 - instantiating and configuring caches
16:43:29,891 INFO SessionFactoryImpl:119 - building session factory
16:43:29,891 DEBUG SessionFactoryImpl:125 - instantiating session factory with properties: {java.assistive=ON, hibernate.connection.password=XXXXX, java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, sun.boot.library.path=C:\Program Files\IBM\WebSphere Studio\Application Developer\v5.1.2\eclipse\jre\bin, java.vm.version=1.3.1, hibernate.connection.username=db2inst1, java.vm.vendor=IBM Corporation, java.vendor.url=http://www.ibm.com/, path.separator=;, java.vm.name=Classic VM, file.encoding.pkg=sun.io, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile, java.runtime.version=1.3.1, java.fullversion=J2RE 1.3.1 IBM Windows 32 build cn131-20031021 (JIT enabled: jitc), java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., java.awt.fonts=, os.name=Windows XP, java.library.path=C:\Program Files\IBM\WebSphere Studio\Application Developer\v5.1.2\eclipse\jre\bin;.;C:\WINDOWS\System32;C:\WINDOWS;C:\Program Files\IBM\WebSphere Studio\Application Developer\v5.1.2\eclipse\jre\bin;C:\PROGRAM FILES\THINKPAD\UTILITIES;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\IBM\Infoprint Select;C:\Utilities;C:\Notes;C:\Program Files\IBM\Trace Facility\;C:\Program Files\IBM\Personal Communications\;C:\Program Files\XLView\;C:\lotus\compnent\;C:\WINDOWS\Downloaded Program Files;C:\PROGRA~1\ULTRAE~1;C:\PROGRA~1\IBM\SQLLIB\BIN;C:\PROGRA~1\IBM\SQLLIB\FUNCTION;C:\PROGRA~1\IBM\SQLLIB\SAMPLES\REPL;C:\Program Files\Rational\common;C:\Program Files\IBM\Java142\bin;C:\Infoprint;, java.specification.name=Java Platform API Specification, java.class.version=46.0, invokedviajava=, os.version=5.1, connection.password=XXXXX, user.home=C:\Documents and Settings\Administrator, user.timezone=America/New_York, connection.username=db2inst1, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.3, hibernate.connection.driver_class=COM.ibm.db2.jdbc.app.DB2Driver, show_sql=true, user.name=jyellis, java.class.path=C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\runtime;C:\Program Files\IBM\WebSphere Studio\Application Developer\v5.1.2\eclipse\plugins\org.apache.xerces_4.0.13\xmlParserAPIs.jar;C:\Program Files\IBM\WebSphere Studio\Application Developer\v5.1.2\eclipse\plugins\org.apache.xerces_4.0.13\xercesImpl.jar;C:\Program Files\IBM\WebSphere Studio\Application Developer\v5.1.2\eclipse\plugins\org.eclipse.core.runtime_2.1.1\runtime.jar;C:\Program Files\IBM\WebSphere Studio\Application Developer\v5.1.2\eclipse\plugins\org.eclipse.core.resources_2.1.1\resources.jar;C:\Program Files\IBM\WebSphere Studio\Application Developer\v5.1.2\eclipse\plugins\org.eclipse.emf.common_1.1.1\runtime\common.jar;C:\Program Files\IBM\WebSphere Studio\Application Developer\v5.1.2\eclipse\plugins\org.eclipse.emf.ecore_1.1.1\runtime\ecore.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\ant-1.5.3.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\ant-optional-1.5.3.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\c3p0-0.8.4.5.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\cglib-full-2.0.1.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\commons-collections-2.0.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\commons-collections-2.1.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\commons-dbcp-1.1.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\commons-lang-1.0.1.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\commons-logging.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\commons-logging-1.0.3.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\commons-pool-1.1.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\concurrent-1.3.2.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\connector.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\db2java.zip;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\dom4j-1.4.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\ehcache-0.7.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\hibernate2.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\hibernate-tools.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\hsqldb.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\jaas.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\jboss-cache.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\jboss-common.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\jboss-jmx.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\jboss-system.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\jcs-1.0-dev.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\jdbc2_0-stdext.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\jdom.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\jgroups-2.2.1.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\jta.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\junit-3.8.1.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\log4j.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\log4j-1.2.8.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\odmg-3.0.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\oscache-2.0.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\proxool-0.8.3.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\swarmcache-1.0rc2.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\velocity-1.3.1.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\xalan-2.4.0.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\xdoclet-1.2.1.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\xdoclet-hibernate-module-1.2.1.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\xdoclet-xdoclet-module-1.2.1.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\xerces-2.4.0.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\xjavadoc-1.0.3.jar;C:\Documents and Settings\Administrator\My Documents\Workspaces5.1\ECBA\DefaultProfile\hibernate\lib\xml-apis.jar;C:\Program Files\IBM\WebSphere Studio\Application Developer\v5.1.2\eclipse\plugins\org.eclipse.emf.ecore.xmi_1.1.1\runtime\ecore.xmi.jar, hibernate.show_sql=true, java.vm.specification.version=1.0, java.home=C:\Program Files\IBM\WebSphere Studio\Application Developer\v5.1.2\eclipse\jre, hibernate.dialect=net.sf.hibernate.dialect.DB2Dialect, hibernate.connection.url=jdbc:db2:ECBA_T, user.language=en, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, hibernate.cglib.use_reflection_optimizer=true, java.vm.info=J2RE 1.3.1 IBM Windows 32 build cn131-20031021 (JIT enabled: jitc), java.version=1.3.1, java.ext.dirs=C:\Program Files\IBM\WebSphere Studio\Application Developer\v5.1.2\eclipse\jre\lib\ext, sun.boot.class.path=C:\Program Files\IBM\WebSphere Studio\Application Developer\v5.1.2\eclipse\jre\lib\rt.jar;C:\Program Files\IBM\WebSphere Studio\Application Developer\v5.1.2\eclipse\jre\lib\i18n.jar;C:\Program Files\IBM\WebSphere Studio\Application Developer\v5.1.2\eclipse\jre\classes, java.vendor=IBM Corporation, connection.driver_class=COM.ibm.db2.jdbc.app.DB2Driver, file.separator=\, java.vendor.url.bug=, java.compiler=jitc, sun.io.unicode.encoding=UnicodeLittle, user.region=US, connection.url=jdbc:db2:ECBA_T, dialect=net.sf.hibernate.dialect.DB2Dialect}
......
16:43:32,204 DEBUG SessionFactoryObjectFactory:39 - initializing class SessionFactoryObjectFactory
16:43:32,214 DEBUG SessionFactoryObjectFactory:76 - registered: 89ac3e08fe4a70f400fe4a70fde20000 (unnamed)
16:43:32,214 INFO SessionFactoryObjectFactory:82 - no JNDI name configured
16:43:32,214 DEBUG SessionFactoryImpl:196 - instantiated session factory
16:43:32,275 DEBUG SessionImpl:555 - opened session
16:43:32,275 DEBUG JDBCTransaction:37 - begin
16:43:32,275 DEBUG DriverManagerConnectionProvider:84 - total checked-out connections: 0
16:43:32,275 DEBUG DriverManagerConnectionProvider:90 - using pooled JDBC connection, pool size: 0
16:43:32,275 DEBUG JDBCTransaction:41 - current autocommit status:false
16:43:32,305 DEBUG BatcherImpl:196 - about to open: 0 open PreparedStatements, 0 open ResultSets
16:43:32,305 DEBUG SQL:237 - values nextval for ID_SEQUENCE
Hibernate: values nextval for ID_SEQUENCE
16:43:32,305 DEBUG BatcherImpl:241 - preparing statement
16:43:32,325 DEBUG SequenceGenerator:81 - Sequence identifier generated: 166
16:43:32,325 DEBUG BatcherImpl:203 - done closing: 0 open PreparedStatements, 0 open ResultSets
16:43:32,325 DEBUG BatcherImpl:261 - closing statement
16:43:32,325 DEBUG SessionImpl:778 - generated identifier: 166
16:43:32,325 DEBUG SessionImpl:825 - saving [defaultprofile.impl.RelatedAssetImpl#166]
16:43:32,335 DEBUG BatcherImpl:196 - about to open: 0 open PreparedStatements, 0 open ResultSets
16:43:32,335 DEBUG SQL:237 - values nextval for ID_SEQUENCE
Hibernate: values nextval for ID_SEQUENCE
16:43:32,335 DEBUG BatcherImpl:241 - preparing statement
16:43:32,365 DEBUG SequenceGenerator:81 - Sequence identifier generated: 167
16:43:32,365 DEBUG BatcherImpl:203 - done closing: 0 open PreparedStatements, 0 open ResultSets
16:43:32,365 DEBUG BatcherImpl:261 - closing statement
16:43:32,365 DEBUG SessionImpl:778 - generated identifier: 167
16:43:32,365 DEBUG SessionImpl:825 - saving [defaultprofile.impl.AssetImpl#167]
16:43:32,365 DEBUG Cascades:497 - processing cascades for: defaultprofile.impl.AssetImpl
16:43:32,365 DEBUG Cascades:506 - done processing cascades for: defaultprofile.impl.AssetImpl
16:43:32,385 DEBUG WrapVisitor:81 - Wrapped collection in role: defaultprofile.impl.AssetImpl.relatedAsset
16:43:32,385 DEBUG Cascades:497 - processing cascades for: defaultprofile.impl.AssetImpl
16:43:32,385 DEBUG Cascades:524 - cascading to collection: defaultprofile.impl.AssetImpl.relatedAsset
16:43:32,385 DEBUG Cascades:506 - done processing cascades for: defaultprofile.impl.AssetImpl
16:43:32,385 DEBUG JDBCTransaction:59 - commit
16:43:32,385 DEBUG SessionImpl:2242 - flushing session
16:43:32,385 DEBUG Cascades:497 - processing cascades for: defaultprofile.impl.AssetImpl
16:43:32,385 DEBUG Cascades:524 - cascading to collection: defaultprofile.impl.AssetImpl.relatedAsset
16:43:32,385 DEBUG Cascades:506 - done processing cascades for: defaultprofile.impl.AssetImpl
16:43:32,385 DEBUG SessionImpl:2435 - Flushing entities and processing referenced collections
16:43:32,395 DEBUG WrapVisitor:81 - Wrapped collection in role: defaultprofile.impl.AssetImpl.relatedAsset
16:43:32,395 DEBUG SessionImpl:2880 - Collection found: [defaultprofile.impl.AssetImpl.relatedAsset#167], was: [<unreferenced>]
16:43:32,395 DEBUG SessionImpl:2776 - Processing unreferenced collections
16:43:32,395 DEBUG SessionImpl:2790 - Scheduling collection removes/(re)creates/updates
16:43:32,395 DEBUG SessionImpl:2266 - Flushed: 2 insertions, 0 updates, 0 deletions to 2 objects
16:43:32,395 DEBUG SessionImpl:2271 - Flushed: 1 (re)creations, 0 updates, 0 removals to 2 collections
16:43:32,415 DEBUG Printer:75 - listing entities:
16:43:32,415 DEBUG Printer:82 - defaultprofile.impl.AssetImpl{state=null, name=Asset Name, id=XXXXX, profile=null, shortDescription=Short Description, date=null, accessRights=*, classification=null, version=null, solution=null, usage=null, relatedAsset=[], description=null, assetId=167}
16:43:32,415 DEBUG Printer:82 - defaultprofile.impl.RelatedAssetImpl{reference=null, name=Related Asset, description=null, assetId=XXXXXXX, relationshipType=child, id=166}
16:43:32,415 DEBUG SessionImpl:2355 - executing flush
16:43:32,415 DEBUG EntityPersister:453 - Inserting entity: [defaultprofile.impl.RelatedAssetImpl#166]
16:43:32,415 DEBUG BatcherImpl:196 - about to open: 0 open PreparedStatements, 0 open ResultSets
16:43:32,415 DEBUG SQL:237 - insert into RELATED_ASSET (NAME, RELATIONSHIP_TYPE, ASSET_ID, DESCRIPTION_ID, ARTIFACT_ID, RELATED_ASSET_ID) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into RELATED_ASSET (NAME, RELATIONSHIP_TYPE, ASSET_ID, DESCRIPTION_ID, ARTIFACT_ID, RELATED_ASSET_ID) values (?, ?, ?, ?, ?, ?)
16:43:32,415 DEBUG BatcherImpl:241 - preparing statement
16:43:32,425 DEBUG EntityPersister:388 - Dehydrating entity: [defaultprofile.impl.RelatedAssetImpl#166]
16:43:32,425 DEBUG EntityPersister:453 - Inserting entity: [defaultprofile.impl.AssetImpl#167]
16:43:32,425 DEBUG BatcherImpl:203 - done closing: 0 open PreparedStatements, 0 open ResultSets
16:43:32,425 DEBUG BatcherImpl:261 - closing statement
16:43:32,425 DEBUG BatcherImpl:196 - about to open: 0 open PreparedStatements, 0 open ResultSets
16:43:32,435 DEBUG SQL:237 - insert into ASSET (NAME, ID, DATE, STATE, VERSION, ACCESS_RIGHTS, SHORT_DESC, CLASSIFICATION_ID, SOLUTION_ID, USAGE_ID, PROFILE_ID, DESCRIPTION_ID, ASSET_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into ASSET (NAME, ID, DATE, STATE, VERSION, ACCESS_RIGHTS, SHORT_DESC, CLASSIFICATION_ID, SOLUTION_ID, USAGE_ID, PROFILE_ID, DESCRIPTION_ID, ASSET_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
16:43:32,435 DEBUG BatcherImpl:241 - preparing statement
16:43:32,435 DEBUG EntityPersister:388 - Dehydrating entity: [defaultprofile.impl.AssetImpl#167]
16:43:32,435 DEBUG BatcherImpl:203 - done closing: 0 open PreparedStatements, 0 open ResultSets
16:43:32,445 DEBUG BatcherImpl:261 - closing statement
16:43:32,445 DEBUG BasicCollectionPersister:508 - Inserting collection: [defaultprofile.impl.AssetImpl.relatedAsset#167]
16:43:32,445 DEBUG BasicCollectionPersister:539 - collection was empty
16:43:32,445 DEBUG SessionImpl:2820 - post flush
16:43:32,465 DEBUG SessionImpl:585 - transaction completion
16:43:32,465 DEBUG SessionImpl:573 - closing session
16:43:32,465 DEBUG SessionImpl:3332 - disconnecting session
16:43:32,465 DEBUG DriverManagerConnectionProvider:120 - returning connection to pool, pool size: 1
16:43:32,465 DEBUG SessionImpl:585 - transaction completion
16:43:32,465 INFO SessionFactoryImpl:531 - closing
16:43:32,465 INFO DriverManagerConnectionProvider:143 - cleaning up connection pool: jdbc:db2:ECBA_T