Обсуждение: 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
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@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of tony Sent: Friday, February 08, 2002 12:41 PM To: pgsql-jdbc@postgresql.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
Tony, Can you send a standalone test case that reproduces the problem? thanks, --Barry tony wrote: > 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 > >
Can the latest JDBC driver for 7.2 also working with PostgreSQL 7.1.3? Is it stable enough at the moment? Anthony > -----Original Message----- > From: pgsql-jdbc-owner@postgresql.org > [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Dave Cramer > Sent: Saturday, February 09, 2002 2:02 AM > To: 'tony'; pgsql-jdbc@postgresql.org > Subject: Re: [JDBC] 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@postgresql.org > [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of tony > Sent: Friday, February 08, 2002 12:41 PM > To: pgsql-jdbc@postgresql.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 > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >
On Fri, 2002-02-08 at 19:31, Barry Lind wrote: > Can you send a standalone test case that reproduces the problem? This is a standard Ultradev JSP application. All code is written by Ultradev. If I write into a form "histoire de l'art" and do an update on the table I get an error. If I put "histoire de l\'art" in the same form the update succeeds. If I write into a search form "histoire de l'art" it correctly returns the list of all documents concerned. Using 7.1.1 and Tomcat 3.32 with a JDBC driver that I downloaded from jdbc.postgresql.org (I believe it was the 7.1.3 jdbc driver) everything worked just fine. I will try a 7.2 jdbc driver to see what happens. Unfortunately the security on my clients network is so good I can't ssh in anymore so I'll test on Monday. 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
Yes the latest driver works with 7.1.3, and as far as stability goes, there are no show stoppers out there that I am aware of. Dave -----Original Message----- From: Anthony Kwok [mailto:anthonykwok@writeme.com] Sent: Friday, February 08, 2002 9:50 PM To: Dave@micro-automation.net; pgsql-jdbc@postgresql.org Subject: RE: [JDBC] Mysterious vanishing ' Can the latest JDBC driver for 7.2 also working with PostgreSQL 7.1.3? Is it stable enough at the moment? Anthony > -----Original Message----- > From: pgsql-jdbc-owner@postgresql.org > [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Dave Cramer > Sent: Saturday, February 09, 2002 2:02 AM > To: 'tony'; pgsql-jdbc@postgresql.org > Subject: Re: [JDBC] 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@postgresql.org > [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of tony > Sent: Friday, February 08, 2002 12:41 PM > To: pgsql-jdbc@postgresql.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 > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >
Yes and Yes. If you wait until monday I will have the final 7.2 driver posted to the website. The build that is there currently is missing one bugfix that is included in 7.2 final. thanks, --Barry Anthony Kwok wrote: > Can the latest JDBC driver for 7.2 also working with PostgreSQL 7.1.3? Is it stable enough at the moment? > > Anthony > > >>-----Original Message----- >>From: pgsql-jdbc-owner@postgresql.org >>[mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Dave Cramer >>Sent: Saturday, February 09, 2002 2:02 AM >>To: 'tony'; pgsql-jdbc@postgresql.org >>Subject: Re: [JDBC] 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@postgresql.org >>[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of tony >>Sent: Friday, February 08, 2002 12:41 PM >>To: pgsql-jdbc@postgresql.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 >> >> >> >>---------------------------(end of broadcast)--------------------------- >>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >> >> > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > >
On Fri, 2002-02-08 at 19:02, Dave Cramer wrote: > 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 OK it is fixed in 7.2 Now _all_ I have to do is modify my pages... Don't hold your breath but Tomcat 4.01 stuff should be online next week Thanks Cheers Tony -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html Macromedia UltraDev with PostgreSQL http://www.animaproductions.com/ultra.html