RE: How to script database upgrade using ANT script

2010-11-09 Thread Java Jboss
Hi Michael, I have tried using the and other examples from Google but I can't get it to work. I just want the "db-upgrade:" bit to stop when it cant meet the next condition. At the moment it still tries to run the script looking for dir2 and dir3 even though these don't exist at the moment bu

Re: How to script database upgrade using ANT script

2010-11-09 Thread Java Jboss
Hi Michael, With my limited ANT knowledge I have got the script to work almost. I have had a look at the link that you sent but having difficulty scripting a routine to tell it that when a condition is not met it should exit. I would really appreciate a soultion for this. I need to get this imp

Re: How to script database upgrade using ANT script

2010-11-08 Thread Java Jboss
Hi, Thank you to all for the suggestions. I have now got an ANT script that checks the current database version and then runs a set of mysql scripts to upgrade the database to the next version. What I am struggling with is when it goes through the list="${db.upgrade.path.list}. On the first ru

RE: How to script database upgrade using ANT script

2010-11-05 Thread Java Jboss
age- > From: Java Jboss [mailto:[hidden email]] > Sent: 04 November 2010 22:43 > To: [hidden email] > Subject: RE: How to script database upgrade using ANT script > > > > Hi Antoine, > > Thank you very much for providing me this example. > unfortunately I've

Re: How to script database upgrade using ANT script

2010-11-05 Thread Java Jboss
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 scripts against newschema1. I need to run e

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 Java Jboss
ild if a script fails. You need to test before hand whether the system commands or the scripts that you will run to create the database and import the dump are returning proper exit statuses. (setting ERRORLEVEL on Windows or $? on UNIX). Regards, Antoine On 11/4/10 12:28 PM, Java Jbos

How to script database upgrade using ANT script

2010-11-04 Thread Java Jboss
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 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