We're running the Netscape Enterprise 2.01 web server and the
Informix 7.1 SQL server on a Solaris 2.5.1 box.
We're trying to get the web server setup so that it authenticates
user passwords and path access from our Informix database rather
than the ACL files. I've got this working fine on a test server,
but when I turned it on for our heavily-used primary server, I
found that SQL calls into Informix (via ESQL/C) are not thread
safe. Whenever two SQL queries from separate threads of the same
web server process get run at the same time, the latter call gets
error -439, indicating that the server connection is busy. Is it
possible to run a different database connection for each thread?
How? If not, what's the best way to lock then connection whenever
I'm executing a query?
I can't find any mention of multi-thread support anywhere in the
Informix manuals. Does anyone have any idea how I can get around
this without eating up gobs of CPU time on each and every HTTP
query?
Thanks,
Obi-Wan
--
Ben "Obi-Wan" Hollingsworth bvh@inetnebr.com
Vice President and System Administrator, Internet Nebraska 402-434-8680
That's what owning a Jeep is really about. Being the sort of person
who sees people in need...and scares the crap out of them. -- Zen