wood burning stoves 2.0*
The moose likes Ant, Maven and Other Build Tools and the fly likes sqlplus Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Engineering » Ant, Maven and Other Build Tools
Bookmark "sqlplus" Watch "sqlplus" New topic
Author

sqlplus

Macca Murray
Greenhorn

Joined: Oct 19, 2004
Posts: 9
I am using ant, and the sql task, i was wondering if anyone knew how to use the sqlplus script I have with the ant sql task?

at them moment it doesnt like the @ command which sqlplus uses to call other sql scripts, i know that you can manually call multiple scripts with the transaction tag, however, i have a butt load of scripts to run and it would be optimum to call them all from one script

please help, this is killing me

Thanks!
Lasse Koskela
author
Sheriff

Joined: Jan 23, 2002
Posts: 11962
    
    5
Would it be an option to call sqlplus using the <exec/> task?


Author of Test Driven (2007) and Effective Unit Testing (2013) [Blog] [HowToAskQuestionsOnJavaRanch]
Macca Murray
Greenhorn

Joined: Oct 19, 2004
Posts: 9
i dont know havent really tried it, ill give it ago and let you know, thanks for the idea
Macca Murray
Greenhorn

Joined: Oct 19, 2004
Posts: 9
this is what i have



but i dont think it is working, it looks like it works, but all it does is:

[exec] Connected to:
[exec] Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
[exec] With the Partitioning, OLAP and Oracle Data Mining options
[exec] JServer Release 9.2.0.4.0 - Production

[exec] 104 Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
[exec] With the Partitioning, OLAP and Oracle Data Mining options
[exec] JServer Release 9.2.0.4.0 - Production

so it connects, then disconnects strait away, any ideas?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: sqlplus