Re: Multi-threaded server application and Informix

Josef Stadelmann wrote: > > Jimmy Hui wrote: > > > Hi all, > > > > I created a multi-threaded server application, within which I used > > ESQL > > statement to try to connect to the informix database. However, it > > consistently complaint about the failure to connect to the database > > server. On the other hand, if I had the same application compiled as > > a > > non-threaded process, everything worked fine. > > > > Question: Do I need any configuration modifications to create a > > multi-threaded server application?? > > > > I used VisiBroker for C++ to generate the server application, as well > > as > > Informix Online Database Server Ver. 7.1 as the database server. > > > > Thanks. > > > > --------------------------------------------------------------- > > Jimmy Ka-Ho Hui > > Newbridge Networks Corporation > > > > (604) 421-2643 Ext 5634 > > mailto:jhui@newbridge.com > > Either the ORB you use or your ESQL API is not thread save or both. > Have you ever written a therad save ORB server not using ESQL. > If this works fine as multithreaded server, then create a short test for > a > threade programm using ESQL but not using the ORB calls and have it > demonstrate multi threadedness. I expect one or the other fails. > > Sepp Stadelmann My understanding is that you need Informix 7.2 for thread safety. They've added some additional functionality for controling multiple database connections, etc. -Peter