groovy-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Tetzlaff <tetzl...@skillsoftware.de>
Subject Re: Oracle Insert Data from one table to another table using Groovy
Date Wed, 27 Jul 2016 12:31:25 GMT
I guess you should do: "...values (${row.ID}, ${row.Name})

The curly brackets...


Am 27.07.2016 um 12:57 schrieb GroovyBeginner:
> I have tried the following code now and seems to be nothing is being inserted
> into the database table. I have executed the following code and the result
> is displayed as null.
>
> import groovy.sql.Sql;
> import java.sql.ResultSet;
> import java.util.Properties;
>
> sql = Sql.newInstance("jdbc:oracle:thin:@localhost:1521:XE","username",
> "password", "oracle.jdbc.driver.OracleDriver")
>      sql.eachRow("select ID, NAME from A where ID not in (select id from B)")
> { row->
>      sql.executeInsert "INSERT INTO A (ID, Name) VALUES ($row.ID,$row.Name)"
> }
>
>
>
> --
> View this message in context: http://groovy.329449.n5.nabble.com/Oracle-Insert-Data-from-one-table-to-another-table-using-Groovy-tp5734285p5734303.html
> Sent from the Groovy Dev mailing list archive at Nabble.com.
>

-- 

*Michael Tetzlaff*
Developer
tetzlaff@skillsoftware.de

Office: +49 69 153 2282 22
Mobil: +49 177 3000 633

Skill Software GmbH
Berger Straße 179-181
60385 Frankfurt
http://www.skillsoftware.de

*Sieger Telekom-Innovationspreis 2012*

Skill Software GmbH, Sitz: 60385 Frankfurt
Geschäftsführer: Edgar Reh, Klaus Szilvas
Amtsgericht Frankfurt am Main, HRB 33988
Umsatzsteuer-ID: DE 114211536


Mime
View raw message