Re: OpenJPA problems running against PG 8.1 - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: OpenJPA problems running against PG 8.1
Date
Msg-id CA+0W9LMTSesV-bpHuYw5CLA7wTPjxTYZCGE-3=So0TKEYs_yxg@mail.gmail.com
Whole thread Raw
In response to OpenJPA problems running against PG 8.1  (Andrew Hastie <andrew@ahastie.net>)
List pgsql-jdbc
On 3 October 2011 22:31, Andrew Hastie <andrew@ahastie.net> wrote:

> 2011-09-30 14:29:41 BST ERROR:  invalid escape string
> 2011-09-30 14:29:41 BST HINT:  Escape string must be empty or one character.
> 2011-09-30 14:29:41 BST STATEMENT:  SELECT t0.id, t0.identificationMask,
> t0.productName FROM DBTYPE t0 WHERE (t0.identificationMask LIKE $1
> ESCAPE '\\')
> 2011-09-30 14:29:41 BST ERROR:  current transaction is aborted, commands
> ignored until end of transaction block

> So, does this mean OpenJPA needs a version dependent dictionary
> definition for Postgres from now on? Anybody got any better solutions or
> care to confirm what I'm seeing?

If you use E''-style strings it will be less version-dependent - that
syntax was added a while back (in 8.1?)

Oliver

pgsql-jdbc by date:

Previous
From: Andrew Hastie
Date:
Subject: Re: OpenJPA problems running against PG 8.1
Next
From: Dave Cramer
Date:
Subject: Re: Moving to git