I rolled back to 0.9.7 and the problem has disappeared. Should I add this as a bug? Anyone else experiencing a similar problem?
Corey -----Original Message----- From: Corey Klaasmeyer [mailto:[EMAIL PROTECTED]] Sent: Friday, November 15, 2002 7:29 AM To: 'OJB Users List' Subject: RE: Antwort: [Client/Server Hangs:java.io.EOFException] v0.9.8 Hi Jurgen, Your problem sounds similar. In fact, I applied your patch but it didn't seem to solve my problem. I suspect that the error I'm seeing is related to management of ConnectionHandlers. I will probably roll back to 0.9.7. Maybe I can isolate the problem is this way. Corey -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 14, 2002 11:15 PM To: OJB Users List Subject: Antwort: [Client/Server Hangs:java.io.EOFException] v0.9.8 hi! i'm not really sure, but i think i had a similar problem. when inserting (or querying) a small number of objects, i have no problem. with more objects, the server crashed (using PBServlet). i found, that the PB's in the BrokerPool were closed, and so they were unusable (but they were used, so the crash). i implemented a mechanism, that checks (on getFreeBrokerId or so), if the broker is usable, and replaces the old PB with a new one in the code. i'm not sure, if my code will be applied to ojb, but it works for me for about 2 or 3 weeks now. you can look my elder postings or ask for the patch. HTH, juergen Any debugging suggestions or, better yet, solutions are welcome... I'm storing an array of objects in a database and the process hangs on the same element for the same data consistently. It behaves in the same way for all data sets regardless of the data. It usually hangs around the 9th, 10th, or 11th element. It DOES NOT hang if any given loop terminates before storing this many objects. Also, it DOES NOT hang if I allocate 20 instead of 10 threads. Unfortunately, this makes the server VM crash hard with: "Unexpected Signal : EXCEPTION_FLT_STACK_CHECK". It always deadlocks on a close(32) request. I believe that I've narrowed it down to PersistentBrokerServer:run() line 205 where it waits on the processors, but I'm fairly certain that this all points to a ConnectionHandlers not be returned to the processors Vector. Check the Thread dump at the end of the log below. The problem is probably related to this Exception which happens on the initial connection to the server: [org.apache.ojb.broker.server.ConnectionHandler] ERROR: null [org.apache.ojb.broker.server.ConnectionHandler] ERROR: null [org.apache.ojb.broker.server.ConnectionHandler] ERROR: null java.io.EOFException at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.java:2 165) at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStream.j ava:2634) at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:734) at java.io.ObjectInputStream.<init>(ObjectInputStream.java:253) at org.apache.ojb.broker.server.BetterObjectInputStream.<init>(BetterObjectInpu tStream.java:74) at org.apache.ojb.broker.server.ConnectionHandler.getRequestFromSocket(Connecti onHandler.java:210) at org.apache.ojb.broker.server.ConnectionHandler.run(ConnectionHandler.java:12 5) at java.lang.Thread.run(Thread.java:536) Client Log query = Query from class com.klaasmeyer.forefront.om.ec.Machine where org.apache.ojb.broker.query.Criteria@1b9ce4b [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(6, -1, Query from class com.klaasmeyer.forefront.om.ec.Machine where org.apache.ojb.broker.query.Criteria@1b9ce4b, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(6, -1, org.apache.ojb.broker.PBKey: repository=repository.xml, user=null, password=null, Query from class com.klaasmeyer.forefront.om.ec.Machine where org.apache.ojb.broker.query.Criteria@1b9ce4b, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: look up com.klaasmeyer.forefront.om.ec.EquipmentTransaction [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(19, -1, class com.klaasmeyer.forefront.om.ec.EquipmentTransaction, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(19, -1, org.apache.ojb.broker.PBKey: repository=repository.xml, user=null, password=null, class com.klaasmeyer.forefront.om.ec.EquipmentTransaction, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, org.apache.ojb.broker.PBKey: repository=repository.xml, user=null, password=null, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(11, -1, com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[EC,ET20021114,Tue Oct 29 00:00:00 CST 2002,0012,103730119917449,0012,G2,3,1,FU,98.4,1.5177845528455283,149.35,6030 ,6400,KCC,KCC,8121-1 72023 GRIFFIN], null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(11, -1, org.apache.ojb.broker.PBKey: repository=repository.xml, user=null, password=null, com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[EC,ET20021114,Tue Oct 29 00:00:00 CST 2002,0012,103730119917449,0012,G2,3,1,FU,98.4,1.5177845528455283,149.35,6030 ,6400,KCC,KCC,8121-1 72023 GRIFFIN], null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, org.apache.ojb.broker.PBKey: repository=repository.xml, user=null, password=null, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, org.apache.ojb.broker.PBKey: repository=repository.xml, user=null, password=null, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(11, -1, com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[EC,ET20021114,Fri Nov 01 00:00:00 CST 2002,1314,103730119925413,1314,G2,3,1,FU,5.597,1.35,7.55,6030,6400,KCC,KCC,8 053-1 72032 GRAY], null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(11, -1, org.apache.ojb.broker.PBKey: repository=repository.xml, user=null, password=null, com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[EC,ET20021114,Fri Nov 01 00:00:00 CST 2002,1314,103730119925413,1314,G2,3,1,FU,5.597,1.35,7.55,6030,6400,KCC,KCC,8 053-1 72032 GRAY], null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, org.apache.ojb.broker.PBKey: repository=repository.xml, user=null, password=null, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, org.apache.ojb.broker.PBKey: repository=repository.xml, user=null, password=null, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(11, -1, com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[EC,ET20021114,Thu Oct 31 00:00:00 CST 2002,1468,103730119922473,1468,G2,3,1,FU,7.86,1.4,11.0,6030,6400,KCC,KCC,806 4-1 786364313 BUNTING], null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(11, -1, org.apache.ojb.broker.PBKey: repository=repository.xml, user=null, password=null, com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[EC,ET20021114,Thu Oct 31 00:00:00 CST 2002,1468,103730119922473,1468,G2,3,1,FU,7.86,1.4,11.0,6030,6400,KCC,KCC,806 4-1 786364313 BUNTING], null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, org.apache.ojb.broker.PBKey: repository=repository.xml, user=null, password=null, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, org.apache.ojb.broker.PBKey: repository=repository.xml, user=null, password=null, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(11, -1, com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[EC,ET20021114,Tue Oct 29 00:00:00 CST 2002,1739,103730119905411,1739,G2,3,1,FU,18.7,1.43,26.72,6030,6400,KCC,KCC,0 188-6 770984104 KLAASMEYER], null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(11, -1, org.apache.ojb.broker.PBKey: repository=repository.xml, user=null, password=null, com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[EC,ET20021114,Tue Oct 29 00:00:00 CST 2002,1739,103730119905411,1739,G2,3,1,FU,18.7,1.43,26.72,6030,6400,KCC,KCC,0 188-6 770984104 KLAASMEYER], null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, org.apache.ojb.broker.PBKey: repository=repository.xml, user=null, password=null, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, org.apache.ojb.broker.PBKey: repository=repository.xml, user=null, password=null, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(11, -1, com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[EC,ET20021114,Tue Oct 29 00:00:00 CST 2002,1743,103730119905412,1743,G3,3,1,FU,18.02,1.6,28.81,6030,6400,KCC,KCC,0 134-1 720325929 KLAASMEYER], null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(11, -1, org.apache.ojb.broker.PBKey: repository=repository.xml, user=null, password=null, com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[EC,ET20021114,Tue Oct 29 00:00:00 CST 2002,1743,103730119905412,1743,G3,3,1,FU,18.02,1.6,28.81,6030,6400,KCC,KCC,0 134-1 720325929 KLAASMEYER], null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, org.apache.ojb.broker.PBKey: repository=repository.xml, user=null, password=null, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, org.apache.ojb.broker.PBKey: repository=repository.xml, user=null, password=null, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(11, -1, com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[EC,ET20021114,Tue Oct 29 00:00:00 CST 2002,1759,103730119905413,1759,D1,3,1,FU,35.012,1.454929738375414,50.94,6030 ,6400,KCC,KCC,8112-1 720230000 JONES], null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(11, -1, org.apache.ojb.broker.PBKey: repository=repository.xml, user=null, password=null, com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[EC,ET20021114,Tue Oct 29 00:00:00 CST 2002,1759,103730119905413,1759,D1,3,1,FU,35.012,1.454929738375414,50.94,6030 ,6400,KCC,KCC,8112-1 720230000 JONES], null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, org.apache.ojb.broker.PBKey: repository=repository.xml, user=null, password=null, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, org.apache.ojb.broker.PBKey: repository=repository.xml, user=null, password=null, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(11, -1, com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[EC,ET20021114,Tue Oct 29 00:00:00 CST 2002,2606,103730119905415,2606,D2,3,1,FU,163.879,1.43904954265037,235.829999 99999998,6030,6400,KCC,KCC,0149-2 72131 JOHNSTON], null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(11, -1, org.apache.ojb.broker.PBKey: repository=repository.xml, user=null, password=null, com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[EC,ET20021114,Tue Oct 29 00:00:00 CST 2002,2606,103730119905415,2606,D2,3,1,FU,163.879,1.43904954265037,235.829999 99999998,6030,6400,KCC,KCC,0149-2 72131 JOHNSTON], null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, org.apache.ojb.broker.PBKey: repository=repository.xml, user=null, password=null, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, org.apache.ojb.broker.PBKey: repository=repository.xml, user=null, password=null, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(11, -1, com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[EC,ET20021114,Wed Oct 30 00:00:00 CST 2002,2610,103730119917450,2610,D1,3,1,FU,374.466,1.474820143884892,552.27,60 30,6400,KCC,KCC,8086-1 769500000 DIXON], null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(11, -1, org.apache.ojb.broker.PBKey: repository=repository.xml, user=null, password=null, com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[EC,ET20021114,Wed Oct 30 00:00:00 CST 2002,2610,103730119917450,2610,D1,3,1,FU,374.466,1.474820143884892,552.27,60 30,6400,KCC,KCC,8086-1 769500000 DIXON], null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, org.apache.ojb.broker.PBKey: repository=repository.xml, user=null, password=null, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, org.apache.ojb.broker.PBKey: repository=repository.xml, user=null, password=null, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(11, -1, com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[EC,ET20021114,Tue Oct 29 00:00:00 CST 2002,2716,103730119905416,2716,G2,3,1,FU,76.27,1.4932476727415762,113.890000 00000001,6030,6400,KCC,KCC,8105-2 76936 PALMER], null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(11, -1, org.apache.ojb.broker.PBKey: repository=repository.xml, user=null, password=null, com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[EC,ET20021114,Tue Oct 29 00:00:00 CST 2002,2716,103730119905416,2716,G2,3,1,FU,76.27,1.4932476727415762,113.890000 00000001,6030,6400,KCC,KCC,8105-2 76936 PALMER], null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, org.apache.ojb.broker.PBKey: repository=repository.xml, user=null, password=null, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, org.apache.ojb.broker.PBKey: repository=repository.xml, user=null, password=null, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(11, -1, com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[EC,ET20021114,Tue Oct 29 00:00:00 CST 2002,2734,103730119906417,2734,G2,3,1,FU,57.447,1.4495099831148712,83.270000 00000001,6030,6400,KCC,KCC,0034-1 727017148 SHORTS], null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(11, -1, org.apache.ojb.broker.PBKey: repository=repository.xml, user=null, password=null, com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[EC,ET20021114,Tue Oct 29 00:00:00 CST 2002,2734,103730119906417,2734,G2,3,1,FU,57.447,1.4495099831148712,83.270000 00000001,6030,6400,KCC,KCC,0034-1 727017148 SHORTS], null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, org.apache.ojb.broker.PBKey: repository=repository.xml, user=null, password=null, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, null, null, null) [org.apache.ojb.broker.server.PersistenceBrokerClient] DEBUG: callServer(32, -1, org.apache.ojb.broker.PBKey: repository=repository.xml, user=null, password=null, null, null, null) Server Log + ThreadDump /_/ PersistenceBrokerServer starting... [DEFAULT] INFO: OJB Descriptor Repository: file:/D:/Public/jakarta-ojb/repository.xml [DEFAULT] INFO: ...Finished parsing [org.apache.ojb.broker.util.sequence.SequenceManagerFactory] INFO: Use sequence manager class: class com.klaasmeyer.ojb.sequence.ZeroPaddedJobCostSequenceManagerImpl [DEFAULT] INFO: OJB Descriptor Repository: file:/D:/Public/jakarta-ojb/repositoryPostgreSQL.xml [DEFAULT] INFO: ...Finished parsing [org.apache.ojb.broker.server.ConnectionHandler] ERROR: null [org.apache.ojb.broker.server.ConnectionHandler] ERROR: null [org.apache.ojb.broker.server.ConnectionHandler] ERROR: null java.io.EOFException at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.java:2 165) at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStream.j ava:2634) at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:734) at java.io.ObjectInputStream.<init>(ObjectInputStream.java:253) at org.apache.ojb.broker.server.BetterObjectInputStream.<init>(BetterObjectInpu tStream.java:74) at org.apache.ojb.broker.server.ConnectionHandler.getRequestFromSocket(Connecti onHandler.java:210) at org.apache.ojb.broker.server.ConnectionHandler.run(ConnectionHandler.java:12 5) at java.lang.Thread.run(Thread.java:536) [org.apache.ojb.broker.server.RequestProcessor] DEBUG: dispatching [6,-1,repository.xml,Query from class com.klaasmeyer.forefront.om.ec.Machine where org.apache.ojb.broker.query.Criteria@11a64ed,null,null] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: looking up BrokerPool for repository.xml [org.apache.ojb.broker.server.RequestProcessor] DEBUG: in map: {repositoryPostgreSQL.xml=org.apache.ojb.broker.server.BrokerPool@8bdcd2, repository.xml=org.apache.ojb.broker.server.BrokerPool@4e79f1} [org.apache.ojb.broker.server.BrokerPool] DEBUG: getBrokerById: 0 [org.apache.ojb.broker.singlevm.PersistenceBrokerImpl] DEBUG: --# Criteria element [onRoad = 1] class org.apache.ojb.broker.query.EqualToCriteria [org.apache.ojb.broker.accesslayer.JdbcAccess] DEBUG: executeQuery : Query from class com.klaasmeyer.forefront.om.ec.Machine where org.apache.ojb.broker.query.Criteria@11a64ed [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL: SELECT A0.Equipment_Make,A0.Year,A0.Equipment_Code,A0.Yard_Code,A0.Description,A0.E quipment_Model,A0.On_Road_Code,A0.Last_Job,A0.Equipment_Type FROM EC_EQUIPMENT_MASTER A0 WHERE A0.On_Road_Code = ? [org.apache.ojb.broker.accesslayer.AbstractPoolableConnectionFactory] INFO: # Create connection pool for JdbcDescriptorKey 1204462713 # 1037301204990|-1||debug||Building driver stack 1037301204990|-1||debug||Creating all modules array 1037301204990|-1||debug||Pushing realdriver on stack: sun.jdbc.odbc.JdbcOdbcDriver 1037301205000|-1||debug||Pushing module on stack: org.sourceforge.jxdbcon.onion.LayerSpyDriver 1037301205000|-1||debug||Pushing module on stack: com.p6spy.engine.logging.P6LogSpyDriver 1037301205000|-1||debug||Driver stack size: 3 1037301206863|-1||debug||P6Spy intentionally did not log category: statement, statement: SELECT A0.Equipment_Make,A0.Year,A0.Equipment_Code,A0.Yard_Code,A0.Description,A0.E quipment_Model,A0.On_Road_Code,A0.Last_Job,A0.Equipment_Type FROM EC_EQUIPMENT_MASTER A0 WHERE A0.On_Road_Code = '1' Reason: Qlog=java.io.PrintStream@158f9d3, isLoggable=true, isCategoryOk=false [org.apache.ojb.broker.singlevm.PersistenceBrokerImpl] DEBUG: --# Criteria element [onRoad = 1] class org.apache.ojb.broker.query.EqualToCriteria [org.apache.ojb.broker.accesslayer.JdbcAccess] DEBUG: executeQuery : ReportQuery from class com.klaasmeyer.forefront.om.ec.Machine count(*) where org.apache.ojb.broker.query.Criteria@14a55f2 [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL: SELECT count(*) FROM EC_EQUIPMENT_MASTER A0 WHERE A0.On_Road_Code = ? 1037301206983|-1||debug||P6Spy intentionally did not log category: statement, statement: SELECT count(*) FROM EC_EQUIPMENT_MASTER A0 WHERE A0.On_Road_Code = '1' Reason: Qlog=java.io.PrintStream@158f9d3, isLoggable=true, isCategoryOk=false [org.apache.ojb.broker.server.BrokerPool] DEBUG: releaseBrokerId: 0 [org.apache.ojb.broker.server.BrokerPool] DEBUG: available: [1, 2, 3, 4, 5, 6, 7, 8, 9, 0] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: dispatching [6,-1,repository.xml,Query from class com.klaasmeyer.forefront.om.ec.Machine where org.apache.ojb.broker.query.Criteria@687ea9,null,null] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: looking up BrokerPool for repository.xml [org.apache.ojb.broker.server.RequestProcessor] DEBUG: in map: {repositoryPostgreSQL.xml=org.apache.ojb.broker.server.BrokerPool@8bdcd2, repository.xml=org.apache.ojb.broker.server.BrokerPool@4e79f1} [org.apache.ojb.broker.server.BrokerPool] DEBUG: getBrokerById: 1 [org.apache.ojb.broker.singlevm.PersistenceBrokerImpl] DEBUG: --# Criteria element [onRoad = 1] class org.apache.ojb.broker.query.EqualToCriteria [org.apache.ojb.broker.accesslayer.JdbcAccess] DEBUG: executeQuery : Query from class com.klaasmeyer.forefront.om.ec.Machine where org.apache.ojb.broker.query.Criteria@687ea9 [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL: SELECT A0.Equipment_Make,A0.Year,A0.Equipment_Code,A0.Yard_Code,A0.Description,A0.E quipment_Model,A0.On_Road_Code,A0.Last_Job,A0.Equipment_Type FROM EC_EQUIPMENT_MASTER A0 WHERE A0.On_Road_Code = ? 1037301220623|-1||debug||P6Spy intentionally did not log category: statement, statement: SELECT A0.Equipment_Make,A0.Year,A0.Equipment_Code,A0.Yard_Code,A0.Description,A0.E quipment_Model,A0.On_Road_Code,A0.Last_Job,A0.Equipment_Type FROM EC_EQUIPMENT_MASTER A0 WHERE A0.On_Road_Code = '1' Reason: Qlog=java.io.PrintStream@158f9d3, isLoggable=true, isCategoryOk=false [org.apache.ojb.broker.singlevm.PersistenceBrokerImpl] DEBUG: --# Criteria element [onRoad = 1] class org.apache.ojb.broker.query.EqualToCriteria [org.apache.ojb.broker.accesslayer.JdbcAccess] DEBUG: executeQuery : ReportQuery from class com.klaasmeyer.forefront.om.ec.Machine count(*) where org.apache.ojb.broker.query.Criteria@c1a0eb [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL: SELECT count(*) FROM EC_EQUIPMENT_MASTER A0 WHERE A0.On_Road_Code = ? 1037301220713|-1||debug||P6Spy intentionally did not log category: statement, statement: SELECT count(*) FROM EC_EQUIPMENT_MASTER A0 WHERE A0.On_Road_Code = '1' Reason: Qlog=java.io.PrintStream@158f9d3, isLoggable=true, isCategoryOk=false [org.apache.ojb.broker.server.BrokerPool] DEBUG: releaseBrokerId: 1 [org.apache.ojb.broker.server.BrokerPool] DEBUG: available: [2, 3, 4, 5, 6, 7, 8, 9, 0, 1] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: dispatching [6,-1,repository.xml,Query from class com.klaasmeyer.forefront.om.ec.Machine where org.apache.ojb.broker.query.Criteria@167c6fd,null,null] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: looking up BrokerPool for repository.xml [org.apache.ojb.broker.server.RequestProcessor] DEBUG: in map: {repositoryPostgreSQL.xml=org.apache.ojb.broker.server.BrokerPool@8bdcd2, repository.xml=org.apache.ojb.broker.server.BrokerPool@4e79f1} [org.apache.ojb.broker.server.BrokerPool] DEBUG: getBrokerById: 2 [org.apache.ojb.broker.singlevm.PersistenceBrokerImpl] DEBUG: --# Criteria element [onRoad = 1] class org.apache.ojb.broker.query.EqualToCriteria [org.apache.ojb.broker.accesslayer.JdbcAccess] DEBUG: executeQuery : Query from class com.klaasmeyer.forefront.om.ec.Machine where org.apache.ojb.broker.query.Criteria@167c6fd [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL: SELECT A0.Equipment_Make,A0.Year,A0.Equipment_Code,A0.Yard_Code,A0.Description,A0.E quipment_Model,A0.On_Road_Code,A0.Last_Job,A0.Equipment_Type FROM EC_EQUIPMENT_MASTER A0 WHERE A0.On_Road_Code = ? 1037301228935|-1||debug||P6Spy intentionally did not log category: statement, statement: SELECT A0.Equipment_Make,A0.Year,A0.Equipment_Code,A0.Yard_Code,A0.Description,A0.E quipment_Model,A0.On_Road_Code,A0.Last_Job,A0.Equipment_Type FROM EC_EQUIPMENT_MASTER A0 WHERE A0.On_Road_Code = '1' Reason: Qlog=java.io.PrintStream@158f9d3, isLoggable=true, isCategoryOk=false [org.apache.ojb.broker.singlevm.PersistenceBrokerImpl] DEBUG: --# Criteria element [onRoad = 1] class org.apache.ojb.broker.query.EqualToCriteria [org.apache.ojb.broker.accesslayer.JdbcAccess] DEBUG: executeQuery : ReportQuery from class com.klaasmeyer.forefront.om.ec.Machine count(*) where org.apache.ojb.broker.query.Criteria@1b25a82 [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL: SELECT count(*) FROM EC_EQUIPMENT_MASTER A0 WHERE A0.On_Road_Code = ? 1037301229035|-1||debug||P6Spy intentionally did not log category: statement, statement: SELECT count(*) FROM EC_EQUIPMENT_MASTER A0 WHERE A0.On_Road_Code = '1' Reason: Qlog=java.io.PrintStream@158f9d3, isLoggable=true, isCategoryOk=false [org.apache.ojb.broker.server.BrokerPool] DEBUG: releaseBrokerId: 2 [org.apache.ojb.broker.server.BrokerPool] DEBUG: available: [3, 4, 5, 6, 7, 8, 9, 0, 1, 2] [org.apache.ojb.broker.server.ConnectionHandler] ERROR: null [org.apache.ojb.broker.server.ConnectionHandler] ERROR: null [org.apache.ojb.broker.server.ConnectionHandler] ERROR: null java.io.EOFException at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.java:2 165) at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStream.j ava:2634) at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:734) at java.io.ObjectInputStream.<init>(ObjectInputStream.java:253) at org.apache.ojb.broker.server.BetterObjectInputStream.<init>(BetterObjectInpu tStream.java:74) at org.apache.ojb.broker.server.ConnectionHandler.getRequestFromSocket(Connecti onHandler.java:210) at org.apache.ojb.broker.server.ConnectionHandler.run(ConnectionHandler.java:12 5) at java.lang.Thread.run(Thread.java:536) [org.apache.ojb.broker.server.ConnectionHandler] ERROR: null [org.apache.ojb.broker.server.ConnectionHandler] ERROR: null [org.apache.ojb.broker.server.ConnectionHandler] ERROR: null java.io.EOFException at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.java:2 165) at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStream.j ava:2634) at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:734) at java.io.ObjectInputStream.<init>(ObjectInputStream.java:253) at org.apache.ojb.broker.server.BetterObjectInputStream.<init>(BetterObjectInpu tStream.java:74) at org.apache.ojb.broker.server.ConnectionHandler.getRequestFromSocket(Connecti onHandler.java:210) at org.apache.ojb.broker.server.ConnectionHandler.run(ConnectionHandler.java:12 5) at java.lang.Thread.run(Thread.java:536) [org.apache.ojb.broker.server.RequestProcessor] DEBUG: dispatching [19,-1,repository.xml,class com.klaasmeyer.forefront.om.ec.EquipmentTransaction,null,null] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: looking up BrokerPool for repository.xml [org.apache.ojb.broker.server.RequestProcessor] DEBUG: in map: {repositoryPostgreSQL.xml=org.apache.ojb.broker.server.BrokerPool@8bdcd2, repository.xml=org.apache.ojb.broker.server.BrokerPool@4e79f1} [org.apache.ojb.broker.server.BrokerPool] DEBUG: getBrokerById: 3 [org.apache.ojb.broker.server.BrokerPool] DEBUG: releaseBrokerId: 3 [org.apache.ojb.broker.server.BrokerPool] DEBUG: available: [4, 5, 6, 7, 8, 9, 0, 1, 2, 3] [org.apache.ojb.broker.server.ConnectionHandler] ERROR: null [org.apache.ojb.broker.server.ConnectionHandler] ERROR: null [org.apache.ojb.broker.server.ConnectionHandler] ERROR: null java.io.EOFException at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.java:2 165) at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStream.j ava:2634) at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:734) at java.io.ObjectInputStream.<init>(ObjectInputStream.java:253) at org.apache.ojb.broker.server.BetterObjectInputStream.<init>(BetterObjectInpu tStream.java:74) at org.apache.ojb.broker.server.ConnectionHandler.getRequestFromSocket(Connecti onHandler.java:210) at org.apache.ojb.broker.server.ConnectionHandler.run(ConnectionHandler.java:12 5) at java.lang.Thread.run(Thread.java:536) [org.apache.ojb.broker.server.ConnectionHandler] ERROR: null [org.apache.ojb.broker.server.ConnectionHandler] ERROR: null [org.apache.ojb.broker.server.ConnectionHandler] ERROR: null java.io.EOFException at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.java:2 165) at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStream.j ava:2634) at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:734) at java.io.ObjectInputStream.<init>(ObjectInputStream.java:253) at org.apache.ojb.broker.server.BetterObjectInputStream.<init>(BetterObjectInpu tStream.java:74) at org.apache.ojb.broker.server.ConnectionHandler.getRequestFromSocket(Connecti onHandler.java:210) at org.apache.ojb.broker.server.ConnectionHandler.run(ConnectionHandler.java:12 5) at java.lang.Thread.run(Thread.java:536) [org.apache.ojb.broker.server.RequestProcessor] DEBUG: dispatching [32,-1,repository.xml,null,null,null] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: looking up BrokerPool for repository.xml [org.apache.ojb.broker.server.RequestProcessor] DEBUG: in map: {repositoryPostgreSQL.xml=org.apache.ojb.broker.server.BrokerPool@8bdcd2, repository.xml=org.apache.ojb.broker.server.BrokerPool@4e79f1} [org.apache.ojb.broker.server.BrokerPool] DEBUG: getBrokerById: 4 [org.apache.ojb.broker.server.BrokerPool] DEBUG: releaseBrokerId: 4 [org.apache.ojb.broker.server.BrokerPool] DEBUG: available: [5, 6, 7, 8, 9, 0, 1, 2, 3, 4] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: dispatching [11,-1,repository.xml,com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[E C,ET20021114,Tue Oct 29 00:00:00 CST 2002,0012,103730119917449,0012,G2,3,1,FU,98.4,1.5177845528455283,149.35,6030 ,6400,KCC,KCC,8121-1 72023 GRIFFIN],null,null] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: looking up BrokerPool for repository.xml [org.apache.ojb.broker.server.RequestProcessor] DEBUG: in map: {repositoryPostgreSQL.xml=org.apache.ojb.broker.server.BrokerPool@8bdcd2, repository.xml=org.apache.ojb.broker.server.BrokerPool@4e79f1} [org.apache.ojb.broker.server.BrokerPool] DEBUG: getBrokerById: 5 [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL: SELECT Equipment_Code,Transaction_Date,Source_Code,Fiscal_Period,Cost_Category_Code ,Fuel_Oil_Code,Batch_ID,Reference,GL_Debit_Account,Company_Code_2,Transactio n_Quantity,Remarks,Transaction_Hours,GL_Credit_Account,Transaction_Rate,Alt_ Company_Code,Transaction_Amount,Fiscal_Year,System_Key FROM EC_TRANSACTION_ENTRY WHERE Source_Code = ? AND Batch_ID = ? AND Transaction_Date = ? AND Reference = ? 1037301230537|-1||debug||P6Spy intentionally did not log category: statement, statement: SELECT Equipment_Code,Transaction_Date,Source_Code,Fiscal_Period,Cost_Category_Code ,Fuel_Oil_Code,Batch_ID,Reference,GL_Debit_Account,Company_Code_2,Transactio n_Quantity,Remarks,Transaction_Hours,GL_Credit_Account,Transaction_Rate,Alt_ Company_Code,Transaction_Amount,Fiscal_Year,System_Key FROM EC_TRANSACTION_ENTRY WHERE Source_Code = 'EC' AND Batch_ID = 'ET20021114' AND Transaction_Date = '20021029' AND Reference = ' 0012' Reason: Qlog=java.io.PrintStream@158f9d3, isLoggable=true, isCategoryOk=false [org.apache.ojb.broker.accesslayer.JdbcAccess] DEBUG: executeInsert : com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[EC,ET20021114,Tue Oct 29 00:00:00 CST 2002,0012,103730119917449,0012,G2,3,1,FU,98.4,1.5177845528455283,149.35,6030 ,6400,KCC,KCC,8121-1 72023 GRIFFIN] [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL: INSERT INTO EC_TRANSACTION_ENTRY (Source_Code,Batch_ID,Transaction_Date,Reference,System_Key,Equipment_Code,F uel_Oil_Code,Fiscal_Year,Fiscal_Period,Cost_Category_Code,Transaction_Quanti ty,Transaction_Hours,Transaction_Rate,Transaction_Amount,GL_Debit_Account,GL _Credit_Account,Company_Code_2,Alt_Company_Code,Remarks) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) 1037301230567|-1||debug||P6Spy intentionally did not log category: statement, statement: INSERT INTO EC_TRANSACTION_ENTRY (Source_Code,Batch_ID,Transaction_Date,Reference,System_Key,Equipment_Code,F uel_Oil_Code,Fiscal_Year,Fiscal_Period,Cost_Category_Code,Transaction_Quanti ty,Transaction_Hours,Transaction_Rate,Transaction_Amount,GL_Debit_Account,GL _Credit_Account,Company_Code_2,Alt_Company_Code,Remarks) VALUES ( 'EC', 'ET20021114', '20021029', ' 0012', '103730119917449', ' 0012', 'G2', '03', '01', 'FU', '98.4', '0.0', '1.5177845528455283', '149.35', '6030', '6400', 'KCC', 'KCC', '8121-1 72023 GRIFFIN' ) Reason: Qlog=java.io.PrintStream@158f9d3, isLoggable=true, isCategoryOk=false [org.apache.ojb.broker.server.BrokerPool] DEBUG: releaseBrokerId: 5 [org.apache.ojb.broker.server.BrokerPool] DEBUG: available: [6, 7, 8, 9, 0, 1, 2, 3, 4, 5] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: dispatching [32,-1,repository.xml,null,null,null] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: looking up BrokerPool for repository.xml [org.apache.ojb.broker.server.RequestProcessor] DEBUG: in map: {repositoryPostgreSQL.xml=org.apache.ojb.broker.server.BrokerPool@8bdcd2, repository.xml=org.apache.ojb.broker.server.BrokerPool@4e79f1} [org.apache.ojb.broker.server.BrokerPool] DEBUG: getBrokerById: 6 [org.apache.ojb.broker.server.BrokerPool] DEBUG: releaseBrokerId: 6 [org.apache.ojb.broker.server.BrokerPool] DEBUG: available: [7, 8, 9, 0, 1, 2, 3, 4, 5, 6] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: dispatching [32,-1,repository.xml,null,null,null] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: looking up BrokerPool for repository.xml [org.apache.ojb.broker.server.RequestProcessor] DEBUG: in map: {repositoryPostgreSQL.xml=org.apache.ojb.broker.server.BrokerPool@8bdcd2, repository.xml=org.apache.ojb.broker.server.BrokerPool@4e79f1} [org.apache.ojb.broker.server.BrokerPool] DEBUG: getBrokerById: 7 [org.apache.ojb.broker.server.BrokerPool] DEBUG: releaseBrokerId: 7 [org.apache.ojb.broker.server.BrokerPool] DEBUG: available: [8, 9, 0, 1, 2, 3, 4, 5, 6, 7] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: dispatching [11,-1,repository.xml,com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[E C,ET20021114,Fri Nov 01 00:00:00 CST 2002,1314,103730119925413,1314,G2,3,1,FU,5.597,1.35,7.55,6030,6400,KCC,KCC,8 053-1 72032 GRAY],null,null] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: looking up BrokerPool for repository.xml [org.apache.ojb.broker.server.RequestProcessor] DEBUG: in map: {repositoryPostgreSQL.xml=org.apache.ojb.broker.server.BrokerPool@8bdcd2, repository.xml=org.apache.ojb.broker.server.BrokerPool@4e79f1} [org.apache.ojb.broker.server.BrokerPool] DEBUG: getBrokerById: 8 [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL: SELECT Equipment_Code,Transaction_Date,Source_Code,Fiscal_Period,Cost_Category_Code ,Fuel_Oil_Code,Batch_ID,Reference,GL_Debit_Account,Company_Code_2,Transactio n_Quantity,Remarks,Transaction_Hours,GL_Credit_Account,Transaction_Rate,Alt_ Company_Code,Transaction_Amount,Fiscal_Year,System_Key FROM EC_TRANSACTION_ENTRY WHERE Source_Code = ? AND Batch_ID = ? AND Transaction_Date = ? AND Reference = ? 1037301231418|-1||debug||P6Spy intentionally did not log category: statement, statement: SELECT Equipment_Code,Transaction_Date,Source_Code,Fiscal_Period,Cost_Category_Code ,Fuel_Oil_Code,Batch_ID,Reference,GL_Debit_Account,Company_Code_2,Transactio n_Quantity,Remarks,Transaction_Hours,GL_Credit_Account,Transaction_Rate,Alt_ Company_Code,Transaction_Amount,Fiscal_Year,System_Key FROM EC_TRANSACTION_ENTRY WHERE Source_Code = 'EC' AND Batch_ID = 'ET20021114' AND Transaction_Date = '20021101' AND Reference = ' 1314' Reason: Qlog=java.io.PrintStream@158f9d3, isLoggable=true, isCategoryOk=false [org.apache.ojb.broker.accesslayer.JdbcAccess] DEBUG: executeInsert : com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[EC,ET20021114,Fri Nov 01 00:00:00 CST 2002,1314,103730119925413,1314,G2,3,1,FU,5.597,1.35,7.55,6030,6400,KCC,KCC,8 053-1 72032 GRAY] [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL: INSERT INTO EC_TRANSACTION_ENTRY (Source_Code,Batch_ID,Transaction_Date,Reference,System_Key,Equipment_Code,F uel_Oil_Code,Fiscal_Year,Fiscal_Period,Cost_Category_Code,Transaction_Quanti ty,Transaction_Hours,Transaction_Rate,Transaction_Amount,GL_Debit_Account,GL _Credit_Account,Company_Code_2,Alt_Company_Code,Remarks) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) 1037301231438|-1||debug||P6Spy intentionally did not log category: statement, statement: INSERT INTO EC_TRANSACTION_ENTRY (Source_Code,Batch_ID,Transaction_Date,Reference,System_Key,Equipment_Code,F uel_Oil_Code,Fiscal_Year,Fiscal_Period,Cost_Category_Code,Transaction_Quanti ty,Transaction_Hours,Transaction_Rate,Transaction_Amount,GL_Debit_Account,GL _Credit_Account,Company_Code_2,Alt_Company_Code,Remarks) VALUES ( 'EC', 'ET20021114', '20021101', ' 1314', '103730119925413', ' 1314', 'G2', '03', '01', 'FU', '5.597', '0.0', '1.35', '7.55', '6030', '6400', 'KCC', 'KCC', '8053-1 72032 GRAY' ) Reason: Qlog=java.io.PrintStream@158f9d3, isLoggable=true, isCategoryOk=false [org.apache.ojb.broker.server.BrokerPool] DEBUG: releaseBrokerId: 8 [org.apache.ojb.broker.server.BrokerPool] DEBUG: available: [9, 0, 1, 2, 3, 4, 5, 6, 7, 8] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: dispatching [32,-1,repository.xml,null,null,null] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: looking up BrokerPool for repository.xml [org.apache.ojb.broker.server.RequestProcessor] DEBUG: in map: {repositoryPostgreSQL.xml=org.apache.ojb.broker.server.BrokerPool@8bdcd2, repository.xml=org.apache.ojb.broker.server.BrokerPool@4e79f1} [org.apache.ojb.broker.server.BrokerPool] DEBUG: getBrokerById: 9 [org.apache.ojb.broker.server.BrokerPool] DEBUG: releaseBrokerId: 9 [org.apache.ojb.broker.server.BrokerPool] DEBUG: available: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: dispatching [32,-1,repository.xml,null,null,null] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: looking up BrokerPool for repository.xml [org.apache.ojb.broker.server.RequestProcessor] DEBUG: in map: {repositoryPostgreSQL.xml=org.apache.ojb.broker.server.BrokerPool@8bdcd2, repository.xml=org.apache.ojb.broker.server.BrokerPool@4e79f1} [org.apache.ojb.broker.server.BrokerPool] DEBUG: getBrokerById: 0 [org.apache.ojb.broker.server.BrokerPool] DEBUG: releaseBrokerId: 0 [org.apache.ojb.broker.server.BrokerPool] DEBUG: available: [1, 2, 3, 4, 5, 6, 7, 8, 9, 0] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: dispatching [11,-1,repository.xml,com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[E C,ET20021114,Thu Oct 31 00:00:00 CST 2002,1468,103730119922473,1468,G2,3,1,FU,7.86,1.4,11.0,6030,6400,KCC,KCC,806 4-1 786364313 BUNTING],null,null] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: looking up BrokerPool for repository.xml [org.apache.ojb.broker.server.RequestProcessor] DEBUG: in map: {repositoryPostgreSQL.xml=org.apache.ojb.broker.server.BrokerPool@8bdcd2, repository.xml=org.apache.ojb.broker.server.BrokerPool@4e79f1} [org.apache.ojb.broker.server.BrokerPool] DEBUG: getBrokerById: 1 [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL: SELECT Equipment_Code,Transaction_Date,Source_Code,Fiscal_Period,Cost_Category_Code ,Fuel_Oil_Code,Batch_ID,Reference,GL_Debit_Account,Company_Code_2,Transactio n_Quantity,Remarks,Transaction_Hours,GL_Credit_Account,Transaction_Rate,Alt_ Company_Code,Transaction_Amount,Fiscal_Year,System_Key FROM EC_TRANSACTION_ENTRY WHERE Source_Code = ? AND Batch_ID = ? AND Transaction_Date = ? AND Reference = ? 1037301232079|-1||debug||P6Spy intentionally did not log category: statement, statement: SELECT Equipment_Code,Transaction_Date,Source_Code,Fiscal_Period,Cost_Category_Code ,Fuel_Oil_Code,Batch_ID,Reference,GL_Debit_Account,Company_Code_2,Transactio n_Quantity,Remarks,Transaction_Hours,GL_Credit_Account,Transaction_Rate,Alt_ Company_Code,Transaction_Amount,Fiscal_Year,System_Key FROM EC_TRANSACTION_ENTRY WHERE Source_Code = 'EC' AND Batch_ID = 'ET20021114' AND Transaction_Date = '20021031' AND Reference = ' 1468' Reason: Qlog=java.io.PrintStream@158f9d3, isLoggable=true, isCategoryOk=false [org.apache.ojb.broker.accesslayer.JdbcAccess] DEBUG: executeInsert : com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[EC,ET20021114,Thu Oct 31 00:00:00 CST 2002,1468,103730119922473,1468,G2,3,1,FU,7.86,1.4,11.0,6030,6400,KCC,KCC,806 4-1 786364313 BUNTING] [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL: INSERT INTO EC_TRANSACTION_ENTRY (Source_Code,Batch_ID,Transaction_Date,Reference,System_Key,Equipment_Code,F uel_Oil_Code,Fiscal_Year,Fiscal_Period,Cost_Category_Code,Transaction_Quanti ty,Transaction_Hours,Transaction_Rate,Transaction_Amount,GL_Debit_Account,GL _Credit_Account,Company_Code_2,Alt_Company_Code,Remarks) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) 1037301232089|-1||debug||P6Spy intentionally did not log category: statement, statement: INSERT INTO EC_TRANSACTION_ENTRY (Source_Code,Batch_ID,Transaction_Date,Reference,System_Key,Equipment_Code,F uel_Oil_Code,Fiscal_Year,Fiscal_Period,Cost_Category_Code,Transaction_Quanti ty,Transaction_Hours,Transaction_Rate,Transaction_Amount,GL_Debit_Account,GL _Credit_Account,Company_Code_2,Alt_Company_Code,Remarks) VALUES ( 'EC', 'ET20021114', '20021031', ' 1468', '103730119922473', ' 1468', 'G2', '03', '01', 'FU', '7.86', '0.0', '1.4', '11.0', '6030', '6400', 'KCC', 'KCC', '8064-1 786364313 BUNTING' ) Reason: Qlog=java.io.PrintStream@158f9d3, isLoggable=true, isCategoryOk=false [org.apache.ojb.broker.server.BrokerPool] DEBUG: releaseBrokerId: 1 [org.apache.ojb.broker.server.BrokerPool] DEBUG: available: [2, 3, 4, 5, 6, 7, 8, 9, 0, 1] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: dispatching [32,-1,repository.xml,null,null,null] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: looking up BrokerPool for repository.xml [org.apache.ojb.broker.server.RequestProcessor] DEBUG: in map: {repositoryPostgreSQL.xml=org.apache.ojb.broker.server.BrokerPool@8bdcd2, repository.xml=org.apache.ojb.broker.server.BrokerPool@4e79f1} [org.apache.ojb.broker.server.BrokerPool] DEBUG: getBrokerById: 2 [org.apache.ojb.broker.server.BrokerPool] DEBUG: releaseBrokerId: 2 [org.apache.ojb.broker.server.BrokerPool] DEBUG: available: [3, 4, 5, 6, 7, 8, 9, 0, 1, 2] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: dispatching [32,-1,repository.xml,null,null,null] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: looking up BrokerPool for repository.xml [org.apache.ojb.broker.server.RequestProcessor] DEBUG: in map: {repositoryPostgreSQL.xml=org.apache.ojb.broker.server.BrokerPool@8bdcd2, repository.xml=org.apache.ojb.broker.server.BrokerPool@4e79f1} [org.apache.ojb.broker.server.BrokerPool] DEBUG: getBrokerById: 3 [org.apache.ojb.broker.server.BrokerPool] DEBUG: releaseBrokerId: 3 [org.apache.ojb.broker.server.BrokerPool] DEBUG: available: [4, 5, 6, 7, 8, 9, 0, 1, 2, 3] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: dispatching [11,-1,repository.xml,com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[E C,ET20021114,Tue Oct 29 00:00:00 CST 2002,1739,103730119905411,1739,G2,3,1,FU,18.7,1.43,26.72,6030,6400,KCC,KCC,0 188-6 770984104 KLAASMEYER],null,null] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: looking up BrokerPool for repository.xml [org.apache.ojb.broker.server.RequestProcessor] DEBUG: in map: {repositoryPostgreSQL.xml=org.apache.ojb.broker.server.BrokerPool@8bdcd2, repository.xml=org.apache.ojb.broker.server.BrokerPool@4e79f1} [org.apache.ojb.broker.server.BrokerPool] DEBUG: creating new PersistenceBroker for id 4 [org.apache.ojb.broker.server.BrokerPool] DEBUG: getBrokerById: 4 [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL: SELECT Equipment_Code,Transaction_Date,Source_Code,Fiscal_Period,Cost_Category_Code ,Fuel_Oil_Code,Batch_ID,Reference,GL_Debit_Account,Company_Code_2,Transactio n_Quantity,Remarks,Transaction_Hours,GL_Credit_Account,Transaction_Rate,Alt_ Company_Code,Transaction_Amount,Fiscal_Year,System_Key FROM EC_TRANSACTION_ENTRY WHERE Source_Code = ? AND Batch_ID = ? AND Transaction_Date = ? AND Reference = ? 1037301232780|-1||debug||P6Spy intentionally did not log category: statement, statement: SELECT Equipment_Code,Transaction_Date,Source_Code,Fiscal_Period,Cost_Category_Code ,Fuel_Oil_Code,Batch_ID,Reference,GL_Debit_Account,Company_Code_2,Transactio n_Quantity,Remarks,Transaction_Hours,GL_Credit_Account,Transaction_Rate,Alt_ Company_Code,Transaction_Amount,Fiscal_Year,System_Key FROM EC_TRANSACTION_ENTRY WHERE Source_Code = 'EC' AND Batch_ID = 'ET20021114' AND Transaction_Date = '20021029' AND Reference = ' 1739' Reason: Qlog=java.io.PrintStream@158f9d3, isLoggable=true, isCategoryOk=false [org.apache.ojb.broker.accesslayer.JdbcAccess] DEBUG: executeInsert : com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[EC,ET20021114,Tue Oct 29 00:00:00 CST 2002,1739,103730119905411,1739,G2,3,1,FU,18.7,1.43,26.72,6030,6400,KCC,KCC,0 188-6 770984104 KLAASMEYER] [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL: INSERT INTO EC_TRANSACTION_ENTRY (Source_Code,Batch_ID,Transaction_Date,Reference,System_Key,Equipment_Code,F uel_Oil_Code,Fiscal_Year,Fiscal_Period,Cost_Category_Code,Transaction_Quanti ty,Transaction_Hours,Transaction_Rate,Transaction_Amount,GL_Debit_Account,GL _Credit_Account,Company_Code_2,Alt_Company_Code,Remarks) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) 1037301232800|-1||debug||P6Spy intentionally did not log category: statement, statement: INSERT INTO EC_TRANSACTION_ENTRY (Source_Code,Batch_ID,Transaction_Date,Reference,System_Key,Equipment_Code,F uel_Oil_Code,Fiscal_Year,Fiscal_Period,Cost_Category_Code,Transaction_Quanti ty,Transaction_Hours,Transaction_Rate,Transaction_Amount,GL_Debit_Account,GL _Credit_Account,Company_Code_2,Alt_Company_Code,Remarks) VALUES ( 'EC', 'ET20021114', '20021029', ' 1739', '103730119905411', ' 1739', 'G2', '03', '01', 'FU', '18.7', '0.0', '1.43', '26.72', '6030', '6400', 'KCC', 'KCC', '0188-6 770984104 KLAASMEYER' ) Reason: Qlog=java.io.PrintStream@158f9d3, isLoggable=true, isCategoryOk=false [org.apache.ojb.broker.server.BrokerPool] DEBUG: releaseBrokerId: 4 [org.apache.ojb.broker.server.BrokerPool] DEBUG: available: [5, 6, 7, 8, 9, 0, 1, 2, 3, 4] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: dispatching [32,-1,repository.xml,null,null,null] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: looking up BrokerPool for repository.xml [org.apache.ojb.broker.server.RequestProcessor] DEBUG: in map: {repositoryPostgreSQL.xml=org.apache.ojb.broker.server.BrokerPool@8bdcd2, repository.xml=org.apache.ojb.broker.server.BrokerPool@4e79f1} [org.apache.ojb.broker.server.BrokerPool] DEBUG: getBrokerById: 5 [org.apache.ojb.broker.server.BrokerPool] DEBUG: releaseBrokerId: 5 [org.apache.ojb.broker.server.BrokerPool] DEBUG: available: [6, 7, 8, 9, 0, 1, 2, 3, 4, 5] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: dispatching [32,-1,repository.xml,null,null,null] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: looking up BrokerPool for repository.xml [org.apache.ojb.broker.server.RequestProcessor] DEBUG: in map: {repositoryPostgreSQL.xml=org.apache.ojb.broker.server.BrokerPool@8bdcd2, repository.xml=org.apache.ojb.broker.server.BrokerPool@4e79f1} [org.apache.ojb.broker.server.BrokerPool] DEBUG: creating new PersistenceBroker for id 6 [org.apache.ojb.broker.server.BrokerPool] DEBUG: getBrokerById: 6 [org.apache.ojb.broker.server.BrokerPool] DEBUG: releaseBrokerId: 6 [org.apache.ojb.broker.server.BrokerPool] DEBUG: available: [7, 8, 9, 0, 1, 2, 3, 4, 5, 6] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: dispatching [11,-1,repository.xml,com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[E C,ET20021114,Tue Oct 29 00:00:00 CST 2002,1743,103730119905412,1743,G3,3,1,FU,18.02,1.6,28.81,6030,6400,KCC,KCC,0 134-1 720325929 KLAASMEYER],null,null] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: looking up BrokerPool for repository.xml [org.apache.ojb.broker.server.RequestProcessor] DEBUG: in map: {repositoryPostgreSQL.xml=org.apache.ojb.broker.server.BrokerPool@8bdcd2, repository.xml=org.apache.ojb.broker.server.BrokerPool@4e79f1} [org.apache.ojb.broker.server.BrokerPool] DEBUG: creating new PersistenceBroker for id 7 [org.apache.ojb.broker.server.BrokerPool] DEBUG: getBrokerById: 7 [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL: SELECT Equipment_Code,Transaction_Date,Source_Code,Fiscal_Period,Cost_Category_Code ,Fuel_Oil_Code,Batch_ID,Reference,GL_Debit_Account,Company_Code_2,Transactio n_Quantity,Remarks,Transaction_Hours,GL_Credit_Account,Transaction_Rate,Alt_ Company_Code,Transaction_Amount,Fiscal_Year,System_Key FROM EC_TRANSACTION_ENTRY WHERE Source_Code = ? AND Batch_ID = ? AND Transaction_Date = ? AND Reference = ? 1037301233361|-1||debug||P6Spy intentionally did not log category: statement, statement: SELECT Equipment_Code,Transaction_Date,Source_Code,Fiscal_Period,Cost_Category_Code ,Fuel_Oil_Code,Batch_ID,Reference,GL_Debit_Account,Company_Code_2,Transactio n_Quantity,Remarks,Transaction_Hours,GL_Credit_Account,Transaction_Rate,Alt_ Company_Code,Transaction_Amount,Fiscal_Year,System_Key FROM EC_TRANSACTION_ENTRY WHERE Source_Code = 'EC' AND Batch_ID = 'ET20021114' AND Transaction_Date = '20021029' AND Reference = ' 1743' Reason: Qlog=java.io.PrintStream@158f9d3, isLoggable=true, isCategoryOk=false [org.apache.ojb.broker.accesslayer.JdbcAccess] DEBUG: executeInsert : com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[EC,ET20021114,Tue Oct 29 00:00:00 CST 2002,1743,103730119905412,1743,G3,3,1,FU,18.02,1.6,28.81,6030,6400,KCC,KCC,0 134-1 720325929 KLAASMEYER] [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL: INSERT INTO EC_TRANSACTION_ENTRY (Source_Code,Batch_ID,Transaction_Date,Reference,System_Key,Equipment_Code,F uel_Oil_Code,Fiscal_Year,Fiscal_Period,Cost_Category_Code,Transaction_Quanti ty,Transaction_Hours,Transaction_Rate,Transaction_Amount,GL_Debit_Account,GL _Credit_Account,Company_Code_2,Alt_Company_Code,Remarks) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) 1037301233381|-1||debug||P6Spy intentionally did not log category: statement, statement: INSERT INTO EC_TRANSACTION_ENTRY (Source_Code,Batch_ID,Transaction_Date,Reference,System_Key,Equipment_Code,F uel_Oil_Code,Fiscal_Year,Fiscal_Period,Cost_Category_Code,Transaction_Quanti ty,Transaction_Hours,Transaction_Rate,Transaction_Amount,GL_Debit_Account,GL _Credit_Account,Company_Code_2,Alt_Company_Code,Remarks) VALUES ( 'EC', 'ET20021114', '20021029', ' 1743', '103730119905412', ' 1743', 'G3', '03', '01', 'FU', '18.02', '0.0', '1.6', '28.81', '6030', '6400', 'KCC', 'KCC', '0134-1 720325929 KLAASMEYER' ) Reason: Qlog=java.io.PrintStream@158f9d3, isLoggable=true, isCategoryOk=false [org.apache.ojb.broker.server.BrokerPool] DEBUG: releaseBrokerId: 7 [org.apache.ojb.broker.server.BrokerPool] DEBUG: available: [8, 9, 0, 1, 2, 3, 4, 5, 6, 7] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: dispatching [32,-1,repository.xml,null,null,null] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: looking up BrokerPool for repository.xml [org.apache.ojb.broker.server.RequestProcessor] DEBUG: in map: {repositoryPostgreSQL.xml=org.apache.ojb.broker.server.BrokerPool@8bdcd2, repository.xml=org.apache.ojb.broker.server.BrokerPool@4e79f1} [org.apache.ojb.broker.server.BrokerPool] DEBUG: getBrokerById: 8 [org.apache.ojb.broker.server.BrokerPool] DEBUG: releaseBrokerId: 8 [org.apache.ojb.broker.server.BrokerPool] DEBUG: available: [9, 0, 1, 2, 3, 4, 5, 6, 7, 8] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: dispatching [32,-1,repository.xml,null,null,null] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: looking up BrokerPool for repository.xml [org.apache.ojb.broker.server.RequestProcessor] DEBUG: in map: {repositoryPostgreSQL.xml=org.apache.ojb.broker.server.BrokerPool@8bdcd2, repository.xml=org.apache.ojb.broker.server.BrokerPool@4e79f1} [org.apache.ojb.broker.server.BrokerPool] DEBUG: creating new PersistenceBroker for id 9 [org.apache.ojb.broker.server.BrokerPool] DEBUG: getBrokerById: 9 [org.apache.ojb.broker.server.BrokerPool] DEBUG: releaseBrokerId: 9 [org.apache.ojb.broker.server.BrokerPool] DEBUG: available: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: dispatching [11,-1,repository.xml,com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[E C,ET20021114,Tue Oct 29 00:00:00 CST 2002,1759,103730119905413,1759,D1,3,1,FU,35.012,1.454929738375414,50.94,6030 ,6400,KCC,KCC,8112-1 720230000 JONES],null,null] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: looking up BrokerPool for repository.xml [org.apache.ojb.broker.server.RequestProcessor] DEBUG: in map: {repositoryPostgreSQL.xml=org.apache.ojb.broker.server.BrokerPool@8bdcd2, repository.xml=org.apache.ojb.broker.server.BrokerPool@4e79f1} [org.apache.ojb.broker.server.BrokerPool] DEBUG: creating new PersistenceBroker for id 0 [org.apache.ojb.broker.server.BrokerPool] DEBUG: getBrokerById: 0 [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL: SELECT Equipment_Code,Transaction_Date,Source_Code,Fiscal_Period,Cost_Category_Code ,Fuel_Oil_Code,Batch_ID,Reference,GL_Debit_Account,Company_Code_2,Transactio n_Quantity,Remarks,Transaction_Hours,GL_Credit_Account,Transaction_Rate,Alt_ Company_Code,Transaction_Amount,Fiscal_Year,System_Key FROM EC_TRANSACTION_ENTRY WHERE Source_Code = ? AND Batch_ID = ? AND Transaction_Date = ? AND Reference = ? 1037301233972|-1||debug||P6Spy intentionally did not log category: statement, statement: SELECT Equipment_Code,Transaction_Date,Source_Code,Fiscal_Period,Cost_Category_Code ,Fuel_Oil_Code,Batch_ID,Reference,GL_Debit_Account,Company_Code_2,Transactio n_Quantity,Remarks,Transaction_Hours,GL_Credit_Account,Transaction_Rate,Alt_ Company_Code,Transaction_Amount,Fiscal_Year,System_Key FROM EC_TRANSACTION_ENTRY WHERE Source_Code = 'EC' AND Batch_ID = 'ET20021114' AND Transaction_Date = '20021029' AND Reference = ' 1759' Reason: Qlog=java.io.PrintStream@158f9d3, isLoggable=true, isCategoryOk=false [org.apache.ojb.broker.accesslayer.JdbcAccess] DEBUG: executeInsert : com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[EC,ET20021114,Tue Oct 29 00:00:00 CST 2002,1759,103730119905413,1759,D1,3,1,FU,35.012,1.454929738375414,50.94,6030 ,6400,KCC,KCC,8112-1 720230000 JONES] [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL: INSERT INTO EC_TRANSACTION_ENTRY (Source_Code,Batch_ID,Transaction_Date,Reference,System_Key,Equipment_Code,F uel_Oil_Code,Fiscal_Year,Fiscal_Period,Cost_Category_Code,Transaction_Quanti ty,Transaction_Hours,Transaction_Rate,Transaction_Amount,GL_Debit_Account,GL _Credit_Account,Company_Code_2,Alt_Company_Code,Remarks) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) 1037301234012|-1||debug||P6Spy intentionally did not log category: statement, statement: INSERT INTO EC_TRANSACTION_ENTRY (Source_Code,Batch_ID,Transaction_Date,Reference,System_Key,Equipment_Code,F uel_Oil_Code,Fiscal_Year,Fiscal_Period,Cost_Category_Code,Transaction_Quanti ty,Transaction_Hours,Transaction_Rate,Transaction_Amount,GL_Debit_Account,GL _Credit_Account,Company_Code_2,Alt_Company_Code,Remarks) VALUES ( 'EC', 'ET20021114', '20021029', ' 1759', '103730119905413', ' 1759', 'D1', '03', '01', 'FU', '35.012', '0.0', '1.454929738375414', '50.94', '6030', '6400', 'KCC', 'KCC', '8112-1 720230000 JONES' ) Reason: Qlog=java.io.PrintStream@158f9d3, isLoggable=true, isCategoryOk=false [org.apache.ojb.broker.server.BrokerPool] DEBUG: releaseBrokerId: 0 [org.apache.ojb.broker.server.BrokerPool] DEBUG: available: [1, 2, 3, 4, 5, 6, 7, 8, 9, 0] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: dispatching [32,-1,repository.xml,null,null,null] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: looking up BrokerPool for repository.xml [org.apache.ojb.broker.server.RequestProcessor] DEBUG: in map: {repositoryPostgreSQL.xml=org.apache.ojb.broker.server.BrokerPool@8bdcd2, repository.xml=org.apache.ojb.broker.server.BrokerPool@4e79f1} [org.apache.ojb.broker.server.BrokerPool] DEBUG: getBrokerById: 1 [org.apache.ojb.broker.server.BrokerPool] DEBUG: releaseBrokerId: 1 [org.apache.ojb.broker.server.BrokerPool] DEBUG: available: [2, 3, 4, 5, 6, 7, 8, 9, 0, 1] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: dispatching [32,-1,repository.xml,null,null,null] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: looking up BrokerPool for repository.xml [org.apache.ojb.broker.server.RequestProcessor] DEBUG: in map: {repositoryPostgreSQL.xml=org.apache.ojb.broker.server.BrokerPool@8bdcd2, repository.xml=org.apache.ojb.broker.server.BrokerPool@4e79f1} [org.apache.ojb.broker.server.BrokerPool] DEBUG: creating new PersistenceBroker for id 2 [org.apache.ojb.broker.server.BrokerPool] DEBUG: getBrokerById: 2 [org.apache.ojb.broker.server.BrokerPool] DEBUG: releaseBrokerId: 2 [org.apache.ojb.broker.server.BrokerPool] DEBUG: available: [3, 4, 5, 6, 7, 8, 9, 0, 1, 2] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: dispatching [11,-1,repository.xml,com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[E C,ET20021114,Tue Oct 29 00:00:00 CST 2002,2606,103730119905415,2606,D2,3,1,FU,163.879,1.43904954265037,235.829999 99999998,6030,6400,KCC,KCC,0149-2 72131 JOHNSTON],null,null] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: looking up BrokerPool for repository.xml [org.apache.ojb.broker.server.RequestProcessor] DEBUG: in map: {repositoryPostgreSQL.xml=org.apache.ojb.broker.server.BrokerPool@8bdcd2, repository.xml=org.apache.ojb.broker.server.BrokerPool@4e79f1} [org.apache.ojb.broker.server.BrokerPool] DEBUG: creating new PersistenceBroker for id 3 [org.apache.ojb.broker.server.BrokerPool] DEBUG: getBrokerById: 3 [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL: SELECT Equipment_Code,Transaction_Date,Source_Code,Fiscal_Period,Cost_Category_Code ,Fuel_Oil_Code,Batch_ID,Reference,GL_Debit_Account,Company_Code_2,Transactio n_Quantity,Remarks,Transaction_Hours,GL_Credit_Account,Transaction_Rate,Alt_ Company_Code,Transaction_Amount,Fiscal_Year,System_Key FROM EC_TRANSACTION_ENTRY WHERE Source_Code = ? AND Batch_ID = ? AND Transaction_Date = ? AND Reference = ? 1037301234673|-1||debug||P6Spy intentionally did not log category: statement, statement: SELECT Equipment_Code,Transaction_Date,Source_Code,Fiscal_Period,Cost_Category_Code ,Fuel_Oil_Code,Batch_ID,Reference,GL_Debit_Account,Company_Code_2,Transactio n_Quantity,Remarks,Transaction_Hours,GL_Credit_Account,Transaction_Rate,Alt_ Company_Code,Transaction_Amount,Fiscal_Year,System_Key FROM EC_TRANSACTION_ENTRY WHERE Source_Code = 'EC' AND Batch_ID = 'ET20021114' AND Transaction_Date = '20021029' AND Reference = ' 2606' Reason: Qlog=java.io.PrintStream@158f9d3, isLoggable=true, isCategoryOk=false [org.apache.ojb.broker.accesslayer.JdbcAccess] DEBUG: executeInsert : com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[EC,ET20021114,Tue Oct 29 00:00:00 CST 2002,2606,103730119905415,2606,D2,3,1,FU,163.879,1.43904954265037,235.829999 99999998,6030,6400,KCC,KCC,0149-2 72131 JOHNSTON] [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL: INSERT INTO EC_TRANSACTION_ENTRY (Source_Code,Batch_ID,Transaction_Date,Reference,System_Key,Equipment_Code,F uel_Oil_Code,Fiscal_Year,Fiscal_Period,Cost_Category_Code,Transaction_Quanti ty,Transaction_Hours,Transaction_Rate,Transaction_Amount,GL_Debit_Account,GL _Credit_Account,Company_Code_2,Alt_Company_Code,Remarks) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) 1037301234693|-1||debug||P6Spy intentionally did not log category: statement, statement: INSERT INTO EC_TRANSACTION_ENTRY (Source_Code,Batch_ID,Transaction_Date,Reference,System_Key,Equipment_Code,F uel_Oil_Code,Fiscal_Year,Fiscal_Period,Cost_Category_Code,Transaction_Quanti ty,Transaction_Hours,Transaction_Rate,Transaction_Amount,GL_Debit_Account,GL _Credit_Account,Company_Code_2,Alt_Company_Code,Remarks) VALUES ( 'EC', 'ET20021114', '20021029', ' 2606', '103730119905415', ' 2606', 'D2', '03', '01', 'FU', '163.879', '0.0', '1.43904954265037', '235.82999999999998', '6030', '6400', 'KCC', 'KCC', '0149-2 72131 JOHNSTON' ) Reason: Qlog=java.io.PrintStream@158f9d3, isLoggable=true, isCategoryOk=false [org.apache.ojb.broker.server.BrokerPool] DEBUG: releaseBrokerId: 3 [org.apache.ojb.broker.server.BrokerPool] DEBUG: available: [4, 5, 6, 7, 8, 9, 0, 1, 2, 3] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: dispatching [32,-1,repository.xml,null,null,null] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: looking up BrokerPool for repository.xml [org.apache.ojb.broker.server.RequestProcessor] DEBUG: in map: {repositoryPostgreSQL.xml=org.apache.ojb.broker.server.BrokerPool@8bdcd2, repository.xml=org.apache.ojb.broker.server.BrokerPool@4e79f1} [org.apache.ojb.broker.server.BrokerPool] DEBUG: getBrokerById: 4 [org.apache.ojb.broker.server.BrokerPool] DEBUG: releaseBrokerId: 4 [org.apache.ojb.broker.server.BrokerPool] DEBUG: available: [5, 6, 7, 8, 9, 0, 1, 2, 3, 4] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: dispatching [32,-1,repository.xml,null,null,null] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: looking up BrokerPool for repository.xml [org.apache.ojb.broker.server.RequestProcessor] DEBUG: in map: {repositoryPostgreSQL.xml=org.apache.ojb.broker.server.BrokerPool@8bdcd2, repository.xml=org.apache.ojb.broker.server.BrokerPool@4e79f1} [org.apache.ojb.broker.server.BrokerPool] DEBUG: creating new PersistenceBroker for id 5 [org.apache.ojb.broker.server.BrokerPool] DEBUG: getBrokerById: 5 [org.apache.ojb.broker.server.BrokerPool] DEBUG: releaseBrokerId: 5 [org.apache.ojb.broker.server.BrokerPool] DEBUG: available: [6, 7, 8, 9, 0, 1, 2, 3, 4, 5] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: dispatching [11,-1,repository.xml,com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[E C,ET20021114,Wed Oct 30 00:00:00 CST 2002,2610,103730119917450,2610,D1,3,1,FU,374.466,1.474820143884892,552.27,60 30,6400,KCC,KCC,8086-1 769500000 DIXON],null,null] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: looking up BrokerPool for repository.xml [org.apache.ojb.broker.server.RequestProcessor] DEBUG: in map: {repositoryPostgreSQL.xml=org.apache.ojb.broker.server.BrokerPool@8bdcd2, repository.xml=org.apache.ojb.broker.server.BrokerPool@4e79f1} [org.apache.ojb.broker.server.BrokerPool] DEBUG: creating new PersistenceBroker for id 6 [org.apache.ojb.broker.server.BrokerPool] DEBUG: getBrokerById: 6 [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL: SELECT Equipment_Code,Transaction_Date,Source_Code,Fiscal_Period,Cost_Category_Code ,Fuel_Oil_Code,Batch_ID,Reference,GL_Debit_Account,Company_Code_2,Transactio n_Quantity,Remarks,Transaction_Hours,GL_Credit_Account,Transaction_Rate,Alt_ Company_Code,Transaction_Amount,Fiscal_Year,System_Key FROM EC_TRANSACTION_ENTRY WHERE Source_Code = ? AND Batch_ID = ? AND Transaction_Date = ? AND Reference = ? 1037301235364|-1||debug||P6Spy intentionally did not log category: statement, statement: SELECT Equipment_Code,Transaction_Date,Source_Code,Fiscal_Period,Cost_Category_Code ,Fuel_Oil_Code,Batch_ID,Reference,GL_Debit_Account,Company_Code_2,Transactio n_Quantity,Remarks,Transaction_Hours,GL_Credit_Account,Transaction_Rate,Alt_ Company_Code,Transaction_Amount,Fiscal_Year,System_Key FROM EC_TRANSACTION_ENTRY WHERE Source_Code = 'EC' AND Batch_ID = 'ET20021114' AND Transaction_Date = '20021030' AND Reference = ' 2610' Reason: Qlog=java.io.PrintStream@158f9d3, isLoggable=true, isCategoryOk=false [org.apache.ojb.broker.accesslayer.JdbcAccess] DEBUG: executeInsert : com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[EC,ET20021114,Wed Oct 30 00:00:00 CST 2002,2610,103730119917450,2610,D1,3,1,FU,374.466,1.474820143884892,552.27,60 30,6400,KCC,KCC,8086-1 769500000 DIXON] [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL: INSERT INTO EC_TRANSACTION_ENTRY (Source_Code,Batch_ID,Transaction_Date,Reference,System_Key,Equipment_Code,F uel_Oil_Code,Fiscal_Year,Fiscal_Period,Cost_Category_Code,Transaction_Quanti ty,Transaction_Hours,Transaction_Rate,Transaction_Amount,GL_Debit_Account,GL _Credit_Account,Company_Code_2,Alt_Company_Code,Remarks) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) 1037301235544|-1||debug||P6Spy intentionally did not log category: statement, statement: INSERT INTO EC_TRANSACTION_ENTRY (Source_Code,Batch_ID,Transaction_Date,Reference,System_Key,Equipment_Code,F uel_Oil_Code,Fiscal_Year,Fiscal_Period,Cost_Category_Code,Transaction_Quanti ty,Transaction_Hours,Transaction_Rate,Transaction_Amount,GL_Debit_Account,GL _Credit_Account,Company_Code_2,Alt_Company_Code,Remarks) VALUES ( 'EC', 'ET20021114', '20021030', ' 2610', '103730119917450', ' 2610', 'D1', '03', '01', 'FU', '374.466', '0.0', '1.474820143884892', '552.27', '6030', '6400', 'KCC', 'KCC', '8086-1 769500000 DIXON' ) Reason: Qlog=java.io.PrintStream@158f9d3, isLoggable=true, isCategoryOk=false [org.apache.ojb.broker.server.BrokerPool] DEBUG: releaseBrokerId: 6 [org.apache.ojb.broker.server.BrokerPool] DEBUG: available: [7, 8, 9, 0, 1, 2, 3, 4, 5, 6] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: dispatching [32,-1,repository.xml,null,null,null] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: looking up BrokerPool for repository.xml [org.apache.ojb.broker.server.RequestProcessor] DEBUG: in map: {repositoryPostgreSQL.xml=org.apache.ojb.broker.server.BrokerPool@8bdcd2, repository.xml=org.apache.ojb.broker.server.BrokerPool@4e79f1} [org.apache.ojb.broker.server.BrokerPool] DEBUG: getBrokerById: 7 [org.apache.ojb.broker.server.BrokerPool] DEBUG: releaseBrokerId: 7 [org.apache.ojb.broker.server.BrokerPool] DEBUG: available: [8, 9, 0, 1, 2, 3, 4, 5, 6, 7] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: dispatching [32,-1,repository.xml,null,null,null] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: looking up BrokerPool for repository.xml [org.apache.ojb.broker.server.RequestProcessor] DEBUG: in map: {repositoryPostgreSQL.xml=org.apache.ojb.broker.server.BrokerPool@8bdcd2, repository.xml=org.apache.ojb.broker.server.BrokerPool@4e79f1} [org.apache.ojb.broker.server.BrokerPool] DEBUG: creating new PersistenceBroker for id 8 [org.apache.ojb.broker.server.BrokerPool] DEBUG: getBrokerById: 8 [org.apache.ojb.broker.server.BrokerPool] DEBUG: releaseBrokerId: 8 [org.apache.ojb.broker.server.BrokerPool] DEBUG: available: [9, 0, 1, 2, 3, 4, 5, 6, 7, 8] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: dispatching [11,-1,repository.xml,com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[E C,ET20021114,Tue Oct 29 00:00:00 CST 2002,2716,103730119905416,2716,G2,3,1,FU,76.27,1.4932476727415762,113.890000 00000001,6030,6400,KCC,KCC,8105-2 76936 PALMER],null,null] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: looking up BrokerPool for repository.xml [org.apache.ojb.broker.server.RequestProcessor] DEBUG: in map: {repositoryPostgreSQL.xml=org.apache.ojb.broker.server.BrokerPool@8bdcd2, repository.xml=org.apache.ojb.broker.server.BrokerPool@4e79f1} [org.apache.ojb.broker.server.BrokerPool] DEBUG: creating new PersistenceBroker for id 9 [org.apache.ojb.broker.server.BrokerPool] DEBUG: getBrokerById: 9 [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL: SELECT Equipment_Code,Transaction_Date,Source_Code,Fiscal_Period,Cost_Category_Code ,Fuel_Oil_Code,Batch_ID,Reference,GL_Debit_Account,Company_Code_2,Transactio n_Quantity,Remarks,Transaction_Hours,GL_Credit_Account,Transaction_Rate,Alt_ Company_Code,Transaction_Amount,Fiscal_Year,System_Key FROM EC_TRANSACTION_ENTRY WHERE Source_Code = ? AND Batch_ID = ? AND Transaction_Date = ? AND Reference = ? 1037301236185|-1||debug||P6Spy intentionally did not log category: statement, statement: SELECT Equipment_Code,Transaction_Date,Source_Code,Fiscal_Period,Cost_Category_Code ,Fuel_Oil_Code,Batch_ID,Reference,GL_Debit_Account,Company_Code_2,Transactio n_Quantity,Remarks,Transaction_Hours,GL_Credit_Account,Transaction_Rate,Alt_ Company_Code,Transaction_Amount,Fiscal_Year,System_Key FROM EC_TRANSACTION_ENTRY WHERE Source_Code = 'EC' AND Batch_ID = 'ET20021114' AND Transaction_Date = '20021029' AND Reference = ' 2716' Reason: Qlog=java.io.PrintStream@158f9d3, isLoggable=true, isCategoryOk=false [org.apache.ojb.broker.accesslayer.JdbcAccess] DEBUG: executeInsert : com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[EC,ET20021114,Tue Oct 29 00:00:00 CST 2002,2716,103730119905416,2716,G2,3,1,FU,76.27,1.4932476727415762,113.890000 00000001,6030,6400,KCC,KCC,8105-2 76936 PALMER] [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL: INSERT INTO EC_TRANSACTION_ENTRY (Source_Code,Batch_ID,Transaction_Date,Reference,System_Key,Equipment_Code,F uel_Oil_Code,Fiscal_Year,Fiscal_Period,Cost_Category_Code,Transaction_Quanti ty,Transaction_Hours,Transaction_Rate,Transaction_Amount,GL_Debit_Account,GL _Credit_Account,Company_Code_2,Alt_Company_Code,Remarks) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) 1037301236205|-1||debug||P6Spy intentionally did not log category: statement, statement: INSERT INTO EC_TRANSACTION_ENTRY (Source_Code,Batch_ID,Transaction_Date,Reference,System_Key,Equipment_Code,F uel_Oil_Code,Fiscal_Year,Fiscal_Period,Cost_Category_Code,Transaction_Quanti ty,Transaction_Hours,Transaction_Rate,Transaction_Amount,GL_Debit_Account,GL _Credit_Account,Company_Code_2,Alt_Company_Code,Remarks) VALUES ( 'EC', 'ET20021114', '20021029', ' 2716', '103730119905416', ' 2716', 'G2', '03', '01', 'FU', '76.27', '0.0', '1.4932476727415762', '113.89000000000001', '6030', '6400', 'KCC', 'KCC', '8105-2 76936 PALMER' ) Reason: Qlog=java.io.PrintStream@158f9d3, isLoggable=true, isCategoryOk=false [org.apache.ojb.broker.server.BrokerPool] DEBUG: releaseBrokerId: 9 [org.apache.ojb.broker.server.BrokerPool] DEBUG: available: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: dispatching [32,-1,repository.xml,null,null,null] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: looking up BrokerPool for repository.xml [org.apache.ojb.broker.server.RequestProcessor] DEBUG: in map: {repositoryPostgreSQL.xml=org.apache.ojb.broker.server.BrokerPool@8bdcd2, repository.xml=org.apache.ojb.broker.server.BrokerPool@4e79f1} [org.apache.ojb.broker.server.BrokerPool] DEBUG: getBrokerById: 0 [org.apache.ojb.broker.server.BrokerPool] DEBUG: releaseBrokerId: 0 [org.apache.ojb.broker.server.BrokerPool] DEBUG: available: [1, 2, 3, 4, 5, 6, 7, 8, 9, 0] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: dispatching [32,-1,repository.xml,null,null,null] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: looking up BrokerPool for repository.xml [org.apache.ojb.broker.server.RequestProcessor] DEBUG: in map: {repositoryPostgreSQL.xml=org.apache.ojb.broker.server.BrokerPool@8bdcd2, repository.xml=org.apache.ojb.broker.server.BrokerPool@4e79f1} [org.apache.ojb.broker.server.BrokerPool] DEBUG: creating new PersistenceBroker for id 1 [org.apache.ojb.broker.server.BrokerPool] DEBUG: getBrokerById: 1 [org.apache.ojb.broker.server.BrokerPool] DEBUG: releaseBrokerId: 1 [org.apache.ojb.broker.server.BrokerPool] DEBUG: available: [2, 3, 4, 5, 6, 7, 8, 9, 0, 1] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: dispatching [11,-1,repository.xml,com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[E C,ET20021114,Tue Oct 29 00:00:00 CST 2002,2734,103730119906417,2734,G2,3,1,FU,57.447,1.4495099831148712,83.270000 00000001,6030,6400,KCC,KCC,0034-1 727017148 SHORTS],null,null] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: looking up BrokerPool for repository.xml [org.apache.ojb.broker.server.RequestProcessor] DEBUG: in map: {repositoryPostgreSQL.xml=org.apache.ojb.broker.server.BrokerPool@8bdcd2, repository.xml=org.apache.ojb.broker.server.BrokerPool@4e79f1} [org.apache.ojb.broker.server.BrokerPool] DEBUG: creating new PersistenceBroker for id 2 [org.apache.ojb.broker.server.BrokerPool] DEBUG: getBrokerById: 2 [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL: SELECT Equipment_Code,Transaction_Date,Source_Code,Fiscal_Period,Cost_Category_Code ,Fuel_Oil_Code,Batch_ID,Reference,GL_Debit_Account,Company_Code_2,Transactio n_Quantity,Remarks,Transaction_Hours,GL_Credit_Account,Transaction_Rate,Alt_ Company_Code,Transaction_Amount,Fiscal_Year,System_Key FROM EC_TRANSACTION_ENTRY WHERE Source_Code = ? AND Batch_ID = ? AND Transaction_Date = ? AND Reference = ? 1037301236876|-1||debug||P6Spy intentionally did not log category: statement, statement: SELECT Equipment_Code,Transaction_Date,Source_Code,Fiscal_Period,Cost_Category_Code ,Fuel_Oil_Code,Batch_ID,Reference,GL_Debit_Account,Company_Code_2,Transactio n_Quantity,Remarks,Transaction_Hours,GL_Credit_Account,Transaction_Rate,Alt_ Company_Code,Transaction_Amount,Fiscal_Year,System_Key FROM EC_TRANSACTION_ENTRY WHERE Source_Code = 'EC' AND Batch_ID = 'ET20021114' AND Transaction_Date = '20021029' AND Reference = ' 2734' Reason: Qlog=java.io.PrintStream@158f9d3, isLoggable=true, isCategoryOk=false [org.apache.ojb.broker.accesslayer.JdbcAccess] DEBUG: executeInsert : com.klaasmeyer.forefront.om.ec.EquipmentTransaction=[EC,ET20021114,Tue Oct 29 00:00:00 CST 2002,2734,103730119906417,2734,G2,3,1,FU,57.447,1.4495099831148712,83.270000 00000001,6030,6400,KCC,KCC,0034-1 727017148 SHORTS] [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL: INSERT INTO EC_TRANSACTION_ENTRY (Source_Code,Batch_ID,Transaction_Date,Reference,System_Key,Equipment_Code,F uel_Oil_Code,Fiscal_Year,Fiscal_Period,Cost_Category_Code,Transaction_Quanti ty,Transaction_Hours,Transaction_Rate,Transaction_Amount,GL_Debit_Account,GL _Credit_Account,Company_Code_2,Alt_Company_Code,Remarks) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) 1037301236896|-1||debug||P6Spy intentionally did not log category: statement, statement: INSERT INTO EC_TRANSACTION_ENTRY (Source_Code,Batch_ID,Transaction_Date,Reference,System_Key,Equipment_Code,F uel_Oil_Code,Fiscal_Year,Fiscal_Period,Cost_Category_Code,Transaction_Quanti ty,Transaction_Hours,Transaction_Rate,Transaction_Amount,GL_Debit_Account,GL _Credit_Account,Company_Code_2,Alt_Company_Code,Remarks) VALUES ( 'EC', 'ET20021114', '20021029', ' 2734', '103730119906417', ' 2734', 'G2', '03', '01', 'FU', '57.447', '0.0', '1.4495099831148712', '83.27000000000001', '6030', '6400', 'KCC', 'KCC', '0034-1 727017148 SHORTS' ) Reason: Qlog=java.io.PrintStream@158f9d3, isLoggable=true, isCategoryOk=false [org.apache.ojb.broker.server.BrokerPool] DEBUG: releaseBrokerId: 2 [org.apache.ojb.broker.server.BrokerPool] DEBUG: available: [3, 4, 5, 6, 7, 8, 9, 0, 1, 2] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: dispatching [32,-1,repository.xml,null,null,null] [org.apache.ojb.broker.server.RequestProcessor] DEBUG: looking up BrokerPool for repository.xml [org.apache.ojb.broker.server.RequestProcessor] DEBUG: in map: {repositoryPostgreSQL.xml=org.apache.ojb.broker.server.BrokerPool@8bdcd2, repository.xml=org.apache.ojb.broker.server.BrokerPool@4e79f1} [org.apache.ojb.broker.server.BrokerPool] DEBUG: getBrokerById: 3 [org.apache.ojb.broker.server.BrokerPool] DEBUG: releaseBrokerId: 3 [org.apache.ojb.broker.server.BrokerPool] DEBUG: available: [4, 5, 6, 7, 8, 9, 0, 1, 2, 3] Full thread dump Java HotSpot(TM) Client VM (1.4.1-rc-b19 mixed mode): "OJB RequestProcessor 10" prio=5 tid=0x0079C6A0 nid=0x1c8 runnable [b60f000..b60fd8c] at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.read(SocketInputStream.java:129) at java.io.ObjectInputStream$PeekInputStream.read(ObjectInputStream.java:2150) at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.java:2 163) at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStream.j ava:2634) at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:734) at java.io.ObjectInputStream.<init>(ObjectInputStream.java:253) at org.apache.ojb.broker.server.BetterObjectInputStream.<init>(BetterObjectInpu tStream.java:74) at org.apache.ojb.broker.server.ConnectionHandler.getRequestFromSocket(Connecti onHandler.java:210) at org.apache.ojb.broker.server.ConnectionHandler.run(ConnectionHandler.java:12 5) - locked <030ADDC8> (a org.apache.ojb.broker.server.ConnectionHandler) at java.lang.Thread.run(Thread.java:536) "OJB RequestProcessor 9" prio=5 tid=0x0079B210 nid=0x317 runnable [b5cf000..b5cfd8c] at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.read(SocketInputStream.java:129) at java.io.ObjectInputStream$PeekInputStream.read(ObjectInputStream.java:2150) at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.java:2 163) at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStream.j ava:2634) at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:734) at java.io.ObjectInputStream.<init>(ObjectInputStream.java:253) at org.apache.ojb.broker.server.BetterObjectInputStream.<init>(BetterObjectInpu tStream.java:74) at org.apache.ojb.broker.server.ConnectionHandler.getRequestFromSocket(Connecti onHandler.java:210) at org.apache.ojb.broker.server.ConnectionHandler.run(ConnectionHandler.java:12 5) - locked <030ADE38> (a org.apache.ojb.broker.server.ConnectionHandler) at java.lang.Thread.run(Thread.java:536) "OJB RequestProcessor 8" prio=5 tid=0x0079A120 nid=0x1c7 runnable [b58f000..b58fd8c] at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.read(SocketInputStream.java:129) at java.io.ObjectInputStream$PeekInputStream.read(ObjectInputStream.java:2150) at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.java:2 163) at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStream.j ava:2634) at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:734) at java.io.ObjectInputStream.<init>(ObjectInputStream.java:253) at org.apache.ojb.broker.server.BetterObjectInputStream.<init>(BetterObjectInpu tStream.java:74) at org.apache.ojb.broker.server.ConnectionHandler.getRequestFromSocket(Connecti onHandler.java:210) at org.apache.ojb.broker.server.ConnectionHandler.run(ConnectionHandler.java:12 5) - locked <030ADEA8> (a org.apache.ojb.broker.server.ConnectionHandler) at java.lang.Thread.run(Thread.java:536) "OJB RequestProcessor 7" prio=5 tid=0x00799030 nid=0x338 runnable [b54f000..b54fd8c] at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.read(SocketInputStream.java:129) at java.io.ObjectInputStream$PeekInputStream.read(ObjectInputStream.java:2150) at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.java:2 163) at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStream.j ava:2634) at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:734) at java.io.ObjectInputStream.<init>(ObjectInputStream.java:253) at org.apache.ojb.broker.server.BetterObjectInputStream.<init>(BetterObjectInpu tStream.java:74) at org.apache.ojb.broker.server.ConnectionHandler.getRequestFromSocket(Connecti onHandler.java:210) at org.apache.ojb.broker.server.ConnectionHandler.run(ConnectionHandler.java:12 5) - locked <030ADF18> (a org.apache.ojb.broker.server.ConnectionHandler) at java.lang.Thread.run(Thread.java:536) "OJB RequestProcessor 6" prio=5 tid=0x00799330 nid=0x326 runnable [b50f000..b50fd8c] at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.read(SocketInputStream.java:129) at java.io.ObjectInputStream$PeekInputStream.read(ObjectInputStream.java:2150) at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.java:2 163) at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStream.j ava:2634) at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:734) at java.io.ObjectInputStream.<init>(ObjectInputStream.java:253) at org.apache.ojb.broker.server.BetterObjectInputStream.<init>(BetterObjectInpu tStream.java:74) at org.apache.ojb.broker.server.ConnectionHandler.getRequestFromSocket(Connecti onHandler.java:210) at org.apache.ojb.broker.server.ConnectionHandler.run(ConnectionHandler.java:12 5) - locked <030ADF88> (a org.apache.ojb.broker.server.ConnectionHandler) at java.lang.Thread.run(Thread.java:536) "OJB RequestProcessor 5" prio=5 tid=0x00799E10 nid=0x2ed runnable [b4cf000..b4cfd8c] at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.read(SocketInputStream.java:129) at java.io.ObjectInputStream$PeekInputStream.read(ObjectInputStream.java:2150) at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.java:2 163) at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStream.j ava:2634) at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:734) at java.io.ObjectInputStream.<init>(ObjectInputStream.java:253) at org.apache.ojb.broker.server.BetterObjectInputStream.<init>(BetterObjectInpu tStream.java:74) at org.apache.ojb.broker.server.ConnectionHandler.getRequestFromSocket(Connecti onHandler.java:210) at org.apache.ojb.broker.server.ConnectionHandler.run(ConnectionHandler.java:12 5) - locked <030ADFF8> (a org.apache.ojb.broker.server.ConnectionHandler) at java.lang.Thread.run(Thread.java:536) "OJB RequestProcessor 4" prio=5 tid=0x00798940 nid=0x314 runnable [b48f000..b48fd8c] at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.read(SocketInputStream.java:129) at java.io.ObjectInputStream$PeekInputStream.read(ObjectInputStream.java:2150) at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.java:2 163) at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStream.j ava:2634) at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:734) at java.io.ObjectInputStream.<init>(ObjectInputStream.java:253) at org.apache.ojb.broker.server.BetterObjectInputStream.<init>(BetterObjectInpu tStream.java:74) at org.apache.ojb.broker.server.ConnectionHandler.getRequestFromSocket(Connecti onHandler.java:210) at org.apache.ojb.broker.server.ConnectionHandler.run(ConnectionHandler.java:12 5) - locked <030AE068> (a org.apache.ojb.broker.server.ConnectionHandler) at java.lang.Thread.run(Thread.java:536) "OJB RequestProcessor 3" prio=5 tid=0x0078F790 nid=0x35f runnable [b44f000..b44fd8c] at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.read(SocketInputStream.java:129) at java.io.ObjectInputStream$PeekInputStream.read(ObjectInputStream.java:2150) at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.java:2 163) at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStream.j ava:2634) at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:734) at java.io.ObjectInputStream.<init>(ObjectInputStream.java:253) at org.apache.ojb.broker.server.BetterObjectInputStream.<init>(BetterObjectInpu tStream.java:74) at org.apache.ojb.broker.server.ConnectionHandler.getRequestFromSocket(Connecti onHandler.java:210) at org.apache.ojb.broker.server.ConnectionHandler.run(ConnectionHandler.java:12 5) - locked <030AE0D8> (a org.apache.ojb.broker.server.ConnectionHandler) at java.lang.Thread.run(Thread.java:536) "OJB RequestProcessor 2" prio=5 tid=0x007962E0 nid=0x31f runnable [b40f000..b40fd8c] at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.read(SocketInputStream.java:129) at java.io.ObjectInputStream$PeekInputStream.read(ObjectInputStream.java:2150) at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.java:2 163) at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStream.j ava:2634) at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:734) at java.io.ObjectInputStream.<init>(ObjectInputStream.java:253) at org.apache.ojb.broker.server.BetterObjectInputStream.<init>(BetterObjectInpu tStream.java:74) at org.apache.ojb.broker.server.ConnectionHandler.getRequestFromSocket(Connecti onHandler.java:210) at org.apache.ojb.broker.server.ConnectionHandler.run(ConnectionHandler.java:12 5) - locked <030AE160> (a org.apache.ojb.broker.server.ConnectionHandler) at java.lang.Thread.run(Thread.java:536) "OJB RequestProcessor 1" prio=5 tid=0x00797EA0 nid=0x360 runnable [b3cf000..b3cfd8c] at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.read(SocketInputStream.java:129) at java.io.ObjectInputStream$PeekInputStream.read(ObjectInputStream.java:2150) at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.java:2 163) at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStream.j ava:2634) at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:734) at java.io.ObjectInputStream.<init>(ObjectInputStream.java:253) at org.apache.ojb.broker.server.BetterObjectInputStream.<init>(BetterObjectInpu tStream.java:74) at org.apache.ojb.broker.server.ConnectionHandler.getRequestFromSocket(Connecti onHandler.java:210) at org.apache.ojb.broker.server.ConnectionHandler.run(ConnectionHandler.java:12 5) - locked <030AE1D0> (a org.apache.ojb.broker.server.ConnectionHandler) at java.lang.Thread.run(Thread.java:536) "Signal Dispatcher" daemon prio=10 tid=0x0076C5B0 nid=0x35d waiting on condition [0..0] "Finalizer" daemon prio=9 tid=0x007686A0 nid=0x30a in Object.wait() [ac8f000..ac8fd8c] at java.lang.Object.wait(Native Method) - waiting on <03037700> (a java.lang.ref.ReferenceQueue$Lock) at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:111) - locked <03037700> (a java.lang.ref.ReferenceQueue$Lock) at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:127) at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:159) "Reference Handler" daemon prio=10 tid=0x00767670 nid=0x37c in Object.wait() [ac4f000..ac4fd8c] at java.lang.Object.wait(Native Method) - waiting on <03037768> (a java.lang.ref.Reference$Lock) at java.lang.Object.wait(Object.java:426) at java.lang.ref.Reference$ReferenceHandler.run(Reference.java:113) - locked <03037768> (a java.lang.ref.Reference$Lock) "main" prio=5 tid=0x00762870 nid=0x375 in Object.wait() [6f000..6fc3c] at java.lang.Object.wait(Native Method) - waiting on <03079628> (a java.util.Vector) at java.lang.Object.wait(Object.java:426) at org.apache.ojb.broker.server.PersistenceBrokerServer.run(PersistenceBrokerSe rver.java:205) - locked <03079628> (a java.util.Vector) at org.apache.ojb.broker.server.PersistenceBrokerServer.main(PersistenceBrokerS erver.java:292) "VM Thread" prio=5 tid=0x00766980 nid=0x310 runnable "VM Periodic Task Thread" prio=10 tid=0x0076BAE0 nid=0x169 waiting on condition "Suspend Checker Thread" prio=10 tid=0x0076B080 nid=0x372 runnable Thanks, Corey -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
