Hi,
I am having a problem with an older 3.x project. I wrote some code where a data
object is set for full override, i.e.
DataObject2.setSqlTextOverride(FULL_TEXT_OVERRIDE);
DataObject2.setSqlTextFull(sqlTable+sqlSet+sqlWhere);
command = DataObject2.execute();
The dataobject is called from within a CSpRepeated. When the num of rows in the
repeated is set to 1 (one), the sql statement is executed fine. When the number
of rows is more than one, I take the appropriate vector components and construct
the same sql statement and execute it but nd just hangs until ds timeout. Below
is the netdyn.log but shows no clues to why it is hanging. Do updates in a
repeated need to be handled differently??
Thanks,
Dave
[EMAIL PROTECTED]
06/24/99 15:45.37 (82 b9000000 930260737456) [javaCP] (M)
spider.control.CSpDSProcessor.run: Got them.
06/24/99 15:45.37 (82 b9000000 930260737466) [javaCP] (M)
spider.control.CSpTimedThread.run: 'CSpDSProcessor' interruptable
Thread is DONE.
06/24/99 15:45.37 (82 b9000000 930260737476) [javaCP] (H)
spider.visual.CSpRepeated.executeOneRecord: Processing record #1
06/24/99 15:45.37 (82 b9000000 930260737496) [javaCP] (H)
spider.database.CSpTransaction.execute(CSpDataObject,CSpDBRequest):
Going to execute DataObject 'CIDS.DataObject1' for DataSource
'CIDS.dsFids' 06/24/99 15:45.37 (82 b9000000 930260737496) [javaCP]
(M) spider.control.CSpDSProcessor.establishConnection(..): Called to
establish a connection to an already opened socket
06/24/99 15:45.37 (82 b9000000 930260737516) [javaCP] (E)
CIDS.DataObject1.@@@ARPT_CD(0)ORD
06/24/99 15:45.37 (82 b9000000 930260737516) [javaCP] (E)
CIDS.DataObject1.@@@@@@@@@@@@@@esc2Value ?
06/24/99 15:45.37 (82 b9000000 930260737526) [javaCP] (E)
CIDS.DataObject1.@@@@@@@@@@@@@@SUBBBBB=BAG
06/24/99 15:45.37 (82 b9000000 930260737526) [javaCP] (E)
CIDS.DataObject1.onBeforeExecuteEvent@@@sqlTable? UPDATE
SIGN_CANNED_MSG_DATA
06/24/99 15:45.37 (82 b9000000 930260737536) [javaCP] (E)
CIDS.DataObject1.onBeforeExecuteEvent@@@sqlSet? SET FRAME_TXT='BAG
CLAIM AREA ' || CHR(27) || '$BCP03 DAVE', LN_ATTR='', JUST='C'
06/24/99 15:45.37 (82 b9000000 930260737536) [javaCP] (E)
CIDS.DataObject1.onBeforeExecuteEvent@@@sqlWhere? WHERE
ARPT_CD='ORD' AND SIGN_TYPE='BC' AND SIGN_MSG_CD='AUTO001' AND
LN_NBR='0' AND FRAME_NBR='1'
06/24/99 15:45.37 (82 b9000000 930260737546) [javaCP] (E)
CIDS.DataObject1.onBeforeExecuteEvent@@@sqlText? UPDATE
SIGN_CANNED_MSG_DATA SET FRAME_TXT='BAG CLAIM AREA ' || CHR(27) ||
'$BCP03 DAVE', LN_ATTR='', JUST='C' WHERE ARPT_CD='ORD' AND
SIGN_TYPE='BC' AND SIGN_MSG_CD='AUTO001' AND LN_NBR='0' AND
FRAME_NBR='1'
06/24/99 15:45.37 (82 b9000000 930260737556) [javaCP] (H)
CIDS.DataObject2.execute: executing 'DataObject2' (first row=0, max
rows=1, from the BEGINNING). SQL query=|UPDATE SIGN_CANNED_MSG_DATA
SET FRAME_TXT='BAG CLAIM AREA ' || CHR(27) || '$BCP03 DAVE',
LN_ATTR='', JUST='C' WHERE ARPT_CD='ORD' AND SIGN_TYPE='BC' AND
SIGN_MSG_CD='AUTO001' AND LN_NBR='0' AND FRAME_NBR='1' |
06/24/99 15:45.37 (82 b9000000 930260737566) [javaCP] (M)
spider.control.CSpDSProcessor.establishConnection(): Called to
establish a connection for the first time
06/24/99 15:45.37 (82 b9000000 930260737566) [javaCP] (M) Inserting slot
1000 -- length = 102, timeout = 300000
06/24/99 15:47.37 (82 b9000000 930260857148) [javaCP] (M)
spider.control.CSpTimedThread.run: 'CSpWebEventProcessor'
interruptable Thread is DONE.
06/24/99 15:47.37 (82 b9000000 930260857148) [javaCP] (E)
spider.control.CSpTimedThread.run: InterruptableThread
CSpWebEventProcessor has not been done in 120000 miliseconds OR an
unrecoverable exception occured
06/24/99 15:47.37 (82 b9000000 930260857158) [javaCP] (E)
spider.control.CSpTimedThread.Trying to stop it...
06/24/99 15:47.37 (304 b9000000 930260857158) [ndServer] (E) cannot read
input request
06/24/99 15:47.37 (304 b9000000 930260857158) [ndServer] (H) Socket
closed
06/24/99 15:47.37 (304 b9000000 930260857158) [ndServer] (M) Looking up
slot 1000, with time in = (120)
06/24/99 15:47.37 (304 b9000000 930260857168) [ndServer] (M) Removing
slot 1000
06/24/99 15:47.37 (304 b9000000 930260857168) [ndServer] (M) reading
input request
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
