Hi
I am getting one error in my application which is running in JBoss-2.4.4_Tomcat-3.2.3 and MySql as the database.
I have highlighted the error below. Can anyone give some idea regarding this error.
Thanks a lot in advance
Mahesh
[2002-04-24 18:22:16,058;
JAWSPersistenceManager]<Thread-30>
> findByUserName command
executing: SELECT USER_ID FROM CLIENT_USERS
> WHERE USERNAME=?
>
[2002-04-24 18:22:16,058; JAWSPersistenceManager]<Thread-30> Set
>
parameter: idx=1, jdbcType=VARCHAR, value=romit.d.misra
> [2002-04-24
18:22:16,063; JAWSPersistenceManager]<Thread-30>
> findByUserName
command executing: SELECT USER_ID FROM CLIENT_USERS
> WHERE
USERNAME=?
> [2002-04-24 18:22:16,063;
JAWSPersistenceManager]<Thread-30> Set
> parameter: idx=1,
jdbcType=VARCHAR, value=erin.m.ivers
> [2002-04-24 18:22:16,064;
PunchOutSessionManagerSB]<Thread-30>
> requester parent exists,
parentId = 1018395653613:10.2.36.84:6001
> [2002-04-24 18:22:16,064;
JAWSPersistenceManager]<Thread-30>
> findByUserName command
executing: SELECT USER_ID FROM CLIENT_USERS
> WHERE USERNAME=?
>
[2002-04-24 18:22:16,064; JAWSPersistenceManager]<Thread-30> Set
>
parameter: idx=1, jdbcType=VARCHAR, value=romit.d.misra
> [2002-04-24
18:22:16,065; PunchOutSessionManagerSB]<Thread-30> -->
> Request
Owner found!
> [2002-04-24 18:22:16,075;
JAWSPersistenceManager]<Thread-30>
> findByPermissionBlockId command
executing: SELECT
> REF_PERMISSION_BLOCK_ID FROM REF_PERMISSION_BLOCKS
WHERE BLOCK_ID=?
> [2002-04-24 18:22:16,075;
JAWSPersistenceManager]<Thread-30> Set
> parameter: idx=1,
jdbcType=VARCHAR, value=6
> [2002-04-24 18:22:16,085;
JAWSPersistenceManager]<Thread-30> Create,
> id is
1019672536085:10.2.36.84:6001
> [2002-04-24 18:22:16,086;
JAWSPersistenceManager]<Thread-30> Exists
> command executing:
SELECT COUNT(*) FROM PUNCHOUT_SESSIONS WHERE
> SESSION_ID=?
>
[2002-04-24 18:22:16,086; JAWSPersistenceManager]<Thread-30> Set
>
parameter: idx=1, jdbcType=VARCHAR, value=1019672536085:10.2.36.84:6001
>
[2002-04-24 18:22:16,086; JAWSPersistenceManager]<Thread-30>
Create
> command executing: INSERT INTO PUNCHOUT_SESSIONS
>
(IS_LAST_APPROVER,SESSION_ID,PO_USER_ROLE,BUYER_REQ_NUMBER,SHARED_SECRET,CREATION_DATE,REQUESTER_ID,PUNCHOUT_TYPE,BROWSER_FORM_POST,BUYER_COOKIE,PO_USER_ID,NETWORK_ID)
>
VALUES (?,?,?,?,?,?,?,?,?,?,?,?)
> [2002-04-24 18:22:16,087;
JAWSPersistenceManager]<Thread-30> Set
> parameter: idx=1,
jdbcType=VARCHAR, value=NULL
> [2002-04-24 18:22:16,087;
JAWSPersistenceManager]<Thread-30> Set
> parameter: idx=2,
jdbcType=VARCHAR, value=1019672536085:10.2.36.84:6001
> [2002-04-24
18:22:16,087; JAWSPersistenceManager]<Thread-30> Set
> parameter:
idx=3, jdbcType=VARCHAR, value=NULL
> [2002-04-24 18:22:16,087;
JAWSPersistenceManager]<Thread-30> Set
> parameter: idx=4,
jdbcType=VARCHAR, value=PR49232
> [2002-04-24 18:22:16,087;
JAWSPersistenceManager]<Thread-30> Set
> parameter: idx=5,
jdbcType=VARCHAR, value=NULL
> [2002-04-24 18:22:16,087;
JAWSPersistenceManager]<Thread-30> Set
> parameter: idx=6,
jdbcType=TIMESTAMP, value=NULL
> [2002-04-24 18:22:16,087;
JAWSPersistenceManager]<Thread-30> Set
> parameter: idx=7,
jdbcType=VARCHAR, value=NULL
> [2002-04-24 18:22:16,087;
JAWSPersistenceManager]<Thread-30> Set
> parameter: idx=8,
jdbcType=VARCHAR, value=INSPECT
> [2002-04-24 18:22:16,087;
JAWSPersistenceManager]<Thread-30> Set
> parameter: idx=9,
jdbcType=VARCHAR, value=NULL
> [2002-04-24 18:22:16,087;
JAWSPersistenceManager]<Thread-30> Set
> parameter: idx=10,
jdbcType=VARCHAR, value=NULL
> [2002-04-24 18:22:16,087;
JAWSPersistenceManager]<Thread-30> Set
> parameter: idx=11,
jdbcType=VARCHAR, value=NULL
> [2002-04-24 18:22:16,087;
JAWSPersistenceManager]<Thread-30> Set
> parameter: idx=12,
jdbcType=VARCHAR, value=NULL
> [2002-04-24 18:22:16,088;
JAWSPersistenceManager]<Thread-30> Rows
> affected = 1
>
[2002-04-24 18:22:16,090; JAWSPersistenceManager]<Thread-30> Store
>
command executing: UPDATE PUNCHOUT_SESSIONS SET
>
IS_LAST_APPROVER=?,PO_USER_ROLE=?,SHARED_SECRET=?,CREATION_DATE=?,REQUESTER_ID=?,BROWSER_FORM_POST=?,BUYER_COOKIE=?,PO_USER_ID=?,NETWORK_ID=?
>
WHERE SESSION_ID=?
> [2002-04-24 18:22:16,090;
JAWSPersistenceManager]<Thread-30> Set
> parameter: idx=1,
jdbcType=VARCHAR, value=false
> [2002-04-24 18:22:16,090;
JAWSPersistenceManager]<Thread-30> Set
> parameter: idx=2,
jdbcType=VARCHAR, value=Requester
> [2002-04-24 18:22:16,090;
JAWSPersistenceManager]<Thread-30> Set
> parameter: idx=3,
jdbcType=VARCHAR, value=YCDjrodpOAA=
> [2002-04-24 18:22:16,090;
JAWSPersistenceManager]<Thread-30> Set
> parameter: idx=4,
jdbcType=TIMESTAMP, value=2002-04-24 18:22:16.089
> [2002-04-24
18:22:16,090; JAWSPersistenceManager]<Thread-30> Set
> parameter:
idx=5, jdbcType=VARCHAR, value=1018395653620:10.2.36.84:6001
> [2002-04-24
18:22:16,090; JAWSPersistenceManager]<Thread-30> Set
> parameter:
idx=6, jdbcType=VARCHAR,
> value=https://service.ariba.com/punchout?ansessionid=1868187
>
[2002-04-24 18:22:16,090; JAWSPersistenceManager]<Thread-30> Set
>
parameter: idx=7, jdbcType=VARCHAR, value=1868187
> [2002-04-24
18:22:16,090; JAWSPersistenceManager]<Thread-30> Set
> parameter:
idx=8, jdbcType=VARCHAR, value=1018395653620:10.2.36.84:6001
> [2002-04-24
18:22:16,090; JAWSPersistenceManager]<Thread-30> Set
> parameter:
idx=9, jdbcType=VARCHAR, [EMAIL PROTECTED]
> [2002-04-24
18:22:16,090; JAWSPersistenceManager]<Thread-30> Set
> parameter:
idx=10, jdbcType=VARCHAR, value=1019672536085:10.2.36.84:6001
>
[2002-04-24 18:22:16,091; JAWSPersistenceManager]<Thread-30> Rows
>
affected = 1
> [2002-04-24 18:22:16,701;
PunchOutSessionAction]<Thread-29> Entering
> initialize
method
> [2002-04-24 18:22:16,710; PunchOutSessionAction]<Thread-29>
Leaving
> initialize method
> [2002-04-24 18:22:16,710;
PunchOutSessionAction]<Thread-29> Entering
> home method
>
[2002-04-24 18:22:16,715; JAWSPersistenceManager]<Thread-29>
>
findByRequestNameStatusNotOrphaned command executing: SELECT
>
REQUESTS.REQUEST_ID FROM REQUESTS where REQUEST_NAME LIKE ? AND
>
REQUEST_STATUS_ID != '0'
> [2002-04-24 18:22:16,716;
JAWSPersistenceManager]<Thread-29> Set
> parameter: idx=1,
jdbcType=VARCHAR, value=PR49232
> [2002-04-24 18:22:16,718;
PunchOutSessionManagerSB]<Thread-29>
> Punchout is for a Regular
Request
> [2002-04-24 18:22:16,732;
JAWSPersistenceManager]<Thread-29>
> findByPermissionBlockId command
executing: SELECT
> REF_PERMISSION_BLOCK_ID FROM REF_PERMISSION_BLOCKS
WHERE BLOCK_ID=?
> [2002-04-24 18:22:16,732;
JAWSPersistenceManager]<Thread-29> Set
> parameter: idx=1,
jdbcType=VARCHAR, value=6
> [2002-04-24 18:22:16,740;
JAWSPersistenceManager]<Thread-29> Remove
> command executing:
DELETE FROM PUNCHOUT_SESSIONS WHERE SESSION_ID=?
> [2002-04-24
18:22:16,740; JAWSPersistenceManager]<Thread-29> Set
> parameter:
idx=1, jdbcType=VARCHAR, value=1019672536085:10.2.36.84:6001
> [2002-04-24
18:22:16,740; JAWSPersistenceManager]<Thread-29> Rows
> affected =
1
> [2002-04-24 18:22:16,761; PunchOutSessionAction]<Thread-29>
Leaving
> home method with OPTSUCCESS
> [2002-04-24 18:22:16,765;
PurchaseOrderAction]<Thread-29> Entering
> initialize method
>
[2002-04-24 18:22:16,765; PurchaseOrderAction]<Thread-29> Leaving
>
initialize method
> [2002-04-24 18:22:16,765;
PurchaseOrderAction]<Thread-29> Entering
> poHomeList method
>
[2002-04-24 18:22:16,765; PurchaseOrderAction]<Thread-29>
>
--------------------------------------The Request URL is :
>
/zeborg/poHome.do
> [2002-04-24 18:22:16,765;
PurchaseOrderAction]<Thread-29>
>
--------------------------------------The Servlet path is : /poHome.do
>
[2002-04-24 18:22:16,765; PurchaseOrderAction]<Thread-29>
>
--------------------------------------The Query String is :
>
sessionId=1019672536085:10.2.36.84:6001
> [2002-04-24 18:22:16,765;
PurchaseOrderAction]<Thread-29>
>
--------------------------------------The Path Info is : null
>
[2002-04-24 18:22:16,765; PurchaseOrderAction]<Thread-29>
>
--------------------------------------The Translated Path is : null
>
[2002-04-24 18:22:16,765; PurchaseOrderAction]<Thread-29>
>
------------------ The PO Home page get back URL is : /zeborg/poHome.do
>
[2002-04-24 18:22:16,765; PurchaseOrderAction]<Thread-29> Got
whether
> to sort or not
> [2002-04-24 18:22:16,765;
PurchaseOrderManagerSB]<Thread-29> Inside
>
getPOHomeRequestData()
> [2002-04-24 18:22:16,770;
JAWSPersistenceManager]<Thread-29>
>
findByRequestIdAndCRIInSubmitedStates command executing: SELECT
>
CONTRACTOR_RESPONSE_INFO.CRI_ID FROM CONTRACTOR_RESPONSE_INFO where
>
Request_ID=? AND CRI_STATUS != 'Unposted'
> [2002-04-24 18:22:16,770;
JAWSPersistenceManager]<Thread-29> Set
> parameter: idx=1,
jdbcType=VARCHAR, value=1019088167592:10.2.36.84:6001
> [2002-04-24
18:22:16,773; PurchaseOrderManagerSB]<Thread-29> The no.
> responses
are : 2
> [2002-04-24 18:22:16,779;
PurchaseOrderManagerSB]<Thread-29> The
> initial user is :
1018395653620:10.2.36.84:6001
> [2002-04-24 18:22:16,800;
PurchaseOrderManagerSB]<Thread-29> The
> parent is : 1
>
[2002-04-24 18:22:16,806; JAWSPersistenceManager]<Thread-29>
>
findByParentId command executing: SELECT USER_ID FROM CLIENT_USERS
> WHERE
PARENT_ID=?
>
> [....lots of repetitive stuff
deleted....]
>
> [2002-04-24 18:22:28,233;
PurchaseOrderAction]<Thread-36> Got the data
> from SB
>
[2002-04-24 18:22:28,233; PurchaseOrderAction]<Thread-36> Leaving
>
getResponses method with SUCCESS
> [2002-04-24 18:22:31,793;
PurchaseOrderAction]<Thread-33> Entering
> initialize method
>
[2002-04-24 18:22:31,793; PurchaseOrderAction]<Thread-33> Leaving
>
initialize method
> [2002-04-24 18:22:31,793;
PurchaseOrderAction]<Thread-33> Entering
> getCRIDetails
method
> [2002-04-24 18:22:31,793; PurchaseOrderAction]<Thread-33>
Inside the
> getCRIDetails() method
> [2002-04-24 18:22:31,795;
PurchaseOrderManagerSB]<Thread-33> Inside
> the
populateClientUserData() method
> [2002-04-24 18:22:31,797;
PurchaseOrderManagerSB]<Thread-33> Inside
> the
populateClientCompanyData() method
> [2002-04-24 18:22:31,799;
PurchaseOrderManagerSB]<Thread-33> Inside
> the
populateLocationData() method
> [2002-04-24 18:22:31,799;
PurchaseOrderManagerSB]<Thread-33> Finsih
> populating the
LocationData
> [2002-04-24 18:22:31,799;
PurchaseOrderManagerSB]<Thread-33> Finish
> populating the
ClientCompanyData
> [2002-04-24 18:22:31,800;
PurchaseOrderManagerSB]<Thread-33> Finish
> populatring the
ClientUserData
> [2002-04-24 18:22:31,800;
PurchaseOrderAction]<Thread-33> Calling
> getContractorDetails() in
POManager
> [2002-04-24 18:22:31,801;
JAWSPersistenceManager]<Thread-33>
> findByContractorId command
executing: SELECT CRI_ID FROM
> CONTRACTOR_RESPONSE_INFO WHERE
CONTRACTOR_ID=?
> [2002-04-24 18:22:31,802;
JAWSPersistenceManager]<Thread-33> Set
> parameter: idx=1,
jdbcType=VARCHAR, value=1019591447101:10.2.36.84:6001
> [2002-04-24
18:22:31,805; PurchaseOrderManagerSB]<Thread-33> The
> ResumeId is
1019591447109:10.2.36.84:6001
> [2002-04-24 18:22:31,806;
PurchaseOrderManagerSB]<Thread-33> A Resume
> exists for this
contractor
> [2002-04-24 18:22:31,823;
JAWSPersistenceManager]<Thread-33> Exists
> command executing:
SELECT COUNT(*) FROM RESUMES WHERE RESUME_ID=?
> [2002-04-24 18:22:31,823;
JAWSPersistenceManager]<Thread-33> Set
> parameter: idx=1,
jdbcType=VARCHAR, value=1019591447109:10.2.36.84:6001
> [2002-04-24
18:22:31,825; JAWSPersistenceManager]<Thread-33> Load
> command
executing: SELECT
>
RESUMES.RESUME_ID,RESUMES.FILE_SIZE,RESUMES.FILE,RESUMES.LAST_UPDATE,RESUMES.CONTRACTOR_USER_ID,RESUMES.FILE_NAME,RESUMES.MIME_TYPE
>
FROM RESUMES WHERE RESUME_ID=?
> [2002-04-24 18:22:31,825;
JAWSPersistenceManager]<Thread-33> Set
> parameter: idx=1,
jdbcType=VARCHAR, value=1019591447109:10.2.36.84:6001
> [2002-04-24
18:22:31,834; JAWSPersistenceManager]<Thread-33> Got a [B:
>
'[B@2929c4' while looking for a com.zeborg.util.BinaryLargeObject
>
[2002-04-24 18:22:31,835; JAWSPersistenceManager]<Thread-33>
> java.sql.SQLException: Unable to load a ResultSet
column 3 into a
> variable of type 'com.zeborg.util.BinaryLargeObject':
java.io.EOFException
> [2002-04-24 18:22:31,836;
PurchaseOrderManagerSB]<Thread-33>
>
ZDeadLockUtils::deadLockDetection - Unexpected RemoteException caught
> in
Session Bean business method
> [2002-04-24 18:22:35,832;
PurchaseOrderAction]<Thread-31> Entering
> initialize method
>
[2002-04-24 18:22:35,832; PurchaseOrderAction]<Thread-31> Leaving
>
initialize method