Random Crashing Sucks 1

[shuesty]

I'm writing a program that downloads information from various FTP sites, placing the information into a database, then recomplies the data and places it onto my company's ftp site. In the download thread the basic funcitonality is - download the data, insert into the database, update the database. In the upload thread it's - get the data, upload the data, update the database. I believe the crash occurs because the databse calls happen concurrently at times ... although completely different tables are being accessed, the thread have there own TOracleSessions and other objects, the only thing that is shared is the library I've written to make the database call. I can write a funciton to get around this problem by making sure only one database call is made at any one point ... but if anyone knows why this is happening it would be nice to know myself.

Shuesty

 

[Griffyn]

Any components you use in threads must be thread-safe. The Delphi help file gives some details on which components are and aren't. If you aren't sure, call a component's methods using Synchronize. And don't create non-thread-safe components in your thread.