Skip site navigation (1) Skip section navigation (2)

Re: Issue getColumns(): Nonstandard use of \\ in a string literal

From: Kris Jurka <books(at)ejurka(dot)com>
To: dv <dzenmassta(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Issue getColumns(): Nonstandard use of \\ in a string literal
Date: 2011-09-09 14:18:53
Message-ID: alpine.BSO.2.00.1109091017130.4040@leary.csoft.net (view raw or flat)
Thread:
Lists: pgsql-jdbc

On Fri, 9 Sep 2011, dv wrote:

> As of postgresql 9.1 defaulted to 
> standard_conforming_strings = on
> 
> These warnings are turned to the errors, so they cannot be ignored any more: 
> 
> 2011-09-09 14:41:06 MSD ERROR:  invalid escape string
> 2011-09-09 14:41:06 MSD HINT:  Escape string must be empty or one character.
> 2011-09-09 14:41:06 MSD STATEMENT:  SELECT COUNT(a0.id) FROM country a0
> WHERE a0."name" LIKE '%%' ESCAPE '\\'
> 

This certainly doesn't look like any JDBC driver generated SQL, so I'm not 
sure what your specific complaint here is.  It looks to me like you are 
using a hardcoded and incorrect escape string.  If you show the Java code 
associated with this, perhaps some more concrete advice could be offered.

Kris Jurka

In response to

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2011-09-09 14:25:05
Subject: Re: Patch: Some more state codes
Previous:From: Devrim GÜNDÜZDate: 2011-09-09 12:26:58
Subject: 9.1 driver status

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group