Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Access DB

 
Grishma Dube
Ranch Hand
Posts: 275
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic