You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ant.apache.org by Caleandro <ka...@katamail.com> on 2006/12/19 14:29:06 UTC
Ant-sql task in rel 1.7.0
Hi all,
Please, I need help about ant <sql> task.
A script like this:
<?xml version="1.0" encoding="ISO-8859-1"?>
<project name="ANT-SQL Test " basedir="." default="all">
<tstamp />
<target name="all" depends="provasql"/>
<target name="provasql">
<sql driver="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@lnx02svim:1521:svilpdd"
userid="myuserid"
password="mypswd"
print="true"
autocommit="true"
output="d:\myresultDir\resultset.txt"
classpath="d:\LibsDir\classes12.jar">
Select * from SCHEMA1.Table01;
</sql>
</target>
</project>
runs correctly (as is) in ant 1.6.5 but in 1.7.0 it seem to hang-up and loop
indefinitely
till I type a break key on keyboard.
Oracle(9i) server console does not signal any query or activity apart my
connection.
Where could be the problem?
Thanks to anyone for some suggestion.
Vito
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org
Re: R: Ant-sql task in rel 1.7.0
Posted by Peter Reilly <pe...@gmail.com>.
On 12/20/06, Caleandro <ka...@katamail.com> wrote:
> Hi Peter,
> Thank you for suggestion,
> it was right.
>
> As consequence I could verify that the -noproxy option is due in other
> situation as well, like posting an http request via Canoo-WebTest tasks and
> so on (related Ant 1.7.0RC1 and Java 1.5).
>
> But please, can you explain to me why this, as the Ant manual is very poor
> about the argument?
The ant manual on the web page is for the released version of
ant.
-noproxy is an option that was only in ant1.7.0Beta1-3 and ant1.7.0rc1,
it does not exist in ant 1.7.0. (due to issues like you encountered)
ant 1.7.0 (like ant 1.6.5) does not enable the system proxy by
default, but does allow it to be set (unlike ant 1.6.5) by
using -autoproxy
see: http://ant.apache.org/manual/running.html#options
Peter
>
> Thanks,
> Vito
>
> > -----Messaggio originale-----
> > Da: Peter Reilly [mailto:peter.kitt.reilly@gmail.com]
> > Inviato: martedì 19 dicembre 2006 14.35
> > A: Ant Users List
> > Oggetto: Re: Ant-sql task in rel 1.7.0
> >
> >
> > Are you using ant 1.7.0RC1 ?
> > If so, try using ant -noproxy
> >
> > Peter
> >
> > On 12/19/06, Caleandro <ka...@katamail.com> wrote:
> > > Hi all,
> > >
> > > Please, I need help about ant <sql> task.
> > > A script like this:
> > >
> > > <?xml version="1.0" encoding="ISO-8859-1"?>
> > > <project name="ANT-SQL Test " basedir="." default="all">
> > > <tstamp />
> > > <target name="all" depends="provasql"/>
> > > <target name="provasql">
> > > <sql driver="oracle.jdbc.driver.OracleDriver"
> > > url="jdbc:oracle:thin:@lnx02svim:1521:svilpdd"
> > > userid="myuserid"
> > > password="mypswd"
> > > print="true"
> > > autocommit="true"
> > > output="d:\myresultDir\resultset.txt"
> > > classpath="d:\LibsDir\classes12.jar">
> > > Select * from SCHEMA1.Table01;
> > > </sql>
> > > </target>
> > > </project>
> > >
> > > runs correctly (as is) in ant 1.6.5 but in 1.7.0 it seem to
> > hang-up and loop
> > > indefinitely
> > > till I type a break key on keyboard.
> > > Oracle(9i) server console does not signal any query or activity apart my
> > > connection.
> > >
> > > Where could be the problem?
> > >
> > > Thanks to anyone for some suggestion.
> > >
> > > Vito
> > >
> > >
> > > ---------------------------------------------------------------------
> > > 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
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org
R: Ant-sql task in rel 1.7.0
Posted by Caleandro <ka...@katamail.com>.
Hi Peter,
Thank you for suggestion,
it was right.
As consequence I could verify that the -noproxy option is due in other
situation as well, like posting an http request via Canoo-WebTest tasks and
so on (related Ant 1.7.0RC1 and Java 1.5).
But please, can you explain to me why this, as the Ant manual is very poor
about the argument?
Thanks,
Vito
> -----Messaggio originale-----
> Da: Peter Reilly [mailto:peter.kitt.reilly@gmail.com]
> Inviato: martedì 19 dicembre 2006 14.35
> A: Ant Users List
> Oggetto: Re: Ant-sql task in rel 1.7.0
>
>
> Are you using ant 1.7.0RC1 ?
> If so, try using ant -noproxy
>
> Peter
>
> On 12/19/06, Caleandro <ka...@katamail.com> wrote:
> > Hi all,
> >
> > Please, I need help about ant <sql> task.
> > A script like this:
> >
> > <?xml version="1.0" encoding="ISO-8859-1"?>
> > <project name="ANT-SQL Test " basedir="." default="all">
> > <tstamp />
> > <target name="all" depends="provasql"/>
> > <target name="provasql">
> > <sql driver="oracle.jdbc.driver.OracleDriver"
> > url="jdbc:oracle:thin:@lnx02svim:1521:svilpdd"
> > userid="myuserid"
> > password="mypswd"
> > print="true"
> > autocommit="true"
> > output="d:\myresultDir\resultset.txt"
> > classpath="d:\LibsDir\classes12.jar">
> > Select * from SCHEMA1.Table01;
> > </sql>
> > </target>
> > </project>
> >
> > runs correctly (as is) in ant 1.6.5 but in 1.7.0 it seem to
> hang-up and loop
> > indefinitely
> > till I type a break key on keyboard.
> > Oracle(9i) server console does not signal any query or activity apart my
> > connection.
> >
> > Where could be the problem?
> >
> > Thanks to anyone for some suggestion.
> >
> > Vito
> >
> >
> > ---------------------------------------------------------------------
> > 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
Re: Ant-sql task in rel 1.7.0
Posted by Peter Reilly <pe...@gmail.com>.
Are you using ant 1.7.0RC1 ?
If so, try using ant -noproxy
Peter
On 12/19/06, Caleandro <ka...@katamail.com> wrote:
> Hi all,
>
> Please, I need help about ant <sql> task.
> A script like this:
>
> <?xml version="1.0" encoding="ISO-8859-1"?>
> <project name="ANT-SQL Test " basedir="." default="all">
> <tstamp />
> <target name="all" depends="provasql"/>
> <target name="provasql">
> <sql driver="oracle.jdbc.driver.OracleDriver"
> url="jdbc:oracle:thin:@lnx02svim:1521:svilpdd"
> userid="myuserid"
> password="mypswd"
> print="true"
> autocommit="true"
> output="d:\myresultDir\resultset.txt"
> classpath="d:\LibsDir\classes12.jar">
> Select * from SCHEMA1.Table01;
> </sql>
> </target>
> </project>
>
> runs correctly (as is) in ant 1.6.5 but in 1.7.0 it seem to hang-up and loop
> indefinitely
> till I type a break key on keyboard.
> Oracle(9i) server console does not signal any query or activity apart my
> connection.
>
> Where could be the problem?
>
> Thanks to anyone for some suggestion.
>
> Vito
>
>
> ---------------------------------------------------------------------
> 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