On 13/10/2011 15:03, shano.shanmugalingm wrote:
Is there a way to run SQLPLUS directly from build.gradle file.
I created a custom task, and added the following;
def db = [un : 'system', pw :'password',tns :'//localhost:1521/xe']
def sqlplus= """sqlplus ${db.un}/${db.pw}@${db.tns}
@script.sql""".execute()
sqlplus.in.eachLine { line -> println line }
this, task gets executed successfully. But It never quits SQLPLUS and keeps
waiting. I tried out different things posted in the web, and nothing seems
to work. Appreciate if some one could provide me a solution to come out of
this.
Well, since I don't what you tried already...
I haven't tried with Gradle, but I had to automate some SQLPLUS tasks and I exit it by
putting a simple
EXIT
at the end of the list of commands. Does it work for you?
--
Philippe Lhoste
-- (near) Paris -- France
-- http://Phi.Lho.free.fr
-- -- -- -- -- -- -- -- -- -- -- -- -- --
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email