I have a system which is about to go into production using SQL Anywhere and
jConnect 4.0. Recently the system started to give to following errors:

12/07/98 08:53:01 cyrj QUEUE JZ0C0: Connection is already closed.
at com.sybase.jdbc.ErrorMessage.raiseError(ErrorMessage.java)
at com.sybase.jdbc.SybConnection.checkConnection SybConnection.java)
at com.sybase.jdbc.SybConnection.prepareCall(SybConnection.java)
at bsiConnection.commit(bsiConnection.java:2500)
at bsiJobQueue.cmdCommitBatch(bsiJobQueue.java:77)
at bsiJobQueue.run(bsiJobQueue.java:276)
at java.lang.Thread.run(Thread.java)

Basically, I am doing one or more inserts into the database using a prepared
statement, and then I prepare a statement and do an update. If I do one
insert, then everything works fine. If I do two or more, then when I try to
create the preparedStatement then I get the error above. What could be
causing the connection to close itself without sending an exception? I have
seen references to this problem on the newsgroups, but I have seen no
definitive answers. Does anyone have any ideas? Thanks,

Chuck May
IMS, Inc.
may@ims.nci.nih.gov