Hi,

I have the following problem:
on a unix-solaris system a have a listener-socket running.
a client can connect to this socket and pass commands,
including sql-commands (on MySQL or Oracle db's)
The listener-server is the parent process and for every new
client/connection
we fork this parent process. The idea was to have a pool of database handles
to handle the sql-staments, so the pool could be shared among the forked
processes and I would maintain their status.

So I had the parent process set up a handle-pool,
and when needed the client/connection would select a handle,
do what it had to do and return it.
But a new connection forkes and so everything from the parent process was
duplicated.
This means that changes to the pool-status where only visible for the client
and not for the parent nor the other connections.

Any suggestions an how the have a common "database handle pool"

Hoping for a fast respons,
kind regards

[EMAIL PROTECTED]


Reply via email to