RE: [Bodington-developers] Problem with prepared statement in Postgresql

[Andrew B. <a.g...@le...>]

Thanks Jon, but the panic is now over.

The problem was an mvnForum one and was caused by a change to the data in
the database when we had to update the usernames to their IdP-qualified form
for Shib. I missed a field in one of the tables. When the database was
accessed by one of the mvnForum JSPs it produced a bug that looked very like
what we described.

Nothing was truncated - just duff data. Garbage in...

Aggie

-----Original Message-----
From: bod...@li...
[mailto:bod...@li...] On Behalf Of Jon
Maber
Sent: 20 April 2006 18:50
To: bod...@li...
Subject: Re: [Bodington-developers] Problem with prepared statement in
Postgresql

Looks like a little edit to the method;

String SqlDatabase.quotedSQL( String )

is required.  Proper SQL provides only one escape character ' which is
only used to represent the ' character within the string literal.
PostgreSQL has an additional non-standard escape method using back
slashes - will fix your problem but must only be used on postgreSQL
connections.

Jon

Andrew Booth wrote:
> Atif and I have found a problem with prepared statements and Postgresql.
>
> If one of the ? replacements is a string containing  an '@' character, the
> string gets truncated at that point.  Has anyone else noticed this?
Anyone
> got a work-around?
>
> Aggie
>
> ____________________________________________
> Andrew G Booth
> Professor of On-Line Learning
> Faculty of Biological Sciences
> Garstang Building
> University of Leeds
> Leeds LS2 9JT
> U.K.
> Tel: +44-113-343-3142  Fax: +44-113-343-3167
> email: a.g...@le...
> personal email should be sent to:
>        an...@ag...
> ____________________________________________
>
>
>
>
>
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job
easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Bodington-developers mailing list
> Bod...@li...
> https://lists.sourceforge.net/lists/listinfo/bodington-developers
>
>



-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job
easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Bodington-developers mailing list
Bod...@li...
https://lists.sourceforge.net/lists/listinfo/bodington-developers