In memory H2 and postgres date function
petek
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
Peter Yuill
> 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 ?
DATE is a legacy function in PostgreSQL, use CURRENT_DATE or
CURRENT_TIMESTAMP instead (supported in both H2 and PostgreSQL)
Regards,
Peter
Peter Yuill
> org.h2.jdbc.JdbcSQLException: Column "DATE" not found; SQL statement:
> Select * from ****** where *******_date< date ? [42122-163]
Should have taken the time to wake up. The date literal in H2 cannot
take a parameter as PostgreSQL does. There is no directly compatible syntax.
Regards,
Peter
Thomas Mueller
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
> --
> You received this message because you are subscribed to the Google Groups "H2 Database" group.
> To post to this group, send email to h2-da...@googlegroups.com.
> To unsubscribe from this group, send email to h2-database...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
>
petek
Looks like I'll have to sort out the legacy SQL before switching to an
in memory DB for unit tests.
A job thats well overdue !!
With Thanks
Peter
On Feb 9, 5:27 am, Thomas Mueller <thomas.tom.muel...@gmail.com>
wrote:
>
> 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
>