This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Access DB Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Access DB" Watch "Access DB" New topic
Author

Access DB

Grishma Dube
Ranch Hand

Joined: Jul 01, 2003
Posts: 275
Hi,

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?

Grishma
Paul Sturrock
Bartender

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: http://aspose.com/file-tools
 
subject: Access DB
 
Similar Threads
java.sql.SQLException: [Micorsoft][ODBC Microsoft Access Driver] Too few parameters.
Problem in updating/deleting data from MS Access Database
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters.
SQL exception
BatchUpdateException : getUpdateCounts doesn't work properly