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


Reply via email to