Subject Re: PreparedStatements
Author Roman Rokytskyy
> I'm getting the following error when trying to set an SQL Date in a
> PreparedStatement:
>
> org.firebirdsql.jdbc.field.TypeConvertionException: Error converting
> to date.
> at org.firebirdsql.jdbc.field.FBField.setDate(FBField.java:744)
> at
>
org.firebirdsql.jdbc.AbstractPreparedStatement.setDate(AbstractPreparedStatement.java:191)
> at
>
com.atoc.datamig.AuditRecordProcessor.saveRecord(AuditRecordProcessor.java:271)
>
> which implies that something is not overriding the setDate method
> somewhere.

Exactly. Can you provide a test case or describe in details datatypes
that you have in your query. Note, according to JDBC specs you can
convert java.sql.Date to java.sql.Timestamp and String. No other
conversions are possible.

Roman