aspose file tools*
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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Sql Exception: inconsistent datatypes, need help
 
Similar Threads
java.net.SocketException: Connection reset
com.sun.mail.smtp.SMTPSendFailedException: 451 4.7.1 Please try again later
FTP server
Hibernate 3: java.sql.SQLException: Field 'passwordConfirmation' doesn't have a default value
Problem with LazyInitializationException