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