I hope to get these issues fixed before the release of 0.9.8.
I'm currently very busy, so I can't promise anything, but the C/S mode issue and Juergen's patches are still on my todo list...
thanks for your patience,
Thomas
Corey Klaasmeyer wrote:
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]>
-- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
