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

java.sql.SQLException: [Micorsoft][ODBC Microsoft Access Driver] Too few parameters.

 
Bradley Wong
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
help!
i am trying to insert a record into access and i get the exception :
java.sql.SQLException: [Micorsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
i have checked the access field names, and types, and everything looks ok (spent about 6 hours checking everything!!!) the funy thing is that the program works when i update the access fields with numbers. but as soon as i put strings, i get the message above. but again, like i said, access and the insert query look like they are set up properly to accept the parameters from the query and update the db. any ideas anyone? i even tried to use a preparedStetment to get around it, but i get an error saying type mismatch. but cannot find a type problem anywhere.
thanks!!!
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Looks like you're going to have to paste some sample code for us then...
Dave
 
namita pa
Ranch Hand
Posts: 56
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
ya please send the query then we can try to solve the problem.....but anyway i'll try to mention here that you yourself please check that whether you are updating the record in the same order as the column in the tables.
------------------
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic