On Thursday, March 27, 2014 2:57:14 PM UTC-7, Anteneh Mamo wrote:
>
> 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: Syntax error in SQL statement "WITH TMP1
> AS[*] (SELECT REQUEST_NO FROM QUOTE) SELECT TMP1.REQUEST_NO FROM TMP1";
> expected "., ("; SQL statement:
> WITH TMP1 AS (SELECT REQUEST_NO FROM QUOTE) SELECT TMP1.REQUEST_NO FROM
> TMP1 [42001-171]
>
> sql statement is fine as we are able to execute it successfully via sql
> developer.
>
> any help is appreciated.
>
> Thanks.
>
>
>
>
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
