Subject Re: [Firebird-Java] Re: Problem with Jaybird 2.2 or 2.1 and Firebird 2.5 beta 1
Author Adriano dos Santos Fernandes
Peter Welch escreveu:
> Roman,
>
> Thank you for your thoughtful reply.
>
> Regarding a test case -- well, that wouldn't be easy. I can describe the configuration and events. We are feeding the Firebird database with HL7 messages (healthcare data). For the first month or two it all (Firebird 2.5 and Jaybird 2.1.6) seemed to work fine. Then, every so often there would be a hung message (in the Rhapsody interface engine) that stopped everything from getting through to the database and finally just stopped accepting data at all. One factor might be volume; we are inserting tens of thousands of rows per second at peak loads. As the database grew in size to over 100G the problem grew, or so it seemed. But, there were problems with lesser volume database feeds to FB2.5. Never a problem with FB2.1, though.
Are you using pure-java or native driver?

As you said about 64 bit, I suppose it's pure Java, but is better if you
confirm.

I think the native driver may have problems with multiple concurrent
threads, as the Mutex class just doesn't work there AFAIR.


Adriano