Executing fork from ProC application

From: Bill Williams <billwilliams_at_qcsoftware.com>
Date: 12 Jul 2001 13:04:39 -0700
Message-ID: <9abba95.0107121204.264faa4f_at_posting.google.com>


I have seen older messages on the newsgroups stating it is a bad thing to have an application that has a connection to the database to execute the fork command. Is there a problem doing this with the newer databases(8.0.5 and higher)?

Here is why I am asking. We have an application running on AIX against Oracle 8.0.5 that creates a connection using ProC embedded SQL. It then will use fork to process messages it receives. Each child creates its own connection to the database. Sometimes, these children processes hang while trying to connect(they could hang for hours). When a kill signal is sent to the parent(there is a signal handler for this), the children then will connect to the database and do their processing. Received on Thu Jul 12 2001 - 22:04:39 CEST

Original text of this message