Hi,
You are using invalid syntax. Try:
* from ****** where *******_date < ?
(remove the keyword "date"). This will work in both PosgreSQL and H2
(and other databases).
Regards,
Thomas
On Wed, Feb 8, 2012 at 8:31 AM, petek <[email protected]> wrote:
> Hi,
> I'm running H2 in memory in postgres compatibility mode:
> jdbc:h2:mem:test;MODE=PostgreSQL
>
> I'm getting a driver error around the DATE function:
>
> org.h2.jdbc.JdbcSQLException: Column "DATE" not found; SQL statement:
> Select * from ****** where *******_date < date ? [42122-163]
>
> Looks like driver is not recognising date as a function.
> Is this date function not supported by H2 PostgreSQL compatibility
> mode ? or am I using the driver incorrectly ?
> I've searched user groups & H2 documentation for an answer and havent
> got any further.
> I undertand H2 is an open source project so I can refer to source
> code, but if someone could give me a hand pointing me in the right
> direction that would be a great help.
> With Thanks
> Peter
>
> --
> You received this message because you are subscribed to the Google Groups "H2
> Database" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> For more options, visit this group at
> http://groups.google.com/group/h2-database?hl=en.
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
