[jira] [Created] (GROOVY-8612) sql query with empty parameter list returns errors

["Ludger Wolter (JIRA)" <ji...@apache.org>]

Ludger Wolter created GROOVY-8612:
-------------------------------------

             Summary: sql query with empty parameter list returns errors
                 Key: GROOVY-8612
                 URL: https://issues.apache.org/jira/browse/GROOVY-8612
             Project: Groovy
          Issue Type: Bug
          Components: SQL processing
    Affects Versions: 2.4.15
            Reporter: Ludger Wolter


{code:java}
import groovy.sql.Sql
import oracle.jdbc.driver.OracleConnection

def sql = Sql.newInstance("jdbc:oracle:thin:@dev6418:1521:l101", "allcus", "allcus", "oracle.jdbc.OracleDriver")
def sqlParams = [:]

def row = sql.firstRow('select count(*) icount from all_tables', Arrays.asList(sqlParams))
println row.icount
{code}
{code:java}
Mai 28, 2018 4:08:36 PM groovy.sql.Sql$AbstractQueryCommand execute
WARNUNG: Failed to execute: select count(*) icount from all_tables because: Ungültiger Spaltentyp
Mai 28, 2018 4:08:36 PM groovy.sql.Sql$AbstractQueryCommand execute
WARNUNG: Failed to execute: select count(*) icount from all_tables because: Ungültiger Spaltentyp
Exception thrown

java.sql.SQLException: Ungültiger Spaltentyp
	at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:10495)
	at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:9974)
	at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:10799)
	at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:10776)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.setObject(OraclePreparedStatementWrapper.java:241)
	at ConsoleScript8.run(ConsoleScript8:8)
{code}
{code:java}
def sqlParams = [a:1]{code}
also provides an error but following works

 {code}
def sqlParams = [a:1, b:1]

def row = sql.firstRow('select count(*) icount from all_tables where 1=:a', Arrays.asList(sqlParams))
{code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)