Re: Cannot do multiple connections with JDBC

pellias@my-dejanews.com wrote: > > Hi > > Currently, i am trying to open a JDBC connection to Informix thru different > threads. To open 1 JDBC connection via a thread is fine, but when i spawn out > another thread and that thread tries to open another JDBC connection, i will > encounter an exception (see below). > I am using IUS 9.12 with the JDBC drivers supplied by Informix. Is there any > way i can do multiple connections to IUS ? Pls cc: all replies to > pellias@acm.org > > informix.api.jdbc.JDBCException: XIX000:-27000:Cannot support > multiple connections over shared memory. The error message is telling you EXACTLY what the problem is and even intimates the solution. You can only have one shared memory connection. To connect to the same instance twice, or to two instances on the same machine, at least one of the connections has to be a Stream Pipe or Network connection. Just change the ALIAS you are connecting to to one defined in the sqlhosts as a non-shared memory connection. Art S. Kagel