Re: Q: multiple connections

Fredrik Fyring wrote: > > Hi! > > I'm using a java/jdbc application to connect to an Informix 7.24 > server residing on a SunOs 5.5.1 machine. > > Sometimes the connections don't get closed properly, and when I > try to reconnect I get the error-message > > "SQLException: XIX000:-27000:Cannot support multiple connections > over shared memory." > > Then I have to manually close the connection from the server-end to > get it running again. > > My questions is this: > > 1) How should I do to get Informix to close a connection to a > client that is gone? > > 2) Can I get Informix in some way to support multiple connections? > > regards You do not get error -27000 when trying to connect when a deceased client has not detached properly. You get it when you are trying to execute multiple CONNECT TO statements within an application when more than on of the connections is to a shared memory connected SERVERNAME or DBSERVERALIAS. To make multiple connections you MAY NOT use a shared memory connection. Art S. Kagel