db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sebb (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-3046) setObj(int,Object,int) causes NPE if no parameter markers are present; should generate SQLException as for setObject(int,Object)
Date Tue, 04 Sep 2007 16:18:44 GMT
setObj(int,Object,int) causes NPE if no parameter markers are present; should generate SQLException
as for setObject(int,Object)
--------------------------------------------------------------------------------------------------------------------------------

                 Key: DERBY-3046
                 URL: https://issues.apache.org/jira/browse/DERBY-3046
             Project: Derby
          Issue Type: Bug
    Affects Versions: 10.3.1.4
            Reporter: Sebb
            Priority: Minor


Change WwdClientExample so that there are no parameters, e.g.

psInsert = conn.prepareStatement("insert into WISH_LIST(WISH_ITEM) values ('?')");

Now change 
   psInsert.setString(1,answer);
to
  psInsert.setObject(1,answer);

and the error is OK:

SQLState:   XCL14
Severity: 20000
Message:  The column position '1' is out of range.  The number of columns for this ResultSet
is '0'.
java.sql.SQLException: The column position '1' is out of range.  The number of columns for
this ResultSet is '0'.
[...]

However, using:

psInsert.setObject(1,answer,java.sql.Types.VARCHAR);

causes an NPE:

java.lang.NullPointerException
        at org.apache.derby.client.am.PreparedStatement.checkForValidParameterIndex(Unknown
Source)
        at org.apache.derby.client.am.PreparedStatement.setObjectX(Unknown Source)
        at org.apache.derby.client.am.PreparedStatement.setObject(Unknown Source)
        at WwdClientExample.main(WwdClientExample.java:93)

Surely it should behave the same as the previous method call - i.e. return an SQLException?

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message