More info please: -- what event method are you executing this in, a button event? Maybe send us the control structure code (for loop?), too. -- are you manually opening a transaction, doing updates against it, and then committing or rolling back? If not, then that might solve your problem. -- Curt Springer, Team ND At 03:55 PM 6/24/99 -0500, Dave Schorsch wrote: >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] > _________________________________________________________________________ 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]
