You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Mamta A. Satoor (JIRA)" <ji...@apache.org> on 2007/10/19 22:34:51 UTC
[jira] Assigned: (DERBY-3046) setObj(int,Object,int) causes NPE if
no parameter markers are present; should generate SQLException as for
setObject(int,Object)
[ https://issues.apache.org/jira/browse/DERBY-3046?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mamta A. Satoor reassigned DERBY-3046:
--------------------------------------
Assignee: Mamta A. Satoor
> 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
> Components: JDBC, Network Client
> Affects Versions: 10.3.1.4
> Reporter: Sebb
> Assignee: Mamta A. Satoor
> 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.