Hi, Prob is I want to proceed further in the build script....in both the cases If db doesnot exists then prompt the user and continue the script and if does continue the script
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2008 12:45 PM To: [email protected] Subject: AW: How to check whether database exists and then proceed ? Just an idea: use <sql onerror="abort"> and execute an sql command which works only if your database is correctly set up. If that sql fails, the task will throw a BuildException which causes the build to fail. Otherwise, just ignore the result of the sql and proceed. Jan >-----Ursprüngliche Nachricht----- >Von: Sharma, Jaikumar [mailto:[EMAIL PROTECTED] >Gesendet: Freitag, 26. September 2008 07:41 >An: Ant Users List >Betreff: RE: How to check whether database exists and then proceed ? > >My way doing it would be : > > - To check if an executable (under MSSQL scope) supports to >check for a particular database, and return the value which can help >further, since ant Support running external programs (EXE) from within >Ant.. > - probably any third party ant task which could do the job. > - ....... > >An exploration of such things would help you... > >-----Original Message----- >From: Kothari, Shivani [mailto:[EMAIL PROTECTED] >Sent: Friday, September 26, 2008 10:43 AM >To: Ant Users List >Subject: RE: How to check whether database exists and then proceed ? > >Hi, >Thanks for pointing it out. >I want to check using ant that whether a particular database exits on >MSSQL server? And if it exists I want to proceed further in the >deployment script. > >Thanks > >-----Original Message----- >From: Sharma, Jaikumar [mailto:[EMAIL PROTECTED] >Sent: Friday, September 26, 2008 10:39 AM >To: Ant Users List >Subject: RE: How to check whether database exists and then proceed ? > >I think this information is not complete in itself to answer >your query, >if you become more explicit in framing your question, somebody >definitely could help you. >- Like which database (MS SQL, Postgres, MySQL, MS Access,... Long >list...) database ? >- What you want to achieve ? So other can understand, what could be >probable solution to your question..etc.. > >-----Original Message----- >From: Kothari, Shivani [mailto:[EMAIL PROTECTED] >Sent: Friday, September 26, 2008 10:33 AM >To: [email protected] >Subject: How to check whether database exists and then proceed ? > >Hi, >How to check whether database exists using ANT and then proceed ? > >Thanks > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] For additional >commands, e-mail: [EMAIL PROTECTED] > > > > >DISCLAIMER: >Unless indicated otherwise, the information contained in this >message is >privileged and confidential, and is intended only for the use of the >addressee(s) named above and others who have been specifically >authorized to receive it. If you are not the intended >recipient, you are >hereby notified that any dissemination, distribution or copying of this >message and/or attachments is strictly prohibited. The company accepts >no liability for any damage caused by any virus transmitted by this >email. Furthermore, the company does not warrant a proper and complete >transmission of this information, nor does it accept liability for any >delays. If you have received this message in error, please contact the >sender and delete the message. Thank you. > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] For additional >commands, e-mail: [EMAIL PROTECTED] > > > > >DISCLAIMER: >Unless indicated otherwise, the information contained in this >message is privileged and confidential, and is intended only >for the use of the addressee(s) named above and others who >have been specifically authorized to receive it. If you are >not the intended recipient, you are hereby notified that any >dissemination, distribution or copying of this message and/or >attachments is strictly prohibited. The company accepts no >liability for any damage caused by any virus transmitted by >this email. Furthermore, the company does not warrant a proper >and complete transmission of this information, nor does it >accept liability for any delays. If you have received this >message in error, please contact the sender and delete the >message. Thank you. > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
