ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Clinton Begin" <clinton.be...@gmail.com>
Subject Re: Upgrading from PostgreSQL 8.1 to 8.3 and escaping special characters
Date Tue, 19 Aug 2008 14:26:18 GMT
FWIW:  iBATIS doesn't escape anything except for parameters through the
PreparedStatement#setXxxxxx() methods (which is the driver's
implementation).

Clinton

On Mon, Aug 18, 2008 at 11:56 AM, Warren Bell <warren@clarksnutrition.com>wrote:

> I am having a problem escaping certain characters like the apostrophe \'.n
>  in PostgreSQL 8.3 after upgradeing from 8.1  I am now getting the following
> error:
>
> syntax error at or near "S" at character 282
>
> that is referring to an apostrophe in an insert statement.
>
> I am not escaping this character in my code. I am assuming that Ibatis or
> the driver is escaping it. I am using the postgresql-8.3-603.jdbc3.jar as
> the driver.
>
> I have read that Postgres 8.3 now escapes special characters like this
> E'Joe\'s', but how do I get this to work without going through all my code
> and shouldn't this be done by the
> driver.
>
> Has anyone else had this problem after upgrading to Postgres 8.3? I have
> tried the Postgres users list and the Postgres JDBC users list and have
> gotten no where.
>
> --
> Thanks,
>
> Warren Bell
> 909-645-8864
> warren@clarksnutrition.com
>
>

Mime
View raw message