SQL Anywhere database - Major Database Connection Problem

Author

Major Database Connection Problem

Winnie

2005-06-29, 9:23 am

ASA 8.0.2.4513
Tomcat 4.1

We have a customer that has 6 Tomcat instances running
against one database server. A few weeks back they started
noticing Tomcat is crashing. After further investigation,
we realize that Tomcat hasn't been able to connect to the
database at all. We see that the database server is up and
running, and Mobilink is connected to it.
But when we run Tomcat, it's throwing exception:
java.sql.SWLException: JZ006: IOException:
java.net.ConnectException: Connection refused: connect

The Tomcats has been running fine for the past six months
and has never experienced this problem before. When we shut
down the database server and bring it up again, everything
runs fine.

This is a major problem for our customer as they are in
production and this is causing them a lot of down time.

Someone please help, or point us to the right direction.

Greg Fenton

2005-06-29, 8:23 pm

Winnie wrote:
>
> The Tomcats has been running fine for the past six months
> and has never experienced this problem before. When we shut
> down the database server and bring it up again, everything
> runs fine.
>

Are there any messages in the database console?
If you aren't already, try adding "-z" to the database server's startup
parameters to log extra connection information.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Sponsored Links