Re: How to use OCI/ODBC in multi-process programs?

Thank you very much, guys.

I had a good leason from you.

Regards,

Jason Liang

Sree <replyto.newsgrp_at_nowhere.com> wrote in message news:<414E9DB3.6060401_at_nowhere.com>...
> Jason Liang wrote:
>
> > I can't use thread, because I have to use another library that is not
> > thread-safe.
> >
> > I know if I open a file before forking a process, then the child
> > process will inherate the open file descriptor. I am not sure if a
> > child process inherate an open database connection - using OCI or
> > ODBC.
> >
> Right now there is no way through OCI to share a connection among
> processes. Fork replicates file descriptors and also the OCI handles,
> but you can get undefined results if you try to use the replicated OCI
> handles in both the parent and child(you should be able to use just one
> of them though!).
> Connection pool would be a good entry point to implementing the required
> feature. However, currently, the connection pool is single-process. If
> Oracle makes it shareable across processes, not necessarily just
> parent-child, that'l be a solution to you among others. You can try to
> file a request for this feature with Oracle!
>
> Thanks,
> Sree
Received on Mon Sep 20 2004 - 19:27:02 CDT