groovy-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dinko Srko─Ź <dinko.sr...@gmail.com>
Subject Re: Oracle Insert Data from one table to another table using Groovy
Date Thu, 28 Jul 2016 08:34:45 GMT
Result is probably being displayed as null because `forEach` method in
fact returns `void`, which Groovy transforms into `null`, as it
expects a method to actually return something.

As for nothing being inserted, perhaps there is nothing to insert
(every ID in A is also in B)?

Cheers,
Dinko

On 27 July 2016 at 12:57, GroovyBeginner <groovybeginner@gmail.com> wrote:
> 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.

Mime
View raw message