Re: Handel failure in sql tag

[Antoine Levy-Lambert <an...@gmx.de>]

Hi,

my advice is :

- do not use the <input/> task,

- create a small web application where your users would choose from a 
dropdown the JDBC URL to connect to

- have this web application kick off ant, passing -Ddb.hostname=foo 
-Ddb.port=1234 ..., or more simply -Djdbc.url=xxxxxxxx

where I am working, we are using CruiseControl and we have patched it to 
make it willing to start a build across JMX with a specific target and a 
list or map of properties.

So our web application passes properties for deployments to 
CruiseControl which then obligingly executes ...

Regards,

Antoine


JMAnt wrote:
> I try to connect to sql by ant and do successful.
> but if I want give sql connection url from user by input tag 
> I must check if it is correct or not. but I can't do it. and
> if url is incorrect my build job will terminate without any 
> announcement to user.
> If we can handle Exceptions and Error in build file and do some work after 
> failure?
>
> my related part of build.xml:
>
> 		<sql classpath="sql/${jdbc.jar}"
> 			driver="${jdbc.driver}"
> 			src="${temp.dir}/sqltemp/all.sql"
> 			url="jdbc:mysql://${db.hostname}:${db.port}/?autoReconnect=true"
> 			userid="${db.username}"
> 			password="${db.password}"
> 			onerror = "continue"
> 			/>
>
>   


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org