[
https://issues.apache.org/jira/browse/DERBY-3046?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Daniel John Debrunner updated DERBY-3046:
-----------------------------------------
Component/s: Network Client
JDBC
> 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
> 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.
