Monday, November 20, 2006

Sybase Error JZ00L when trying to connect/login to database

Background:
Trying to Connect to a Sybase Database, the login fails with an error message:
An error occured while establishing the connection.
Type: java.sql.SQLException Error Code: 0 SQL State: JZ00L
Message:
JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).


Problem Description:
According to the Sybase SQL Error Code description page, error JZ00L occurs as follows:
This error occurs if you enter an incorrect password and/or login ID in the Password and Login ID fields of the Database Profile.

Refer: http://www.sybase.com/detail?id=47902

Problem Solution:
There was no problem with username/password I was using.

The problem I experienced was that the Sybase server had too many idle connections lying around (probably because our network dropped out prior to previous connections disconnecting correctly and we had finally reached our pool limit).

I restarted the Sybase server & it resolved the issue. (It would have been cleaner to kill the idle connections)

0 Comments:

Post a Comment

<< Home