943,747 Members | Top Members by Rank

Ad:
Jul 2nd, 2009
0

Multithread+BDE+Oracle database Error

Expand Post »
I create an application with three threads(access oracle database by bde tquery)

main program:random select,insert data;cycle:10S
thread1:random select,insert,delete data;cycle:10s
thread2:random select;cycle:60s
thread3:random insert;cycle:20s

five errors occur between 24 hours,longest interval:12hours;shortest interval:0.5hour,
error as following:
"Lost communication with SQL server.ORA-03113:..."
"General SQL error. ORA-03114:..."

ping database is ok during error;
the dba not find error like that in database log;

Client OS:WINDOWS XP
DevelopToolELPHI 6.0
BDE Ver:5.01
Oracle client:ver 8.1.7
Oracle DB:9i

why..?

can anyone help me?,thanks!
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
DUST.ZHU is offline Offline
1 posts
since Jun 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Pascal and Delphi Forum Timeline: May I ask you a question on Delphi?
Next Thread in Pascal and Delphi Forum Timeline: Probably a silly question.. but im new to delphi :)





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC