----- Original Message ----- From: "Lutz Epperlein" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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