Subject Re: [Firebird-Java] Re: Type2 local-mode threadsafe ?
Author Carsten Schäfer
Roman Rokytskyy wrote:
> Hi,
>
> Not neccessarily, gds32.dll or fbclient.dll should be already in
> C:\WINNT\SYSTEM32, jaybird.dll should find them.

gds32.dll is in SYSTEM32 dir, jaybird ist not finding it, even not in my
working dir.
i have to use fbclient.dll in my working dir. (it was a typing error from me
in my first message)
and my app finds the jaybird.dll only in the working directory, not in any
other directory, although
it is in the java.library.path.

>> My questions:
>> Is type2 local mode thread-safe (like type4) ?
>
> Yes. Client library requires one thread per connection at a time, this
> is ensured by driver itself. See release notes.
>
>> Can i use the jaybird build-in connection pooling with type 2 local
>> mode ?
>
> Yes, connection and prepared statement pooling is available for all
> variants of JayBird. Be sure to set type correctly, it is "LOCAL",
> probably not reflected in the documentation. I will update it.

I have to write "local" not "LOCAL". "LOCAL" is not working.
i get unknown host LOCAL

Problem with local mode:
I get a deadlock when i have 2 concurrent connections, this seems to be a
bug in the driver.
(my appserver is getting the connections and doing db-selects for my rmi
clients).

With embedded-mode everything is working.

mfg
Carsten