I guess I can give You a postgreSQL example, if that suits You. Under
unix/linux pgsql comes with a command line tool which you can easily
use. Here's the sample part of antfile - not tested, so no guarantees,
but I suppose it could look more or less like this:
<exec dir="." executable="pgsql">
<arg line="-i ./mystuff/mysqlscript.sql"/>
</exec>
Dig the ant docs a little to find out more. If I remember pgsql well,
this should probably work fine, if you'd have it accessible on the
system path.
Best regards,
Krzysztof
miro wrote:
> Thank you very much for your reply can you send me a simple example of using
> exec task to execute a sql file ?
> Thanks
> Miro
>
>
> Krzysztof Kucybała wrote:
>> I suppose the easies, though maybe not the smartest way to do it, would
>> be to use exec task. Of course that is only useful if you have a command
>> line interface for the db that You're trying to use. You could put this
>> in some *.sql file and have it exec-uted from ant. Does that help?
>>
>> Best regards,
>> Krzysztof
>>
>> temp temp wrote:
>>> I trying to execute small script using ant , here is the script
>>> SET NEWPAGE 0
>>> SET SPACE 0
>>> SET LINESIZE 80
>>> SET PAGESIZE 0
>>> SET ECHO OFF
>>> SET FEEDBACK OFF
>>> SET HEADING OFF
>>> SET MARKUP HTML OFF
>>> SET ESCAPE \
>>> SPOOL DELETEME.SQL
>>> select 'drop table ', table_name, 'cascade constraints \;' from
>>> user_tables
>>>
>>> how to run this script using ant sql task
>>> Thanks
>>> Miro
>>>
>>>
>>> ---------------------------------
>>> Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user
>>> panel and lay it on us.
>> ---------------------------------------------------------------------
>> 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
|