Re: Mysterious vanishing '

Tony,

Are you logging postgres ? If so have a look at the logs and see what is
being inserted. I suspect it is the driver.

One thing you can do is upgrade the driver to 7.2 from
jdbc.postgresql.org. Many things have been fixed in the latest version

Dave

-----Original Message-----
From: pgsql-jdbc-owner(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of tony
Sent: Friday, February 08, 2002 12:41 PM
To: pgsql-jdbc(at)postgresql(dot)org
Subject: [JDBC] Mysterious vanishing '

I have been beating my brows on this one for some time.

Postgresql upgraded to 7.1.3 using rpm for Red Hat 7.2

Tomcat upgraded to 4.01 using binaries for above

The JDBC driver is from the rpm.

My web application which was happily writing "'" to the database isn't
anymore. I believe that this is a JDBC issue. The application returns
"'" from the database without problems. There is no change in the JSP
being used to write the data.

If I manually escape the ' like so \' it works just fine.

So the guilty party - Tomcat or the JDBC?

Cheers

Tony Grant

--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org