Build broken for JDK9

2016-07-26 Thread Russel Winder
It appears that the Asciidoctor part of the build has been moved from after the creation of the Groovy install to during. Since Asciidoctor appears incapable of running on JDK9, this has rendered the Groovy build broken on JDK9. Is there no JDK9 CI? -- Russel. ===

Re: Oracle Insert Data from one table to another table using Groovy

2016-07-26 Thread Russel Winder
It does seem a pity that Groovy only provides drivers of SQL statements when Groovy is a language superb for DSLs and builders. Python is very similar to Groovy in this respect and Python has SQLAlchemy which provides the low level SQL driving stuff, but also provides an expression language, DSL a

Re: Oracle Insert Data from one table to another table using Groovy

2016-07-26 Thread Dinko Srkoč
On 26 July 2016 at 15:47, GroovyBeginner wrote: > I tried this and facing the following issue > > groovy.lang.MissingPropertyException: No such property: ID for class: > oracle.jdbc.driver.OracleResultSetImpl I'm only guessing here because I can't run the code at the moment and I'd always avoided

Re: Oracle Insert Data from one table to another table using Groovy

2016-07-26 Thread GroovyBeginner
I tried this and facing the following issue groovy.lang.MissingPropertyException: No such property: ID for class: oracle.jdbc.driver.OracleResultSetImpl Possible solutions: row at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.unwrap(ScriptBytecodeAdapter.java:51) at org.codeh

Re: Oracle Insert Data from one table to another table using Groovy

2016-07-26 Thread ngalarneau
The notation $row is for use inside a string (called string interpolation). Try changing your sql.executeInsert line to: sql.executeInsert "INSERT INTO A (ID, Name) VALUES ($row.ID,$row.Name)" See: http://docs.groovy-lang.org/latest/html/documentation/index.html#_string_interpolation

Re: Oracle Insert Data from one table to another table using Groovy

2016-07-26 Thread Jochen Theodorou
On 26.07.2016 08:46, GroovyBeginner wrote: I have a requirement of inserting the data from table A into table B and am using Oracle database. My condition is am going to insert only those records which are not present in table B and am facing an issue of retrieving the current row column values