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

Re: JDBC Support for standard_conforming_strings

From: Kris Jurka <books(at)ejurka(dot)com>
To: Michael Paesold <mpaesold(at)gmx(dot)at>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: JDBC Support for standard_conforming_strings
Date: 2006-11-06 06:36:04
Message-ID: Pine.BSO.4.63.0611060130450.23864@leary2.csoft.net (view raw or flat)
Thread:
Lists: pgsql-jdbc

On Sun, 5 Nov 2006, Michael Paesold wrote:

> Regarding standard_conforming_strings, I am currently reading through the 
> code and looking at all places that need to understand string escaping rules.
>
> I have found two issues where I need more advice:
>
> arrays (org.postgresql.jdbc2.AbstractJdbc2Array)
> bytea (org.postgresql.util.PGbytea)
>
> As far as I understand, quoting in arrays and bytea only changes as far as 
> the types are passing through the backend parser as string-literals. Correct?
>
> Since the result of AbstractJdbc2Array.toString() and PGbytea.toPGString() 
> will be fed to PreparedStatement.setString() in the end, we do not have to 
> change the array or bytea code. Is this reasoning valid?

Right.  The parameters will either be sent out of line which won't require 
escaping or for the V2 path they will be sent in the query, but it isn't 
the array or bytea codes' responsibility to escape them correctly.  The 
code in core(dot)v2(dot)SimpleParameterList(at)setStringParameter should handle that 
for us.

Kris Jurka

In response to

Responses

pgsql-jdbc by date

Next:From: Michael PaesoldDate: 2006-11-06 21:59:51
Subject: Re: JDBC Support for standard_conforming_strings
Previous:From: Kris JurkaDate: 2006-11-06 05:50:09
Subject: Re: [PATCH] Comments in PGbytea byte[] to pgstring conversion

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