Hi, > Both the server and the client are using H2 1.4.186.
No, that's not the case. You reported the error message is "Column "TS" not found; SQL statement: select TS '2015-03-16 12:12:12.12' [42122-170]". The "170" at the end of the error code means you are using version 1.3.170 on the server side. Regards, Thomas On Wednesday, March 18, 2015, Andy Glick <[email protected]> wrote: > Noel, > > Thank you for your response, but I'm not sure how your answer, or the > changes to JDBC escape processing in release 1.4.181 impact the issue that > I am reporting. > > I am running an h2 in memory instance that is frontended by an H2 > networked server. I run this in a separate process from the application > which uses the same jdbc connect string as the database server process. > > "jdbc:h2:tcp://127.0.0.1/mem:top;MODE=Oracle;MVCC=TRUE;DEFAULT_LOCK_TIMEOUT=60000;DB_CLOSE_ON_EXIT=FALSE;" > > > > Both the server and the client are using H2 1.4.186. > > In addition I have run the H2 console again using 1.4.186 as the H2 > release and in the console the 2 Timestamp JDBC escape processing syntax > expressions fail, and the H2 console reports bad SQL > > > From the release notes that you are referring to I would have expected > that expressions such as > > TS '2015-03-17 12:12:12.12' > > { TS '2015-03-17 12:12:12.12' } > > ought to be handled by the SQL parser rather than throwing an exception if > the client and the server were running against the same H2 revision. > > That exceptions are being thrown is the problem that I have been trying to > report > > > in what I am seeing it looks as if the JDBC escape processing is now > broken for the syntax { TS '2015-03-17 12:12:12.12' } > > > > > > On 3/18/15 4:26 AM, Noel Grandin wrote: > > We had to change part of the client-server protocol, see the changelog > entry > > Version 1.4.182 Beta (2014-10-17) > The change in JDBC escape processing in version 1.4.181 affects both the > parser > (which is running on the server) and the JDBC API (which is running on > the client). > If you (or a tool you use) use the syntax "{t 'time}", or "{ts > 'timestamp'}", or "{d 'data'}", > then both the client and the server need to be upgraded to version > 1.4.181 or later. > > > -- > 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 [email protected] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
