SQL Anywhere 11, JZ0C0: Connection is already closed

connection sqlanywhere
Alex picture Alex · Apr 7, 2010 · Viewed 7.5k times · Source

I develop am webservice based on apache tomcat 6.0.26, apache cxf 2.2.7, spring 3.0, hibernate 3.3 and sybase sqlanywhere 11. im using the latest JDBC Driver from SYBASE jconn.jar Version 6.

The persistence layer is based on spring + hibernate dao, the connection is configured via a JNDI datasoure (META-INF directory).

It seems that, during longer times of inactivity, the connection from the webservice to the database is closed.

Exception: java.sql.SQLException: JZ0C0: Connection is already closed.

Answer

Graeme Perrow picture Graeme Perrow · Jun 29, 2010

By default, SQL Anywhere will close an inactive connection after four hours. To change this, you can specify IdleTimeout=x (or Idle=x) in your connection string, where x is the number of minutes after which the connection will be closed (0=never). Alternatively, you can reset the default on the server using the -ti x switch - again, x is in minutes.

Related questions

java.net.SocketException: Connection reset

I am getting the following error trying to read from a socket. I'm doing a readInt() on that InputStream, and I am getting this error. Perusing the documentation this suggests that the client part of the connection closed the connection. …

Read More
Setting up connection string in ASP.NET to SQL SERVER

I'm trying to set up a connecting string in my web.config file (Visual Studio 2008/ASP.NET 3.5) to a local server (SQL server 2008). In my web.config, how and where do I place the connection string? Here's what web.config …

Read More
Login to Microsoft SQL Server Error: 18456

I am getting this error while trying to connect to the SQL Server. Microsoft SQL Server Error: 18456 Can anybody tell me what the error code means?

Read More