RE: How to script database upgrade using ANT script

2010-11-09 Thread Ludwig, Michael
> I have tried using the and other examples > from Google but I can't get it to work. Then you should try a little harder, it is not difficult, certainly way less difficult than anything involving JBoss. Start with a minimum script and the Ant manual. You shouldn't need more. Good luck, Michael

RE: How to script database upgrade using ANT script

2010-11-09 Thread Java Jboss
meet it. -- View this message in context: http://ant.1045680.n5.nabble.com/How-to-script-database-upgrade-using-ANT-script-tp3250375p3256644.html Sent from the Ant - Users mailing list archive at Nabble.com. - To unsubscri

RE: How to script database upgrade using ANT script

2010-11-09 Thread Ludwig, Michael
> having difficulty scripting a > routine to tell it that when a condition is not met it should exit. Look at the docs for to see how to set the property. Michael - To unsubscribe, e-mail: user-unsubscr...@ant.apache.org For

Re: How to script database upgrade using ANT script

2010-11-09 Thread Java Jboss
implemented today and currently trying various things but not having any success. Thank you. -- View this message in context: http://ant.1045680.n5.nabble.com/How-to-script-database-upgrade-using-ANT-script-tp3250375p3256512.html Sent from the Ant - Users mailing list archive at Nabble.com

RE: How to script database upgrade using ANT script

2010-11-09 Thread Ludwig, Michael
I commented on the task: > Note that the first example given in the manual is sort of > stupid, as it is wasteful to call "ls -l" once for each file > in a list of possibly hundreds of files, spawning a new > process each time around. You can have Ant execute the batch all at once by supplying:

Re: How to script database upgrade using ANT script

2010-11-08 Thread Robert Kirkpatrick
You should really get rid of the exec task and use the Ant sql task instead. It just requires a JDBC driver. Suitable parameters exist for all your args. Robert. Le 8/11/2010 16:19, Java Jboss a écrit : Hi, Thank you to all for the suggestions. I have now got an ANT script that checks the

Re: How to script database upgrade using ANT script

2010-11-08 Thread Mugdha Acharya
We are using dbdeploy and are very happy with the results. You can read more about it at http://dbdeploy.com/ On Mon, 2010-11-08 at 07:19 -0800, Java Jboss wrote: > Hi, > > Thank you to all for the suggestions. I have now

Re: How to script database upgrade using ANT script

2010-11-08 Thread Java Jboss
led to open ../build/dir-upgrade-3.0-4.0/Upgrade-1.01-3-Post.sql [exec] Failed to open ../build/dir-upgrade-3.0-4.0/Upgrade-1.01-4-Version.sql BUILD SUCCESSFUL -- View this message in context: http://ant.1045680.n5.nabble.com/How-to-script-database-upgrade-using-ANT-script-tp3250375p325519

Re : How to script database upgrade using ANT script

2010-11-08 Thread Hoang-Vu PHUNG
oss > Objet: How to script database upgrade using ANT script > À: user@ant.apache.org > Date: Jeudi 4 novembre 2010, 18h28 > > Hi, > > I’m a complete newbie to ANT and I need to write an ant > script which > upgrades a database version from base level 1.00 to a given &

Re: How to script database upgrade using ANT script

2010-11-05 Thread Gilbert Rebhan
Original Message Subject: Re: How to script database upgrade using ANT script From: Java Jboss To: user@ant.apache.org Date: 05.11.2010 11:48 > This is rather urgent so I would appreciate any assistance. I need to create > a recursive loop which I can't do and also

Re: How to script database upgrade using ANT script

2010-11-05 Thread Brian Pontarelli
> > > > > > > > > > > > > > Running sql in dir > failonerror="true"> > > > > > > > > > Running sql in dir > failonerror="true"> > >

RE: How to script database upgrade using ANT script

2010-11-05 Thread Ludwig, Michael
> can you please provide an example of how I could do this? If you didn't top-post, it'd be easier to read your mail. Take a look at the documentation for the task in the manual. Well, scroll down to the example section. Looks like the task applies the command to each file in the nested . Which

RE: How to script database upgrade using ANT script

2010-11-05 Thread Java Jboss
Hi Darragh, can you please provide an example of how I could do this? Date: Fri, 5 Nov 2010 03:49:57 -0700 From: ml-node+3251630-1672610580-143...@n5.nabble.com To: apache...@hotmail.co.uk Subject: RE: How to script database upgrade using ANT script > -Original Mess

Re: How to script database upgrade using ANT script

2010-11-05 Thread Antoine Levy Lambert
On 11/5/10 6:48 AM, Java Jboss wrote: Hi, Thank you for the suggestions so far from Antoine and Michael. unfortunately I've been asked to use ANT only without using unix shell scripts. I have tried to tackle it as individual modules using ANT script running the 1st iteration of the mysql scrip

RE: How to script database upgrade using ANT script

2010-11-05 Thread Bailey, Darragh
> -Original Message- > From: Java Jboss [mailto:apache...@hotmail.co.uk] > Sent: 04 November 2010 22:43 > To: user@ant.apache.org > Subject: RE: How to script database upgrade using ANT script > > > > Hi Antoine, > > Thank you very m

Re: How to script database upgrade using ANT script

2010-11-05 Thread Java Jboss
ning sql in dir -- View this message in context: http://ant.1045680.n5.nabble.com/How-to-script-database-upgrade-using-ANT-script-tp3250375p3251629.html Sent from the Ant - Users mailing list archiv

RE: How to script database upgrade using ANT script

2010-11-04 Thread Java Jboss
ning sql in dir Running sql in dir Date: Thu, 4 Nov 2010 10:45:35 -0700 From: ml-node+3250502-1415855530-143...@n5.nabble.com To: apache...@hotmail.co.uk Subject: Re: How to script database upgrade using ANT script On 11/4/10 1:35 PM, J

Re: How to script database upgrade using ANT script

2010-11-04 Thread Antoine Levy Lambert
50409-888287632-143...@n5.nabble.com To: apache...@hotmail.co.uk Subject: Re: How to script database upgrade using ANT script Hi, you will need to use the task for steps like creating the database and importing the dump into the new schema. Once your database is up, you can use the task to run DD

RE: How to script database upgrade using ANT script

2010-11-04 Thread Java Jboss
for help. Thank you. Date: Thu, 4 Nov 2010 09:46:31 -0700 From: ml-node+3250409-888287632-143...@n5.nabble.com To: apache...@hotmail.co.uk Subject: Re: How to script database upgrade using ANT script Hi, you will need to use the task for steps like creating the database and importing the

Re: How to script database upgrade using ANT script

2010-11-04 Thread Antoine Levy Lambert
Hi, you will need to use the task for steps like creating the database and importing the dump into the new schema. Once your database is up, you can use the task to run DDL and DML statements. To check whether a script exists, there is a task called which can set a property if a file is ava

RE: How to script database upgrade using ANT script

2010-11-04 Thread Ludwig, Michael
> I need to write an ant script which upgrades a database version from > base level 1.00 to a given version number by running a series of mysql > (ver 5.1.45) scripts. > > Using ANT script I need to: > 1) create a database > 2) import mysql database(s) dump to a new schema > 3) check current datab

How to script database upgrade using ANT script

2010-11-04 Thread Java Jboss
un second sql script and so on until the required database version is reached. 5) check database version is at correct level then “end” or else start the loop again 6) how can I script error checking also Thank you all in advance. -- View this message in context: http://ant.1045680.n5.nabble.