Return-Path: 
 <user-return-65959-apmail-ant-user-archive=ant.apache.org@ant.apache.org>
Delivered-To: apmail-ant-user-archive@www.apache.org
Received: (qmail 96455 invoked from network); 26 Sep 2008 08:19:27 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 26 Sep 2008 08:19:27 -0000
Received: (qmail 73986 invoked by uid 500); 26 Sep 2008 08:19:20 -0000
Delivered-To: apmail-ant-user-archive@ant.apache.org
Received: (qmail 73954 invoked by uid 500); 26 Sep 2008 08:19:20 -0000
Mailing-List: contact user-help@ant.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:user-unsubscribe@ant.apache.org>
List-Help: <mailto:user-help@ant.apache.org>
List-Post: <mailto:user@ant.apache.org>
List-Id: "Ant Users List" <user.ant.apache.org>
Reply-To: "Ant Users List" <user@ant.apache.org>
Delivered-To: mailing list user@ant.apache.org
Received: (qmail 73943 invoked by uid 99); 26 Sep 2008 08:19:20 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 26 Sep 2008 01:19:20 -0700
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: local policy)
Received: from [193.109.238.66] (HELO dnsinet.rzf-nrw.de) (193.109.238.66)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 26 Sep 2008 08:18:19 +0000
Received: from z011100.bk.fin.local (z011100.bk.fin.local [172.18.101.140])
	by dnsinet.rzf-nrw.de (8.14.0/8.14.0) with ESMTP id m8Q8IpLZ019467
	for <user@ant.apache.org>; Fri, 26 Sep 2008 10:18:51 +0200
Received: from z011101.bk.fin.local ([130.11.7.101]) by z011100.bk.fin.local
 with Microsoft SMTPSVC(6.0.3790.1830);
	 Fri, 26 Sep 2008 10:18:52 +0200
Received: from z011021.bk.fin.local ([130.11.7.21]) by z011101.bk.fin.local
 with Microsoft SMTPSVC(6.0.3790.1830);
	 Fri, 26 Sep 2008 10:18:51 +0200
X-MimeOLE: Produced By Microsoft Exchange V6.5
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Subject: AW: How to check whether database exists and then proceed ?
Date: Fri, 26 Sep 2008 10:18:51 +0200
Message-ID: <9EE86F1965E19E499C80DE52AC807B55D6FD3A@z011021.bk.fin.local>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: How to check whether database exists and then proceed ?
Thread-Index: 
 AckflQT035J8It6EQFmxTEfUo9svjAAAE4ogAAA6JUAAAOIfgAADZHEwAAAdumAAADxEwAAATSqwAAFqm9A=
References: 
 <4916D8D7E909DA45B034BB266733E28F02698C@mail-p2s.Baroda.Inteq.Smartweb.com>
From: <Jan.Materne@rzf.fin-nrw.de>
To: <user@ant.apache.org>
X-OriginalArrivalTime: 26 Sep 2008 08:18:51.0832 (UTC)
 FILETIME=[82589B80:01C91FB0]
X-Virus-Checked: Checked by ClamAV on apache.org

You could write a Condition.

<condition property=3D"sqlonline">
    <scriptcondition language=3D"javascript">
        // Try your SQL, maybe using <sql> task which implemented
        // in org.apache.tools.ant.taskdefs.SQLExec
        self.setValue( sqlWasOK );=09
    </scriptcondition>
</condition>=20
<target name=3D"-sql.online" if=3D"sqlonline">
    <echo> Hello Database </echo>
</target>
<target name=3D"-sql.online" unless=3D"sqlonline">
    <echo> Sorry, no Database </echo>
</target>
<target name=3D"sql" depends=3D"-sql.online,-sql.offline"/>


Jan

>-----Urspr=FCngliche Nachricht-----
>Von: Kothari, Shivani [mailto:skothari@inteqnet.com]=20
>Gesendet: Freitag, 26. September 2008 09:33
>An: Ant Users List
>Betreff: RE: How to check whether database exists and then proceed ?
>
>Hi thanks rebhan
>I did the same only, why I raised this question in email is to find out
>..if there is any better approach then doing this....
>
>Thanks
>skothari
>
>-----Original Message-----
>From: Rebhan, Gilbert [mailto:Gilbert.Rebhan@huk-coburg.de]=20
>Sent: Friday, September 26, 2008 1:00 PM
>To: 'Ant Users List'
>Subject: RE: How to check whether database exists and then proceed ?
>
>
>
>
>-----Original Message-----
>From: Kothari, Shivani [mailto:skothari@inteqnet.com]
>Sent: Friday, September 26, 2008 9:19 AM
>To: Ant Users List; Jan.Materne@rzf.fin-nrw.de
>Subject: RE: How to check whether database exists and then proceed ?
>
>/*
>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=20
>the script
>and if does continue the script
>
>*/
>
>AFAIK, the sql task has no errorproperty like f.e. the java task,so you
>can't do stuff like that =3D
>
><sql ... errorproperty=3D"${sqlfailure} ..... >
>
><target name=3D"promptuser" if=3D"sqlfailure">
>...
>
>
>but you may use the <sql onerror=3D"fail"> within a <try> <catch>
>construct.
>
>try / catch is part of the antcontrib task suite, see =3D
>http://ant-contrib.sourceforge.net/tasks/tasks/trycatch.html
>
>download=3D
>http://sourceforge.net/project/showfiles.php?group_id=3D36177&pac
>kage_id=3D2
>8636
>
>pick Version 1.0b2 or 1.0b3
>
>
>Regards, Gilbert
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
>For additional commands, e-mail: user-help@ant.apache.org
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
>For additional commands, e-mail: user-help@ant.apache.org
>
>

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