Thanks a lot for your help with this. 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 <[email protected]> wrote: > 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 inpostgrescompatibility 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 > > athttp://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.
