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: Syn
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
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 is
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 create
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