Ant/Sybase: java.sql.SQLException: JZ00L: Login failed.

[Terrence Martin <tw...@its.to>]

I am trying to use Ant with the jconn2.jar 5.5 from Sybase and I am
getting this error intermittently or after a long run.

java.sql.SQLException: JZ00L: Login failed

Now this error does not occur immediately. In fact it often only occurs
after a large number of database queries have been sent. Also if I run
each section seperately for instance I can successfully get through my
loads.  However if I try to run them together I have problems.

In addition to the standard SQL task we are also using a custom task that
loads XML files through our business logic into the database. This part
connects also through JDBC< but after going through toplink.

Has anyone had any similar problems with SyBase JDBC drivers and ant?

Cheers,

Terrence

Re: Ant/Sybase: java.sql.SQLException: JZ00L: Login failed.

[Shyam Koppikar <vk...@tds.net>]

----- Original Message ----- 
From: "Lutz Epperlein" <ep...@opix.de>
To: <an...@jakarta.apache.org>
Sent: Monday, October 01, 2001 12:51 AM
Subject: Re: Ant/Sybase: java.sql.SQLException: JZ00L: Login failed.


> > java.sql.SQLException: JZ00L: Login failed
> > 
> > Now this error does not occur immediately. In fact it often only
> > occurs after a large number of database queries have been sent. Also
> > if I run each section seperately for instance I can successfully get
> > through my loads.  However if I try to run them together I have
> > problems.
> > 
> 
> May be this is caused by a too small number of allowed user 
> connections in Sybase database. I don't know how the connections 
> are administrated in Ant, maybe after a task doesn't be happened a 
> correct log out or aren't reused these connections correctly? 
> You can test the number of allowed user connections via 
> "sp_configure 'user conn'" . Use the same way to adjust this value 
> "sp_configure 'user conn', 100". 
> 
> But since I doesn't use the SQL task this is only a guess. Please 
> are carefully while changing such values, it should be done by 
> database admin.
> 
> Lutz E.
> 
> -- 
> Lutz Epperlein, Software Developer
> Opix AG Berlin, Germany

Re: Ant/Sybase: java.sql.SQLException: JZ00L: Login failed.

[Terrence Martin <tw...@its.to>]

This seems to be the problem. Our custom ant task was leaving connections
each time it was run. This eventualy exhasuted the available connections
to Sybase.

We did actually have a DBA change the setting, although changes to our
custom task reduced the need for DB connections substantially.

Thanks for the insight,

Cheers,

Terrence


On Mon, 1 Oct 2001, Lutz Epperlein wrote:

> > java.sql.SQLException: JZ00L: Login failed
> >
> > Now this error does not occur immediately. In fact it often only
> > occurs after a large number of database queries have been sent. Also
> > if I run each section seperately for instance I can successfully get
> > through my loads.  However if I try to run them together I have
> > problems.
> >
>
> May be this is caused by a too small number of allowed user
> connections in Sybase database. I don't know how the connections
> are administrated in Ant, maybe after a task doesn't be happened a
> correct log out or aren't reused these connections correctly?
> You can test the number of allowed user connections via
> "sp_configure 'user conn'" . Use the same way to adjust this value
> "sp_configure 'user conn', 100".
>
> But since I doesn't use the SQL task this is only a guess. Please
> are carefully while changing such values, it should be done by
> database admin.
>
> Lutz E.
>
>

Re: Ant/Sybase: java.sql.SQLException: JZ00L: Login failed.

[Lutz Epperlein <ep...@opix.de>]

> java.sql.SQLException: JZ00L: Login failed
> 
> Now this error does not occur immediately. In fact it often only
> occurs after a large number of database queries have been sent. Also
> if I run each section seperately for instance I can successfully get
> through my loads.  However if I try to run them together I have
> problems.
> 

May be this is caused by a too small number of allowed user 
connections in Sybase database. I don't know how the connections 
are administrated in Ant, maybe after a task doesn't be happened a 
correct log out or aren't reused these connections correctly? 
You can test the number of allowed user connections via 
"sp_configure 'user conn'" . Use the same way to adjust this value 
"sp_configure 'user conn', 100". 

But since I doesn't use the SQL task this is only a guess. Please 
are carefully while changing such values, it should be done by 
database admin.

Lutz E.

-- 
Lutz Epperlein, Software Developer
Opix AG Berlin, Germany