Thanks Helen.
I am not fully aware of firebird internals. When I was trying port my
apps (Java) running with embedded linux version
i hit into this problem. So I decided to write a test case.
Open 100 connections to a simple database, make select on each, make
update, make delete, close connection.
Of course I was using connection pool. On windows, everything is fine.
On linux - crash.
That's why I have made this descision
As you have explained - libfbembed is not threaded, that's why I had
this problem. I will rewrote the test case this evening to check again.
Niki

Helen Borrie wrote:

>At 02:02 PM 1/04/2004 +0300, you wrote:
>
>
>
>>>>Under Linux it is not possible, since it is using classic architecture.
>>>>
>>>>
>>>>
>>>>
>>>What is it that you are saying is not possible under Linux?
>>>
>>>/heLen
>>>
>>>
>>>
>>>
>>You cannot open multiple connections from an application to a database
>>under Linux using embedded version
>>
>>
>
>Hmm....I'm trying to process that one. Simply, libfbembed.so is
>non-threading, so the question of multiple connections from a single
>application doesn't arise. It's a genuine "direct-connect": if you are
>connected, you are connected to a running server process. If you
>disconnect, the server process goes away.
>
>You can run as many instances of libfbembed.so as you want, connecting to
>the same database - there is no exclusive file locking on Classic.
>
>The Windows embedded *server* model is a Superserver variant, not a Classic
>instance as the embedded *library* (libfbembed.so) is on Linux. The
>limitation on having multiple instances of a Windows embedded server
>application relates to the exclusive locking of the database by the first
>process spawned by the Superserver. An embedded server is always the first
>and, therefore the only connection.
>
>I'm reliably informed that libfbclient.so can be used for multi-threading
>connections to Fb 1.5 Classic servers on either Windows or Linux, though I
>haven't tried it myself.
>
>/heLen
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>

[Non-text portions of this message have been removed]