Indexes in embedded firebird

Hi all.

Using embedded Firebird 1.5 I have created :
- two tables T1, T2
- an index on T1

I have an application that is inserting data in T1 and T2 and in the same time is performing a delete on T1.
Because of this index that I created (I think this is the culprit), the Firebird engine is throwing an exception (access violation) when is trying to insert data in T2. After this, the engine is dead.

Any ideea? Is there a known issue with the indexes in this version of embedded Firebird?

Thank you.

Mircea

There's no known issues with that.

Are you sure the engine throws the access violation?

What is the exact error message?

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle & MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

The error message:
"Access violation.
The code attempted to access a virtual address without privilege to do so. This exception will cause the Firebird server
to terminate abnormally."

It looks like is a multithread issue. But it should not be that. As I said, I have 2 threads:
- one is inserting, updating values in T1 and T2
- second one is deleting records from T1

I get the error only when I try to update T2.

So, it doesn't make sense to me.

Are you using separate connections for each thread?

Yes.

Hmm, that should be OK then.

If you use a single thread to do your stuff, does it work then?