• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

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

 
Ranch Hand
Posts: 36
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
I am trying to execute this query
SELECT Format(Appointments.AppointmentStartDateTime, "mm/dd/yyyy h") + ':00:00' As ModeDateTime From Appointments
after executing it gave the following error :
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters.
My Back End is Access and iam using jdbc-odbc bridge.
Any solutions ?
Prashant
 
Ranch Hand
Posts: 1514
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
It seems like the DB does not support something. You may need to post some more code.
 
prashant komaragiri
Ranch Hand
Posts: 36
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by Bosun Bello:
It seems like the DB does not support something. You may need to post some more code.


Hi Bosun
That is the Query which iam executing. The query is working fine in MS Access 2000 Sql Window.This query iam Executing through a jsp page Using tomcat.
Prashant
 
Ranch Hand
Posts: 173
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
The JDBC-ODBC bridge is not recommended for production use, as it's more like a reference implementation. Visit Sun's JDBC drivers page to find another driver that can work with Access.
Also, you may want to try the MSDN advanced search page for articles that address the "too few parameters" issue. It has always been a difficult one to track down for me, but I haven't developed against Access in many, many months.
Good luck,
Craig
[ May 28, 2002: Message edited by: Craig Demyanovich ]
 
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by prashant komaragiri:
Hi,
I am trying to execute this query
SELECT Format(Appointments.AppointmentStartDateTime, "mm/dd/yyyy h") + ':00:00' As ModeDateTime From Appointments
after executing it gave the following error :
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters.
My Back End is Access and iam using jdbc-odbc bridge.
Any solutions ?
Prashant


Prashant: This error can occur if you mispelled the table or column names in your SQL statement. double check your spelling
Jamie
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic