Re: [h2] How does H2 DB support TIMESTAMP WITH TIMEZONE DATATYPE

2014-03-27 Thread Noel Grandin
Well, this is an open-source project, so patches are always welcome :-) But that being said, I might have some time to work on this in the next few weeks, provided that you can provide me with some input: Do you know (a) what the most common string representation of such a datatype is (b) how

[h2] Re: Inserting into View not supported

2014-03-27 Thread Martin Schmiedel
Hi Thomas, I'm bringing this old thread back to life, but it's still better than starting a new one with the same issue. I'm running into the same situation, but I really don't want to create a trigger in this way (with a Java Class). Is there a way to do the same thing without having to

Re: [h2] Re: Inserting into View not supported

2014-03-27 Thread Rami Ojares
I feel your pain. I would like to be rich. You know like filthy rich. But the banks simply refuse to give me the money! - Rami Ps. View updateability is a complex issue and currently not implemented in a generic and complete fashion in ANY database in existence (afaik). The nice thing with h2

Re: [h2] Unique index or primary key violation: SYS_ID ON PUBLIC.SYS(ID) [23505-168] (using 1.3.168)

2014-03-27 Thread Dieter Cailliau
Thoms the database is attached to the first post of this topic. Op donderdag 20 maart 2014 07:53:26 UTC+1 schreef Thomas Mueller: Hi, I'm not using temporary tables I think there are some cases where Hibernate creates temporary tables, and for some queries (those that return many rows)

[h2] Syntax error in SQL statement WITH keyword

2014-03-27 Thread Anteneh Mamo
Hi, jdbc:h2:mem:request_no;MODE=Oracle We are using the h2 version 1.3.171 with windows 7 (64 bit) and jdk 1.7.0_25. when we try to run the sql statement : *WITH TMP1 AS (SELECT col1 FROM table1) SELECT TMP1.col1 FROM TMP1* . we are getting the below exception org.h2.jdbc.JdbcSQLException: