Java Database Connectivity (JDBC)

... cannot format given Object as a Date...

I know the date-problem is frequently raised here (shame on me), but I haven't found neither a question or a reply which (I think) suits my problem.

So if anyone could give me a hint on this, it would be very, very appreciated... The problem:

I'm using a JTable-class(GUI), with a resultSetTableModel class and a SQLContainer class (sort of). In the JTable I display the date of an item purchase, a persons birth... or. Dates. This works fine as long as my SQL-query does not include a WHERE-clause. When the WHERE-clause is included, which is suppose to be the case, I get the java.lang.IllegalArgumentException cannot format given object as a date.

I am not using prepared statements. If anyone responds to my message, could you also give me a hint on benefits of using prepared statements.

thanks,

gmtongar