Re: Problem with multiple connections.

I 'm working on SCO UW7. In my systems these parameters are SFNOLIM and HFNOLIM. But besides these the max number of open files is hardcoded (I think) in limits.h (or stdio.h) as the OPEN_MAX constant. Just look your man page for "man limits". Best Regards, Octav Aleksandr Shneyderman wrote: > That was my guess at first too. I did go through the Sun's documentation and > figured that the variable that I would have to tweak is maxusers it was set > to 60 > by default. I reset it to 125 but that did not help. I am wondering whether > it was > correct variable to tweak? > > Thanks, > Alex. > > -----Original Message----- > From: Octav Chiriac [mailto:com@netinfo-moldova.com] > Sent: Wednesday, May 19, 1999 10:35 PM > To: Aleksandr Shneyderman; informix-list@iiug.org > Subject: Re: Problem with multiple connections. > > Just a guess: is it a limit on number of open files for a process in the OS > kernel ? > > Best Regards, > Octav > > Aleksandr Shneyderman wrote: > > > Hello, everyone! > > > > I have a Java program, that uses Informix JDBC driver to create a pool > > of connections with Informix database(let's say 100).When the program > > executes it only opens a certain number of connections about 50 and then > > fails giving the error msg > > > > Attempt to connect to database server (Java socket exception > > encountered:Too many open files) failed. > > Error code: -908 > > SQL State : 08004 > > > > However, when I run the program on 2 or more instances of JVM all of > > them open the same limited number of connections (50), i.e. the database > > server allows more than 100 simultaneous conections. > > The problem appears regardless whether the program runs on remote host > > or on the same machine where I have the engine. > > > > Is it limitation of JVM, JDBC driver, or IDS? > > > > OS:Solaris 7, IDS 7.31, JDK 1.1.7 > > > > Any help is appreciated.