One to One relationship: Transfering ObjEntity from one DataConetx to Another

• Previous message: Andrus Adamchik: "Re: SQLTemplate not faulting an object"
• Next in thread: urugn urugn: "One to One relationship: Transfering ObjEntity from one DataConetx to Another"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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?

       
____________________________________________________________________________________
Sick sense of humor? Visit Yahoo! TV's
Comedy with an Edge to see what's on, when.
http://tv.yahoo.com/collections/222

• Next message: urugn urugn: "One to One relationship: Transfering ObjEntity from one DataConetx to Another"
• Previous message: Andrus Adamchik: "Re: SQLTemplate not faulting an object"
• Next in thread: urugn urugn: "One to One relationship: Transfering ObjEntity from one DataConetx to Another"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Fri Jun 08 2007 - 17:44:25 EDT