[GROOVY-2585] Can not insert nulls into the table using Sql.execute

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.5.4
• Fix Version/s: 1.5.5, 1.6-beta-1
• Component/s: SQL processing
• Environment: Windows XP
• Assignee: Paul King
• Reporter: Pavel Ganelin
• Created: 06/Feb/08 15:27
• Updated: 05/Nov/08 19:55
• Resolved: 08/Feb/08 17:12

Description

Running this script:

import groovy.sql.Sql

Sql sql = Sql.newInstance("jdbc:oracle:oci:@???, "???", "???", "oracle.jdbc.driver.OracleDriver")

sql.execute "CREATE TABLE TEST (A INT, B INT)"

sql.execute " insert into test (A,B) values (?,?)",         [10, 20]     // works OK
sql.execute " insert into test (A,B) values (?,?)",         [10, null]  // fails

Results in:

Caught: java.sql.SQLException: ORA-01008: not all variables bound
	at test.run(test.groovy:11)
	at test.main(test.groovy)

AFAIK, th problem lies with the following code (groovy.sql.Sql.java: 1390)

            if (value != null) {
                setObject(statement, i++, value);

I think it should be

            if (value != null) {
                setObject(statement, i++, value);
          else
                 statement.setNull(i, in.getType());

Issue Links

• is related to: GROOVY-2146 Can't insert null values into database