What kind of Date object are you using? There's the standard java.util.Date,
and then there's java.sql.Date passed into and returned by SQL queries. You may
need to convert from one to the other. The best way to do that is by using a
java.util.Calendar object.
Hope this helps.
- Roby
"Heijns, P.J.B." wrote:
> Hi
>
> I use interbase and tomcat. I have made a jsp page, where I do a select
> query on the database. When I query a table with a date object in it, the
> jsp page generates the following error:
> "javax.servlet.servletexecption: [interclient] [interbase] Dynamic sql error
> sql error code = -804
> data type unknown
> Client sql dialect 1 does not support reference to DATE datatype"
>
> If I do a select query on a table without a date object, everyting goes
> fine.
> What do I wrong?
>
> Thanks Pieter
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, email: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
