Re: OpenJPA problems running against PG 8.1

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Andrew Hastie <andrew(at)ahastie(dot)net>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: OpenJPA problems running against PG 8.1
Date: 2011-10-03 10:27:42
Message-ID: CA+0W9LMTSesV-bpHuYw5CLA7wTPjxTYZCGE-3=So0TKEYs_yxg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On 3 October 2011 22:31, Andrew Hastie <andrew(at)ahastie(dot)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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2011-10-03 11:04:19 Re: Moving to git
Previous Message Andrew Hastie 2011-10-03 10:17:51 Re: OpenJPA problems running against PG 8.1