Thread: Mysterious vanishing '

Mysterious vanishing '

From
tony
Date:
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


Re: Mysterious vanishing '

From
"Dave Cramer"
Date:
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



Re: Mysterious vanishing '

From
Barry Lind
Date:
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
>
>



Re: Mysterious vanishing '

From
"Anthony Kwok"
Date:
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
>

Re: Mysterious vanishing '

From
tony
Date:
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


Re: Mysterious vanishing '

From
"Dave Cramer"
Date:
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
>


Re: Mysterious vanishing '

From
Barry Lind
Date:
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
>
>



Re: Mysterious vanishing '

From
tony
Date:
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