Recent content by cdev

Thanks a lot Marco. It was exactly what I wanted to know : Separate sessions will never block each other. The synchronization will occur only between threads trying to access the session, without blocking the main thread...

Ok thanks. Let's see a short example : I have 2 TOracleSession and one of them is accessed by several threads but the second one is accessed only by an unique thread simultaneously. Can I set ThreadSafe to True for the first OracleSession and Threadsafe to False for the second one? In this...

Hello I have a multithreaded application where each thread owns its own session. If I set the Threadsafe property to true for each sessions, does it mean there is a risk for all threads to block each other when they are accessing the database? Does each thread stop waiting for query executing...

You can run a select count query on V$OPEN_CURSOR to know how many cursors are opened. You just need to write appropriate where clause to filter only one session.

Hi J.Beaven, Did you use a CloseAll before doing a Free on your TOracleDataSets ? Help file description for TOracleDataSet.CloseAll procedure says : CloseAll closes the dataset, including all associated cursors. By default, the cursor of the select statement of the dataset will remain open...

OK. Thanks Marco. In fact, I tried to use Timers created with each of my sessions to insure the session is always connected. :p So, is there a possibility to periodically refresh all sessions (with or without timers). The goal is to prevent each session to be disconnected after the user's...

Hi Marco, In a reply you posted on 15 March, 2004 14:42 (Topic: Application crash without exception on LogOff when busy ) : What did you want to say exactly by "The timer event will always occur in the main thread, it does not matter where you create it." Does it means a TTimer.timer...

Thanks Marco for your answer. I haven't got the problem any more today. I think I was right when I supposed an old record in insertion mode without any commit or rollback produce this error. Anyway, I haven't enough time to go further in tests and it works fine now... CdeV

Yes Uli, I have tried CheckConnection(true) whitout success. I have to make some tests again but the problem seems to be basicly in multi-threaded multi-sessions usage. May I have to checkconnection on all of these. I will look at that tomorrow. CdeV

Hi Does anybody know the possible reasons for a TOracleDataset.insert command to success (no error is raised) but not updating the TOracleDataset.state to dsInsert? Actually, it stays to dsBrowse and i get an exception when I try to post : TClient := TOracleDataSet.Create(nil); Try...

Hi I use a 8.1.7 Oracle Database which have set the idle time parameter to 60 (1 hour) in the application user's profile. When a user stay connected for up to an hour, i get the ORA-02396 Error (exceeded maximum idle time, please connect again) . That's normal but what to do exactly now to...

Hi, I tried to write a Multi-threaded, multi-session application (each thread uses its own dedicated TOracleSession) with DOA 4.0.4.0 Unfortunately, during one thread "open" a long query, the others are uncapable to make use of their own sessions before the first thread's "open" end. In this...