Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Art S. Kagel — — source: Informix-list mailing list archive (1991-1998)
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.