| Bug #18722 | moveToInsertRow fails: parameter index out of range (PreparedStatement) | ||
|---|---|---|---|
| Submitted: | 3 Apr 2006 3:31 | Modified: | 15 Jul 2006 21:50 |
| Reporter: | [ name withheld ] | ||
| Status: | No Feedback | ||
| Category: | Connector/J | Severity: | S2 (Serious) |
| Version: | 3.1.12 | OS: | Mac OS X (Mac OS 10.4.5) |
| Assigned to: | Target Version: | ||
[3 Apr 2006 23:16]
Mark Matthews
Where is the INSERT sql coming from the driver, or something you've written?
[4 Apr 2006 2:18]
[ name withheld ]
From the driver.
[15 Jun 2006 21:50]
Mark Matthews
Can you test with 3.1.13, this looks like a duplicate of BUG#19724 which was fixed in that release.
[16 Jul 2006 1:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
Description: When I attempt to moveToInsertRow() on a result set, I get: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0). The insert SQL is: INSERT INTO "music"."tune types" ("Total Measures","Type Description","Type ID","Parts","Root Type","Type Name","Meter","Measures Per Part") VALUES (?,?,?,?,?,?,?,?) It looks like the PreparedStatement has parsed the SQL incorrectly. When it finishes the first part of the parsing, inQuotes is true. My database is set to use UTF8 and ANSI mode. How to repeat: Use moveToInsertRow.