Mailing-List: contact ant-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ant-user@jakarta.apache.org
Message-ID: <012a01c14af1$355dad70$700101cf@vkoppika>
From: "Shyam Koppikar" <vkoppika@tds.net>
To: <ant-user@jakarta.apache.org>
References: <3D0E38416579D411803C00D0B7AF6B210D56E9D3@gsny47e.ny.fw.gs.com>
 <3BB83C94.19607.256EF5@localhost>
Subject: Re: Ant/Sybase: java.sql.SQLException: JZ00L: Login failed.
Date: Mon, 1 Oct 2001 20:20:35 -0700
Organization: Descon Consultants
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit


----- Original Message ----- 
From: "Lutz Epperlein" <epperlein@opix.de>
To: <ant-user@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