Hi Pedro,
You have got the wrong parameterIndex in the PreparedStatement.setInt()
method. You should be using parameter 1 and parameter 2. (JDBC param
numbers start with 1), not 3.
Cheers,
Jesse
On 15/06/2010 23:18, Pedro Gontijo wrote:
I have a statement with 2 expressions:
insert into my_table (a, b) values (?, ?);
insert into another_table (c, d) values (?, ?);
Then I get a
org.h2.jdbc.JdbcSQLException: Invalid value "3" for parameter
"parameterIndex" [90008-137]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:
327)
at org.h2.message.DbException.get(DbException.java:167)
at
org.h2.message.DbException.getInvalidValueException(DbException.java:
213)
at
org.h2.jdbc.JdbcPreparedStatement.setParameter(JdbcPreparedStatement.java:
1251)
at
org.h2.jdbc.JdbcPreparedStatement.setInt(JdbcPreparedStatement.java:
301)
Any help?
Thanks in advance
Pedro Gontijo
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
