Hibernate Community • View topic - Cannot populate a column.

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Cannot populate a column.

Page 1 of 1

[ 8 posts ]

Previous topic | Next topic

Author

Message

ndk

Post subject: Cannot populate a column.

Posted: Fri Nov 04, 2005 4:48 pm

Newbie

Joined: Fri Nov 04, 2005 4:26 pm
Posts: 5

I have a simple database schema with 3 tables that I have used the ant reverse engineering tools to develop mapping classes and POJOs. A simple method to add a record to one of these tables does not populate one particular column. I have found no way to do this, having tried cascade="all", and removing insert="false".

The issue, as I see it, as that I have a foreign key which is compound. One column of that key is also part of the primary key. The compound foreign key is marked 'insert = false', I assume because one of the columns in that key is populated by virtue of it being part of the primary key. However, the other column of the foreign key is not present in the INSERT SQL. Setting the dependent object does not cause this to update. I have tried various experiments, all have failed. Removing insert=false, of course causes an exception because the primary key column that is also part of the foreign key then appears twice.

Although I have tried it, I believe the same pattern attempted with forward engineering would also run into similar difficulties.

Now, about the schema. There is a general pattern here that I think is not so unusual. I have many tables, with various "planes" of data present. Mutliple banks within the schema, each with their own set of transaction codes and own set of transactions. The transaction codes and transactions are qualified by the bank id. I don't see this as particularly strange or unusual.

I am stumped - cannot get the transaction code column in the transaction log table to populate no matter what I try.

Hibernate version: 3.1rc1

Mapping documents (auto generated by reverse engineering process):

Code:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<!-- 
    Auto-generated mapping file from
    the hibernate.org cfg2hbm engine
-->
    <class name="com.epocket.simplehibernatedebug.domain.Bank" table="BANK" schema="HIBERNATE">
        <id name="bankId" type="string">
            <column name="BANK_ID" length="40" />

            <generator class="assigned" />
        </id>

        <property name="bankName" type="string">
            <column name="BANK_NAME" length="100" not-null="true" />
        </property>

        <property name="defaultCurrencyCode" type="string">
            <column name="DEFAULT_CURRENCY_CODE" length="4" not-null="true" />
        </property>

        <property name="nextTransactionId" type="long">
            <column name="NEXT_TRANSACTION_ID" precision="15" scale="0" />
        </property>

        <set name="transactionTypes" inverse="true">
            <key>
                <column name="BANK_ID" length="40" not-null="true" />
            </key>

            <one-to-many class="com.epocket.simplehibernatedebug.domain.TransactionType" />
        </set>

        <set name="transactionLogs" inverse="true">
            <key>
                <column name="BANK_ID" length="40" not-null="true" />
            </key>

            <one-to-many class="com.epocket.simplehibernatedebug.domain.TransactionLog" />
        </set>
    </class>
</hibernate-mapping>

Code:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<!-- 
    Auto-generated mapping file from
    the hibernate.org cfg2hbm engine
-->
    <class name="com.epocket.simplehibernatedebug.domain.TransactionLog" table="TRANSACTION_LOG" schema="HIBERNATE">
        <composite-id name="id" class="com.epocket.simplehibernatedebug.domain.TransactionLogId">
            <key-property name="bankId" type="string">
                <column name="BANK_ID" length="40" />
            </key-property>

            <key-property name="transactionId" type="string">
                <column name="TRANSACTION_ID" length="32" />
            </key-property>
        </composite-id>

        <many-to-one name="transactionType" class="com.epocket.simplehibernatedebug.domain.TransactionType" update="false" insert="false">
            <column name="BANK_ID" length="40" not-null="true" />

            <column name="TRANSACTION_TYPE_CODE" length="8" not-null="true" />
        </many-to-one>

        <many-to-one name="bank" class="com.epocket.simplehibernatedebug.domain.Bank" update="false" insert="false">
            <column name="BANK_ID" length="40" not-null="true" />
        </many-to-one>

        <property name="transactionDate" type="date">
            <column name="TRANSACTION_DATE" length="7" not-null="true" />
        </property>

        <property name="amount" type="big_decimal">
            <column name="AMOUNT" precision="12" scale="3" />
        </property>

        <property name="originator" type="string">
            <column name="ORIGINATOR" length="40" not-null="true" />
        </property>

        <property name="originatorReference" type="string">
            <column name="ORIGINATOR_REFERENCE" length="40" not-null="true" />
        </property>
    </class>
</hibernate-mapping>

<?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.epocket.simplehibernatedebug.domain.TransactionType" table="TRANSACTION_TYPE" schema="HIBERNATE">
<composite-id name="id" class="com.epocket.simplehibernatedebug.domain.TransactionTypeId">
<key-property name="bankId" type="string">
<column name="BANK_ID" length="40" />
</key-property>

<key-property name="typeCode" type="string">
<column name="TYPE_CODE" length="8" />
</key-property>
</composite-id>

<many-to-one name="bank" class="com.epocket.simplehibernatedebug.domain.Bank" update="false" insert="false">
<column name="BANK_ID" length="40" not-null="true" />
</many-to-one>

<property name="description" type="string">
<column name="DESCRIPTION" length="40" not-null="true" />
</property>

<set name="transactionLogs" inverse="true">
<key>
<column name="BANK_ID" length="40" not-null="true" />

<column name="TRANSACTION_TYPE_CODE" length="8" not-null="true" />
</key>

<one-to-many class="com.epocket.simplehibernatedebug.domain.TransactionLog" />
</set>
</class>
</hibernate-mapping>

Code between session.open() and session.close():

Code:

   protected static void addTransactionRow(final String bankId, final String transactionTypeCode) {
        Session hibernateSession = HibernateUtil.getNewSession();
        Bank bank = null;
        TransactionTypeId transactionTypeId = null;
        TransactionType transactionType = null;
        Transaction transaction = null;
        TransactionLogId transactionLogId = null;
        TransactionLog transactionLog = null;
        long transactionId;
        
        // this is the timestamp for all of the transaction log and transaction records
        Date transactionDate = new Date();
        
        try {
            transaction = hibernateSession.beginTransaction();
        } catch (HibernateException he) {
            log.error("failed to begin transaction", he);
        }
        
        // validate the bank id provided by loading the bank information
        try {
           bank = (Bank) hibernateSession.load(Bank.class, bankId);
           log.info("loaded bank " + bank.getBankName());
          if (bank.getTransactionLogs() == null) {
             bank.setTransactionLogs(new HashSet());
          }
        } catch (ObjectNotFoundException onfe) {
            log.error("bankid is unknown: " + bankId, onfe);
            transaction.rollback();
            return;              
        } catch (HibernateException he) {
            log.error("failed to load bank: " + bankId, he);
            if (transaction != null) {
               transaction.rollback();
            }
            hibernateSession.close();
            return;
        }
        
        
        // get the transaction type
        transactionTypeId = new TransactionTypeId();
        transactionTypeId.setBankId(bankId);
        transactionTypeId.setTypeCode(transactionTypeCode);
        
        try {
           transactionType = (TransactionType) hibernateSession.load(TransactionType.class, transactionTypeId);
           log.info("loaded transaction type " + transactionType.getId().getTypeCode() + ": " + transactionType.getDescription());
            if (transactionType.getTransactionLogs() == null) {
               transactionType.setTransactionLogs(new HashSet());
            }
        } catch (ObjectNotFoundException onfe) {
            log.error("invalid transaction type: " + transactionTypeCode, onfe);
            transaction.rollback();
            hibernateSession.close();
            return;
        } catch (HibernateException he) {
            log.error("failed to load transaction type: " + transactionTypeCode, he);
            transaction.rollback();
            hibernateSession.close();
            return;           
        }
        
        
        // save the transaction log
        try {
            // assign a transaction id
            transactionId = System.currentTimeMillis();
            
            // create a transaction log for new transaction        
            transactionLogId = new TransactionLogId();
            transactionLogId.setBankId(bankId);
            transactionLogId.setTransactionId(new Long(transactionId).toString());
            
            transactionLog = new TransactionLog();
            transactionLog.setBank(bank);
            transactionLog.setId(transactionLogId);
            transactionLog.setAmount(new BigDecimal("1.234"));
            transactionLog.setTransactionDate(transactionDate);
            transactionLog.setOriginator("AddTransactionLogTest");
            transactionLog.setOriginatorReference(transactionLogId.getTransactionId());

            // link the transaction log to the bank and transaction type
            transactionLog.setTransactionType(transactionType);
          bank.getTransactionLogs().add(transactionLog);
            transactionType.getTransactionLogs().add(transactionLog);
                    
           hibernateSession.save(transactionLog);
           log.info("saved transaction log " + transactionLog.getId().getTransactionId());
           
           transaction.commit();
           log.info("successfully commited transfer transaction " + transactionLogId.getTransactionId());
           
            hibernateSession.close();
           log.info("successfully closed Hibernate session transaction");
        } catch (HibernateException he) {
            log.error("failed to save transaction log", he);
            if (transaction != null) transaction.rollback();
       } finally {
          if (hibernateSession != null) {
             if (hibernateSession.isOpen()) {
                hibernateSession.close();
             }
          }
       }
        return;                  
   }
   

Full stack trace of any exception that occurs:
<code>
java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("HIBERNATE"."TRANSACTION_LOG"."TRANSACTION_TYPE_CODE")

at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:342)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10656)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:193)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:230)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:877)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:345)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at com.epocket.simplehibernatedebug.AddTransactionLogTest.addTransactionRow(AddTransactionLogTest.java:157)
at com.epocket.simplehibernatedebug.AddTransactionLogTest.main(AddTransactionLogTest.java:181)
19:47:17,504 WARN JDBCExceptionReporter:71 - SQL Error: 1400, SQLState: 23000
19:47:17,504 ERROR JDBCExceptionReporter:72 - ORA-01400: cannot insert NULL into ("HIBERNATE"."TRANSACTION_LOG"."TRANSACTION_TYPE_CODE")

19:47:17,504 WARN JDBCExceptionReporter:71 - SQL Error: 1400, SQLState: 23000
19:47:17,504 ERROR JDBCExceptionReporter:72 - ORA-01400: cannot insert NULL into ("HIBERNATE"."TRANSACTION_LOG"."TRANSACTION_TYPE_CODE")

19:47:17,504 ERROR AbstractFlushingEventListener:299 - 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:69)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:200)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:230)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:877)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:345)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at com.epocket.simplehibernatedebug.AddTransactionLogTest.addTransactionRow(AddTransactionLogTest.java:157)
at com.epocket.simplehibernatedebug.AddTransactionLogTest.main(AddTransactionLogTest.java:181)
Caused by: java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("HIBERNATE"."TRANSACTION_LOG"."TRANSACTION_TYPE_CODE")

at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:342)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10656)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:193)
... 9 more
19:47:17,514 ERROR AddTransactionLogTest:163 - failed to save transaction log
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:200)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:230)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:877)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:345)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at com.epocket.simplehibernatedebug.AddTransactionLogTest.addTransactionRow(AddTransactionLogTest.java:157)
at com.epocket.simplehibernatedebug.AddTransactionLogTest.main(AddTransactionLogTest.java:181)
Caused by: java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("HIBERNATE"."TRANSACTION_LOG"."TRANSACTION_TYPE_CODE")

at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:342)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10656)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:193)
... 9 more
</code>

Name and version of the database you are using:
Oracle 10gR2 on Whitebox Enterprise Linux 4

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:
<code>
19:47:12,237 INFO Environment:474 - Hibernate 3.1 rc1
19:47:12,287 INFO Environment:504 - hibernate.properties not found
19:47:12,297 INFO Environment:520 - using CGLIB reflection optimizer
19:47:12,297 INFO Environment:550 - using JDK 1.4 java.sql.Timestamp handling
19:47:12,427 INFO Configuration:1257 - configuring from resource: /hibernate.cfg.xml
19:47:12,427 INFO Configuration:1234 - Configuration resource: /hibernate.cfg.xml
19:47:12,868 DEBUG DTDEntityResolver:42 - trying to locate http://hibernate.sourceforge.net/hibern ... on-3.0.dtd in classpath under org/hibernate/
19:47:13,188 DEBUG DTDEntityResolver:56 - found http://hibernate.sourceforge.net/hibern ... on-3.0.dtd in classpath
19:47:13,278 DEBUG Configuration:1218 - dialect=org.hibernate.dialect.Oracle9Dialect
19:47:13,278 DEBUG Configuration:1218 - show_sql=true
19:47:13,278 DEBUG Configuration:1218 - use_outer_join=false
19:47:13,278 DEBUG Configuration:1218 - connection.username=HIBERNATE
19:47:13,288 DEBUG Configuration:1218 - connection.password=hibernate
19:47:13,288 DEBUG Configuration:1218 - connection.driver_class=oracle.jdbc.OracleDriver
19:47:13,288 DEBUG Configuration:1218 - connection.url=jdbc:oracle:thin:@oracle1-vip.kendall.net:1521:gsps1
19:47:13,288 DEBUG Configuration:1218 - default_schema=HIBERNATE
19:47:13,288 DEBUG Configuration:1218 - hibernate.transaction.factory_class=org.hibernate.transaction.JDBCTransactionFactory
19:47:13,288 INFO Configuration:1368 - Configured SessionFactory: null
19:47:13,288 DEBUG Configuration:1369 - properties: {hibernate.connection.password=hibernate, java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, hibernate.default_schema=HIBERNATE, sun.boot.library.path=C:\Program Files\Java\jdk1.5.0_04\jre\bin, java.vm.version=1.5.0_04-b05, hibernate.connection.username=HIBERNATE, 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, use_outer_join=false, user.country=CA, sun.os.patch.level=Service Pack 2, java.vm.specification.name=Java Virtual Machine Specification, user.dir=E:\home\nkendall\eclipse-projects-epocket\simple-hibernate-debug\unittest, java.runtime.version=1.5.0_04-b05, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Program Files\Java\jdk1.5.0_04\jre\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\Noel\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., default_schema=HIBERNATE, user.variant=, os.name=Windows XP, sun.jnu.encoding=Cp1252, java.library.path=C:\Program Files\Java\jdk1.5.0_04\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\oracle\product\10.2.0\client_1\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Common Files\Adaptec Shared\System;C:\Program Files\Java\jdk1.5.0_04\bin;c:\php;c:\php\dlls;c:\php\sapi;C:\Program Files\MySQL\MySQL Server 4.1\bin;C:\Program Files\cvsnt;C:\Program Files\java\j2sdk-1.5.0_03\bin;C:\apache-ant-1.6.5\bin;C:\Program Files\pstoedit;c:\Program Files\putty;C:\Sun\AppServer\bin;C:\Program Files\Common Files\Adobe\AGL;C:\Oracle\product\10.2.0\client_1, java.specification.name=Java Platform API Specification, java.class.version=49.0, sun.management.compiler=HotSpot Client Compiler, hibernate.transaction.factory_class=org.hibernate.transaction.JDBCTransactionFactory, os.version=5.1, connection.password=hibernate, user.home=C:\Documents and Settings\Noel, user.timezone=America/New_York, connection.username=HIBERNATE, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.5, hibernate.connection.driver_class=oracle.jdbc.OracleDriver, show_sql=true, user.name=Noel, java.class.path=E:\home\nkendall\eclipse-projects-epocket\simple-hibernate-debug\unittest;E:\home\nkendall\eclipse-projects-epocket\simple-hibernate-debug\bin;E:\build-libraries\hibernate-3.1\lib\asm.jar;E:\build-libraries\hibernate-3.1\lib\asm-attrs.jar;E:\build-libraries\hibernate-3.1\lib\c3p0-0.9.0.jar;E:\build-libraries\hibernate-3.1\lib\cglib-2.1.2.jar;E:\build-libraries\hibernate-3.1\lib\commons-collections-2.1.1.jar;E:\build-libraries\hibernate-3.1\lib\ehcache-1.1.jar;E:\build-libraries\hibernate-3.1\lib\jdbc2_0-stdext.jar;E:\build-libraries\hibernate-3.1\lib\oscache-2.1.jar;E:\build-libraries\hibernate-3.1\lib\proxool-0.8.3.jar;E:\build-libraries\hibernate-3.1\lib\swarmcache-1.0rc2.jar;E:\build-libraries\hibernate-3.1\lib\versioncheck.jar;E:\build-libraries\hibernate-3.1\lib\xerces-2.6.2.jar;E:\build-libraries\hibernate-3.1\lib\xml-apis.jar;E:\build-libraries\hibernate-3.1\bin;E:\build-libraries\commons-logging-1.0.4\commons-logging.jar;E:\build-libraries\dom4j-1.6.1\dom4j-1.6.1.jar;E:\build-libraries\oracle-10gR2-jdbc-drivers\nls_charset12.jar;E:\build-libraries\oracle-10gR2-jdbc-drivers\classes12.jar;E:\build-libraries\logging-log4j-1.2.12\dist\lib\log4j-1.2.12.jar;E:\build-libraries\hibernate-3.1\lib\jta.jar, hibernate.show_sql=true, java.vm.specification.version=1.0, java.home=C:\Program Files\Java\jdk1.5.0_04\jre, sun.arch.data.model=32, hibernate.connection.url=jdbc:oracle:thin:@oracle1-vip.kendall.net:1521:gsps1, hibernate.dialect=org.hibernate.dialect.Oracle9Dialect, user.language=en, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, hibernate.cglib.use_reflection_optimizer=true, java.vm.info=mixed mode, java.version=1.5.0_04, java.ext.dirs=C:\Program Files\Java\jdk1.5.0_04\jre\lib\ext, sun.boot.class.path=C:\Program Files\Java\jdk1.5.0_04\jre\lib\rt.jar;C:\Program Files\Java\jdk1.5.0_04\jre\lib\i18n.jar;C:\Program Files\Java\jdk1.5.0_04\jre\lib\sunrsasign.jar;C:\Program Files\Java\jdk1.5.0_04\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.5.0_04\jre\lib\jce.jar;C:\Program Files\Java\jdk1.5.0_04\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.5.0_04\jre\classes, java.vendor=Sun Microsystems Inc., connection.driver_class=oracle.jdbc.OracleDriver, file.separator=\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, hibernate.use_outer_join=false, sun.desktop=windows, connection.url=jdbc:oracle:thin:@oracle1-vip.kendall.net:1521:gsps1, dialect=org.hibernate.dialect.Oracle9Dialect, sun.cpu.isalist=pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86}
19:47:13,298 DEBUG Configuration:1137 - Preparing to build session factory with filters : {}
19:47:13,298 INFO Configuration:1014 - processing extends queue
19:47:13,298 INFO Configuration:1018 - processing collection mappings
19:47:13,298 INFO Configuration:1027 - processing association property references
19:47:13,359 INFO Configuration:1049 - processing foreign key constraints
19:47:13,379 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
19:47:13,379 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 20
19:47:13,379 INFO DriverManagerConnectionProvider:45 - autocommit mode: false
19:47:13,389 INFO DriverManagerConnectionProvider:80 - using driver: oracle.jdbc.OracleDriver at URL: jdbc:oracle:thin:@oracle1-vip.kendall.net:1521:gsps1
19:47:13,389 INFO DriverManagerConnectionProvider:83 - connection properties: {user=HIBERNATE, password=hibernate}
19:47:13,389 DEBUG DriverManagerConnectionProvider:93 - total checked-out connections: 0
19:47:13,509 DEBUG DriverManagerConnectionProvider:109 - opening new JDBC connection
19:47:14,140 DEBUG DriverManagerConnectionProvider:115 - created connection to: jdbc:oracle:thin:@oracle1-vip.kendall.net:1521:gsps1, Isolation Level: 2
19:47:14,150 INFO SettingsFactory:77 - RDBMS: Oracle, version: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
19:47:14,150 INFO SettingsFactory:78 - JDBC driver: Oracle JDBC driver, version: 10.2.0.1.0
19:47:14,150 DEBUG DriverManagerConnectionProvider:129 - returning connection to pool, pool size: 1
19:47:14,210 INFO Dialect:100 - Using dialect: org.hibernate.dialect.Oracle9Dialect
19:47:14,320 INFO TransactionFactoryFactory:34 - Transaction strategy: org.hibernate.transaction.JDBCTransactionFactory
19:47:14,450 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
19:47:14,450 INFO SettingsFactory:125 - Automatic flush during beforeCompletion(): disabled
19:47:14,450 INFO SettingsFactory:129 - Automatic session close at end of transaction: disabled
19:47:14,450 INFO SettingsFactory:136 - JDBC batch size: 15
19:47:14,450 INFO SettingsFactory:139 - JDBC batch updates for versioned data: disabled
19:47:14,460 INFO SettingsFactory:144 - Scrollable result sets: enabled
19:47:14,460 DEBUG SettingsFactory:148 - Wrap result sets: disabled
19:47:14,460 INFO SettingsFactory:152 - JDBC3 getGeneratedKeys(): enabled
19:47:14,460 INFO SettingsFactory:160 - Connection release mode: null
19:47:14,460 INFO SettingsFactory:178 - Default schema: HIBERNATE
19:47:14,460 INFO SettingsFactory:187 - Default batch fetch size: 1
19:47:14,460 INFO SettingsFactory:191 - Generate SQL with comments: disabled
19:47:14,460 INFO SettingsFactory:195 - Order SQL updates by primary key: disabled
19:47:14,470 INFO SettingsFactory:338 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
19:47:14,500 INFO ASTQueryTranslatorFactory:21 - Using ASTQueryTranslatorFactory
19:47:14,500 INFO SettingsFactory:203 - Query language substitutions: {}
19:47:14,500 INFO SettingsFactory:209 - Second-level cache: enabled
19:47:14,500 INFO SettingsFactory:213 - Query cache: disabled
19:47:14,500 INFO SettingsFactory:325 - Cache provider: org.hibernate.cache.EhCacheProvider
19:47:14,510 INFO SettingsFactory:228 - Optimize cache for minimal puts: disabled
19:47:14,510 INFO SettingsFactory:237 - Structured second-level cache entries: disabled
19:47:14,510 DEBUG SQLExceptionConverterFactory:52 - Using dialect defined converter
19:47:14,520 INFO SettingsFactory:257 - Echoing all SQL to stdout
19:47:14,520 INFO SettingsFactory:264 - Statistics: disabled
19:47:14,520 INFO SettingsFactory:268 - Deleted entity synthetic identifier rollback: disabled
19:47:14,520 INFO SettingsFactory:283 - Default entity-mode: POJO
19:47:14,730 INFO SessionFactoryImpl:155 - building session factory
19:47:14,730 DEBUG SessionFactoryImpl:166 - Session factory constructed with filter configurations : {}
19:47:14,730 DEBUG SessionFactoryImpl:170 - instantiating session factory with properties: {java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, hibernate.connection.password=hibernate, sun.boot.library.path=C:\Program Files\Java\jdk1.5.0_04\jre\bin, hibernate.default_schema=HIBERNATE, java.vm.version=1.5.0_04-b05, hibernate.connection.username=HIBERNATE, 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=CA, sun.os.patch.level=Service Pack 2, use_outer_join=false, java.vm.specification.name=Java Virtual Machine Specification, user.dir=E:\home\nkendall\eclipse-projects-epocket\simple-hibernate-debug\unittest, java.runtime.version=1.5.0_04-b05, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Program Files\Java\jdk1.5.0_04\jre\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\Noel\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, default_schema=HIBERNATE, os.name=Windows XP, sun.jnu.encoding=Cp1252, java.library.path=C:\Program Files\Java\jdk1.5.0_04\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\oracle\product\10.2.0\client_1\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Common Files\Adaptec Shared\System;C:\Program Files\Java\jdk1.5.0_04\bin;c:\php;c:\php\dlls;c:\php\sapi;C:\Program Files\MySQL\MySQL Server 4.1\bin;C:\Program Files\cvsnt;C:\Program Files\java\j2sdk-1.5.0_03\bin;C:\apache-ant-1.6.5\bin;C:\Program Files\pstoedit;c:\Program Files\putty;C:\Sun\AppServer\bin;C:\Program Files\Common Files\Adobe\AGL;C:\Oracle\product\10.2.0\client_1, java.specification.name=Java Platform API Specification, java.class.version=49.0, sun.management.compiler=HotSpot Client Compiler, hibernate.transaction.factory_class=org.hibernate.transaction.JDBCTransactionFactory, os.version=5.1, user.home=C:\Documents and Settings\Noel, connection.password=hibernate, user.timezone=America/New_York, java.awt.printerjob=sun.awt.windows.WPrinterJob, connection.username=HIBERNATE, java.specification.version=1.5, file.encoding=Cp1252, hibernate.connection.driver_class=oracle.jdbc.OracleDriver, show_sql=true, java.class.path=E:\home\nkendall\eclipse-projects-epocket\simple-hibernate-debug\unittest;E:\home\nkendall\eclipse-projects-epocket\simple-hibernate-debug\bin;E:\build-libraries\hibernate-3.1\lib\asm.jar;E:\build-libraries\hibernate-3.1\lib\asm-attrs.jar;E:\build-libraries\hibernate-3.1\lib\c3p0-0.9.0.jar;E:\build-libraries\hibernate-3.1\lib\cglib-2.1.2.jar;E:\build-libraries\hibernate-3.1\lib\commons-collections-2.1.1.jar;E:\build-libraries\hibernate-3.1\lib\ehcache-1.1.jar;E:\build-libraries\hibernate-3.1\lib\jdbc2_0-stdext.jar;E:\build-libraries\hibernate-3.1\lib\oscache-2.1.jar;E:\build-libraries\hibernate-3.1\lib\proxool-0.8.3.jar;E:\build-libraries\hibernate-3.1\lib\swarmcache-1.0rc2.jar;E:\build-libraries\hibernate-3.1\lib\versioncheck.jar;E:\build-libraries\hibernate-3.1\lib\xerces-2.6.2.jar;E:\build-libraries\hibernate-3.1\lib\xml-apis.jar;E:\build-libraries\hibernate-3.1\bin;E:\build-libraries\commons-logging-1.0.4\commons-logging.jar;E:\build-libraries\dom4j-1.6.1\dom4j-1.6.1.jar;E:\build-libraries\oracle-10gR2-jdbc-drivers\nls_charset12.jar;E:\build-libraries\oracle-10gR2-jdbc-drivers\classes12.jar;E:\build-libraries\logging-log4j-1.2.12\dist\lib\log4j-1.2.12.jar;E:\build-libraries\hibernate-3.1\lib\jta.jar, user.name=Noel, hibernate.show_sql=true, java.vm.specification.version=1.0, sun.arch.data.model=32, java.home=C:\Program Files\Java\jdk1.5.0_04\jre, hibernate.dialect=org.hibernate.dialect.Oracle9Dialect, hibernate.connection.url=jdbc:oracle:thin:@oracle1-vip.kendall.net:1521:gsps1, java.specification.vendor=Sun Microsystems Inc., user.language=en, awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, hibernate.cglib.use_reflection_optimizer=true, java.version=1.5.0_04, java.ext.dirs=C:\Program Files\Java\jdk1.5.0_04\jre\lib\ext, sun.boot.class.path=C:\Program Files\Java\jdk1.5.0_04\jre\lib\rt.jar;C:\Program Files\Java\jdk1.5.0_04\jre\lib\i18n.jar;C:\Program Files\Java\jdk1.5.0_04\jre\lib\sunrsasign.jar;C:\Program Files\Java\jdk1.5.0_04\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.5.0_04\jre\lib\jce.jar;C:\Program Files\Java\jdk1.5.0_04\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.5.0_04\jre\classes, java.vendor=Sun Microsystems Inc., file.separator=\, connection.driver_class=oracle.jdbc.OracleDriver, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.cpu.endian=little, sun.io.unicode.encoding=UnicodeLittle, hibernate.use_outer_join=false, sun.desktop=windows, connection.url=jdbc:oracle:thin:@oracle1-vip.kendall.net:1521:gsps1, sun.cpu.isalist=pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86, dialect=org.hibernate.dialect.Oracle9Dialect}
19:47:14,751 WARN Configurator:126 - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/E:/build-libraries/hibernate-3.1/lib/ehcache-1.1.jar!/ehcache-failsafe.xml
19:47:14,771 DEBUG SessionFactoryObjectFactory:39 - initializing class SessionFactoryObjectFactory
19:47:14,821 DEBUG SessionFactoryObjectFactory:76 - registered: 40288049075397780107539779530000 (unnamed)
19:47:14,821 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
19:47:14,831 DEBUG SessionFactoryImpl:295 - instantiated session factory
19:47:14,831 INFO SessionFactoryImpl:432 - Checking 0 named queries
19:47:14,831 INFO Configuration:488 - Reading mappings from resource: com/epocket/simplehibernatedebug/domain/Bank.hbm.xml
19:47:14,841 DEBUG DTDEntityResolver:42 - trying to locate http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
19:47:14,841 DEBUG DTDEntityResolver:56 - found http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
19:47:15,001 INFO HbmBinder:266 - Mapping class: com.epocket.simplehibernatedebug.domain.Bank -> BANK
19:47:15,011 DEBUG HbmBinder:1179 - Mapped property: bankId -> BANK_ID
19:47:15,021 DEBUG HbmBinder:1179 - Mapped property: bankName -> BANK_NAME
19:47:15,021 DEBUG HbmBinder:1179 - Mapped property: defaultCurrencyCode -> DEFAULT_CURRENCY_CODE
19:47:15,021 DEBUG HbmBinder:1179 - Mapped property: nextTransactionId -> NEXT_TRANSACTION_ID
19:47:15,051 DEBUG HbmBinder:1179 - Mapped property: transactionTypes
19:47:15,081 DEBUG HbmBinder:1179 - Mapped property: transactionLogs
19:47:15,081 INFO Configuration:488 - Reading mappings from resource: com/epocket/simplehibernatedebug/domain/TransactionType.hbm.xml
19:47:15,091 DEBUG DTDEntityResolver:42 - trying to locate http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
19:47:15,091 DEBUG DTDEntityResolver:56 - found http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
19:47:15,151 INFO HbmBinder:266 - Mapping class: com.epocket.simplehibernatedebug.domain.TransactionType -> TRANSACTION_TYPE
19:47:15,171 DEBUG HbmBinder:1179 - Mapped property: bankId -> BANK_ID
19:47:15,171 DEBUG HbmBinder:1179 - Mapped property: typeCode -> TYPE_CODE
19:47:15,171 DEBUG HbmBinder:1179 - Mapped property: id -> BANK_ID, TYPE_CODE
19:47:15,211 DEBUG HbmBinder:1179 - Mapped property: bank -> BANK_ID
19:47:15,211 DEBUG HbmBinder:1179 - Mapped property: description -> DESCRIPTION
19:47:15,211 DEBUG HbmBinder:1179 - Mapped property: transactionLogs
19:47:15,211 INFO Configuration:488 - Reading mappings from resource: com/epocket/simplehibernatedebug/domain/TransactionLog.hbm.xml
19:47:15,211 DEBUG DTDEntityResolver:42 - trying to locate http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
19:47:15,211 DEBUG DTDEntityResolver:56 - found http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
19:47:15,251 INFO HbmBinder:266 - Mapping class: com.epocket.simplehibernatedebug.domain.TransactionLog -> TRANSACTION_LOG
19:47:15,251 DEBUG HbmBinder:1179 - Mapped property: bankId -> BANK_ID
19:47:15,251 DEBUG HbmBinder:1179 - Mapped property: transactionId -> TRANSACTION_ID
19:47:15,251 DEBUG HbmBinder:1179 - Mapped property: id -> BANK_ID, TRANSACTION_ID
19:47:15,261 DEBUG HbmBinder:1179 - Mapped property: transactionType -> BANK_ID, TRANSACTION_TYPE_CODE
19:47:15,261 DEBUG HbmBinder:1179 - Mapped property: bank -> BANK_ID
19:47:15,261 DEBUG HbmBinder:1179 - Mapped property: transactionDate -> TRANSACTION_DATE
19:47:15,261 DEBUG HbmBinder:1179 - Mapped property: amount -> AMOUNT
19:47:15,261 DEBUG HbmBinder:1179 - Mapped property: originator -> ORIGINATOR
19:47:15,261 DEBUG HbmBinder:1179 - Mapped property: originatorReference -> ORIGINATOR_REFERENCE
19:47:15,271 DEBUG Configuration:1137 - Preparing to build session factory with filters : {}
19:47:15,271 INFO Configuration:1014 - processing extends queue
19:47:15,271 INFO Configuration:1018 - processing collection mappings
19:47:15,271 DEBUG CollectionSecondPass:33 - Second pass for collection: com.epocket.simplehibernatedebug.domain.Bank.transactionTypes
19:47:15,271 INFO HbmBinder:2233 - Mapping collection: com.epocket.simplehibernatedebug.domain.Bank.transactionTypes -> TRANSACTION_TYPE
19:47:15,271 DEBUG CollectionSecondPass:49 - Mapped collection key: BANK_ID, one-to-many: com.epocket.simplehibernatedebug.domain.TransactionType
19:47:15,271 DEBUG CollectionSecondPass:33 - Second pass for collection: com.epocket.simplehibernatedebug.domain.Bank.transactionLogs
19:47:15,271 INFO HbmBinder:2233 - Mapping collection: com.epocket.simplehibernatedebug.domain.Bank.transactionLogs -> TRANSACTION_LOG
19:47:15,271 DEBUG CollectionSecondPass:49 - Mapped collection key: BANK_ID, one-to-many: com.epocket.simplehibernatedebug.domain.TransactionLog
19:47:15,271 DEBUG CollectionSecondPass:33 - Second pass for collection: com.epocket.simplehibernatedebug.domain.TransactionType.transactionLogs
19:47:15,271 INFO HbmBinder:2233 - Mapping collection: com.epocket.simplehibernatedebug.domain.TransactionType.transactionLogs -> TRANSACTION_LOG
19:47:15,271 DEBUG CollectionSecondPass:49 - Mapped collection key: BANK_ID, TRANSACTION_TYPE_CODE, one-to-many: com.epocket.simplehibernatedebug.domain.TransactionLog
19:47:15,271 INFO Configuration:1027 - processing association property references
19:47:15,271 INFO Configuration:1049 - processing foreign key constraints
19:47:15,271 DEBUG Configuration:1100 - resolving reference to class: com.epocket.simplehibernatedebug.domain.TransactionType
19:47:15,271 DEBUG Configuration:1100 - resolving reference to class: com.epocket.simplehibernatedebug.domain.Bank
19:47:15,271 DEBUG Configuration:1100 - resolving reference to class: com.epocket.simplehibernatedebug.domain.Bank
19:47:15,482 WARN RootClass:211 - composite-id class does not override equals(): com.epocket.simplehibernatedebug.domain.TransactionLogId
19:47:15,482 WARN RootClass:216 - composite-id class does not override hashCode(): com.epocket.simplehibernatedebug.domain.TransactionLogId
19:47:15,482 WARN RootClass:211 - composite-id class does not override equals(): com.epocket.simplehibernatedebug.domain.TransactionTypeId
19:47:15,482 WARN RootClass:216 - composite-id class does not override hashCode(): com.epocket.simplehibernatedebug.domain.TransactionTypeId
19:47:15,482 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
19:47:15,482 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 20
19:47:15,482 INFO DriverManagerConnectionProvider:45 - autocommit mode: false
19:47:15,482 INFO DriverManagerConnectionProvider:80 - using driver: oracle.jdbc.OracleDriver at URL: jdbc:oracle:thin:@oracle1-vip.kendall.net:1521:gsps1
19:47:15,482 INFO DriverManagerConnectionProvider:83 - connection properties: {user=HIBERNATE, password=hibernate}
19:47:15,482 DEBUG DriverManagerConnectionProvider:93 - total checked-out connections: 0
19:47:15,482 DEBUG DriverManagerConnectionProvider:109 - opening new JDBC connection
19:47:15,572 DEBUG DriverManagerConnectionProvider:115 - created connection to: jdbc:oracle:thin:@oracle1-vip.kendall.net:1521:gsps1, Isolation Level: 2
19:47:15,572 INFO SettingsFactory:77 - RDBMS: Oracle, version: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
19:47:15,572 INFO SettingsFactory:78 - JDBC driver: Oracle JDBC driver, version: 10.2.0.1.0
19:47:15,572 DEBUG DriverManagerConnectionProvider:129 - returning connection to pool, pool size: 1
19:47:15,572 INFO Dialect:100 - Using dialect: org.hibernate.dialect.Oracle9Dialect
19:47:15,572 INFO TransactionFactoryFactory:34 - Transaction strategy: org.hibernate.transaction.JDBCTransactionFactory
19:47:15,572 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
19:47:15,582 INFO SettingsFactory:125 - Automatic flush during beforeCompletion(): disabled
19:47:15,582 INFO SettingsFactory:129 - Automatic session close at end of transaction: disabled
19:47:15,582 INFO SettingsFactory:136 - JDBC batch size: 15
19:47:15,582 INFO SettingsFactory:139 - JDBC batch updates for versioned data: disabled
19:47:15,582 INFO SettingsFactory:144 - Scrollable result sets: enabled
19:47:15,582 DEBUG SettingsFactory:148 - Wrap result sets: disabled
19:47:15,582 INFO SettingsFactory:152 - JDBC3 getGeneratedKeys(): enabled
19:47:15,582 INFO SettingsFactory:160 - Connection release mode: null
19:47:15,582 INFO SettingsFactory:178 - Default schema: HIBERNATE
19:47:15,582 INFO SettingsFactory:187 - Default batch fetch size: 1
19:47:15,582 INFO SettingsFactory:191 - Generate SQL with comments: disabled
19:47:15,582 INFO SettingsFactory:195 - Order SQL updates by primary key: disabled
19:47:15,582 INFO SettingsFactory:338 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
19:47:15,582 INFO ASTQueryTranslatorFactory:21 - Using ASTQueryTranslatorFactory
19:47:15,582 INFO SettingsFactory:203 - Query language substitutions: {}
19:47:15,582 INFO SettingsFactory:209 - Second-level cache: enabled
19:47:15,582 INFO SettingsFactory:213 - Query cache: disabled
19:47:15,582 INFO SettingsFactory:325 - Cache provider: org.hibernate.cache.EhCacheProvider
19:47:15,582 INFO SettingsFactory:228 - Optimize cache for minimal puts: disabled
19:47:15,582 INFO SettingsFactory:237 - Structured second-level cache entries: disabled
19:47:15,582 DEBUG SQLExceptionConverterFactory:52 - Using dialect defined converter
19:47:15,582 INFO SettingsFactory:257 - Echoing all SQL to stdout
19:47:15,582 INFO SettingsFactory:264 - Statistics: disabled
19:47:15,582 INFO SettingsFactory:268 - Deleted entity synthetic identifier rollback: disabled
19:47:15,582 INFO SettingsFactory:283 - Default entity-mode: POJO
19:47:15,592 INFO SessionFactoryImpl:155 - building session factory
19:47:15,592 DEBUG SessionFactoryImpl:166 - Session factory constructed with filter configurations : {}
19:47:15,592 DEBUG SessionFactoryImpl:170 - instantiating session factory with properties: {java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, hibernate.connection.password=hibernate, sun.boot.library.path=C:\Program Files\Java\jdk1.5.0_04\jre\bin, hibernate.default_schema=HIBERNATE, java.vm.version=1.5.0_04-b05, hibernate.connection.username=HIBERNATE, 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=CA, sun.os.patch.level=Service Pack 2, use_outer_join=false, java.vm.specification.name=Java Virtual Machine Specification, user.dir=E:\home\nkendall\eclipse-projects-epocket\simple-hibernate-debug\unittest, java.runtime.version=1.5.0_04-b05, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Program Files\Java\jdk1.5.0_04\jre\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\Noel\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, default_schema=HIBERNATE, os.name=Windows XP, sun.jnu.encoding=Cp1252, java.library.path=C:\Program Files\Java\jdk1.5.0_04\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\oracle\product\10.2.0\client_1\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Common Files\Adaptec Shared\System;C:\Program Files\Java\jdk1.5.0_04\bin;c:\php;c:\php\dlls;c:\php\sapi;C:\Program Files\MySQL\MySQL Server 4.1\bin;C:\Program Files\cvsnt;C:\Program Files\java\j2sdk-1.5.0_03\bin;C:\apache-ant-1.6.5\bin;C:\Program Files\pstoedit;c:\Program Files\putty;C:\Sun\AppServer\bin;C:\Program Files\Common Files\Adobe\AGL;C:\Oracle\product\10.2.0\client_1, java.specification.name=Java Platform API Specification, java.class.version=49.0, sun.management.compiler=HotSpot Client Compiler, hibernate.transaction.factory_class=org.hibernate.transaction.JDBCTransactionFactory, os.version=5.1, user.home=C:\Documents and Settings\Noel, connection.password=hibernate, user.timezone=America/New_York, java.awt.printerjob=sun.awt.windows.WPrinterJob, connection.username=HIBERNATE, java.specification.version=1.5, file.encoding=Cp1252, hibernate.connection.driver_class=oracle.jdbc.OracleDriver, show_sql=true, java.class.path=E:\home\nkendall\eclipse-projects-epocket\simple-hibernate-debug\unittest;E:\home\nkendall\eclipse-projects-epocket\simple-hibernate-debug\bin;E:\build-libraries\hibernate-3.1\lib\asm.jar;E:\build-libraries\hibernate-3.1\lib\asm-attrs.jar;E:\build-libraries\hibernate-3.1\lib\c3p0-0.9.0.jar;E:\build-libraries\hibernate-3.1\lib\cglib-2.1.2.jar;E:\build-libraries\hibernate-3.1\lib\commons-collections-2.1.1.jar;E:\build-libraries\hibernate-3.1\lib\ehcache-1.1.jar;E:\build-libraries\hibernate-3.1\lib\jdbc2_0-stdext.jar;E:\build-libraries\hibernate-3.1\lib\oscache-2.1.jar;E:\build-libraries\hibernate-3.1\lib\proxool-0.8.3.jar;E:\build-libraries\hibernate-3.1\lib\swarmcache-1.0rc2.jar;E:\build-libraries\hibernate-3.1\lib\versioncheck.jar;E:\build-libraries\hibernate-3.1\lib\xerces-2.6.2.jar;E:\build-libraries\hibernate-3.1\lib\xml-apis.jar;E:\build-libraries\hibernate-3.1\bin;E:\build-libraries\commons-logging-1.0.4\commons-logging.jar;E:\build-libraries\dom4j-1.6.1\dom4j-1.6.1.jar;E:\build-libraries\oracle-10gR2-jdbc-drivers\nls_charset12.jar;E:\build-libraries\oracle-10gR2-jdbc-drivers\classes12.jar;E:\build-libraries\logging-log4j-1.2.12\dist\lib\log4j-1.2.12.jar;E:\build-libraries\hibernate-3.1\lib\jta.jar, user.name=Noel, hibernate.show_sql=true, java.vm.specification.version=1.0, sun.arch.data.model=32, java.home=C:\Program Files\Java\jdk1.5.0_04\jre, hibernate.dialect=org.hibernate.dialect.Oracle9Dialect, hibernate.connection.url=jdbc:oracle:thin:@oracle1-vip.kendall.net:1521:gsps1, java.specification.vendor=Sun Microsystems Inc., user.language=en, awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, hibernate.cglib.use_reflection_optimizer=true, java.version=1.5.0_04, java.ext.dirs=C:\Program Files\Java\jdk1.5.0_04\jre\lib\ext, sun.boot.class.path=C:\Program Files\Java\jdk1.5.0_04\jre\lib\rt.jar;C:\Program Files\Java\jdk1.5.0_04\jre\lib\i18n.jar;C:\Program Files\Java\jdk1.5.0_04\jre\lib\sunrsasign.jar;C:\Program Files\Java\jdk1.5.0_04\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.5.0_04\jre\lib\jce.jar;C:\Program Files\Java\jdk1.5.0_04\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.5.0_04\jre\classes, java.vendor=Sun Microsystems Inc., file.separator=\, connection.driver_class=oracle.jdbc.OracleDriver, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.cpu.endian=little, sun.io.unicode.encoding=UnicodeLittle, hibernate.use_outer_join=false, sun.desktop=windows, connection.url=jdbc:oracle:thin:@oracle1-vip.kendall.net:1521:gsps1, sun.cpu.isalist=pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86, dialect=org.hibernate.dialect.Oracle9Dialect}
19:47:16,112 DEBUG AbstractEntityPersister:2446 - Static SQL for entity: com.epocket.simplehibernatedebug.domain.Bank
19:47:16,112 DEBUG AbstractEntityPersister:2448 - Version select: select BANK_ID from HIBERNATE.BANK where BANK_ID =?
19:47:16,112 DEBUG AbstractEntityPersister:2449 - Snapshot select: select bank_.BANK_ID, bank_.BANK_NAME as BANK2_0_, bank_.DEFAULT_CURRENCY_CODE as DEFAULT3_0_, bank_.NEXT_TRANSACTION_ID as NEXT4_0_ from HIBERNATE.BANK bank_ where bank_.BANK_ID=?
19:47:16,112 DEBUG AbstractEntityPersister:2451 - Insert 0: insert into HIBERNATE.BANK (BANK_NAME, DEFAULT_CURRENCY_CODE, NEXT_TRANSACTION_ID, BANK_ID) values (?, ?, ?, ?)
19:47:16,133 DEBUG AbstractEntityPersister:2452 - Update 0: update HIBERNATE.BANK set BANK_NAME=?, DEFAULT_CURRENCY_CODE=?, NEXT_TRANSACTION_ID=? where BANK_ID=?
19:47:16,133 DEBUG AbstractEntityPersister:2453 - Delete 0: delete from HIBERNATE.BANK where BANK_ID=?
19:47:16,253 DEBUG AbstractEntityPersister:2446 - Static SQL for entity: com.epocket.simplehibernatedebug.domain.TransactionLog
19:47:16,253 DEBUG AbstractEntityPersister:2448 - Version select: select BANK_ID, TRANSACTION_ID from HIBERNATE.TRANSACTION_LOG where BANK_ID =? and TRANSACTION_ID =?
19:47:16,253 DEBUG AbstractEntityPersister:2449 - Snapshot select: select transactio_.BANK_ID, transactio_.TRANSACTION_ID, transactio_.TRANSACTION_DATE as TRANSACT4_2_, transactio_.AMOUNT as AMOUNT2_, transactio_.ORIGINATOR as ORIGINATOR2_, transactio_.ORIGINATOR_REFERENCE as ORIGINATOR7_2_ from HIBERNATE.TRANSACTION_LOG transactio_ where transactio_.BANK_ID=? and transactio_.TRANSACTION_ID=?
19:47:16,253 DEBUG AbstractEntityPersister:2451 - Insert 0: insert into HIBERNATE.TRANSACTION_LOG (TRANSACTION_DATE, AMOUNT, ORIGINATOR, ORIGINATOR_REFERENCE, BANK_ID, TRANSACTION_ID) values (?, ?, ?, ?, ?, ?)
19:47:16,253 DEBUG AbstractEntityPersister:2452 - Update 0: update HIBERNATE.TRANSACTION_LOG set TRANSACTION_DATE=?, AMOUNT=?, ORIGINATOR=?, ORIGINATOR_REFERENCE=? where BANK_ID=? and TRANSACTION_ID=?
19:47:16,253 DEBUG AbstractEntityPersister:2453 - Delete 0: delete from HIBERNATE.TRANSACTION_LOG where BANK_ID=? and TRANSACTION_ID=?
19:47:16,273 DEBUG AbstractEntityPersister:2446 - Static SQL for entity: com.epocket.simplehibernatedebug.domain.TransactionType
19:47:16,273 DEBUG AbstractEntityPersister:2448 - Version select: select BANK_ID, TYPE_CODE from HIBERNATE.TRANSACTION_TYPE where BANK_ID =? and TYPE_CODE =?
19:47:16,273 DEBUG AbstractEntityPersister:2449 - Snapshot select: select transactio_.BANK_ID, transactio_.TYPE_CODE, transactio_.DESCRIPTION as DESCRIPT3_1_ from HIBERNATE.TRANSACTION_TYPE transactio_ where transactio_.BANK_ID=? and transactio_.TYPE_CODE=?
19:47:16,273 DEBUG AbstractEntityPersister:2451 - Insert 0: insert into HIBERNATE.TRANSACTION_TYPE (DESCRIPTION, BANK_ID, TYPE_CODE) values (?, ?, ?)
19:47:16,273 DEBUG AbstractEntityPersister:2452 - Update 0: update HIBERNATE.TRANSACTION_TYPE set DESCRIPTION=? where BANK_ID=? and TYPE_CODE=?
19:47:16,273 DEBUG AbstractEntityPersister:2453 - Delete 0: delete from HIBERNATE.TRANSACTION_TYPE where BANK_ID=? and TYPE_CODE=?
19:47:16,283 DEBUG AbstractCollectionPersister:511 - Static SQL for collection: com.epocket.simplehibernatedebug.domain.Bank.transactionTypes
19:47:16,283 DEBUG AbstractCollectionPersister:512 - Row insert: update HIBERNATE.TRANSACTION_TYPE set BANK_ID=? where BANK_ID=? and TYPE_CODE=?
19:47:16,293 DEBUG AbstractCollectionPersister:514 - Row delete: update HIBERNATE.TRANSACTION_TYPE set BANK_ID=null where BANK_ID=? and BANK_ID=? and TYPE_CODE=?
19:47:16,293 DEBUG AbstractCollectionPersister:515 - One-shot delete: update HIBERNATE.TRANSACTION_TYPE set BANK_ID=null where BANK_ID=?
19:47:16,293 DEBUG AbstractCollectionPersister:511 - Static SQL for collection: com.epocket.simplehibernatedebug.domain.Bank.transactionLogs
19:47:16,293 DEBUG AbstractCollectionPersister:512 - Row insert: update HIBERNATE.TRANSACTION_LOG set BANK_ID=? where BANK_ID=? and TRANSACTION_ID=?
19:47:16,293 DEBUG AbstractCollectionPersister:514 - Row delete: update HIBERNATE.TRANSACTION_LOG set BANK_ID=null where BANK_ID=? and BANK_ID=? and TRANSACTION_ID=?
19:47:16,293 DEBUG AbstractCollectionPersister:515 - One-shot delete: update HIBERNATE.TRANSACTION_LOG set BANK_ID=null where BANK_ID=?
19:47:16,293 DEBUG AbstractCollectionPersister:511 - Static SQL for collection: com.epocket.simplehibernatedebug.domain.TransactionType.transactionLogs
19:47:16,293 DEBUG AbstractCollectionPersister:512 - Row insert: update HIBERNATE.TRANSACTION_LOG set BANK_ID=?, TRANSACTION_TYPE_CODE=? where BANK_ID=? and TRANSACTION_ID=?
19:47:16,293 DEBUG AbstractCollectionPersister:514 - Row delete: update HIBERNATE.TRANSACTION_LOG set BANK_ID=null, TRANSACTION_TYPE_CODE=null where BANK_ID=? and TRANSACTION_TYPE_CODE=? and BANK_ID=? and TRANSACTION_ID=?
19:47:16,293 DEBUG AbstractCollectionPersister:515 - One-shot delete: update HIBERNATE.TRANSACTION_LOG set BANK_ID=null, TRANSACTION_TYPE_CODE=null where BANK_ID=? and TRANSACTION_TYPE_CODE=?
19:47:16,333 DEBUG EntityLoader:79 - Static select for entity com.epocket.simplehibernatedebug.domain.Bank: select bank0_.BANK_ID as BANK1_0_0_, bank0_.BANK_NAME as BANK2_0_0_, bank0_.DEFAULT_CURRENCY_CODE as DEFAULT3_0_0_, bank0_.NEXT_TRANSACTION_ID as NEXT4_0_0_ from HIBERNATE.BANK bank0_ where bank0_.BANK_ID=?
19:47:16,333 DEBUG EntityLoader:79 - Static select for entity com.epocket.simplehibernatedebug.domain.Bank: select bank0_.BANK_ID as BANK1_0_0_, bank0_.BANK_NAME as BANK2_0_0_, bank0_.DEFAULT_CURRENCY_CODE as DEFAULT3_0_0_, bank0_.NEXT_TRANSACTION_ID as NEXT4_0_0_ from HIBERNATE.BANK bank0_ where bank0_.BANK_ID=?
19:47:16,333 DEBUG EntityLoader:79 - Static select for entity com.epocket.simplehibernatedebug.domain.Bank: select bank0_.BANK_ID as BANK1_0_0_, bank0_.BANK_NAME as BANK2_0_0_, bank0_.DEFAULT_CURRENCY_CODE as DEFAULT3_0_0_, bank0_.NEXT_TRANSACTION_ID as NEXT4_0_0_ from HIBERNATE.BANK bank0_ where bank0_.BANK_ID=? for update
19:47:16,333 DEBUG EntityLoader:79 - Static select for entity com.epocket.simplehibernatedebug.domain.Bank: select bank0_.BANK_ID as BANK1_0_0_, bank0_.BANK_NAME as BANK2_0_0_, bank0_.DEFAULT_CURRENCY_CODE as DEFAULT3_0_0_, bank0_.NEXT_TRANSACTION_ID as NEXT4_0_0_ from HIBERNATE.BANK bank0_ where bank0_.BANK_ID=? for update nowait
19:47:16,363 DEBUG EntityLoader:67 - Static select for action ACTION_MERGE on entity com.epocket.simplehibernatedebug.domain.Bank: select bank0_.BANK_ID as BANK1_0_0_, bank0_.BANK_NAME as BANK2_0_0_, bank0_.DEFAULT_CURRENCY_CODE as DEFAULT3_0_0_, bank0_.NEXT_TRANSACTION_ID as NEXT4_0_0_ from HIBERNATE.BANK bank0_ where bank0_.BANK_ID=?
19:47:16,363 DEBUG EntityLoader:67 - Static select for action ACTION_REFRESH on entity com.epocket.simplehibernatedebug.domain.Bank: select bank0_.BANK_ID as BANK1_0_0_, bank0_.BANK_NAME as BANK2_0_0_, bank0_.DEFAULT_CURRENCY_CODE as DEFAULT3_0_0_, bank0_.NEXT_TRANSACTION_ID as NEXT4_0_0_ from HIBERNATE.BANK bank0_ where bank0_.BANK_ID=?
19:47:16,393 DEBUG EntityLoader:79 - Static select for entity com.epocket.simplehibernatedebug.domain.TransactionType: select transactio0_.BANK_ID as BANK1_1_0_, transactio0_.TYPE_CODE as TYPE2_1_0_, transactio0_.DESCRIPTION as DESCRIPT3_1_0_ from HIBERNATE.TRANSACTION_TYPE transactio0_ where transactio0_.BANK_ID=? and transactio0_.TYPE_CODE=?
19:47:16,393 DEBUG EntityLoader:79 - Static select for entity com.epocket.simplehibernatedebug.domain.TransactionType: select transactio0_.BANK_ID as BANK1_1_0_, transactio0_.TYPE_CODE as TYPE2_1_0_, transactio0_.DESCRIPTION as DESCRIPT3_1_0_ from HIBERNATE.TRANSACTION_TYPE transactio0_ where transactio0_.BANK_ID=? and transactio0_.TYPE_CODE=?
19:47:16,403 DEBUG EntityLoader:79 - Static select for entity com.epocket.simplehibernatedebug.domain.TransactionType: select transactio0_.BANK_ID as BANK1_1_0_, transactio0_.TYPE_CODE as TYPE2_1_0_, transactio0_.DESCRIPTION as DESCRIPT3_1_0_ from HIBERNATE.TRANSACTION_TYPE transactio0_ where transactio0_.BANK_ID=? and transactio0_.TYPE_CODE=? for update
19:47:16,403 DEBUG EntityLoader:79 - Static select for entity com.epocket.simplehibernatedebug.domain.TransactionType: select transactio0_.BANK_ID as BANK1_1_0_, transactio0_.TYPE_CODE as TYPE2_1_0_, transactio0_.DESCRIPTION as DESCRIPT3_1_0_ from HIBERNATE.TRANSACTION_TYPE transactio0_ where transactio0_.BANK_ID=? and transactio0_.TYPE_CODE=? for update nowait
19:47:16,403 DEBUG EntityLoader:67 - Static select for action ACTION_MERGE on entity com.epocket.simplehibernatedebug.domain.TransactionType: select transactio0_.BANK_ID as BANK1_1_0_, transactio0_.TYPE_CODE as TYPE2_1_0_, transactio0_.DESCRIPTION as DESCRIPT3_1_0_ from HIBERNATE.TRANSACTION_TYPE transactio0_ where transactio0_.BANK_ID=? and transactio0_.TYPE_CODE=?
19:47:16,403 DEBUG EntityLoader:67 - Static select for action ACTION_REFRESH on entity com.epocket.simplehibernatedebug.domain.TransactionType: select transactio0_.BANK_ID as BANK1_1_0_, transactio0_.TYPE_CODE as TYPE2_1_0_, transactio0_.DESCRIPTION as DESCRIPT3_1_0_ from HIBERNATE.TRANSACTION_TYPE transactio0_ where transactio0_.BANK_ID=? and transactio0_.TYPE_CODE=?
19:47:16,413 DEBUG EntityLoader:79 - Static select for entity com.epocket.simplehibernatedebug.domain.TransactionLog: select transactio0_.BANK_ID as BANK1_2_0_, transactio0_.TRANSACTION_ID as TRANSACT2_2_0_, transactio0_.TRANSACTION_TYPE_CODE as TRANSACT3_2_0_, transactio0_.TRANSACTION_DATE as TRANSACT4_2_0_, transactio0_.AMOUNT as AMOUNT2_0_, transactio0_.ORIGINATOR as ORIGINATOR2_0_, transactio0_.ORIGINATOR_REFERENCE as ORIGINATOR7_2_0_ from HIBERNATE.TRANSACTION_LOG transactio0_ where transactio0_.BANK_ID=? and transactio0_.TRANSACTION_ID=?
19:47:16,413 DEBUG EntityLoader:79 - Static select for entity com.epocket.simplehibernatedebug.domain.TransactionLog: select transactio0_.BANK_ID as BANK1_2_0_, transactio0_.TRANSACTION_ID as TRANSACT2_2_0_, transactio0_.TRANSACTION_TYPE_CODE as TRANSACT3_2_0_, transactio0_.TRANSACTION_DATE as TRANSACT4_2_0_, transactio0_.AMOUNT as AMOUNT2_0_, transactio0_.ORIGINATOR as ORIGINATOR2_0_, transactio0_.ORIGINATOR_REFERENCE as ORIGINATOR7_2_0_ from HIBERNATE.TRANSACTION_LOG transactio0_ where transactio0_.BANK_ID=? and transactio0_.TRANSACTION_ID=?
19:47:16,413 DEBUG EntityLoader:79 - Static select for entity com.epocket.simplehibernatedebug.domain.TransactionLog: select transactio0_.BANK_ID as BANK1_2_0_, transactio0_.TRANSACTION_ID as TRANSACT2_2_0_, transactio0_.TRANSACTION_TYPE_CODE as TRANSACT3_2_0_, transactio0_.TRANSACTION_DATE as TRANSACT4_2_0_, transactio0_.AMOUNT as AMOUNT2_0_, transactio0_.ORIGINATOR as ORIGINATOR2_0_, transactio0_.ORIGINATOR_REFERENCE as ORIGINATOR7_2_0_ from HIBERNATE.TRANSACTION_LOG transactio0_ where transactio0_.BANK_ID=? and transactio0_.TRANSACTION_ID=? for update
19:47:16,413 DEBUG EntityLoader:79 - Static select for entity com.epocket.simplehibernatedebug.domain.TransactionLog: select transactio0_.BANK_ID as BANK1_2_0_, transactio0_.TRANSACTION_ID as TRANSACT2_2_0_, transactio0_.TRANSACTION_TYPE_CODE as TRANSACT3_2_0_, transactio0_.TRANSACTION_DATE as TRANSACT4_2_0_, transactio0_.AMOUNT as AMOUNT2_0_, transactio0_.ORIGINATOR as ORIGINATOR2_0_, transactio0_.ORIGINATOR_REFERENCE as ORIGINATOR7_2_0_ from HIBERNATE.TRANSACTION_LOG transactio0_ where transactio0_.BANK_ID=? and transactio0_.TRANSACTION_ID=? for update nowait
19:47:16,413 DEBUG EntityLoader:67 - Static select for action ACTION_MERGE on entity com.epocket.simplehibernatedebug.domain.TransactionLog: select transactio0_.BANK_ID as BANK1_2_0_, transactio0_.TRANSACTION_ID as TRANSACT2_2_0_, transactio0_.TRANSACTION_TYPE_CODE as TRANSACT3_2_0_, transactio0_.TRANSACTION_DATE as TRANSACT4_2_0_, transactio0_.AMOUNT as AMOUNT2_0_, transactio0_.ORIGINATOR as ORIGINATOR2_0_, transactio0_.ORIGINATOR_REFERENCE as ORIGINATOR7_2_0_ from HIBERNATE.TRANSACTION_LOG transactio0_ where transactio0_.BANK_ID=? and transactio0_.TRANSACTION_ID=?
19:47:16,413 DEBUG EntityLoader:67 - Static select for action ACTION_REFRESH on entity com.epocket.simplehibernatedebug.domain.TransactionLog: select transactio0_.BANK_ID as BANK1_2_0_, transactio0_.TRANSACTION_ID as TRANSACT2_2_0_, transactio0_.TRANSACTION_TYPE_CODE as TRANSACT3_2_0_, transactio0_.TRANSACTION_DATE as TRANSACT4_2_0_, transactio0_.AMOUNT as AMOUNT2_0_, transactio0_.ORIGINATOR as ORIGINATOR2_0_, transactio0_.ORIGINATOR_REFERENCE as ORIGINATOR7_2_0_ from HIBERNATE.TRANSACTION_LOG transactio0_ where transactio0_.BANK_ID=? and transactio0_.TRANSACTION_ID=?
19:47:16,423 DEBUG OneToManyLoader:64 - Static select for one-to-many com.epocket.simplehibernatedebug.domain.Bank.transactionTypes: select transactio0_.BANK_ID as BANK1_1_, transactio0_.TYPE_CODE as TYPE2_1_, transactio0_.BANK_ID as BANK1_1_0_, transactio0_.TYPE_CODE as TYPE2_1_0_, transactio0_.DESCRIPTION as DESCRIPT3_1_0_ from HIBERNATE.TRANSACTION_TYPE transactio0_ where transactio0_.BANK_ID=?
19:47:16,433 DEBUG OneToManyLoader:64 - Static select for one-to-many com.epocket.simplehibernatedebug.domain.Bank.transactionLogs: select transactio0_.BANK_ID as BANK1_1_, transactio0_.TRANSACTION_ID as TRANSACT2_1_, transactio0_.BANK_ID as BANK1_2_0_, transactio0_.TRANSACTION_ID as TRANSACT2_2_0_, transactio0_.TRANSACTION_TYPE_CODE as TRANSACT3_2_0_, transactio0_.TRANSACTION_DATE as TRANSACT4_2_0_, transactio0_.AMOUNT as AMOUNT2_0_, transactio0_.ORIGINATOR as ORIGINATOR2_0_, transactio0_.ORIGINATOR_REFERENCE as ORIGINATOR7_2_0_ from HIBERNATE.TRANSACTION_LOG transactio0_ where transactio0_.BANK_ID=?
19:47:16,433 DEBUG OneToManyLoader:64 - Static select for one-to-many com.epocket.simplehibernatedebug.domain.TransactionType.transactionLogs: select transactio0_.BANK_ID as BANK1_1_, transactio0_.TRANSACTION_TYPE_CODE as TRANSACT3_1_, transactio0_.TRANSACTION_ID as TRANSACT2_1_, transactio0_.BANK_ID as BANK1_2_0_, transactio0_.TRANSACTION_ID as TRANSACT2_2_0_, transactio0_.TRANSACTION_TYPE_CODE as TRANSACT3_2_0_, transactio0_.TRANSACTION_DATE as TRANSACT4_2_0_, transactio0_.AMOUNT as AMOUNT2_0_, transactio0_.ORIGINATOR as ORIGINATOR2_0_, transactio0_.ORIGINATOR_REFERENCE as ORIGINATOR7_2_0_ from HIBERNATE.TRANSACTION_LOG transactio0_ where transactio0_.BANK_ID=? and transactio0_.TRANSACTION_TYPE_CODE=?
19:47:16,433 DEBUG SessionFactoryObjectFactory:76 - registered: 4028804907539778010753977fd10001 (unnamed)
19:47:16,433 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
19:47:16,433 DEBUG SessionFactoryImpl:295 - instantiated session factory
19:47:16,433 INFO SessionFactoryImpl:432 - Checking 0 named queries
19:47:16,553 DEBUG SessionImpl:271 - opened session at timestamp: 4632489314029568
19:47:16,553 DEBUG JDBCTransaction:54 - begin
19:47:16,553 DEBUG ConnectionManager:309 - opening JDBC connection
19:47:16,553 DE

Top

ndk

Post subject: the SQL that was used to establish the database schema...

Posted: Fri Nov 04, 2005 5:13 pm

Newbie

Joined: Fri Nov 04, 2005 4:26 pm
Posts: 5

Code:

DROP TABLE transaction_log CASCADE CONSTRAINTS;
DROP TABLE transaction_type CASCADE CONSTRAINTS;
DROP TABLE bank CASCADE CONSTRAINTS;

REM ---------------------------------------------
REM TABLE bank
REM describes a bank
REM we allow multiple banks to operate out of one
REM database (i.e. one provider could support
REM multiple brands)
REM ---------------------------------------------

CREATE TABLE bank (
   bank_id               VARCHAR2(40) NOT NULL,
   bank_name            VARCHAR2(100) NOT NULL,
   default_currency_code         VARCHAR2(4) NOT NULL,
   next_transaction_id         NUMBER(15)
);

ALTER TABLE bank ADD  ( PRIMARY KEY (bank_id) ) ;


       
REM ---------------------------------------------
REM TABLE transaction_type
REM describes transaction types
REM ---------------------------------------------

CREATE TABLE transaction_type (
   bank_id               VARCHAR2(40) NOT NULL,
   type_code            VARCHAR2(8) NOT NULL,
   description            VARCHAR2(40) NOT NULL
);

ALTER TABLE transaction_type ADD ( PRIMARY KEY (bank_id, type_code) ) ;
ALTER TABLE transaction_type ADD ( FOREIGN KEY (bank_id) REFERENCES bank ) ;


REM ---------------------------------------------
REM TABLE transaction_log
REM log of all transactions
REM ---------------------------------------------

CREATE TABLE transaction_log (
   bank_id               VARCHAR2(40) NOT NULL,
   transaction_id            VARCHAR2(32) NOT NULL,
   transaction_date         DATE NOT NULL,
   transaction_type_code         VARCHAR2(8) NOT NULL,
   amount               NUMBER(12,3) DEFAULT 0.000,
   originator            VARCHAR(40) NOT NULL,
   originator_reference         VARCHAR(40) NOT NULL   
);

ALTER TABLE transaction_log ADD ( PRIMARY KEY (bank_id, transaction_id) ) ;
ALTER TABLE transaction_log ADD ( FOREIGN KEY (bank_id) REFERENCES bank );
ALTER TABLE transaction_log ADD ( FOREIGN KEY (bank_id, transaction_type_code) REFERENCES transaction_type );



COMMIT;

Top

snpesnpe

Post subject:

Posted: Fri Nov 04, 2005 8:38 pm

Expert

Joined: Sat Jun 12, 2004 4:49 pm
Posts: 915

try add property 'transactionType' in class TransactionLog and populate this property with values
in many-to-one for TransactionType or what you want for this property

Top

ndk

Post subject: that is already being done

Posted: Sat Nov 05, 2005 8:57 am

Newbie

Joined: Fri Nov 04, 2005 4:26 pm
Posts: 5

If you look at the code that adds the transaction log, you will see that there is a set(transactionType) in the transaction log. It was the fact that this did not set the column that started my entire investigation into this.

It cannot be set if you set the code directly as you suggest. It cannot be set if cascade=all is used. The insert=false set in the mapping file is blanket over both columns in the foreign key.

Top

ndk

Post subject: relevant section of mapping file causing the trouble

Posted: Sat Nov 05, 2005 9:54 am

Newbie

Joined: Fri Nov 04, 2005 4:26 pm
Posts: 5

[code] <many-to-one name="transactionType" class="com.epocket.simplehibernatedebug.domain.TransactionType" update="false" insert="false">
<column name="BANK_ID" length="40" not-null="true" />

<column name="TRANSACTION_TYPE_CODE" length="8" not-null="true" />
</many-to-one>
[/code

Above is the foreign key that references transactionType. Note that bank_id is a primary key column, and can be populated by setting the Bank object.

The transaction_type_code column is not populated, ever, even if the transactionType object is set.

Top

snpesnpe

Post subject:

Posted: Sat Nov 05, 2005 1:18 pm

Expert

Joined: Sat Jun 12, 2004 4:49 pm
Posts: 915

you don't understand me

leave column in many-to-one (it have insert=false) and add yet another property like this

Code:

<many-to-one name="transactionType" class="com.epocket.simplehibernatedebug.domain.TransactionType" update="false" insert="false">
<column name="BANK_ID" length="40" not-null="true" />
<column name="TRANSACTION_TYPE_CODE" length="8" not-null="true" />
</many-to-one> 
<property name="type" column="TRASNACTION_TYPE_CODE" ... />

then populate property "type" what you want for this column (property :type" have insert=true)

Top

ndk

Post subject: you are correct

Posted: Sun Nov 06, 2005 12:59 am

Newbie

Joined: Fri Nov 04, 2005 4:26 pm
Posts: 5

You are quite correct. I did not understand you. Thanks for the patience to take another crack at it.

I altered the mapping file, and the POJO as per your suggestion. Indeed, this worked.

My only comment at this point is that if one is reverse engineering a larger schema, one was to go over the generated objects and mappings very carefully, and do careful unit testing to ensure that one has uncovered and corrected these little gotchas.

Thanks for your help. It was much appreciated.

Top

radashkjr

Post subject: Re: Cannot populate a column.

Posted: Mon Oct 31, 2011 11:43 am

Newbie

Joined: Mon Oct 31, 2011 11:41 am
Posts: 1

I`m having the exact same issue. Could you please explain a bit more clear how u added that property? Perhaps you could write the working example please.

Top

Page 1 of 1

[ 8 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

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