Return-Path: 
 <user-return-43058-apmail-ant-user-archive=ant.apache.org@ant.apache.org>
Delivered-To: apmail-ant-user-archive@www.apache.org
Received: (qmail 24678 invoked from network); 11 May 2004 13:04:17 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur-2.apache.org with SMTP; 11 May 2004 13:04:17 -0000
Received: (qmail 72537 invoked by uid 500); 11 May 2004 13:05:14 -0000
Delivered-To: apmail-ant-user-archive@ant.apache.org
Received: (qmail 72503 invoked by uid 500); 11 May 2004 13:05:14 -0000
Mailing-List: contact user-help@ant.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:user-unsubscribe@ant.apache.org>
List-Subscribe: <mailto:user-subscribe@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 72488 invoked by uid 98); 11 May 2004 13:05:14 -0000
Received: from vinod.nayak@iflexsolutions.com by hermes.apache.org by uid 82
 with qmail-scanner-1.20
 (clamuko: 0.70.  Clear:RC:0(202.144.91.162):.
 Processed in 0.716536 secs); 11 May 2004 13:05:14 -0000
X-Qmail-Scanner-Mail-From: vinod.nayak@iflexsolutions.com via
 hermes.apache.org
X-Qmail-Scanner: 1.20 (Clear:RC:0(202.144.91.162):. Processed in 0.716536
 secs)
Received: from unknown (HELO relay2.iflexsolutions.com) (202.144.91.162)
  by hermes.apache.org with SMTP; 11 May 2004 13:05:13 -0000
Received: from fmgrt.rt.i-flex.com (pppserver [192.168.50.2])
	by relay2.iflexsolutions.com (8.12.3/8.12.3) with ESMTP id i4BIVucl011038
	for <user@ant.apache.org>; Tue, 11 May 2004 18:31:56 GMT
Received: from fmgrt.rt.i-flex.com ([192.168.50.2]) by fmgrt.rt.i-flex.com
 with Microsoft SMTPSVC(5.0.2195.6713);
	 Tue, 11 May 2004 18:37:49 +0530
Received: from fmg-op.opal.i-flex.com ([169.165.63.11]) by fmgrt.rt.i-flex.com
 with Microsoft SMTPSVC(5.0.2195.6713);
	 Tue, 11 May 2004 18:37:48 +0530
Subject: RE: war deploy
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Date: Tue, 11 May 2004 18:37:48 +0530
content-class: urn:content-classes:message
Message-ID: <4421DECD1639A149826D84B0F3EE8F1F07FBE86C@fmg-op.opal.i-flex.com>
X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: war deploy
Thread-Index: AcQ3Ony7kFZ5q/fHQdKuDONnOPBTFgK4pQHw
From: <vinod.nayak@iflexsolutions.com>
To: <user@ant.apache.org>
X-OriginalArrivalTime: 11 May 2004 13:07:48.0963 (UTC)
 FILETIME=[F58E9B30:01C43758]
X-Spam-Rating: hermes.apache.org 1.6.2 0/1000/N
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

Hi All,

I have similar task like this in my build.xml

    <target name=3D"initdb" description=3D"Re-Compiles a procedure">
        <sql driver=3D"${jdbc.mysql.driver}"
            classpathref=3D"jdbc.driver.cp"
            url=3D"${install.dburl}"
            userid=3D"" password=3D""
            print=3D"yes">
            <transaction src=3D"procdure.sql"/>
        </sql>
    </target>

Though the procedure successfully gets compiled in the SQL plus window
it does not through this Ant task.

Am I missing anything here.
It gives the SQL error at CURSOR declaration of the procedure.

Regards,
Vinod.

-----Original Message-----
From: Ivan Ivanov [mailto:rambiusparkisanius@yahoo.com]
Sent: Tuesday, May 11, 2004 2:55 PM
To: Ant Users List; pvalle@eprocess.fr
Subject: Re: war deploy


Hello Philippe,

a month ago I created a web app installion script,
which creates db for the app and deploys the war. I am
sending you the whole script (it is small). "deploy"
target will be of interest of you. I do not use tomcat
ant tasks, since deploying in tomcat is a matter of
single <copy>.=20

Note also that my "deploy" target should be invoked
when tomcat is _started_. Of course, you can start
tomcat via your ant script too. If you want this
message me and I will send you more scripts.

Regards Ivan

----  install.xml ----
<!DOCTYPE project [<!ENTITY package "iatinstall">]>
<project name=3D"iatinstall" default=3D"usage"
basedir=3D".">
    <description>IAT installation script; installs IAT
distribution</description>

    <target name=3D"usage">
    </target>

    <target name=3D"-init" depends=3D""
description=3D"Initializes the neccessary properties">
        <property environment=3D"env"/>
        <!-- Servlet Container Property -->
        <property name=3D"catalina.home"
value=3D"${env.CATALINA_HOME}"/>
        <property name=3D"jdbc.mysql.driver.lib"
value=3D"mysql-connector-java-3.0.6-stable-bin.jar"/>
        <property name=3D"jdbc.mysql.driver"
value=3D"org.gjt.mm.mysql.Driver"/>
        <property name=3D"install.lib"
value=3D"${basedir}/lib"/>
        <property name=3D"install.sql"
value=3D"${basedir}/sql"/>
        <property name=3D"install.dbname"
value=3D"iatbonea"/>
        <property name=3D"install.dburl"
value=3D"jdbc:mysql://localhost:3306/${install.dbname}"/>
        <property name=3D"install.context"
value=3D"iatbonea"/>
        <property name=3D"install.port" value=3D"8080"/>
        <property name=3D"install.httpurl"
value=3D"http://localhost:${install.port}/${install.context}/index.jsp"/>=

        <property name=3D"project.name"
value=3D"iatbonea"/>
        <path id=3D"jdbc.driver.cp">
            <pathelement
location=3D"${install.lib}/${jdbc.mysql.driver.lib}"/>
        </path>
    </target>

    <target name=3D"initdb" depends=3D"-init"
description=3D"Creates and populates iat tables">
        <sql driver=3D"${jdbc.mysql.driver}"
            classpathref=3D"jdbc.driver.cp"
            url=3D"${install.dburl}"
            userid=3D"" password=3D""
            print=3D"yes">
            <transaction
src=3D"${install.sql}/create.sql"/>
            <transaction
src=3D"${install.sql}/insert.sql"/>
        </sql>
    </target>

    <target name=3D"deploy" depends=3D"-init"
description=3D"Deploys the IAT war">
        <copy file=3D"${basedir}/${project.name}.war"
todir=3D"${catalina.home}/webapps"/>
        <waitfor timeoutproperty=3D"time.out.property">
            <http url=3D"${install.httpurl}"/>
        </waitfor>
        <fail if=3D"time.out.property"
message=3D"Deployment failed. Check whether Tomcat
Service is started and if not start it."/>
        <echo message=3D"Deployment finished. IAT
application is ready to be accessed"/>
    </target>

</project>



--- Philippe Valle <pvalle@eprocess.fr> wrote:
> HI,
>=20
>=20
> how to deploy WAR file with ant 1.6.1 ( i use tomcat
> 4.1.29 ) :
>=20
>=20
> this lines in build.xml file doesnt works :
>=20
> <-- Configure the custom Ant tasks for the Manager
> application -->
>    <taskdef name=3D"deploy"   =20
> classname=3D"org.apache.catalina.ant.DeployTask"/>
>    <taskdef name=3D"install"  =20
> classname=3D"org.apache.catalina.ant.InstallTask"/>
>    <taskdef name=3D"list"    =20
> classname=3D"org.apache.catalina.ant.ListTask"/>
>    <taskdef name=3D"reload"   =20
> classname=3D"org.apache.catalina.ant.ReloadTask"/>
>    <taskdef name=3D"remove"   =20
> classname=3D"org.apache.catalina.ant.RemoveTask"/>
>    <taskdef name=3D"resources"=20
> classname=3D"org.apache.catalina.ant.ResourcesTask"/>
>    <taskdef name=3D"roles"    =20
> classname=3D"org.apache.catalina.ant.RolesTask"/>
>    <taskdef name=3D"start"    =20
> classname=3D"org.apache.catalina.ant.StartTask"/>
>    <taskdef name=3D"stop"    =20
> classname=3D"org.apache.catalina.ant.StopTask"/>
>    <taskdef name=3D"undeploy" =20
> classname=3D"org.apache.catalina.ant.UndeployTask"/>
>=20
>=20
> Thanks , for sample code .
>=20
> Philip
>=20
>=20
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> user-unsubscribe@ant.apache.org
> For additional commands, e-mail:
> user-help@ant.apache.org
>=20



=09
	=09
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs =20
http://hotjobs.sweepstakes.yahoo.com/careermakeover=20

---------------------------------------------------------------------
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