Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.

843853Sep 25 2001 — edited Sep 25 2001

When I try to update a table I take the above error no matter how many parmameters I use with the "Expected #" always being the number I'm passing +1. I don't have any MS manuals so I'm not sure where to turn. Here's the pertinent code that generated the error.

    private static final String UPDATE = "UPDATE ReachPct SET REACH_Percent = ?";

    prepStmt = JDBC.getConnection().prepareStatement(UPDATE);
    prepStmt.setDouble(1,reachPercent);
    prepStmt.executeUpdate();

Anyone know what other parameter MS is expecting?

TIA,
Row

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 23 2001

Added on Sep 25 2001

#java-database-connectivity-jdbc

2 comments

130 views