File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Access DB Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Access DB" Watch "Access DB" New topic

Access DB

Grishma Dube
Ranch Hand

Joined: Jul 01, 2003
Posts: 275

I am trying to update a row in a Access database, with the following query.

"update inv set Flag='T' where uniq_id='"+uniq_id+"'";

I'm getting the following error:-

org.apache.jasper.JasperException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

When I am trying the same query with oracle, it is working fine.

Is there any syntax difference in Access?

Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

Is there any syntax difference in Access?

Yes - there are odd nuances in Access "SQL" you won't see anywhere else. But your statement should run fine in both DBs. Assuming there is a value for uniq_id that is.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
I agree. Here's the link:
subject: Access DB
It's not a secret anymore!