my dog learned polymorphism*
The moose likes Object Relational Mapping and the fly likes Sql Exception: inconsistent datatypes, need help Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Sql Exception: inconsistent datatypes, need help" Watch "Sql Exception: inconsistent datatypes, need help" New topic
Author

Sql Exception: inconsistent datatypes, need help

Tommi Vd
Ranch Hand

Joined: Apr 23, 2009
Posts: 49
Hi i have a problem when i want to get some date out of my oracle database:

The table is empty but normally that may not be the cause, this is the error:



This is the code that queries the database:



In my database there is a from date and a to date, both are stored as dates in the database...
the now Date is java.util

Anyone who has an idea?

regards,

Kwast
Emanuel Kadziela
Ranch Hand

Joined: Mar 24, 2005
Posts: 186
change "date = ?" to "date is null" and remove the extra parameter.
 
jQuery in Action, 2nd edition
 
subject: Sql Exception: inconsistent datatypes, need help