Issue Details (XML | Word | Printable)

Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Andy Jefferson
Reporter: Andy Jefferson
Votes: 0
Watchers: 0

If you were logged in you would be able to see more operations.
DataNucleus Store RDBMS

JDOQL2 : use of input parameters with multiple columns can lead to exception when applied directly

Created: 02/Apr/10 10:08 AM   Updated: 02/Apr/10 06:08 PM   Resolved: 02/Apr/10 10:10 AM
Component/s: Queries
Affects Version/s: 2.0.0.release, 2.0.1, 2.0.2, 2.0.3
Fix Version/s: 2.0.4, 2.1.0.m1

 Description  « Hide
Can get something like

Caused by: java.sql.SQLException: Parameter index out of range (19 > number of parameters, which is 7).
        at com.mysql.jdbc.SQLError.createSQLException(
        at com.mysql.jdbc.SQLError.createSQLException(
        at com.mysql.jdbc.SQLError.createSQLException(
        at com.mysql.jdbc.PreparedStatement.checkBounds(
        at com.mysql.jdbc.PreparedStatement.setInternal(
        at com.mysql.jdbc.PreparedStatement.setString(
        at com.mysql.jdbc.jdbc2.optional.PreparedStatementWrapper.setString(
        at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.setString(

Sort Order: Ascending order - Click to sort in descending order
Andy Jefferson added a comment - 02/Apr/10 10:10 AM
SVN trunk and branches/2.0 fix this

Marco Schulze added a comment - 02/Apr/10 06:08 PM
Works fine in JFire (i.e. real life use case).