[JIRA] Created: (CAY-798) One to one relationship issue, transfering ObjEntity from one DataContext to Another

From: Tonnee Urugn (JIRA) ("Tonnee)
Date: Wed Jun 06 2007 - 20:04:27 EDT

  • Next message: Tonnee Urugn (JIRA): "[JIRA] Created: (CAY-799) One to One relationship, Transfering ObjEntity/DataObject from one DataConetx to Another."

    One to one relationship issue, transfering ObjEntity from one DataContext to Another
    ------------------------------------------------------------------------------------

                     Key: CAY-798
                     URL: https://issues.apache.org/cayenne/browse/CAY-798
                 Project: Cayenne
              Issue Type: Bug
             Environment: SunOS i86pc i386 i86pc
                Reporter: Tonnee Urugn
                Assignee: Andrus Adamchik

    Hi. I have written a transfer code for migrating ObjEntity from one DataContext to Another (source and target), to help me upgrade my database as i write applications.
    Am using hsqldb. this just to mention..
    The transfer works well for OBjEntities without ONE to ONE relationships.
    Here is the method that calls ObjEntities from the source DataContext

        public void sourceViaCayenne(DataObject object){
            DataContext context = CayenneSource.session().context();
            try{
                //source load
                SelectQuery query = new SelectQuery(object.getClass());
                ss = context.performQuery(query); //ss is a decleared java.util.List
                context.unregisterObjects(ss);
                System.out.println("Source objects found: "+ss.size());
            }catch(Exception he){
                he.printStackTrace();
                transferStatusLabel.setForeground(Color.RED);
                transferStatusLabel.setText("Cayenne Error sourcing object..");
            }
        }

    Here is the method that inserts ObjEntities to the target DataContext

    public void targetViaCayenne(){
            DataContext context = CayenneTarget.session().context();
            try{
                //target insert
                for(int i = 0; i < ss.size(); i++){//ss is a decleared java.util.List
                    DataObject o = (DataObject) ss.get(i);
                    System.out.println(o+"<======>"+o.readProperty("id"));
                    context.registerNewObject(o);
                }
                context.commitChanges();
                
                System.out.println("Source objects inserted: "+ss.size());
                //sourceTx.commit();
                
            }catch(Exception he){
                he.printStackTrace();
                transferStatusLabel.setForeground(Color.RED);
                transferStatusLabel.setText("Error transfering object..");
            }
        }

    For the time being am transfering on object one at a time thru an ActionButton that calls this code.

    try{
                DataObject o = (DataObject)Class.forName(objectNameField.getText()).newInstance();
                sourceViaCayenne(o);
            } catch (ClassNotFoundException ex) {
                ex.printStackTrace();
                transferStatusLabel.setForeground(Color.RED);
                transferStatusLabel.setText("Error transfering object.. class not found");
            } catch (InstantiationException ex) {
                ex.printStackTrace();
                transferStatusLabel.setForeground(Color.RED);
                transferStatusLabel.setText("Error transfering object.. could not instatiate");
            } catch (IllegalAccessException ex) {
                ex.printStackTrace();
                transferStatusLabel.setForeground(Color.RED);
                transferStatusLabel.setText("Error transfering object.. illegal access");
            }

    Here is the source debug...

    03:28:18,839 DEBUG DefaultConfiguration:69 - using domain file name: cayenne.xml
    03:28:18,853 INFO Configuration:63 - CAYENNE JNDI - loading
    03:28:18,854 INFO Configuration:75 - FOUND CONTEXT /jdbc
    03:28:18,944 INFO Configuration:105 - CAYENNE JNDI - ready
    03:28:18,945 DEBUG DefaultConfiguration:141 - initialize starting.
    03:28:18,945 DEBUG ResourceLocator:594 - No file at absolute path: cayenne.xml
    03:28:18,946 DEBUG ResourceLocator:594 - file not found in current directory: cayenne.xml
    03:28:18,947 DEBUG ResourceLocator:594 - searching additional paths: [/zfsurugn/developer/projects/desktop/unuts-ebroker-0.0.1_ca/transfer/source]
    03:28:18,948 DEBUG ResourceLocator:594 - searching for: /zfsurugn/developer/projects/desktop/unuts-ebroker-0.0.1_ca/transfer/source/cayenne.xml
    03:28:19,001 INFO RuntimeLoadDelegate:492 - started configuration loading.
    03:28:19,014 INFO RuntimeLoadDelegate:151 - loaded domain: eBroker
    03:28:19,041 DEBUG ResourceLocator:594 - No file at absolute path: eBrokerMap.map.xml
    03:28:19,042 DEBUG ResourceLocator:594 - file not found in current directory: eBrokerMap.map.xml
    03:28:19,043 DEBUG ResourceLocator:594 - searching additional paths: [/zfsurugn/developer/projects/desktop/unuts-ebroker-0.0.1_ca/transfer/source]
    03:28:19,044 DEBUG ResourceLocator:594 - searching for: /zfsurugn/developer/projects/desktop/unuts-ebroker-0.0.1_ca/transfer/source/eBrokerMap.map.xml
    03:28:19,286 INFO RuntimeLoadDelegate:212 - loaded <map name='eBrokerMap' location='eBrokerMap.map.xml'>.
    03:28:19,288 INFO RuntimeLoadDelegate:250 - loading <node name='eBrokerNode' datasource='jdbc/source' factory='org.apache.cayenne.conf.JNDIDataSourceFactory'>.
    03:28:19,314 INFO RuntimeLoadDelegate:294 - using factory: org.apache.cayenne.conf.JNDIDataSourceFactory
    03:28:19,318 INFO QueryLogger:192 - Connecting. JNDI path: jdbc/source
    03:28:19,459 INFO QueryLogger:254 - +++ Connecting: SUCCESS.
    03:28:19,459 INFO RuntimeLoadDelegate:299 - loaded datasource.
    03:28:19,461 INFO RuntimeLoadDelegate:368 - no adapter set, using automatic adapter.
    03:28:19,485 INFO RuntimeLoadDelegate:379 - loaded map-ref: eBrokerMap.
    03:28:19,490 DEBUG Configuration:421 - added domain: eBroker
    03:28:19,491 INFO RuntimeLoadDelegate:482 - finished configuration loading in 490 ms.
    03:28:19,492 DEBUG DefaultConfiguration:169 - initialize finished.
    03:28:19,493 DEBUG DefaultConfiguration:178 - didInitialize finished.
    03:28:19,521 DEBUG DataRowStore:164 - DataRowStore property cayenne.DataRowStore.snapshot.expiration = 7200
    03:28:19,525 DEBUG DataRowStore:168 - DataRowStore property cayenne.DataRowStore.snapshot.size = 10000
    03:28:19,532 DEBUG DataRowStore:172 - DataRowStore property cayenne.DataRowStore.remote.notify = false
    03:28:19,533 DEBUG DataRowStore:176 - DataRowStore property cayenne.DataRowStore.EventBridge.factory = org.apache.cayenne.event.JavaGroupsBridgeFactory
    03:28:19,745 INFO QueryLogger:423 - --- will run 1 query.
    03:28:19,842 INFO QueryLogger:377 - --- transaction started.
    03:28:19,873 INFO DbAdapterFactoryChain:58 - DB name: HSQL Database Engine
    03:28:19,879 DEBUG ResourceLocator:594 - URL found with classloader: jar:file:/zfsurugn/developer/resources/cayenne/lib/cayenne.jar!/org/apache/cayenne/dba/hsqldb/types.xml
    03:28:19,908 INFO QueryLogger:181 - Detected and installed adapter: org.apache.cayenne.dba.hsqldb.HSQLDBAdapter
    03:28:19,953 INFO QueryLogger:300 - SELECT t0.CLAIM_ABSTRACT_AMOUNT, t0.CLAIM_ABSTRACT_CLIENT_DATE, t0.CLAIM_ABSTRACT_US_DATE, t0.CLAIM_ACCEPTANCE_DATE, t0.CLAIM_AGREEMENT_AMOUNT, t0.CLAIM_AGREEMENT_DATE, t0.CLAIM_CLIENT_DATE, t0.CLAIM_REMARKS, t0.CLAIM_US_DATE, t0.CLAIM_CREDIT_NOTE_AMOUNT, t0.CLAIM_CREDIT_NOTE_COME_CHEQUE_RECEIVE_DATE, t0.CLAIM_CREDIT_NOTE_COME_CHEQUE_RECEIVED, t0.CLAIM_DISCHARGE_VOUCHER_AMOUNT, t0.CLAIM_DISCHARGE_VOUCHER_RECEPTION_DATE, t0.CLAIM_DISCHARGE_VOUCHER_RECEIVED, t0.CLAIM_DISCHARGE_VOUCHER_REQUEST_DATE, t0.CLAIM_DISCHARGE_VOUCHER_REQUESTED, t0.CLAIM_DISCHARGE_VOUCHER_RETURN_DATE, t0.CLAIM_DISCHARGE_VOUCHER_RETURNED, t0.CLAIM_DOCUMENTS_CLIENT_DATE, t0.CLAIM_DOCUMENTS_US_DATE, t0.CLAIM_DV_CHEQUE, t0.CLAIM_DV_CREDITNOTE, t0.CLAIM_EXCESS_AMOUNT, t0.CLAIM_DETAIL_ID, t0.CLAIM_RECOVERY, t0.CLAIM_RECOVERY_REMARKS, t0.CLAIM_REPORT_DATE, t0.CLAIM_SETTLED, t0.CLAIM_UNDERWRITING_ADJUSTMENT FROM EBROKER.EBROKER_CLAIMS_DETAILS t0 - prepared in 28 ms.
    03:28:20,094 INFO QueryLogger:351 - === returned 152 rows. - took 172 ms.
    03:28:20,095 INFO QueryLogger:384 - +++ transaction committed.
    03:28:20,236 DEBUG DataRowStore:668 - postSnapshotsChangeEvent: [SnapshotEvent] source: org.apache.cayenne.access.DataRowStor..18d26, invalidated 152 id(s)
    Source objects found: 152

    Then another ActionButton calls the target method.

    targetViaCayenne();

    Here is the target debug

    03:46:18,981 DEBUG DefaultConfiguration:69 - using domain file name: cayenne.xml
    03:46:18,982 INFO Configuration:64 - CAYENNE JNDI - loading
    03:46:18,983 INFO Configuration:76 - FOUND CONTEXT /jdbc
    03:46:18,986 INFO Configuration:106 - CAYENNE JNDI - ready
    03:46:18,986 DEBUG DefaultConfiguration:141 - initialize starting.
    03:46:18,987 DEBUG ResourceLocator:594 - No file at absolute path: cayenne.xml
    03:46:18,987 DEBUG ResourceLocator:594 - file not found in current directory: cayenne.xml
    03:46:18,988 DEBUG ResourceLocator:594 - searching additional paths: [/zfsurugn/developer/projects/desktop/unuts-ebroker-0.0.1_ca/transfer/target]
    03:46:18,988 DEBUG ResourceLocator:594 - searching for: /zfsurugn/developer/projects/desktop/unuts-ebroker-0.0.1_ca/transfer/target/cayenne.xml
    03:46:18,993 INFO RuntimeLoadDelegate:492 - started configuration loading.
    03:46:18,994 INFO RuntimeLoadDelegate:151 - loaded domain: eBroker
    03:46:18,995 DEBUG ResourceLocator:594 - No file at absolute path: eBrokerMap.map.xml
    03:46:18,996 DEBUG ResourceLocator:594 - file not found in current directory: eBrokerMap.map.xml
    03:46:18,996 DEBUG ResourceLocator:594 - searching additional paths: [/zfsurugn/developer/projects/desktop/unuts-ebroker-0.0.1_ca/transfer/target]
    03:46:18,997 DEBUG ResourceLocator:594 - searching for: /zfsurugn/developer/projects/desktop/unuts-ebroker-0.0.1_ca/transfer/target/eBrokerMap.map.xml
    03:46:19,069 INFO RuntimeLoadDelegate:212 - loaded <map name='eBrokerMap' location='eBrokerMap.map.xml'>.
    03:46:19,070 INFO RuntimeLoadDelegate:250 - loading <node name='eBrokerNode' datasource='jdbc/target' factory='org.apache.cayenne.conf.JNDIDataSourceFactory'>.
    03:46:19,071 INFO RuntimeLoadDelegate:294 - using factory: org.apache.cayenne.conf.JNDIDataSourceFactory
    03:46:19,071 INFO QueryLogger:192 - Connecting. JNDI path: jdbc/target
    03:46:19,073 INFO QueryLogger:254 - +++ Connecting: SUCCESS.
    03:46:19,077 INFO RuntimeLoadDelegate:299 - loaded datasource.
    03:46:19,077 INFO RuntimeLoadDelegate:368 - no adapter set, using automatic adapter.
    03:46:19,078 INFO RuntimeLoadDelegate:379 - loaded map-ref: eBrokerMap.
    03:46:19,079 DEBUG Configuration:421 - added domain: eBroker
    03:46:19,079 INFO RuntimeLoadDelegate:482 - finished configuration loading in 86 ms.
    03:46:19,079 DEBUG DefaultConfiguration:169 - initialize finished.
    03:46:19,080 DEBUG DefaultConfiguration:178 - didInitialize finished.
    03:46:19,081 DEBUG DataRowStore:164 - DataRowStore property cayenne.DataRowStore.snapshot.expiration = 7200
    03:46:19,081 DEBUG DataRowStore:168 - DataRowStore property cayenne.DataRowStore.snapshot.size = 10000
    03:46:19,081 DEBUG DataRowStore:172 - DataRowStore property cayenne.DataRowStore.remote.notify = false
    03:46:19,082 DEBUG DataRowStore:176 - DataRowStore property cayenne.DataRowStore.EventBridge.factory = org.apache.cayenne.event.JavaGroupsBridgeFactory
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    {<no id>; transient; }<======>null
    03:46:19,523 INFO DbAdapterFactoryChain:58 - DB name: HSQL Database Engine
    03:46:19,527 DEBUG ResourceLocator:594 - URL found with classloader: jar:file:/zfsurugn/developer/resources/cayenne/lib/cayenne.jar!/org/apache/cayenne/dba/hsqldb/types.xml
    03:46:19,529 INFO QueryLogger:181 - Detected and installed adapter: org.apache.cayenne.dba.hsqldb.HSQLDBAdapter
    03:46:19,719 INFO QueryLogger:423 - --- will run 1 query.
    03:46:19,720 INFO QueryLogger:377 - --- transaction started.
    03:46:19,727 INFO QueryLogger:300 - INSERT INTO EBROKER.EBROKER_CLAIMS_DETAILS (CLAIM_ABSTRACT_AMOUNT, CLAIM_ABSTRACT_CLIENT_DATE, CLAIM_ABSTRACT_US_DATE, CLAIM_ACCEPTANCE_DATE, CLAIM_AGREEMENT_AMOUNT, CLAIM_AGREEMENT_DATE, CLAIM_CLIENT_DATE, CLAIM_CREDIT_NOTE_AMOUNT, CLAIM_CREDIT_NOTE_COME_CHEQUE_RECEIVED, CLAIM_CREDIT_NOTE_COME_CHEQUE_RECEIVE_DATE, CLAIM_DETAIL_ID, CLAIM_DISCHARGE_VOUCHER_AMOUNT, CLAIM_DISCHARGE_VOUCHER_RECEIVED, CLAIM_DISCHARGE_VOUCHER_RECEPTION_DATE, CLAIM_DISCHARGE_VOUCHER_REQUESTED, CLAIM_DISCHARGE_VOUCHER_REQUEST_DATE, CLAIM_DISCHARGE_VOUCHER_RETURNED, CLAIM_DISCHARGE_VOUCHER_RETURN_DATE, CLAIM_DOCUMENTS_CLIENT_DATE, CLAIM_DOCUMENTS_US_DATE, CLAIM_DV_CHEQUE, CLAIM_DV_CREDITNOTE, CLAIM_EXCESS_AMOUNT, CLAIM_RECOVERY, CLAIM_RECOVERY_REMARKS, CLAIM_REMARKS, CLAIM_REPORT_DATE, CLAIM_SETTLED, CLAIM_UNDERWRITING_ADJUSTMENT, CLAIM_US_DATE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    03:46:19,733 INFO QueryLogger:322 - [bind: 0.0, '2007-01-11 00:00:00.0', '2007-01-16 00:00:00.0', '2007-02-08 00:00:00.0', 6922500.0, '2007-02-07 00:00:00.0', '2007-01-11 00:00:00.0', 6922500.0, 'false', '2007-03-02 00:00:00.0', NULL, 0.0, 'false', '2007-02-09 00:00:00.0', 'true', NULL, 'false', '2007-02-12 00:00:00.0', '2007-01-11 00:00:00.0', '2007-01-16 00:00:00.0', 'false', 'false', 177500.0, 'false', 'N/A', 'Close file credit note received', '2007-02-07 00:00:00.0', 'true', 'false', '2007-01-16 00:00:00.0']
    03:46:19,739 INFO QueryLogger:403 - *** error.
    java.sql.SQLException: Attempt to insert null into a non-nullable column: column: CLAIM_DETAIL_ID table: EBROKER_CLAIMS_DETAILS in statement [INSERT INTO EBROKER.EBROKER_CLAIMS_DETAILS (CLAIM_ABSTRACT_AMOUNT, CLAIM_ABSTRACT_CLIENT_DATE, CLAIM_ABSTRACT_US_DATE, CLAIM_ACCEPTANCE_DATE, CLAIM_AGREEMENT_AMOUNT, CLAIM_AGREEMENT_DATE, CLAIM_CLIENT_DATE, CLAIM_CREDIT_NOTE_AMOUNT, CLAIM_CREDIT_NOTE_COME_CHEQUE_RECEIVED, CLAIM_CREDIT_NOTE_COME_CHEQUE_RECEIVE_DATE, CLAIM_DETAIL_ID, CLAIM_DISCHARGE_VOUCHER_AMOUNT, CLAIM_DISCHARGE_VOUCHER_RECEIVED, CLAIM_DISCHARGE_VOUCHER_RECEPTION_DATE, CLAIM_DISCHARGE_VOUCHER_REQUESTED, CLAIM_DISCHARGE_VOUCHER_REQUEST_DATE, CLAIM_DISCHARGE_VOUCHER_RETURNED, CLAIM_DISCHARGE_VOUCHER_RETURN_DATE, CLAIM_DOCUMENTS_CLIENT_DATE, CLAIM_DOCUMENTS_US_DATE, CLAIM_DV_CHEQUE, CLAIM_DV_CREDITNOTE, CLAIM_EXCESS_AMOUNT, CLAIM_RECOVERY, CLAIM_RECOVERY_REMARKS, CLAIM_REMARKS, CLAIM_REPORT_DATE, CLAIM_SETTLED, CLAIM_UNDERWRITING_ADJUSTMENT, CLAIM_US_DATE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]
            at org.hsqldb.jdbc.Util.throwError(Unknown Source)
            at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
            at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
    org.apache.cayenne.CayenneRuntimeException: [v.2.0.2 January 14 2007] Commit Exception
            at org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:1254)
            at org.apache.cayenne.access.DataContext.commitChanges(DataContext.java:1130)
            at com.unuts.transfer.DSTransferUI.targetViaCayenne(DSTransferUI.java:449)
            at com.unuts.transfer.DSTransferUI.cayenneTargetButtonActionPerformed(DSTransferUI.java:374)
            at com.unuts.transfer.DSTransferUI.access$300(DSTransferUI.java:24)
            at com.unuts.transfer.DSTransferUI$4.actionPerformed(DSTransferUI.java:289)
            at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
            at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
            at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
            at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
            at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
            at java.awt.Component.processMouseEvent(Component.java:6038)
            at javax.swing.JComponent.processMouseEvent(JComponent.java:3260)
            at java.awt.Component.processEvent(Component.java:5803)
            at java.awt.Container.processEvent(Container.java:2058)
            at java.awt.Component.dispatchEventImpl(Component.java:4410)
            at java.awt.Container.dispatchEventImpl(Container.java:2116)
            at java.awt.Component.dispatchEvent(Component.java:4240)
            at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
            at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
            at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
            at java.awt.Container.dispatchEventImpl(Container.java:2102)
            at java.awt.Window.dispatchEventImpl(Window.java:2429)
            at java.awt.Component.dispatchEvent(Component.java:4240)
            at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
            at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
            at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
            at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
            at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
            at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
            at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
    Caused by: java.sql.SQLException: Attempt to insert null into a non-nullable column: column: CLAIM_DETAIL_ID table: EBROKER_CLAIMS_DETAILS in statement [INSERT INTO EBROKER.EBROKER_CLAIMS_DETAILS (CLAIM_ABSTRACT_AMOUNT, CLAIM_ABSTRACT_CLIENT_DATE, CLAIM_ABSTRACT_US_DATE, CLAIM_ACCEPTANCE_DATE, CLAIM_AGREEMENT_AMOUNT, CLAIM_AGREEMENT_DATE, CLAIM_CLIENT_DATE, CLAIM_CREDIT_NOTE_AMOUNT, CLAIM_CREDIT_NOTE_COME_CHEQUE_RECEIVED, CLAIM_CREDIT_NOTE_COME_CHEQUE_RECEIVE_DATE, CLAIM_DETAIL_ID, CLAIM_DISCHARGE_VOUCHER_AMOUNT, CLAIM_DISCHARGE_VOUCHER_RECEIVED, CLAIM_DISCHARGE_VOUCHER_RECEPTION_DATE, CLAIM_DISCHARGE_VOUCHER_REQUESTED, CLAIM_DISCHARGE_VOUCHER_REQUEST_DATE, CLAIM_DISCHARGE_VOUCHER_RETURNED, CLAIM_DISCHARGE_VOUCHER_RETURN_DATE, CLAIM_DOCUMENTS_CLIENT_DATE, CLAIM_DOCUMENTS_US_DATE, CLAIM_DV_CHEQUE, CLAIM_DV_CREDITNOTE, CLAIM_EXCESS_AMOUNT, CLAIM_RECOVERY, CLAIM_RECOVERY_REMARKS, CLAIM_REMARKS, CLAIM_REPORT_DATE, CLAIM_SETTLED, CLAIM_UNDERWRITING_ADJUSTMENT, CLAIM_US_DATE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]
            at org.hsqldb.jdbc.Util.throwError(Unknown Source)
            at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
            at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
            at org.apache.cayenne.access.jdbc.BatchAction.runAsIndividualQueries(BatchAction.java:188)
            at org.apache.cayenne.access.jdbc.BatchAction.performAction(BatchAction.java:81)
            at org.apache.cayenne.access.DataNodeQueryAction.runQuery(DataNodeQueryAction.java:59)
            at org.apache.cayenne.access.DataNode.performQueries(DataNode.java:273)
            at org.apache.cayenne.access.DataDomainFlushAction.runQueries(DataDomainFlushAction.java:219)
            at org.apache.cayenne.access.DataDomainFlushAction.flush(DataDomainFlushAction.java:141)
            at org.apache.cayenne.access.DataDomain.onSyncFlush(DataDomain.java:794)
            at org.apache.cayenne.access.DataDomain$2.transform(DataDomain.java:765)
            at org.apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:820)
            at org.apache.cayenne.access.DataDomain.onSync(DataDomain.java:762)
            at org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:1226)
            ... 30 more
            at org.apache.cayenne.access.jdbc.BatchAction.runAsIndividualQueries(BatchAction.java:188)
            at org.apache.cayenne.access.jdbc.BatchAction.performAction(BatchAction.java:81)
            at org.apache.cayenne.access.DataNodeQueryAction.runQuery(DataNodeQueryAction.java:59)
            at org.apache.cayenne.access.DataNode.performQueries(DataNode.java:273)
            at org.apache.cayenne.access.DataDomainFlushAction.runQueries(DataDomainFlushAction.java:219)
            at org.apache.cayenne.access.DataDomainFlushAction.flush(DataDomainFlushAction.java:141)
            at org.apache.cayenne.access.DataDomain.onSyncFlush(DataDomain.java:794)
            at org.apache.cayenne.access.DataDomain$2.transform(DataDomain.java:765)
            at org.apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:820)
            at org.apache.cayenne.access.DataDomain.onSync(DataDomain.java:762)
            at org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:1226)
            at org.apache.cayenne.access.DataContext.commitChanges(DataContext.java:1130)
            at com.unuts.transfer.DSTransferUI.targetViaCayenne(DSTransferUI.java:449)
            at com.unuts.transfer.DSTransferUI.cayenneTargetButtonActionPerformed(DSTransferUI.java:374)
            at com.unuts.transfer.DSTransferUI.access$300(DSTransferUI.java:24)
            at com.unuts.transfer.DSTransferUI$4.actionPerformed(DSTransferUI.java:289)
            at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
            at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
            at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
            at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
            at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
            at java.awt.Component.processMouseEvent(Component.java:6038)
            at javax.swing.JComponent.processMouseEvent(JComponent.java:3260)
            at java.awt.Component.processEvent(Component.java:5803)
            at java.awt.Container.processEvent(Container.java:2058)
            at java.awt.Component.dispatchEventImpl(Component.java:4410)
            at java.awt.Container.dispatchEventImpl(Container.java:2116)
            at java.awt.Component.dispatchEvent(Component.java:4240)
            at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
            at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
            at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
            at java.awt.Container.dispatchEventImpl(Container.java:2102)
            at java.awt.Window.dispatchEventImpl(Window.java:2429)
            at java.awt.Component.dispatchEvent(Component.java:4240)
            at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
            at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
            at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
            at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
            at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
            at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
            at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)

    I noticed the null id(s). so i decided to go for meaningful PK and inserted the following code at the constructor of the ObjEntity..

            if(super.getId() == null || super.getId().equals("") || super.getId().length() < 15)// checking for id nullability
                if(getClaim() != null) //the master ObjEntity PK for use with the dependent ObjEntity.
                    setId(getClaim().getId());// setting the dependent PK

    Well here goes the target Debug...

    03:12:49,536 DEBUG DefaultConfiguration:69 - using domain file name: cayenne.xml
    03:12:49,537 INFO Configuration:64 - CAYENNE JNDI - loading
    03:12:49,537 INFO Configuration:76 - FOUND CONTEXT /jdbc
    03:12:49,546 INFO Configuration:106 - CAYENNE JNDI - ready
    03:12:49,546 DEBUG DefaultConfiguration:141 - initialize starting.
    03:12:49,547 DEBUG ResourceLocator:594 - No file at absolute path: cayenne.xml
    03:12:49,547 DEBUG ResourceLocator:594 - file not found in current directory: cayenne.xml
    03:12:49,548 DEBUG ResourceLocator:594 - searching additional paths: [/zfsurugn/developer/projects/desktop/unuts-ebroker-0.0.1_ca/transfer/target]
    03:12:49,548 DEBUG ResourceLocator:594 - searching for: /zfsurugn/developer/projects/desktop/unuts-ebroker-0.0.1_ca/transfer/target/cayenne.xml
    03:12:49,549 INFO RuntimeLoadDelegate:492 - started configuration loading.
    03:12:49,551 INFO RuntimeLoadDelegate:151 - loaded domain: eBroker
    03:12:49,551 DEBUG ResourceLocator:594 - No file at absolute path: eBrokerMap.map.xml
    03:12:49,552 DEBUG ResourceLocator:594 - file not found in current directory: eBrokerMap.map.xml
    03:12:49,554 DEBUG ResourceLocator:594 - searching additional paths: [/zfsurugn/developer/projects/desktop/unuts-ebroker-0.0.1_ca/transfer/target]
    03:12:49,555 DEBUG ResourceLocator:594 - searching for: /zfsurugn/developer/projects/desktop/unuts-ebroker-0.0.1_ca/transfer/target/eBrokerMap.map.xml
    03:12:49,639 INFO RuntimeLoadDelegate:212 - loaded <map name='eBrokerMap' location='eBrokerMap.map.xml'>.
    03:12:49,640 INFO RuntimeLoadDelegate:250 - loading <node name='eBrokerNode' datasource='jdbc/target' factory='org.apache.cayenne.conf.JNDIDataSourceFactory'>.
    03:12:49,641 INFO RuntimeLoadDelegate:294 - using factory: org.apache.cayenne.conf.JNDIDataSourceFactory
    03:12:49,641 INFO QueryLogger:192 - Connecting. JNDI path: jdbc/target
    03:12:49,643 INFO QueryLogger:254 - +++ Connecting: SUCCESS.
    03:12:49,643 INFO RuntimeLoadDelegate:299 - loaded datasource.
    03:12:49,644 INFO RuntimeLoadDelegate:368 - no adapter set, using automatic adapter.
    03:12:49,644 INFO RuntimeLoadDelegate:379 - loaded map-ref: eBrokerMap.
    03:12:49,645 DEBUG Configuration:421 - added domain: eBroker
    03:12:49,645 INFO RuntimeLoadDelegate:482 - finished configuration loading in 96 ms.
    03:12:49,647 DEBUG DefaultConfiguration:169 - initialize finished.
    03:12:49,648 DEBUG DefaultConfiguration:178 - didInitialize finished.
    03:12:49,648 DEBUG DataRowStore:164 - DataRowStore property cayenne.DataRowStore.snapshot.expiration = 7200
    03:12:49,648 DEBUG DataRowStore:168 - DataRowStore property cayenne.DataRowStore.snapshot.size = 10000
    03:12:49,649 DEBUG DataRowStore:172 - DataRowStore property cayenne.DataRowStore.remote.notify = false
    03:12:49,649 DEBUG DataRowStore:176 - DataRowStore property cayenne.DataRowStore.EventBridge.factory = org.apache.cayenne.event.JavaGroupsBridgeFactory
    {<no id>; transient; }<======>1
    {<no id>; transient; }<======>2
    {<no id>; transient; }<======>3
    {<no id>; transient; }<======>4
    {<no id>; transient; }<======>5
    {<no id>; transient; }<======>6
    {<no id>; transient; }<======>7
    {<no id>; transient; }<======>9
    {<no id>; transient; }<======>10
    {<no id>; transient; }<======>12
    {<no id>; transient; }<======>13
    {<no id>; transient; }<======>14
    {<no id>; transient; }<======>15
    {<no id>; transient; }<======>16
    {<no id>; transient; }<======>17
    {<no id>; transient; }<======>18
    {<no id>; transient; }<======>19
    {<no id>; transient; }<======>20
    {<no id>; transient; }<======>21
    {<no id>; transient; }<======>23
    {<no id>; transient; }<======>24
    {<no id>; transient; }<======>25
    {<no id>; transient; }<======>26
    {<no id>; transient; }<======>27
    {<no id>; transient; }<======>28
    {<no id>; transient; }<======>29
    {<no id>; transient; }<======>31
    {<no id>; transient; }<======>32
    {<no id>; transient; }<======>33
    {<no id>; transient; }<======>34
    {<no id>; transient; }<======>35
    {<no id>; transient; }<======>36
    {<no id>; transient; }<======>37
    {<no id>; transient; }<======>38
    {<no id>; transient; }<======>39
    {<no id>; transient; }<======>40
    {<no id>; transient; }<======>42
    {<no id>; transient; }<======>43
    {<no id>; transient; }<======>44
    {<no id>; transient; }<======>45
    {<no id>; transient; }<======>46
    {<no id>; transient; }<======>47
    {<no id>; transient; }<======>48
    {<no id>; transient; }<======>49
    {<no id>; transient; }<======>50
    {<no id>; transient; }<======>51
    {<no id>; transient; }<======>52
    {<no id>; transient; }<======>54
    {<no id>; transient; }<======>55
    {<no id>; transient; }<======>56
    {<no id>; transient; }<======>57
    {<no id>; transient; }<======>58
    {<no id>; transient; }<======>59
    {<no id>; transient; }<======>60
    {<no id>; transient; }<======>61
    {<no id>; transient; }<======>62
    {<no id>; transient; }<======>63
    {<no id>; transient; }<======>64
    {<no id>; transient; }<======>65
    {<no id>; transient; }<======>66
    {<no id>; transient; }<======>67
    {<no id>; transient; }<======>68
    {<no id>; transient; }<======>69
    {<no id>; transient; }<======>70
    {<no id>; transient; }<======>71
    {<no id>; transient; }<======>72
    {<no id>; transient; }<======>73
    {<no id>; transient; }<======>74
    {<no id>; transient; }<======>75
    {<no id>; transient; }<======>76
    {<no id>; transient; }<======>77
    {<no id>; transient; }<======>78
    {<no id>; transient; }<======>79
    {<no id>; transient; }<======>80
    {<no id>; transient; }<======>81
    {<no id>; transient; }<======>82
    {<no id>; transient; }<======>83
    {<no id>; transient; }<======>84
    {<no id>; transient; }<======>85
    {<no id>; transient; }<======>86
    {<no id>; transient; }<======>87
    {<no id>; transient; }<======>88
    {<no id>; transient; }<======>89
    {<no id>; transient; }<======>90
    {<no id>; transient; }<======>91
    {<no id>; transient; }<======>92
    {<no id>; transient; }<======>93
    {<no id>; transient; }<======>94
    {<no id>; transient; }<======>95
    {<no id>; transient; }<======>96
    {<no id>; transient; }<======>99
    {<no id>; transient; }<======>100
    {<no id>; transient; }<======>101
    {<no id>; transient; }<======>102
    {<no id>; transient; }<======>103
    {<no id>; transient; }<======>104
    {<no id>; transient; }<======>105
    {<no id>; transient; }<======>106
    {<no id>; transient; }<======>107
    {<no id>; transient; }<======>108
    {<no id>; transient; }<======>109
    {<no id>; transient; }<======>110
    {<no id>; transient; }<======>111
    {<no id>; transient; }<======>112
    {<no id>; transient; }<======>113
    {<no id>; transient; }<======>114
    {<no id>; transient; }<======>115
    {<no id>; transient; }<======>116
    {<no id>; transient; }<======>117
    {<no id>; transient; }<======>118
    {<no id>; transient; }<======>119
    {<no id>; transient; }<======>120
    {<no id>; transient; }<======>121
    {<no id>; transient; }<======>122
    {<no id>; transient; }<======>123
    {<no id>; transient; }<======>125
    {<no id>; transient; }<======>126
    {<no id>; transient; }<======>127
    {<no id>; transient; }<======>128
    {<no id>; transient; }<======>130
    {<no id>; transient; }<======>131
    {<no id>; transient; }<======>132
    {<no id>; transient; }<======>133
    {<no id>; transient; }<======>135
    {<no id>; transient; }<======>137
    {<no id>; transient; }<======>138
    {<no id>; transient; }<======>139
    {<no id>; transient; }<======>140
    {<no id>; transient; }<======>141
    {<no id>; transient; }<======>142
    {<no id>; transient; }<======>143
    {<no id>; transient; }<======>144
    {<no id>; transient; }<======>145
    {<no id>; transient; }<======>146
    {<no id>; transient; }<======>147
    {<no id>; transient; }<======>149
    {<no id>; transient; }<======>150
    {<no id>; transient; }<======>151
    {<no id>; transient; }<======>152
    {<no id>; transient; }<======>153
    {<no id>; transient; }<======>154
    {<no id>; transient; }<======>155
    {<no id>; transient; }<======>156
    {<no id>; transient; }<======>157
    {<no id>; transient; }<======>158
    {<no id>; transient; }<======>159
    {<no id>; transient; }<======>160
    {<no id>; transient; }<======>163
    {<no id>; transient; }<======>164
    {<no id>; transient; }<======>165
    {<no id>; transient; }<======>166
    {<no id>; transient; }<======>167
    03:12:49,959 INFO DbAdapterFactoryChain:58 - DB name: HSQL Database Engine
    03:12:49,965 DEBUG ResourceLocator:594 - URL found with classloader: jar:file:/zfsurugn/developer/resources/cayenne/lib/cayenne.jar!/org/apache/cayenne/dba/hsqldb/types.xml
    03:12:49,966 INFO QueryLogger:181 - Detected and installed adapter: org.apache.cayenne.dba.hsqldb.HSQLDBAdapter
    03:12:50,157 INFO QueryLogger:423 - --- will run 1 query.
    03:12:50,158 INFO QueryLogger:377 - --- transaction started.
    03:12:50,167 INFO QueryLogger:300 - INSERT INTO EBROKER.EBROKER_CLAIMS_DETAILS (CLAIM_ABSTRACT_AMOUNT, CLAIM_ABSTRACT_CLIENT_DATE, CLAIM_ABSTRACT_US_DATE, CLAIM_ACCEPTANCE_DATE, CLAIM_AGREEMENT_AMOUNT, CLAIM_AGREEMENT_DATE, CLAIM_CLIENT_DATE, CLAIM_CREDIT_NOTE_AMOUNT, CLAIM_CREDIT_NOTE_COME_CHEQUE_RECEIVED, CLAIM_CREDIT_NOTE_COME_CHEQUE_RECEIVE_DATE, CLAIM_DETAIL_ID, CLAIM_DISCHARGE_VOUCHER_AMOUNT, CLAIM_DISCHARGE_VOUCHER_RECEIVED, CLAIM_DISCHARGE_VOUCHER_RECEPTION_DATE, CLAIM_DISCHARGE_VOUCHER_REQUESTED, CLAIM_DISCHARGE_VOUCHER_REQUEST_DATE, CLAIM_DISCHARGE_VOUCHER_RETURNED, CLAIM_DISCHARGE_VOUCHER_RETURN_DATE, CLAIM_DOCUMENTS_CLIENT_DATE, CLAIM_DOCUMENTS_US_DATE, CLAIM_DV_CHEQUE, CLAIM_DV_CREDITNOTE, CLAIM_EXCESS_AMOUNT, CLAIM_RECOVERY, CLAIM_RECOVERY_REMARKS, CLAIM_REMARKS, CLAIM_REPORT_DATE, CLAIM_SETTLED, CLAIM_UNDERWRITING_ADJUSTMENT, CLAIM_US_DATE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    03:12:50,171 INFO QueryLogger:322 - [bind: 20000.0, '2005-07-14 00:00:00.0', '2005-07-14 00:00:00.0', NULL, 0.0, NULL, '2005-07-14 00:00:00.0', 2000.0, 'true', '2005-08-26 00:00:00.0', '160', 0.0, 'true', '2005-08-04 00:00:00.0', 'true', '2005-07-14 00:00:00.0', 'true', '2005-08-04 00:00:00.0', NULL, NULL, 'true', 'false', 10000.0, 'true', NULL, NULL, NULL, 'true', 'false', '2005-07-14 00:00:00.0']
    03:12:50,173 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,174 INFO QueryLogger:322 - [bind: 654240.0, '2006-09-15 00:00:00.0', '2006-09-15 00:00:00.0', NULL, 654240.0, '2007-02-19 00:00:00.0', '2006-09-15 00:00:00.0', 0.0, 'false', NULL, '75', 0.0, 'true', '2007-02-20 00:00:00.0', 'true', '2007-01-04 00:00:00.0', 'true', '2007-03-08 00:00:00.0', '2007-01-02 00:00:00.0', '2007-01-04 00:00:00.0', 'true', 'false', 0.0, 'false', NULL, 'Awaiting cheque', NULL, 'false', 'false', '2006-09-15 00:00:00.0']
    03:12:50,176 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,179 INFO QueryLogger:322 - [bind: 0.0, '2007-02-10 00:00:00.0', '2007-02-12 00:00:00.0', NULL, 0.0, NULL, '2007-02-10 00:00:00.0', 0.0, 'false', NULL, '44', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, '2007-02-10 00:00:00.0', '2007-02-12 00:00:00.0', 'false', 'false', 25201.0, 'true', 'Recovery', 'Release letter received close file', NULL, 'true', 'false', '2007-02-12 00:00:00.0']
    03:12:50,181 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,182 INFO QueryLogger:322 - [bind: 0.0, '2007-05-09 00:00:00.0', '2007-05-10 00:00:00.0', NULL, 0.0, NULL, '2007-05-09 00:00:00.0', 0.0, 'false', NULL, '118', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, '2007-05-09 00:00:00.0', '2007-05-10 00:00:00.0', 'false', 'false', 0.0, 'false', NULL, 'Close file claim documented', NULL, 'true', 'false', '2007-05-10 00:00:00.0']
    03:12:50,183 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,184 INFO QueryLogger:322 - [bind: 0.0, '2007-01-22 00:00:00.0', '2007-01-23 00:00:00.0', NULL, 0.0, NULL, '2007-01-22 00:00:00.0', 0.0, 'false', NULL, '142', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, 'Close file ', NULL, 'true', 'false', '2007-01-23 00:00:00.0']
    03:12:50,185 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,186 INFO QueryLogger:322 - [bind: 882889.0, '2007-04-05 00:00:00.0', '2007-04-10 00:00:00.0', NULL, 0.0, NULL, '2007-04-05 00:00:00.0', 0.0, 'false', NULL, '133', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, 'Awaiting DV', NULL, 'false', 'false', '2007-04-10 00:00:00.0']
    03:12:50,187 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,188 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 0.0, NULL, '2006-06-30 00:00:00.0', 0.0, 'false', NULL, '120', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'true', 'false', '2006-07-03 00:00:00.0']
    03:12:50,190 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,191 INFO QueryLogger:322 - [bind: 98426.0, '2007-04-25 00:00:00.0', '2007-04-26 00:00:00.0', NULL, 0.0, NULL, '2007-04-25 00:00:00.0', 0.0, 'false', NULL, '135', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, '2007-04-25 00:00:00.0', '2007-04-25 00:00:00.0', 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'false', 'false', '2007-04-26 00:00:00.0']
    03:12:50,195 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,196 INFO QueryLogger:322 - [bind: 15000.0, '2007-03-08 00:00:00.0', '2007-03-09 00:00:00.0', NULL, 0.0, NULL, '2007-03-08 00:00:00.0', 0.0, 'false', NULL, '57', 0.0, 'false', NULL, 'true', '2007-03-09 00:00:00.0', 'false', NULL, '2007-03-08 00:00:00.0', '2007-03-09 00:00:00.0', 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'false', 'false', '2007-03-09 00:00:00.0']
    03:12:50,197 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,199 INFO QueryLogger:322 - [bind: 0.0, '2007-01-08 00:00:00.0', '2007-01-08 00:00:00.0', '2007-02-02 00:00:00.0', 12335.0, '2007-02-02 00:00:00.0', '2007-01-08 00:00:00.0', 0.0, 'false', NULL, '29', 0.0, 'false', '2007-02-02 00:00:00.0', 'true', NULL, 'false', '2007-02-02 00:00:00.0', '2007-01-24 00:00:00.0', '2007-01-24 00:00:00.0', 'false', 'false', 0.0, 'false', NULL, NULL, '2007-02-02 00:00:00.0', 'true', 'false', '2007-01-08 00:00:00.0']
    03:12:50,201 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,203 INFO QueryLogger:322 - [bind: 16000.0, '2007-04-16 00:00:00.0', '2007-04-16 00:00:00.0', NULL, 16000.0, NULL, '2007-04-16 00:00:00.0', 16000.0, 'true', '2007-05-11 00:00:00.0', '143', 0.0, 'true', '2007-04-26 00:00:00.0', 'true', '2007-04-16 00:00:00.0', 'true', '2007-05-04 00:00:00.0', '2007-04-16 00:00:00.0', '2007-04-16 00:00:00.0', 'false', 'true', 0.0, 'false', NULL, 'Credit note received close file', NULL, 'true', 'false', '2007-04-16 00:00:00.0']
    03:12:50,205 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,206 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 391680.0, NULL, NULL, 0.0, 'false', NULL, '87', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'false', 'false', NULL]
    03:12:50,207 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,207 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 475000.0, NULL, '2007-02-17 00:00:00.0', 0.0, 'false', NULL, '54', 0.0, 'true', '2007-05-22 00:00:00.0', 'true', '2007-02-17 00:00:00.0', 'false', NULL, '2007-02-17 00:00:00.0', '2007-02-17 00:00:00.0', 'false', 'false', 25000.0, 'false', NULL, NULL, NULL, 'false', 'false', '2007-02-17 00:00:00.0']
    03:12:50,209 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,210 INFO QueryLogger:322 - [bind: 0.0, '2006-10-30 00:00:00.0', '2006-10-31 00:00:00.0', NULL, 948480.0, '2007-02-19 00:00:00.0', '2006-10-30 00:00:00.0', 0.0, 'false', NULL, '76', 0.0, 'true', '2007-02-20 00:00:00.0', 'true', '2007-01-04 00:00:00.0', 'true', '2007-03-08 00:00:00.0', '2007-01-02 00:00:00.0', '2007-01-04 00:00:00.0', 'true', 'false', 0.0, 'false', NULL, 'Awaiting cheque', NULL, 'false', 'false', '2006-10-31 00:00:00.0']
    03:12:50,214 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,215 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 0.0, NULL, NULL, 0.0, 'false', NULL, '121', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, 'Close file repair cost below excess', NULL, 'true', 'false', NULL]
    03:12:50,217 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,218 INFO QueryLogger:322 - [bind: 0.0, '2006-12-04 00:00:00.0', '2006-12-04 00:00:00.0', NULL, 245974.0, '2006-12-21 00:00:00.0', '2006-12-04 00:00:00.0', 245974.0, 'false', '2007-02-19 00:00:00.0', '6', 0.0, 'false', '2006-12-22 00:00:00.0', 'true', NULL, 'false', '2006-12-29 00:00:00.0', '2006-12-04 00:00:00.0', '2006-12-04 00:00:00.0', 'false', 'false', 27331.0, 'false', NULL, 'Credit note received', NULL, 'true', 'false', '2006-12-04 00:00:00.0']
    03:12:50,219 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,220 INFO QueryLogger:322 - [bind: 0.0, '2006-10-18 00:00:00.0', '2006-10-18 00:00:00.0', '2006-10-24 00:00:00.0', 3434.0, '2006-10-19 00:00:00.0', '2006-10-05 00:00:00.0', 3434.0, 'false', '2006-10-19 00:00:00.0', '1', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, '2006-10-10 00:00:00.0', '2006-10-19 00:00:00.0', 'false', 'false', 3434.0, 'false', 'rtyrty', 'dyty', '2006-10-17 00:00:00.0', 'true', 'false', '2006-10-19 00:00:00.0']
    03:12:50,222 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,222 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 450720.0, NULL, NULL, 0.0, 'false', NULL, '82', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'false', 'false', NULL]
    03:12:50,223 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,224 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 0.0, NULL, NULL, 0.0, 'false', NULL, '107', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, 'Close file client handling himself', NULL, 'true', 'false', NULL]
    03:12:50,225 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,227 INFO QueryLogger:322 - [bind: 360000.0, '2006-11-03 00:00:00.0', '2007-12-08 00:00:00.0', NULL, 160000.0, '2007-03-13 00:00:00.0', '2006-11-03 00:00:00.0', 160000.0, 'true', '2007-04-11 00:00:00.0', '28', 0.0, 'true', '2007-03-15 00:00:00.0', 'true', '2007-02-05 00:00:00.0', 'true', '2007-03-21 00:00:00.0', '2006-11-03 00:00:00.0', '2006-12-08 00:00:00.0', 'false', 'true', 200000.0, 'false', NULL, 'Credit note received', NULL, 'true', 'false', '2006-12-08 00:00:00.0']
    03:12:50,228 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,231 INFO QueryLogger:322 - [bind: 41342.0, '2007-01-22 00:00:00.0', '2007-01-23 00:00:00.0', NULL, 26342.0, NULL, '2007-01-22 00:00:00.0', 0.0, 'false', NULL, '13', 0.0, 'false', NULL, 'true', '2007-01-23 00:00:00.0', 'false', NULL, NULL, NULL, 'false', 'false', 15000.0, 'false', NULL, 'Awaiting DV', NULL, 'false', 'false', '2007-01-23 00:00:00.0']
    03:12:50,233 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,234 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 0.0, NULL, NULL, 0.0, 'false', NULL, '60', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 10000.0, 'false', NULL, 'repair cost less than excess', NULL, 'true', 'false', NULL]
    03:12:50,235 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,236 INFO QueryLogger:322 - [bind: 696000.0, '2006-11-30 00:00:00.0', '2006-12-01 00:00:00.0', '2006-12-01 00:00:00.0', 450000.0, '2007-03-06 00:00:00.0', '2006-11-30 00:00:00.0', 450000.0, 'true', '2007-04-25 00:00:00.0', '62', 0.0, 'true', '2007-03-27 00:00:00.0', 'true', '2006-12-21 00:00:00.0', 'true', '2007-03-30 00:00:00.0', '2006-11-30 00:00:00.0', '2006-12-01 00:00:00.0', 'true', 'false', 50000.0, 'false', NULL, 'Cheque received.close file', '2006-11-30 00:00:00.0', 'true', 'false', '2006-12-01 00:00:00.0']
    03:12:50,237 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,238 INFO QueryLogger:322 - [bind: 3500.0, '2007-01-15 00:00:00.0', '2007-01-16 00:00:00.0', NULL, 3500.0, NULL, '2007-01-15 00:00:00.0', 0.0, 'false', NULL, '37', 0.0, 'true', '2007-02-05 00:00:00.0', 'true', '2007-01-16 00:00:00.0', 'true', '2007-02-05 00:00:00.0', '2007-01-15 00:00:00.0', '2007-01-16 00:00:00.0', 'true', 'false', 0.0, 'false', 'N/A', 'Awaiting DV', NULL, 'false', 'false', '2007-01-16 00:00:00.0']
    03:12:50,239 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,249 INFO QueryLogger:322 - [bind: 38999.0, '2007-02-26 00:00:00.0', '2007-02-27 00:00:00.0', '2007-04-21 00:00:00.0', 13874.0, '2007-04-20 00:00:00.0', '2007-02-26 00:00:00.0', 0.0, 'false', NULL, '15', 0.0, 'true', '2007-05-22 00:00:00.0', 'true', '2007-02-27 00:00:00.0', 'false', NULL, '2007-02-27 00:00:00.0', '2007-02-27 00:00:00.0', 'false', 'false', 15000.0, 'false', NULL, 'Awaiting credit note', '2007-04-20 00:00:00.0', 'false', 'false', '2007-02-27 00:00:00.0']
    03:12:50,254 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,256 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 0.0, NULL, NULL, 0.0, 'false', NULL, '113', 0.0, 'false', NULL, 'false', '2007-04-12 00:00:00.0', 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'false', 'false', NULL]
    03:12:50,258 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,259 INFO QueryLogger:322 - [bind: 269015.0, '2007-02-26 00:00:00.0', '2007-02-27 00:00:00.0', '2007-04-20 00:00:00.0', 254015.0, '2007-04-19 00:00:00.0', '2007-02-26 00:00:00.0', 0.0, 'false', NULL, '49', 0.0, 'false', NULL, 'true', '2007-02-27 00:00:00.0', 'false', NULL, '2007-02-26 00:00:00.0', '2007-02-27 00:00:00.0', 'false', 'false', 15000.0, 'false', NULL, 'Awaiting DV', '2007-04-20 00:00:00.0', 'false', 'false', '2007-02-27 00:00:00.0']
    03:12:50,261 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,262 INFO QueryLogger:322 - [bind: 0.0, '2007-02-26 00:00:00.0', '2007-02-27 00:00:00.0', NULL, 112059.0, '2007-04-20 00:00:00.0', '2007-02-26 00:00:00.0', 0.0, 'false', NULL, '16', 0.0, 'true', '2007-02-27 00:00:00.0', 'true', '2007-02-27 00:00:00.0', 'false', NULL, '2007-02-27 00:00:00.0', '2007-02-27 00:00:00.0', 'false', 'false', 15000.0, 'false', NULL, 'Awaiting credit note', NULL, 'false', 'false', '2007-02-27 00:00:00.0']
    03:12:50,263 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,264 INFO QueryLogger:322 - [bind: 29580.0, '2007-01-19 00:00:00.0', '2007-04-23 00:00:00.0', NULL, 29580.0, NULL, '2007-01-19 00:00:00.0', 29580.0, 'true', '2007-05-02 00:00:00.0', '40', 0.0, 'true', '2007-04-26 00:00:00.0', 'true', '2007-04-10 00:00:00.0', 'true', '2007-04-27 00:00:00.0', '2007-04-10 00:00:00.0', '2007-04-10 00:00:00.0', 'true', 'false', 0.0, 'false', NULL, 'Cheque received close file', NULL, 'true', 'false', '2007-01-23 00:00:00.0']
    03:12:50,265 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,266 INFO QueryLogger:322 - [bind: 50200.0, '2007-02-25 00:00:00.0', '2007-02-27 00:00:00.0', NULL, 35200.0, NULL, '2007-02-25 00:00:00.0', 0.0, 'false', NULL, '65', 0.0, 'false', NULL, 'true', '2007-02-27 00:00:00.0', 'false', NULL, '2007-02-25 00:00:00.0', '2007-02-27 00:00:00.0', 'false', 'false', 15000.0, 'false', NULL, 'Awaiting assessor''s report', NULL, 'false', 'false', '2007-02-27 00:00:00.0']
    03:12:50,268 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,268 INFO QueryLogger:322 - [bind: 1079040.0, '2006-07-07 00:00:00.0', '2006-07-07 00:00:00.0', NULL, 1079040.0, NULL, '2006-07-07 00:00:00.0', 0.0, 'false', NULL, '91', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'false', 'false', '2006-07-07 00:00:00.0']
    03:12:50,273 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,274 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 0.0, NULL, NULL, 0.0, 'false', NULL, '50', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, 'Close file repair estimate below excess', NULL, 'true', 'false', NULL]
    03:12:50,275 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,276 INFO QueryLogger:322 - [bind: 0.0, '2007-02-08 00:00:00.0', '2007-02-09 00:00:00.0', NULL, 290000.0, NULL, '2007-02-08 00:00:00.0', 290000.0, 'false', '2007-03-15 00:00:00.0', '31', 0.0, 'false', '2007-03-15 00:00:00.0', 'true', NULL, 'false', '2007-03-15 00:00:00.0', '2007-02-08 00:00:00.0', '2007-02-09 00:00:00.0', 'false', 'false', 10000.0, 'false', NULL, 'Cheque received', NULL, 'true', 'false', '2007-02-09 00:00:00.0']
    03:12:50,278 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,278 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 0.0, NULL, NULL, 0.0, 'false', NULL, '164', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'false', 'false', NULL]
    03:12:50,279 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,281 INFO QueryLogger:322 - [bind: 9250000.0, '2007-04-10 00:00:00.0', '2007-04-11 00:00:00.0', NULL, 901875.0, NULL, '2007-04-10 00:00:00.0', 0.0, 'false', NULL, '131', 0.0, 'false', NULL, 'true', '2007-04-11 00:00:00.0', 'false', NULL, '2007-04-11 00:00:00.0', '2007-04-12 00:00:00.0', 'false', 'false', 23125.0, 'false', NULL, 'Awaiting DV', NULL, 'false', 'false', '2007-04-11 00:00:00.0']
    03:12:50,284 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,286 INFO QueryLogger:322 - [bind: 404875.0, '2007-05-09 00:00:00.0', '2007-05-10 00:00:00.0', NULL, 404875.0, NULL, '2007-05-09 00:00:00.0', 0.0, 'false', NULL, '156', 0.0, 'true', '2007-05-25 00:00:00.0', 'true', '2007-05-10 00:00:00.0', 'false', NULL, '2007-05-09 00:00:00.0', '2007-05-10 00:00:00.0', 'false', 'false', 15125.0, 'false', NULL, 'Awaiting cheque', NULL, 'false', 'false', '2007-05-10 00:00:00.0']
    03:12:50,287 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,288 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 0.0, NULL, NULL, 0.0, 'false', NULL, '145', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'false', 'false', NULL]
    03:12:50,290 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,291 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 391680.0, NULL, NULL, 0.0, 'false', NULL, '90', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'false', 'false', NULL]
    03:12:50,292 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,292 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 458880.0, NULL, NULL, 0.0, 'false', NULL, '151', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'false', 'false', NULL]
    03:12:50,293 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,338 INFO QueryLogger:322 - [bind: 924480.0, '2006-01-04 00:00:00.0', '2006-01-04 00:00:00.0', NULL, 924480.0, '2007-04-10 00:00:00.0', '2006-01-04 00:00:00.0', 0.0, 'false', NULL, '93', 0.0, 'true', '2007-04-12 00:00:00.0', 'true', '2007-02-08 00:00:00.0', 'true', '2007-04-30 00:00:00.0', '2007-01-04 00:00:00.0', '2007-01-04 00:00:00.0', 'true', 'false', 0.0, 'false', NULL, 'Awaiting cheque', NULL, 'false', 'false', '2006-01-04 00:00:00.0']
    03:12:50,389 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,390 INFO QueryLogger:322 - [bind: 0.0, '2006-08-02 00:00:00.0', '2006-08-02 00:00:00.0', NULL, 407040.0, '2007-02-19 00:00:00.0', '2006-08-02 00:00:00.0', 0.0, 'false', NULL, '73', 0.0, 'true', '2007-02-20 00:00:00.0', 'true', '2007-01-04 00:00:00.0', 'true', '2007-03-08 00:00:00.0', '2007-01-02 00:00:00.0', '2007-01-04 00:00:00.0', 'true', 'false', 0.0, 'false', NULL, 'Awaiting cheque', NULL, 'false', 'false', '2006-08-02 00:00:00.0']
    03:12:50,391 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,395 INFO QueryLogger:322 - [bind: 25360.0, '2007-04-02 00:00:00.0', '2007-04-02 00:00:00.0', NULL, 25360.0, NULL, '2007-04-02 00:00:00.0', 0.0, 'false', NULL, '141', 0.0, 'true', '2007-05-09 00:00:00.0', 'true', '2007-04-02 00:00:00.0', 'true', '2007-05-10 00:00:00.0', '2007-04-02 00:00:00.0', '2007-04-02 00:00:00.0', 'false', 'true', 0.0, 'false', NULL, 'Awaiting credit note', NULL, 'false', 'false', '2007-04-02 00:00:00.0']
    03:12:50,401 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,403 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 0.0, NULL, NULL, 0.0, 'false', NULL, '132', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, 'Close file client handling direct with TP', NULL, 'true', 'false', NULL]
    03:12:50,404 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,404 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 0.0, NULL, NULL, 0.0, 'false', NULL, '116', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 30000.0, 'false', NULL, 'Awaitng documents ', NULL, 'false', 'false', NULL]
    03:12:50,405 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,406 INFO QueryLogger:322 - [bind: 0.0, '2006-12-11 00:00:00.0', '2006-12-13 00:00:00.0', NULL, 0.0, NULL, '2006-12-11 00:00:00.0', 0.0, 'false', NULL, '101', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, '2006-12-11 00:00:00.0', '2006-12-13 00:00:00.0', 'false', 'false', 15000.0, 'true', NULL, 'Release letter received', NULL, 'true', 'false', '2006-12-13 00:00:00.0']
    03:12:50,407 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,408 INFO QueryLogger:322 - [bind: 6500.0, '2007-03-27 00:00:00.0', '2007-03-28 00:00:00.0', NULL, 6500.0, '2007-04-09 00:00:00.0', '2007-03-27 00:00:00.0', 6500.0, 'true', '2007-05-18 00:00:00.0', '114', 0.0, 'true', '2007-04-10 00:00:00.0', 'true', '2007-03-28 00:00:00.0', 'true', '2007-04-16 00:00:00.0', '2007-03-27 00:00:00.0', '2007-03-28 00:00:00.0', 'false', 'true', 0.0, 'false', NULL, 'Credit note received.Close file', NULL, 'true', 'false', '2007-03-28 00:00:00.0']
    03:12:50,415 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,416 INFO QueryLogger:322 - [bind: 0.0, '2007-03-21 00:00:00.0', '2007-03-21 00:00:00.0', NULL, 0.0, NULL, '2007-03-21 00:00:00.0', 0.0, 'false', NULL, '110', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, '2007-03-21 00:00:00.0', '2007-03-21 00:00:00.0', 'false', 'false', 10750.0, 'true', NULL, 'Release letter received. Close file', NULL, 'true', 'false', '2007-03-21 00:00:00.0']
    03:12:50,417 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,418 INFO QueryLogger:322 - [bind: 0.0, '2007-03-28 00:00:00.0', '2007-03-30 00:00:00.0', NULL, 0.0, NULL, '2007-03-28 00:00:00.0', 0.0, 'false', NULL, '105', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 15000.0, 'true', NULL, 'close file release letter received', NULL, 'true', 'false', '2007-03-30 00:00:00.0']
    03:12:50,421 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,422 INFO QueryLogger:322 - [bind: 294720.0, '2007-02-20 00:00:00.0', '2007-02-20 00:00:00.0', NULL, 294720.0, NULL, '2007-02-20 00:00:00.0', 0.0, 'false', NULL, '81', 0.0, 'false', NULL, 'true', '2007-02-20 00:00:00.0', 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, 'Awaiting DV', NULL, 'false', 'false', '2007-02-20 00:00:00.0']
    03:12:50,426 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,436 INFO QueryLogger:322 - [bind: 151179.0, '2007-02-27 00:00:00.0', '2007-02-27 00:00:00.0', NULL, 15923.0, '2007-04-02 00:00:00.0', '2007-02-27 00:00:00.0', 0.0, 'false', NULL, '102', 0.0, 'true', '2007-04-05 00:00:00.0', 'true', '2007-02-27 00:00:00.0', 'false', NULL, '2007-02-27 00:00:00.0', '2007-02-27 00:00:00.0', 'false', 'false', 125000.0, 'false', NULL, 'Awaiting credit note ', NULL, 'false', 'false', '2007-02-27 00:00:00.0']
    03:12:50,455 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,458 INFO QueryLogger:322 - [bind: 0.0, '2006-12-01 00:00:00.0', '2006-12-01 00:00:00.0', NULL, 50000.0, '2006-12-22 00:00:00.0', '2006-12-01 00:00:00.0', 50000.0, 'false', '2007-01-22 00:00:00.0', '26', 0.0, 'false', '2006-12-28 00:00:00.0', 'true', NULL, 'false', '2007-01-03 00:00:00.0', '2006-12-01 00:00:00.0', '2006-12-01 00:00:00.0', 'false', 'false', 0.0, 'false', 'None', 'Close file', NULL, 'true', 'false', '2006-12-01 00:00:00.0']
    03:12:50,461 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,462 INFO QueryLogger:322 - [bind: 0.0, '2006-01-13 00:00:00.0', '2006-01-13 00:00:00.0', '2006-02-02 00:00:00.0', 240000.0, '2006-02-03 00:00:00.0', '2006-01-13 00:00:00.0', 24000.0, 'false', '2007-02-19 00:00:00.0', '46', 0.0, 'false', '2007-02-05 00:00:00.0', 'true', NULL, 'false', '2007-02-06 00:00:00.0', '2006-01-13 00:00:00.0', '2006-01-13 00:00:00.0', 'false', 'false', 10000.0, 'false', 'N/A', 'Credit note received', '2006-02-01 00:00:00.0', 'true', 'false', '2006-01-13 00:00:00.0']
    03:12:50,463 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,464 INFO QueryLogger:322 - [bind: 0.0, '2007-01-26 00:00:00.0', '2007-01-29 00:00:00.0', NULL, 278506.0, '2007-02-27 00:00:00.0', '2007-01-26 00:00:00.0', 0.0, 'false', NULL, '59', 0.0, 'true', '2007-03-05 00:00:00.0', 'true', '2007-01-29 00:00:00.0', 'true', '2007-03-15 00:00:00.0', NULL, NULL, 'false', 'true', 2500.0, 'false', NULL, 'Awaiting cheque', NULL, 'false', 'false', '2007-01-29 00:00:00.0']
    03:12:50,465 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,466 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 1078080.0, NULL, NULL, 0.0, 'false', NULL, '84', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'false', 'false', NULL]
    03:12:50,468 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,468 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 0.0, NULL, NULL, 0.0, 'false', NULL, '128', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, 'No claim', NULL, 'true', 'false', NULL]
    03:12:50,469 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,471 INFO QueryLogger:322 - [bind: 0.0, '2006-11-25 00:00:00.0', '2006-11-27 00:00:00.0', NULL, 60300.0, NULL, '2006-11-25 00:00:00.0', 0.0, 'false', NULL, '52', 0.0, 'false', NULL, 'true', '2006-11-27 00:00:00.0', 'false', NULL, '2006-11-25 00:00:00.0', '2006-11-27 00:00:00.0', 'false', 'false', 10000.0, 'false', NULL, 'Awaiting purchase invoices for the parts', NULL, 'false', 'false', '2006-11-27 00:00:00.0']
    03:12:50,472 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,473 INFO QueryLogger:322 - [bind: 0.0, '2006-10-27 00:00:00.0', '2006-10-23 00:00:00.0', NULL, 0.0, NULL, NULL, 0.0, 'false', NULL, '3', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'true', 'false', NULL]
    03:12:50,474 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,474 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 0.0, NULL, NULL, 0.0, 'false', NULL, '140', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'false', 'false', NULL]
    03:12:50,475 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,483 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 1078080.0, NULL, NULL, 0.0, 'false', NULL, '95', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'false', 'false', NULL]
    03:12:50,484 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,485 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 0.0, NULL, NULL, 0.0, 'false', NULL, '2', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'true', 'false', NULL]
    03:12:50,489 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,489 INFO QueryLogger:322 - [bind: 0.0, '2007-03-02 00:00:00.0', '2007-03-02 00:00:00.0', NULL, 0.0, '2007-02-21 00:00:00.0', '2007-03-02 00:00:00.0', 0.0, 'false', NULL, '36', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, '2007-03-02 00:00:00.0', '2007-03-02 00:00:00.0', 'false', 'false', 100000.0, 'false', NULL, 'Close file release.', NULL, 'true', 'false', '2007-03-02 00:00:00.0']
    03:12:50,491 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,492 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 0.0, NULL, NULL, 0.0, 'false', NULL, '159', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 10000.0, 'false', NULL, 'Awaiting documents form insured', NULL, 'false', 'false', NULL]
    03:12:50,493 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,493 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 0.0, NULL, NULL, 0.0, 'false', NULL, '39', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, 'Close file for non responsive', NULL, 'true', 'false', NULL]
    03:12:50,494 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,495 INFO QueryLogger:322 - [bind: 0.0, '2007-03-09 00:00:00.0', '2007-03-12 00:00:00.0', NULL, 0.0, NULL, '2007-03-08 00:00:00.0', 0.0, 'false', NULL, '100', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'false', 'false', '2007-03-12 00:00:00.0']
    03:12:50,496 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,496 INFO QueryLogger:322 - [bind: 0.0, '2007-04-17 00:00:00.0', '2007-04-18 00:00:00.0', NULL, 0.0, NULL, '2007-04-17 00:00:00.0', 0.0, 'false', NULL, '123', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, '2007-04-17 00:00:00.0', '2007-04-18 00:00:00.0', 'false', 'false', 45000.0, 'false', NULL, 'Close file release received', NULL, 'true', 'false', '2007-04-18 00:00:00.0']
    03:12:50,498 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,499 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, '2006-10-15 00:00:00.0', 0.0, NULL, NULL, 34.0, 'false', '2006-10-12 00:00:00.0', '4', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', 'dvvcx', 'fdfdf', '2006-10-31 00:00:00.0', 'true', 'false', NULL]
    03:12:50,501 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,501 INFO QueryLogger:322 - [bind: 0.0, '2006-06-30 00:00:00.0', '2006-07-03 00:00:00.0', NULL, 0.0, NULL, '2006-06-30 00:00:00.0', 0.0, 'false', NULL, '137', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, 'Close file', NULL, 'true', 'false', '2006-07-03 00:00:00.0']
    03:12:50,503 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,503 INFO QueryLogger:322 - [bind: 0.0, '2007-03-30 00:00:00.0', '2007-04-02 00:00:00.0', NULL, 0.0, NULL, '2007-03-30 00:00:00.0', 0.0, 'false', NULL, '125', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'true', 'false', '2007-04-02 00:00:00.0']
    03:12:50,504 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,505 INFO QueryLogger:322 - [bind: 0.0, '2006-10-18 00:00:00.0', '2006-10-18 00:00:00.0', NULL, 0.0, NULL, '2006-10-18 00:00:00.0', 0.0, 'false', NULL, '64', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, '2006-10-18 00:00:00.0', '2006-10-18 00:00:00.0', 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'false', 'false', '2006-10-18 00:00:00.0']
    03:12:50,506 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,507 INFO QueryLogger:322 - [bind: 3100.0, '2007-04-28 00:00:00.0', '2007-04-30 00:00:00.0', NULL, 3100.0, NULL, '2007-04-28 00:00:00.0', 0.0, 'false', NULL, '153', 0.0, 'true', '2007-05-23 00:00:00.0', 'true', '2007-05-23 00:00:00.0', 'true', '2007-05-25 00:00:00.0', '2007-04-28 00:00:00.0', '2007-04-30 00:00:00.0', 'false', 'true', 10000.0, 'false', NULL, 'Awaiting credit note', NULL, 'false', 'false', '2007-04-30 00:00:00.0']
    03:12:50,508 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,509 INFO QueryLogger:322 - [bind: 354240.0, '2006-05-08 00:00:00.0', '2006-05-10 00:00:00.0', NULL, 354240.0, '2007-02-19 00:00:00.0', '2006-05-08 00:00:00.0', 0.0, 'false', NULL, '71', 0.0, 'true', '2007-02-20 00:00:00.0', 'true', '2007-01-04 00:00:00.0', 'true', '2007-03-08 00:00:00.0', '2007-01-02 00:00:00.0', '2007-01-04 00:00:00.0', 'true', 'false', 0.0, 'false', NULL, 'Awaititing cheque', NULL, 'false', 'false', '2006-05-10 00:00:00.0']
    03:12:50,511 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,513 INFO QueryLogger:322 - [bind: 0.0, '2006-06-30 00:00:00.0', '2006-06-30 00:00:00.0', NULL, 30000.0, '2007-11-20 00:00:00.0', '2006-06-30 00:00:00.0', 0.0, 'false', NULL, '89', 0.0, 'true', '2007-11-20 00:00:00.0', 'true', '2006-11-20 00:00:00.0', 'true', '2006-11-24 00:00:00.0', NULL, NULL, 'true', 'false', 0.0, 'false', NULL, 'Awaiting cheque', NULL, 'false', 'false', '2006-06-30 00:00:00.0']
    03:12:50,514 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,515 INFO QueryLogger:322 - [bind: 0.0, '2006-12-15 00:00:00.0', '2006-12-15 00:00:00.0', NULL, 530000.0, '2006-12-29 00:00:00.0', '2005-12-15 00:00:00.0', 530000.0, 'false', '2007-02-22 00:00:00.0', '27', 0.0, 'false', '2007-01-03 00:00:00.0', 'true', NULL, 'false', '2007-01-10 00:00:00.0', '2006-12-15 00:00:00.0', '2006-12-15 00:00:00.0', 'false', 'false', 20750.0, 'false', NULL, 'Amount electronically transferred', NULL, 'true', 'false', '2006-12-15 00:00:00.0']
    03:12:50,516 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,517 INFO QueryLogger:322 - [bind: 0.0, '2007-05-19 00:00:00.0', '2007-05-21 00:00:00.0', NULL, 0.0, NULL, '2007-05-19 00:00:00.0', 0.0, 'false', NULL, '157', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, '2007-05-19 00:00:00.0', '2007-05-21 00:00:00.0', 'false', 'false', 10000.0, 'false', NULL, 'Close file', NULL, 'true', 'false', '2007-05-21 00:00:00.0']
    03:12:50,518 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,519 INFO QueryLogger:322 - [bind: 0.0, '2007-01-11 00:00:00.0', '2007-01-16 00:00:00.0', '2007-02-08 00:00:00.0', 6922500.0, '2007-02-07 00:00:00.0', '2007-01-11 00:00:00.0', 6922500.0, 'false', '2007-03-02 00:00:00.0', '9', 0.0, 'false', '2007-02-09 00:00:00.0', 'true', NULL, 'false', '2007-02-12 00:00:00.0', '2007-01-11 00:00:00.0', '2007-01-16 00:00:00.0', 'false', 'false', 177500.0, 'false', 'N/A', 'Close file credit note received', '2007-02-07 00:00:00.0', 'true', 'false', '2007-01-16 00:00:00.0']
    03:12:50,521 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,522 INFO QueryLogger:322 - [bind: 4230.0, '2007-04-18 00:00:00.0', '2007-04-19 00:00:00.0', NULL, 4230.0, NULL, '2007-04-17 00:00:00.0', 4230.0, 'true', '2007-05-03 00:00:00.0', '147', 0.0, 'true', '2007-04-27 00:00:00.0', 'true', '2007-04-19 00:00:00.0', 'true', '2007-05-02 00:00:00.0', '2007-04-18 00:00:00.0', '2007-04-19 00:00:00.0', 'true', 'false', 0.0, 'false', NULL, 'Cheque received close file', NULL, 'true', 'false', '2007-04-26 00:00:00.0']
    03:12:50,523 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,524 INFO QueryLogger:322 - [bind: 0.0, '2007-03-14 00:00:00.0', '2007-03-14 00:00:00.0', NULL, 0.0, NULL, '2007-03-14 00:00:00.0', 0.0, 'false', NULL, '122', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, '2007-03-14 00:00:00.0', '2007-03-14 00:00:00.0', 'false', 'false', 0.0, 'false', NULL, 'Close file ', NULL, 'true', 'false', '2007-03-14 00:00:00.0']
    03:12:50,526 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,534 INFO QueryLogger:322 - [bind: 0.0, '2006-12-13 00:00:00.0', '2006-12-14 00:00:00.0', NULL, 120000.0, '2007-02-15 00:00:00.0', '2006-12-13 00:00:00.0', 120000.0, 'false', '2007-03-16 00:00:00.0', '48', 0.0, 'false', '2007-02-16 00:00:00.0', 'true', NULL, 'false', '2007-02-22 00:00:00.0', '2006-12-13 00:00:00.0', '2006-12-14 00:00:00.0', 'false', 'false', 0.0, 'false', NULL, 'Close file credit note received', NULL, 'true', 'false', '2006-12-14 00:00:00.0']
    03:12:50,536 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,536 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 90000.0, '2007-01-24 00:00:00.0', NULL, 90000.0, 'false', '2007-01-31 00:00:00.0', '20', 0.0, 'false', '2007-01-24 00:00:00.0', 'true', NULL, 'false', '2007-01-25 00:00:00.0', NULL, NULL, 'false', 'false', 1000.0, 'false', NULL, 'Credit note received close file', NULL, 'true', 'false', NULL]
    03:12:50,538 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,538 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 1078080.0, NULL, NULL, 0.0, 'false', NULL, '79', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'false', 'false', NULL]
    03:12:50,539 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,541 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 0.0, NULL, NULL, 0.0, 'false', NULL, '112', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, 'Close file patient discharged', NULL, 'true', 'false', NULL]
    03:12:50,542 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,542 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 0.0, NULL, NULL, 0.0, 'false', NULL, '43', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'true', 'false', NULL]
    03:12:50,543 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,544 INFO QueryLogger:322 - [bind: 0.0, '2006-10-02 00:00:00.0', '2006-10-02 00:00:00.0', NULL, 427500.0, '2007-01-05 00:00:00.0', '2006-10-02 00:00:00.0', 427500.0, 'false', '2007-01-24 00:00:00.0', '18', 0.0, 'false', '2007-01-05 00:00:00.0', 'true', NULL, 'false', '2007-01-23 00:00:00.0', '2006-10-02 00:00:00.0', '2006-10-02 00:00:00.0', 'false', 'false', 22500.0, 'false', NULL, 'Close file credit note received', NULL, 'true', 'false', '2006-10-02 00:00:00.0']
    03:12:50,551 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,552 INFO QueryLogger:322 - [bind: 334080.0, '2007-04-16 00:00:00.0', '2007-04-16 00:00:00.0', '2007-04-16 00:00:00.0', 334080.0, NULL, '2007-04-16 00:00:00.0', 0.0, 'false', NULL, '83', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, '2007-04-16 00:00:00.0', '2007-04-16 00:00:00.0', 'false', 'false', 0.0, 'false', NULL, 'Awaiting discharge/clinical summary
    ', '2007-04-17 00:00:00.0', 'false', 'false', '2007-04-16 00:00:00.0']
    03:12:50,554 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,555 INFO QueryLogger:322 - [bind: 210000.0, '2007-04-18 00:00:00.0', '2007-04-20 00:00:00.0', NULL, 0.0, NULL, '2007-04-18 00:00:00.0', 0.0, 'false', NULL, '33', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, '2007-04-18 00:00:00.0', '2007-04-20 00:00:00.0', 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'false', 'false', '2007-04-20 00:00:00.0']
    03:12:50,556 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,557 INFO QueryLogger:322 - [bind: 0.0, '2007-05-02 00:00:00.0', '2007-05-02 00:00:00.0', NULL, 0.0, NULL, '2007-05-02 00:00:00.0', 0.0, 'false', NULL, '126', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, '2007-05-02 00:00:00.0', '2007-05-02 00:00:00.0', 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'false', 'false', '2007-05-02 00:00:00.0']
    03:12:50,613 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,614 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 0.0, NULL, NULL, 0.0, 'false', NULL, '119', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, 'Close file repair estimate below excess', NULL, 'true', 'false', NULL]
    03:12:50,616 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,618 INFO QueryLogger:322 - [bind: 0.0, '2006-11-30 00:00:00.0', '2006-12-01 00:00:00.0', NULL, 489120.0, '2007-02-19 00:00:00.0', '2006-11-30 00:00:00.0', 0.0, 'false', NULL, '68', 0.0, 'true', '2007-02-20 00:00:00.0', 'true', '2007-01-04 00:00:00.0', 'true', '2007-03-08 00:00:00.0', '2007-01-02 00:00:00.0', '2007-01-04 00:00:00.0', 'true', 'false', 0.0, 'false', NULL, 'Awaiting cheque', NULL, 'false', 'false', '2006-12-01 00:00:00.0']
    03:12:50,620 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,624 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 1049280.0, NULL, NULL, 0.0, 'false', NULL, '88', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'false', 'false', NULL]
    03:12:50,625 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,626 INFO QueryLogger:322 - [bind: 0.0, '2006-12-14 00:00:00.0', '2006-12-14 00:00:00.0', '2006-12-14 00:00:00.0', 650000.0, '2007-01-19 00:00:00.0', '2006-12-14 00:00:00.0', 650000.0, 'false', '2007-02-06 00:00:00.0', '5', 0.0, 'false', '2007-01-22 00:00:00.0', 'true', NULL, 'false', '2007-01-23 00:00:00.0', '2006-12-14 00:00:00.0', '2006-12-14 00:00:00.0', 'false', 'false', 0.0, 'false', 'N/A', 'Cheque received close file', '2006-12-14 00:00:00.0', 'true', 'false', '2006-12-14 00:00:00.0']
    03:12:50,636 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,637 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 792720.0, NULL, NULL, 0.0, 'false', NULL, '152', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'false', 'false', NULL]
    03:12:50,639 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,641 INFO QueryLogger:322 - [bind: 0.0, '2007-05-25 00:00:00.0', '2007-05-25 00:00:00.0', NULL, 0.0, NULL, '2007-05-25 00:00:00.0', 0.0, 'false', NULL, '167', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, '2007-05-25 00:00:00.0', '2007-05-25 00:00:00.0', 'false', 'false', 0.0, 'false', NULL, 'Close file', NULL, 'true', 'false', '2007-05-25 00:00:00.0']
    03:12:50,643 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,644 INFO QueryLogger:322 - [bind: 5500.0, '2007-05-22 00:00:00.0', '2007-05-23 00:00:00.0', NULL, 5500.0, NULL, '2007-05-22 00:00:00.0', 0.0, 'false', NULL, '166', 0.0, 'false', NULL, 'true', '2007-05-23 00:00:00.0', 'false', NULL, '2007-05-22 00:00:00.0', '2007-05-23 00:00:00.0', 'false', 'false', 0.0, 'false', NULL, 'Awaiting DV', NULL, 'false', 'false', '2007-05-23 00:00:00.0']
    03:12:50,645 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,646 INFO QueryLogger:322 - [bind: 6000.0, '2007-05-25 00:00:00.0', '2007-05-18 00:00:00.0', NULL, 6000.0, NULL, '2007-05-18 00:00:00.0', 0.0, 'false', NULL, '163', 0.0, 'false', NULL, 'true', '2007-05-18 00:00:00.0', 'false', NULL, '2007-05-18 00:00:00.0', '2007-05-18 00:00:00.0', 'false', 'false', 0.0, 'false', NULL, 'Awaiting cheque', NULL, 'false', 'false', '2007-05-18 00:00:00.0']
    03:12:50,647 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,649 INFO QueryLogger:322 - [bind: 0.0, '2006-06-30 00:00:00.0', '2006-06-30 00:00:00.0', NULL, 1078080.0, '2007-02-19 00:00:00.0', '2006-06-30 00:00:00.0', 0.0, 'false', NULL, '70', 0.0, 'true', '2007-02-21 00:00:00.0', 'true', '2007-01-04 00:00:00.0', 'true', '2007-03-08 00:00:00.0', '2007-01-02 00:00:00.0', '2007-01-04 00:00:00.0', 'true', 'false', 0.0, 'false', NULL, 'Awaiting cheque', NULL, 'false', 'false', '2006-06-30 00:00:00.0']
    03:12:50,651 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,652 INFO QueryLogger:322 - [bind: 0.0, '2007-04-13 00:00:00.0', '2007-04-13 00:00:00.0', NULL, 0.0, NULL, '2007-04-13 00:00:00.0', 0.0, 'false', NULL, '144', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 5000.0, 'false', NULL, 'Close file', NULL, 'true', 'false', '2007-04-13 00:00:00.0']
    03:12:50,654 INFO QueryLogger:368 - === updated 1 row.
    org.apache.cayenne.CayenneRuntimeException: [v.2.0.2 January 14 2007] Can't build a query for temporary id: <ObjectId:eBrokerClaimDetail, TEMP:00009286C39F0001>
            at org.apache.cayenne.query.ObjectIdQuery.createReplacementQuery(ObjectIdQuery.java:115)
            at org.apache.cayenne.query.IndirectQuery.getReplacementQuery(IndirectQuery.java:75)
            at org.apache.cayenne.query.IndirectQuery.route(IndirectQuery.java:58)
            at org.apache.cayenne.access.DataDomainQueryAction.runQuery(DataDomainQueryAction.java:292)
            at org.apache.cayenne.access.DataDomainQueryAction.access$000(DataDomainQueryAction.java:60)
            at org.apache.cayenne.access.DataDomainQueryAction$1.transform(DataDomainQueryAction.java:273)
            at org.apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:810)
            at org.apache.cayenne.access.DataDomainQueryAction.runQueryInTransaction(DataDomainQueryAction.java:270)
            at org.apache.cayenne.access.DataDomainQueryAction.interceptOIDQuery(DataDomainQueryAction.java:138)
            at org.apache.cayenne.access.DataDomainQueryAction.execute(DataDomainQueryAction.java:107)
            at org.apache.cayenne.access.DataDomain.onQuery(DataDomain.java:730)
            at org.apache.cayenne.access.ObjectStore.getSnapshot(ObjectStore.java:700)
            at org.apache.cayenne.access.DataContext.currentSnapshot(DataContext.java:623)
            at org.apache.cayenne.access.DataDomainSyncBucket.postprocess(DataDomainSyncBucket.java:166)
            at org.apache.cayenne.access.DataDomainFlushAction.postprocess(DataDomainFlushAction.java:235)
            at org.apache.cayenne.access.DataDomainFlushAction.flush(DataDomainFlushAction.java:142)
            at org.apache.cayenne.access.DataDomain.onSyncFlush(DataDomain.java:794)
            at org.apache.cayenne.access.DataDomain$2.transform(DataDomain.java:765)
            at org.apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:820)
            at org.apache.cayenne.access.DataDomain.onSync(DataDomain.java:762)
            at org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:1226)
            at org.apache.cayenne.access.DataContext.commitChanges(DataContext.java:1130)
            at com.unuts.transfer.DSTransferUI.targetViaCayenne(DSTransferUI.java:449)
            at com.unuts.transfer.DSTransferUI.cayenneTargetButtonActionPerformed(DSTransferUI.java:374)
            at com.unuts.transfer.DSTransferUI.access$300(DSTransferUI.java:24)
            at com.unuts.transfer.DSTransferUI$4.actionPerformed(DSTransferUI.java:289)
            at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
            at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
            at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
            at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
            at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
            at java.awt.Component.processMouseEvent(Component.java:6038)
            at javax.swing.JComponent.processMouseEvent(JComponent.java:3260)
            at java.awt.Component.processEvent(Component.java:5803)
            at java.awt.Container.processEvent(Container.java:2058)
            at java.awt.Component.dispatchEventImpl(Component.java:4410)
            at java.awt.Container.dispatchEventImpl(Container.java:2116)
            at java.awt.Component.dispatchEvent(Component.java:4240)
            at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
            at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
            at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
            at java.awt.Container.dispatchEventImpl(Container.java:2102)
            at java.awt.Window.dispatchEventImpl(Window.java:2429)
            at java.awt.Component.dispatchEvent(Component.java:4240)
            at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
            at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
            at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
            at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
            at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
            at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
            at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
    03:12:50,654 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 0.0, NULL, NULL, 0.0, 'false', NULL, '111', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'true', 'false', NULL]
    03:12:50,655 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,666 INFO QueryLogger:322 - [bind: 0.0, '2007-01-31 00:00:00.0', '2007-02-01 00:00:00.0', NULL, 9696.0, '2007-02-20 00:00:00.0', '2007-01-31 00:00:00.0', 9696.0, 'false', '2007-03-14 00:00:00.0', '35', 0.0, 'false', '2007-02-23 00:00:00.0', 'true', NULL, 'false', '2007-03-02 00:00:00.0', '2007-01-31 00:00:00.0', '2007-02-01 00:00:00.0', 'false', 'false', 0.0, 'false', NULL, 'Credit note received close file', NULL, 'true', 'false', '2007-02-01 00:00:00.0']
    03:12:50,667 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,668 INFO QueryLogger:322 - [bind: 0.0, '2006-10-25 00:00:00.0', '2006-10-25 00:00:00.0', '2006-12-19 00:00:00.0', 524135.0, '2006-10-19 00:00:00.0', '2006-10-25 00:00:00.0', 524135.0, 'false', '2007-01-19 00:00:00.0', '7', 0.0, 'false', '2006-12-21 00:00:00.0', 'true', NULL, 'false', '2006-12-22 00:00:00.0', '2006-10-25 00:00:00.0', '2006-10-25 00:00:00.0', 'false', 'false', 58237.0, 'false', NULL, 'Close file cheque received', '2006-12-19 00:00:00.0', 'true', 'false', '2006-10-25 00:00:00.0']
    03:12:50,670 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,671 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 294780.0, NULL, NULL, 0.0, 'false', NULL, '108', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'false', 'false', NULL]
    03:12:50,673 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,673 INFO QueryLogger:322 - [bind: 0.0, '2006-10-17 00:00:00.0', '2006-10-17 00:00:00.0', NULL, 479520.0, '2007-02-19 00:00:00.0', '2006-10-17 00:00:00.0', 0.0, 'false', NULL, '69', 0.0, 'true', '2007-02-21 00:00:00.0', 'true', '2007-01-04 00:00:00.0', 'true', '2007-03-08 00:00:00.0', '2007-01-02 00:00:00.0', '2007-01-04 00:00:00.0', 'true', 'false', 0.0, 'false', NULL, 'Awaiting cheque', NULL, 'false', 'false', '2006-10-17 00:00:00.0']
    03:12:50,675 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,675 INFO QueryLogger:322 - [bind: 294720.0, '2007-01-10 00:00:00.0', '2007-01-12 00:00:00.0', NULL, 294720.0, NULL, '2007-01-10 00:00:00.0', 0.0, 'false', NULL, '86', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, NULL, '2007-01-10 00:00:00.0', 'false', 'false', '2007-01-12 00:00:00.0']
    03:12:50,676 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,677 INFO QueryLogger:322 - [bind: 0.0, '2006-05-10 00:00:00.0', '2006-04-12 00:00:00.0', NULL, 0.0, NULL, '2006-05-10 00:00:00.0', 0.0, 'false', NULL, '138', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, 'Close file', NULL, 'true', 'false', '2006-05-12 00:00:00.0']
    03:12:50,678 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,679 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 215175.0, NULL, NULL, 0.0, 'false', NULL, '14', 0.0, 'true', '2006-09-09 00:00:00.0', 'true', '2006-03-30 00:00:00.0', 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, 'Close file for non responsive', NULL, 'true', 'false', NULL]
    03:12:50,681 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,681 INFO QueryLogger:322 - [bind: 395525.0, '2007-02-28 00:00:00.0', '2007-04-28 00:00:00.0', NULL, 0.0, '2007-03-14 00:00:00.0', '2007-02-28 00:00:00.0', 0.0, 'false', NULL, '24', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, '2007-02-28 00:00:00.0', '2007-02-28 00:00:00.0', 'false', 'false', 0.0, 'false', NULL, 'Close file liability denied', NULL, 'true', 'false', '2007-02-28 00:00:00.0']
    03:12:50,683 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,683 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 535200.0, NULL, NULL, 0.0, 'false', NULL, '80', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'false', 'false', NULL]
    03:12:50,685 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,686 INFO QueryLogger:322 - [bind: 0.0, '2007-02-23 00:00:00.0', '2007-02-23 00:00:00.0', NULL, 168205.0, '2007-03-06 00:00:00.0', '2007-02-23 00:00:00.0', 168205.0, 'false', '2007-03-28 00:00:00.0', '103', 0.0, 'false', '2007-03-07 00:00:00.0', 'true', NULL, 'false', '2007-03-13 00:00:00.0', '2007-02-23 00:00:00.0', '2007-02-23 00:00:00.0', 'false', 'false', 0.0, 'false', NULL, 'Cheque received close file', NULL, 'true', 'false', '2007-02-23 00:00:00.0']
    03:12:50,688 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,689 INFO QueryLogger:322 - [bind: 316800.0, '2006-11-23 00:00:00.0', '2006-11-24 00:00:00.0', NULL, 316800.0, '2007-02-19 00:00:00.0', '2006-11-23 00:00:00.0', 0.0, 'false', NULL, '72', 0.0, 'true', '2007-02-20 00:00:00.0', 'true', '2007-01-04 00:00:00.0', 'true', '2007-03-08 00:00:00.0', '2006-11-23 00:00:00.0', '2006-11-24 00:00:00.0', 'true', 'false', 0.0, 'false', NULL, 'Awaiting cheque', NULL, 'false', 'false', '2006-11-24 00:00:00.0']
    03:12:50,695 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,696 INFO QueryLogger:322 - [bind: 0.0, '2007-01-03 00:00:00.0', '2007-01-03 00:00:00.0', '2007-02-02 00:00:00.0', 278460.0, '2007-02-12 00:00:00.0', '2007-01-03 00:00:00.0', 0.0, 'false', NULL, '45', 0.0, 'true', '2007-02-16 00:00:00.0', 'true', '2007-01-03 00:00:00.0', 'true', '2007-02-19 00:00:00.0', '2007-01-03 00:00:00.0', '2007-01-03 00:00:00.0', 'false', 'true', 30940.0, 'false', NULL, 'Awaiting cheque', '2007-02-02 00:00:00.0', 'false', 'false', '2007-01-03 00:00:00.0']
    03:12:50,698 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,698 INFO QueryLogger:322 - [bind: 1017000.0, '2007-04-11 00:00:00.0', '2007-04-11 00:00:00.0', NULL, 0.0, NULL, '2007-04-11 00:00:00.0', 0.0, 'false', NULL, '61', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, '2007-04-11 00:00:00.0', '2007-04-11 00:00:00.0', 'false', 'false', 200000.0, 'false', NULL, 'Awaiting assessor''s report', NULL, 'false', 'false', '2007-04-11 00:00:00.0']
    03:12:50,714 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,715 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 731520.0, NULL, NULL, 0.0, 'false', NULL, '150', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'false', 'false', NULL]
    03:12:50,717 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,718 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 0.0, NULL, NULL, 0.0, 'false', NULL, '38', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', 'N/A', 'Close file repair cost below excess', NULL, 'true', 'false', NULL]
    03:12:50,719 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,720 INFO QueryLogger:322 - [bind: 0.0, '2007-04-23 00:00:00.0', '2007-04-24 00:00:00.0', NULL, 1135680.0, NULL, '2007-04-23 00:00:00.0', 0.0, 'false', NULL, '78', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, 'Awaiting clinical summary', NULL, 'false', 'false', '2007-04-24 00:00:00.0']
    03:12:50,724 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,725 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 0.0, NULL, NULL, 0.0, 'false', NULL, '165', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'true', 'false', NULL]
    03:12:50,726 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,726 INFO QueryLogger:322 - [bind: 0.0, '2007-04-27 00:00:00.0', '2007-04-27 00:00:00.0', NULL, 0.0, NULL, '2007-04-27 00:00:00.0', 0.0, 'false', NULL, '155', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, 'Close file', NULL, 'true', 'false', '2007-04-27 00:00:00.0']
    03:12:50,728 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,729 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 0.0, NULL, NULL, 0.0, 'false', NULL, '117', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, 'Awaiting documents', NULL, 'false', 'false', NULL]
    03:12:50,730 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,731 INFO QueryLogger:322 - [bind: 0.0, '2006-09-18 00:00:00.0', '2006-09-18 00:00:00.0', NULL, 540460.0, '2007-01-16 00:00:00.0', '2006-09-19 00:00:00.0', 540740.0, 'false', '2007-02-07 00:00:00.0', '12', 0.0, 'false', '2007-01-18 00:00:00.0', 'true', NULL, 'false', '2007-01-24 00:00:00.0', '2006-09-19 00:00:00.0', '2006-09-19 00:00:00.0', 'false', 'false', 28460.0, 'false', 'N/A', 'Cheque received close file', NULL, 'true', 'false', '2006-09-19 00:00:00.0']
    03:12:50,732 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,751 INFO QueryLogger:322 - [bind: 0.0, '2007-01-16 00:00:00.0', '2007-01-17 00:00:00.0', NULL, 113328.0, NULL, '2007-01-16 00:00:00.0', 0.0, 'false', NULL, '25', 0.0, 'true', '2007-04-02 00:00:00.0', 'true', '2007-01-17 00:00:00.0', 'true', '2007-04-04 00:00:00.0', NULL, NULL, 'false', 'true', 0.0, 'false', NULL, 'Awaiting credit note', NULL, 'false', 'false', '2007-01-17 00:00:00.0']
    03:12:50,752 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,753 INFO QueryLogger:322 - [bind: 20000.0, '2007-02-17 00:00:00.0', '2007-02-17 00:00:00.0', NULL, 30000.0, NULL, '2007-02-17 00:00:00.0', 0.0, 'false', NULL, '55', 0.0, 'true', '2007-05-22 00:00:00.0', 'true', '2007-02-16 00:00:00.0', 'false', NULL, '2007-02-17 00:00:00.0', '2007-02-17 00:00:00.0', 'false', 'false', 10000.0, 'false', NULL, NULL, NULL, 'false', 'false', '2007-02-17 00:00:00.0']
    03:12:50,754 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,754 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 294720.0, NULL, NULL, 0.0, 'false', NULL, '130', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'false', 'false', NULL]
    03:12:50,755 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,756 INFO QueryLogger:322 - [bind: 267862.0, '2007-01-30 00:00:00.0', '2007-01-31 00:00:00.0', NULL, 267862.0, NULL, '2007-01-30 00:00:00.0', 0.0, 'false', NULL, '23', 0.0, 'false', NULL, 'true', '2007-01-31 00:00:00.0', 'false', NULL, NULL, NULL, 'false', 'false', 5500.0, 'false', NULL, NULL, NULL, 'false', 'false', '2007-01-31 00:00:00.0']
    03:12:50,757 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,758 INFO QueryLogger:322 - [bind: 322560.0, '2007-02-07 00:00:00.0', '2007-02-08 00:00:00.0', '2007-02-07 00:00:00.0', 322560.0, '2007-04-10 00:00:00.0', '2007-02-07 00:00:00.0', 0.0, 'false', NULL, '77', 0.0, 'true', '2007-04-12 00:00:00.0', 'true', '2007-02-08 00:00:00.0', 'true', '2007-04-30 00:00:00.0', '2007-02-07 00:00:00.0', '2007-02-07 00:00:00.0', 'true', 'false', 0.0, 'false', NULL, 'Awaiting cheque', '2007-02-07 00:00:00.0', 'false', 'false', '2007-02-08 00:00:00.0']
    03:12:50,761 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,762 INFO QueryLogger:322 - [bind: 7000.0, '2007-04-27 00:00:00.0', '2007-04-27 00:00:00.0', NULL, 7000.0, NULL, '2007-04-27 00:00:00.0', 0.0, 'false', NULL, '154', 0.0, 'true', '2007-05-17 00:00:00.0', 'true', '2007-04-27 00:00:00.0', 'false', NULL, '2007-04-27 00:00:00.0', '2007-04-26 00:00:00.0', 'false', 'false', 0.0, 'false', NULL, 'Awaiting dv', NULL, 'false', 'false', '2007-04-27 00:00:00.0']
    03:12:50,764 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,765 INFO QueryLogger:322 - [bind: 0.0, '2007-04-04 00:00:00.0', '2007-04-04 00:00:00.0', NULL, 1590.0, NULL, '2007-04-04 00:00:00.0', 0.0, 'false', NULL, '139', 0.0, 'true', '2007-05-19 00:00:00.0', 'true', '2007-04-04 00:00:00.0', 'false', NULL, '2007-04-04 00:00:00.0', '2007-04-04 00:00:00.0', 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'false', 'false', '2007-04-04 00:00:00.0']
    03:12:50,766 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,767 INFO QueryLogger:322 - [bind: 0.0, '2007-02-07 00:00:00.0', '2007-02-08 00:00:00.0', NULL, 1135680.0, NULL, '2007-02-07 00:00:00.0', 0.0, 'false', NULL, '85', 0.0, 'false', NULL, 'true', '2007-05-14 00:00:00.0', 'false', NULL, '2007-05-14 00:00:00.0', '2007-05-14 00:00:00.0', 'false', 'false', 0.0, 'false', NULL, 'Awaiting DV', NULL, 'false', 'false', '2007-02-08 00:00:00.0']
    03:12:50,770 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,771 INFO QueryLogger:322 - [bind: 500640.0, '2007-03-29 00:00:00.0', '2007-03-29 00:00:00.0', NULL, 500640.0, NULL, '2007-03-29 00:00:00.0', 0.0, 'false', NULL, '94', 0.0, 'false', NULL, 'true', '2007-03-29 00:00:00.0', 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'false', 'false', '2007-03-29 00:00:00.0']
    03:12:50,772 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,772 INFO QueryLogger:322 - [bind: 26680.0, '2007-02-27 00:00:00.0', '2007-02-27 00:00:00.0', NULL, 26680.0, NULL, '2007-02-27 00:00:00.0', 0.0, 'false', NULL, '51', 0.0, 'false', NULL, 'true', '2007-04-20 00:00:00.0', 'false', NULL, '2007-02-27 00:00:00.0', '2007-02-27 00:00:00.0', 'false', 'false', 10000.0, 'true', NULL, 'Close file', NULL, 'true', 'false', '2007-02-27 00:00:00.0']
    03:12:50,774 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,774 INFO QueryLogger:322 - [bind: 0.0, '2006-03-17 00:00:00.0', '2006-03-20 00:00:00.0', NULL, 1135680.0, '2007-02-20 00:00:00.0', '2006-03-17 00:00:00.0', 0.0, 'false', NULL, '66', 0.0, 'true', '2007-02-20 00:00:00.0', 'true', '2007-01-04 00:00:00.0', 'true', '2007-03-08 00:00:00.0', '2007-01-02 00:00:00.0', '2007-01-04 00:00:00.0', 'true', 'false', 0.0, 'false', NULL, 'Awaiting cheque', NULL, 'false', 'false', '2006-03-20 00:00:00.0']
    03:12:50,775 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,777 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 294720.0, NULL, NULL, 0.0, 'false', NULL, '109', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'false', 'false', NULL]
    03:12:50,778 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,779 INFO QueryLogger:322 - [bind: 0.0, '2007-01-25 00:00:00.0', '2007-01-25 00:00:00.0', NULL, 170500.0, '2007-02-01 00:00:00.0', '2007-01-25 00:00:00.0', 170500.0, 'false', '2007-03-02 00:00:00.0', '10', 0.0, 'false', '2007-02-01 00:00:00.0', 'true', NULL, 'false', '2007-02-01 00:00:00.0', '2007-01-25 00:00:00.0', '2007-01-25 00:00:00.0', 'false', 'false', 50000.0, 'false', NULL, 'Credit note received close file', NULL, 'true', 'false', '2007-01-25 00:00:00.0']
    03:12:50,780 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,781 INFO QueryLogger:322 - [bind: 7500.0, '2007-04-18 00:00:00.0', '2007-04-19 00:00:00.0', NULL, 7500.0, '2007-04-27 00:00:00.0', '2007-04-18 00:00:00.0', 7500.0, 'true', '2007-05-07 00:00:00.0', '149', 0.0, 'true', '2007-04-24 00:00:00.0', 'true', '2007-04-19 00:00:00.0', 'true', '2007-04-25 00:00:00.0', '2007-04-18 00:00:00.0', '2007-04-19 00:00:00.0', 'true', 'false', 0.0, 'false', NULL, 'Cheque received close file', NULL, 'true', 'false', '2007-04-19 00:00:00.0']
    03:12:50,782 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,783 INFO QueryLogger:322 - [bind: 948482.0, '2006-09-21 00:00:00.0', '2006-09-21 00:00:00.0', NULL, 948480.0, '2007-02-19 00:00:00.0', '2006-09-21 00:00:00.0', 0.0, 'false', '2006-09-21 00:00:00.0', '74', 0.0, 'true', '2007-03-28 00:00:00.0', 'true', '2007-01-04 00:00:00.0', 'true', '2007-03-07 00:00:00.0', '2007-01-02 00:00:00.0', '2007-01-04 00:00:00.0', 'true', 'false', 0.0, 'false', NULL, 'Awaiting cheque', NULL, 'false', 'false', '2006-09-21 00:00:00.0']
    03:12:50,784 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,785 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 0.0, NULL, '2007-03-30 00:00:00.0', 0.0, 'false', NULL, '106', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, 'Close file no TP vehicle', NULL, 'true', 'false', '2007-03-30 00:00:00.0']
    03:12:50,785 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,786 INFO QueryLogger:322 - [bind: 0.0, '2006-10-18 00:00:00.0', '2006-10-18 00:00:00.0', NULL, 0.0, NULL, '2006-10-18 00:00:00.0', 0.0, 'false', NULL, '63', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, '2006-10-18 00:00:00.0', '2006-10-18 00:00:00.0', 'false', 'false', 0.0, 'false', NULL, 'Awaitng assessor''s report', NULL, 'false', 'false', '2006-10-18 00:00:00.0']
    03:12:50,787 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,789 INFO QueryLogger:322 - [bind: 320000.0, '2006-01-28 00:00:00.0', '2007-01-29 00:00:00.0', NULL, 80000.0, NULL, '2006-01-28 00:00:00.0', 0.0, 'false', NULL, '146', 0.0, 'true', '2006-11-06 00:00:00.0', 'true', '2006-01-30 00:00:00.0', 'false', NULL, '2006-01-28 00:00:00.0', '2006-01-30 00:00:00.0', 'false', 'false', 20000.0, 'false', NULL, 'Awaiting credit note', NULL, 'false', 'false', '2006-01-30 00:00:00.0']
    03:12:50,791 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,799 INFO QueryLogger:322 - [bind: 0.0, '2007-04-16 00:00:00.0', '2007-04-16 00:00:00.0', NULL, 0.0, NULL, '2007-04-16 00:00:00.0', 0.0, 'false', NULL, '127', 0.0, 'false', NULL, 'true', '2007-04-12 00:00:00.0', 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, 'Close file', NULL, 'true', 'false', '2007-04-16 00:00:00.0']
    03:12:50,800 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,801 INFO QueryLogger:322 - [bind: 0.0, '2006-06-12 00:00:00.0', '2006-06-12 00:00:00.0', '2007-02-02 00:00:00.0', 264786.0, '2007-02-09 00:00:00.0', '2006-07-12 00:00:00.0', 0.0, 'false', NULL, '32', 0.0, 'true', '2007-02-20 00:00:00.0', 'true', '2006-07-12 00:00:00.0', 'true', '2007-02-20 00:00:00.0', '2006-06-12 00:00:00.0', '2006-07-12 00:00:00.0', 'false', 'true', 29421.0, 'false', NULL, 'Awaiting credit note', '2007-02-01 00:00:00.0', 'false', 'false', '2006-07-12 00:00:00.0']
    03:12:50,802 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,803 INFO QueryLogger:322 - [bind: 0.0, '2006-07-20 00:00:00.0', '2006-07-20 00:00:00.0', NULL, 290880.0, NULL, '2006-07-20 00:00:00.0', 0.0, 'false', NULL, '92', 0.0, 'false', NULL, 'true', '2007-02-08 00:00:00.0', 'false', NULL, '2007-02-07 00:00:00.0', '2007-02-08 00:00:00.0', 'false', 'false', 0.0, 'false', NULL, 'Awaiting DV', NULL, 'false', 'false', '2006-07-20 00:00:00.0']
    03:12:50,804 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,805 INFO QueryLogger:322 - [bind: 0.0, '2006-09-29 00:00:00.0', '2006-09-29 00:00:00.0', NULL, 54264.0, '2007-01-05 00:00:00.0', '2006-10-02 00:00:00.0', 54264.0, 'false', '2007-01-25 00:00:00.0', '17', 0.0, 'false', '2007-01-08 00:00:00.0', 'true', NULL, 'false', '2007-01-23 00:00:00.0', '2006-10-02 00:00:00.0', '2006-10-02 00:00:00.0', 'false', 'false', 15000.0, 'false', NULL, 'Close file credit note received', NULL, 'true', 'false', '2006-10-02 00:00:00.0']
    03:12:50,806 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,806 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 0.0, NULL, NULL, 0.0, 'false', NULL, '115', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'false', 'false', NULL]
    03:12:50,808 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,809 INFO QueryLogger:322 - [bind: 0.0, '2006-08-21 00:00:00.0', '2006-08-24 00:00:00.0', NULL, 171540.0, '2006-11-10 00:00:00.0', '2006-08-21 00:00:00.0', 171540.0, 'false', '2006-12-06 00:00:00.0', '58', 0.0, 'false', '2006-11-13 00:00:00.0', 'true', NULL, 'false', '2006-11-15 00:00:00.0', '2006-08-21 00:00:00.0', '2006-08-24 00:00:00.0', 'false', 'false', 0.0, 'false', NULL, 'Close file cheque sent to client', NULL, 'true', 'false', '2006-08-24 00:00:00.0']
    03:12:50,846 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,847 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 0.0, NULL, NULL, 0.0, 'false', NULL, '42', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'true', 'false', NULL]
    03:12:50,848 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,848 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 386700.0, '2007-01-22 00:00:00.0', NULL, 386700.0, 'false', '2007-01-31 00:00:00.0', '19', 0.0, 'false', '2007-01-23 00:00:00.0', 'true', NULL, 'false', '2007-01-25 00:00:00.0', NULL, NULL, 'false', 'false', 0.0, 'false', NULL, 'Credit note received', NULL, 'true', 'false', NULL]
    03:12:50,849 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,850 INFO QueryLogger:322 - [bind: 80000.0, '2007-03-08 00:00:00.0', '2007-03-09 00:00:00.0', NULL, 70000.0, NULL, '2007-03-08 00:00:00.0', 0.0, 'false', NULL, '56', 0.0, 'true', '2007-05-22 00:00:00.0', 'true', '2007-03-09 00:00:00.0', 'false', NULL, '2007-03-08 00:00:00.0', '2007-03-09 00:00:00.0', 'false', 'false', 10000.0, 'false', NULL, 'Awaiting credit note', NULL, 'false', 'false', '2007-03-09 00:00:00.0']
    03:12:50,851 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,852 INFO QueryLogger:322 - [bind: 4666323.0, NULL, NULL, NULL, 4666323.0, '2007-02-12 00:00:00.0', NULL, 4666323.0, 'true', '2007-04-27 00:00:00.0', '47', 0.0, 'true', '2007-04-23 00:00:00.0', 'true', '2007-04-02 00:00:00.0', 'true', '2007-04-23 00:00:00.0', NULL, NULL, 'true', 'false', 0.0, 'false', NULL, 'Cheque received. Close file', NULL, 'true', 'false', NULL]
    03:12:50,853 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,855 INFO QueryLogger:322 - [bind: 0.0, '2007-02-06 00:00:00.0', '2007-02-06 00:00:00.0', NULL, 26500.0, '2007-02-27 00:00:00.0', '2007-02-06 00:00:00.0', 26500.0, 'false', '2007-03-14 00:00:00.0', '99', 0.0, 'false', '2007-03-23 00:00:00.0', 'true', NULL, 'false', '2007-02-27 00:00:00.0', '2007-02-27 00:00:00.0', '2007-02-27 00:00:00.0', 'false', 'false', 0.0, 'false', NULL, 'Credit note received close file', NULL, 'true', 'false', '2007-02-06 00:00:00.0']
    03:12:50,856 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,857 INFO QueryLogger:322 - [bind: 0.0, '2006-08-02 00:00:00.0', '2006-08-02 00:00:00.0', NULL, 1135680.0, '2007-02-19 00:00:00.0', '2005-12-21 00:00:00.0', 0.0, 'false', NULL, '67', 0.0, 'true', '2007-02-21 00:00:00.0', 'true', '2006-08-02 00:00:00.0', 'true', '2007-03-08 00:00:00.0', '2007-01-02 00:00:00.0', '2007-01-04 00:00:00.0', 'true', 'false', 0.0, 'false', NULL, 'Awaitng cheque', NULL, 'false', 'false', '2005-12-21 00:00:00.0']
    03:12:50,858 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,859 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 0.0, NULL, NULL, 0.0, 'false', NULL, '104', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'false', 'false', NULL]
    03:12:50,866 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,866 INFO QueryLogger:322 - [bind: 380418.0, '2007-05-10 00:00:00.0', '2007-05-11 00:00:00.0', NULL, 0.0, NULL, '2007-05-10 00:00:00.0', 0.0, 'false', NULL, '34', 0.0, 'false', NULL, 'true', '2007-05-11 00:00:00.0', 'false', NULL, '2007-05-10 00:00:00.0', '2007-05-11 00:00:00.0', 'false', 'false', 0.0, 'false', NULL, 'Awaiting DV', NULL, 'false', 'false', '2007-05-11 00:00:00.0']
    03:12:50,868 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,868 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 0.0, NULL, NULL, 0.0, 'false', NULL, '158', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 2000.0, 'false', NULL, 'Awaiting documents', NULL, 'false', 'false', NULL]
    03:12:50,871 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,872 INFO QueryLogger:322 - [bind: 0.0, '2006-04-20 00:00:00.0', '2006-04-20 00:00:00.0', '2007-02-05 00:00:00.0', 414262.0, '2007-02-09 00:00:00.0', '2006-04-20 00:00:00.0', 414242.0, 'true', '2007-04-11 00:00:00.0', '21', 0.0, 'true', '2007-02-09 00:00:00.0', 'true', '2007-02-02 00:00:00.0', 'true', '2007-02-14 00:00:00.0', '2007-02-02 00:00:00.0', '2007-02-02 00:00:00.0', 'true', 'false', 46027.0, 'false', 'n/a', 'Cheque received. close file', '2007-02-02 00:00:00.0', 'true', 'false', '2006-02-20 00:00:00.0']
    03:12:50,873 INFO QueryLogger:368 - === updated 1 row.
    03:12:50,874 INFO QueryLogger:322 - [bind: 0.0, NULL, NULL, NULL, 1135680.0, NULL, NULL, 0.0, 'false', NULL, '96', 0.0, 'false', NULL, 'false', NULL, 'false', NULL, NULL, NULL, 'false', 'false', 0.0, 'false', NULL, NULL, NULL, 'false', 'false', NULL]
    03:12:50,875 INFO QueryLogger:368 - === updated 1 row.

    That gets rid of the null id(s). which is alright.
    Now what am i to do with the cayenne exception Can't build a query for temporary id: <ObjectId:eBrokerClaimDetail, TEMP:00009286C39F0001>
    I already have the id from the master ObjEntity.
    Is there a way to disable the temporarity issue here? Just want the DEPENDENT ObjEntity transfered.
    What am i missing?. Don know what to try. Can some one help please?

    -- 
    This message is automatically generated by JIRA.
    -
    You can reply to this email to add a comment to the issue online.
    



    This archive was generated by hypermail 2.0.0 : Wed Jun 06 2007 - 20:04:54 EDT