Thread: FW: JDBC Driver Munging My Text?

FW: JDBC Driver Munging My Text?

From

Hunter Hillegas

Date:

20 December 2001, 17:41:02

Forgot to add the list...


------ Forwarded Message
From: Hunter Hillegas <lists@lastonepicked.com>
Date: Thu, 20 Dec 2001 09:54:41 -0800
To: <Dave@micro-automation.net>
Subject: Re: [JDBC] JDBC Driver Munging My Text?

Sure...

The Java code is like this:

pst = con.prepareStatement("insert into news (rec_num, title, body, lead_in,
location, source, display_order, date_of_entry, entered_by, active_status)
values (nextval('news_seq'), ?, ?, ?, ?, ?, ?, ?, ?, ?)");

The news table looks like this:

CREATE TABLE news (
    rec_num integer NOT NULL PRIMARY KEY,
    title varchar(255),
    body text,
    lead_in text,
    location varchar(255),
    source varchar(255),
    display_order integer,
    date_of_entry date,
    entered_by integer REFERENCES users,
    active_status boolean
);

> From: "Dave Cramer" <Dave@micro-automation.net>
> Organization: Micro Automation Inc
> Reply-To: <Dave@micro-automation.net>
> Date: Thu, 20 Dec 2001 12:52:08 -0500
> To: "'Hunter Hillegas'" <lists@lastonepicked.com>, "'PostgreSQL'"
> <pgsql-general@postgresql.org>, "'Postgre JDBC'" <pgsql-jdbc@postgresql.org>
> Subject: RE: [JDBC] JDBC Driver Munging My Text?
>
> Hunter,
>
> Can you provide the insert statement that inserts this
>
> Dave
>
> -----Original Message-----
> From: pgsql-jdbc-owner@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Hunter Hillegas
> Sent: Thursday, December 20, 2001 11:45 AM
> To: PostgreSQL; Postgre JDBC
> Subject: [JDBC] JDBC Driver Munging My Text?
>
>
> We are seeing some strange behavior in our system that uses Postgres
> 7.1.3 and JDBC. System: Red Hat Linux 7.1/Intel.
>
> Basically what we are seeing is that text stored in a VARCHAR is entered
> like this: "hello, how are you" is stored like this: "hello ,how are
> you". Notice the space and comma being transposed...
>
> The plot thickens...
>
> This is on a new server. The old server, also running 7.1.3, though
> built quite a long time ago, does not exhibit this behavior.
>
> Any ideas? Known bug? Strange config? It is possible that I built the
> JDBC driver on the old machine and just copied it to the new machine...
> I can't remember but it shouldn't matter, should it?
>
> Thanks,
> Hunter
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

------ End of Forwarded Message

Re: JDBC Driver Munging My Text?

From

"Dave Cramer"

Date:

20 December 2001, 23:40:47

Hunter,

I was unable to replicate the problem. Would it be possible for you to
send a small piece of code that does replicate it?

Here is the code I tried with

      PreparedStatement pstmt = con.prepareStatement("insert into
testcomma (id,info,info2,num) values
(nextval('testcomma_id_seq'),?,?,?)");
      pstmt.setString(1,"hello, how are you");
      pstmt.setString(2,"how are you, today");
      pstmt.setInt(3,1);
    pstmt.execute()

My table looks like this

create table testcomma (id serial,info text, info2 text,num int);

Dave

-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Hunter Hillegas
Sent: Thursday, December 20, 2001 2:38 PM
To: Postgre JDBC
Subject: FW: [JDBC] JDBC Driver Munging My Text?


Forgot to add the list...


------ Forwarded Message
From: Hunter Hillegas <lists@lastonepicked.com>
Date: Thu, 20 Dec 2001 09:54:41 -0800
To: <Dave@micro-automation.net>
Subject: Re: [JDBC] JDBC Driver Munging My Text?

Sure...

The Java code is like this:

pst = con.prepareStatement("insert into news (rec_num, title, body,
lead_in, location, source, display_order, date_of_entry, entered_by,
active_status) values (nextval('news_seq'), ?, ?, ?, ?, ?, ?, ?, ?,
?)");

The news table looks like this:

CREATE TABLE news (
    rec_num integer NOT NULL PRIMARY KEY,
    title varchar(255),
    body text,
    lead_in text,
    location varchar(255),
    source varchar(255),
    display_order integer,
    date_of_entry date,
    entered_by integer REFERENCES users,
    active_status boolean
);

> From: "Dave Cramer" <Dave@micro-automation.net>
> Organization: Micro Automation Inc
> Reply-To: <Dave@micro-automation.net>
> Date: Thu, 20 Dec 2001 12:52:08 -0500
> To: "'Hunter Hillegas'" <lists@lastonepicked.com>, "'PostgreSQL'"
> <pgsql-general@postgresql.org>, "'Postgre JDBC'"
> <pgsql-jdbc@postgresql.org>
> Subject: RE: [JDBC] JDBC Driver Munging My Text?
>
> Hunter,
>
> Can you provide the insert statement that inserts this
>
> Dave
>
> -----Original Message-----
> From: pgsql-jdbc-owner@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Hunter Hillegas
> Sent: Thursday, December 20, 2001 11:45 AM
> To: PostgreSQL; Postgre JDBC
> Subject: [JDBC] JDBC Driver Munging My Text?
>
>
> We are seeing some strange behavior in our system that uses Postgres
> 7.1.3 and JDBC. System: Red Hat Linux 7.1/Intel.
>
> Basically what we are seeing is that text stored in a VARCHAR is
> entered like this: "hello, how are you" is stored like this: "hello
> ,how are you". Notice the space and comma being transposed...
>
> The plot thickens...
>
> This is on a new server. The old server, also running 7.1.3, though
> built quite a long time ago, does not exhibit this behavior.
>
> Any ideas? Known bug? Strange config? It is possible that I built the
> JDBC driver on the old machine and just copied it to the new
> machine... I can't remember but it shouldn't matter, should it?
>
> Thanks,
> Hunter
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

------ End of Forwarded Message


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Re: JDBC Driver Munging My Text?

From

Hunter Hillegas

Date:

21 December 2001, 02:03:53

Sure!

This is what I am using:

//do the database action
PreparedStatement pst = con.prepareStatement("insert into news (rec_num,
title, body, lead_in, location, source, display_order, date_of_entry,
entered_by, active_status) values (nextval('news_seq'), ?, ?, ?, ?, ?, ?, ?,
?, ?)");

pst.clearParameters();
pst.setString(1, request.getParameter("title"));
pst.setString(2, request.getParameter("body"));
pst.setString(3, request.getParameter("lead_in"));
pst.setString(4, request.getParameter("location"));
pst.setString(5, request.getParameter("source"));
pst.setString(6, displayOrderID);
pst.setString(7, "NOW()");
pst.setString(8, theUserBean.getRecNum());
pst.setString(9, request.getParameter("active_status"));
pst.executeUpdate();
pst = null;

That inserts into the table as defined below... I'm only able to replicate
the problem on one machine... I think I am going to try to rebuild the
driver on the machine itself, to see if that helps.

Hunter

> From: "Dave Cramer" <Dave@micro-automation.net>
> Organization: Micro Automation Inc
> Reply-To: <Dave@micro-automation.net>
> Date: Thu, 20 Dec 2001 20:19:10 -0500
> To: "'Hunter Hillegas'" <lists@lastonepicked.com>, "'Postgre JDBC'"
> <pgsql-jdbc@postgresql.org>
> Subject: RE: [JDBC] JDBC Driver Munging My Text?
>
> Hunter,
>
> I was unable to replicate the problem. Would it be possible for you to
> send a small piece of code that does replicate it?
>
> Here is the code I tried with
>
>     PreparedStatement pstmt = con.prepareStatement("insert into
> testcomma (id,info,info2,num) values
> (nextval('testcomma_id_seq'),?,?,?)");
>     pstmt.setString(1,"hello, how are you");
>     pstmt.setString(2,"how are you, today");
>     pstmt.setInt(3,1);
> pstmt.execute()
>
> My table looks like this
>
> create table testcomma (id serial,info text, info2 text,num int);
>
> Dave
>
> -----Original Message-----
> From: pgsql-jdbc-owner@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Hunter Hillegas
> Sent: Thursday, December 20, 2001 2:38 PM
> To: Postgre JDBC
> Subject: FW: [JDBC] JDBC Driver Munging My Text?
>
>
> Forgot to add the list...
>
>
> ------ Forwarded Message
> From: Hunter Hillegas <lists@lastonepicked.com>
> Date: Thu, 20 Dec 2001 09:54:41 -0800
> To: <Dave@micro-automation.net>
> Subject: Re: [JDBC] JDBC Driver Munging My Text?
>
> Sure...
>
> The Java code is like this:
>
> pst = con.prepareStatement("insert into news (rec_num, title, body,
> lead_in, location, source, display_order, date_of_entry, entered_by,
> active_status) values (nextval('news_seq'), ?, ?, ?, ?, ?, ?, ?, ?,
> ?)");
>
> The news table looks like this:
>
> CREATE TABLE news (
>   rec_num integer NOT NULL PRIMARY KEY,
>   title varchar(255),
>   body text,
>   lead_in text,
>   location varchar(255),
>   source varchar(255),
>   display_order integer,
>   date_of_entry date,
>   entered_by integer REFERENCES users,
>   active_status boolean
> );
>
>> From: "Dave Cramer" <Dave@micro-automation.net>
>> Organization: Micro Automation Inc
>> Reply-To: <Dave@micro-automation.net>
>> Date: Thu, 20 Dec 2001 12:52:08 -0500
>> To: "'Hunter Hillegas'" <lists@lastonepicked.com>, "'PostgreSQL'"
>> <pgsql-general@postgresql.org>, "'Postgre JDBC'"
>> <pgsql-jdbc@postgresql.org>
>> Subject: RE: [JDBC] JDBC Driver Munging My Text?
>>
>> Hunter,
>>
>> Can you provide the insert statement that inserts this
>>
>> Dave
>>
>> -----Original Message-----
>> From: pgsql-jdbc-owner@postgresql.org
>> [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Hunter Hillegas
>> Sent: Thursday, December 20, 2001 11:45 AM
>> To: PostgreSQL; Postgre JDBC
>> Subject: [JDBC] JDBC Driver Munging My Text?
>>
>>
>> We are seeing some strange behavior in our system that uses Postgres
>> 7.1.3 and JDBC. System: Red Hat Linux 7.1/Intel.
>>
>> Basically what we are seeing is that text stored in a VARCHAR is
>> entered like this: "hello, how are you" is stored like this: "hello
>> ,how are you". Notice the space and comma being transposed...
>>
>> The plot thickens...
>>
>> This is on a new server. The old server, also running 7.1.3, though
>> built quite a long time ago, does not exhibit this behavior.
>>
>> Any ideas? Known bug? Strange config? It is possible that I built the
>> JDBC driver on the old machine and just copied it to the new
>> machine... I can't remember but it shouldn't matter, should it?
>>
>> Thanks,
>> Hunter
>>
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 6: Have you searched our list archives?
>>
>> http://archives.postgresql.org
>>
>
> ------ End of Forwarded Message
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

Re: JDBC Driver Munging My Text?

From

"Dave Cramer"

Date:

24 December 2001, 02:16:51

Hunter,

There must be something else going on here. I would be very interested
if rebuilding the driver works. It shouldn't!

You may want to try putting some logging statements in there to see what
is going on. It is puzzling. The fact that you can only replicate it on
one machine is troublesome

Dave

-----Original Message-----
From: Hunter Hillegas [mailto:lists@lastonepicked.com]
Sent: Thursday, December 20, 2001 10:50 PM
To: Dave@micro-automation.net; Postgre JDBC
Subject: Re: [JDBC] JDBC Driver Munging My Text?


Sure!

This is what I am using:

//do the database action
PreparedStatement pst = con.prepareStatement("insert into news (rec_num,
title, body, lead_in, location, source, display_order, date_of_entry,
entered_by, active_status) values (nextval('news_seq'), ?, ?, ?, ?, ?,
?, ?, ?, ?)");

pst.clearParameters();
pst.setString(1, request.getParameter("title")); pst.setString(2,
request.getParameter("body")); pst.setString(3,
request.getParameter("lead_in")); pst.setString(4,
request.getParameter("location"));
pst.setString(5, request.getParameter("source")); pst.setString(6,
displayOrderID); pst.setString(7, "NOW()"); pst.setString(8,
theUserBean.getRecNum()); pst.setString(9,
request.getParameter("active_status"));
pst.executeUpdate();
pst = null;

That inserts into the table as defined below... I'm only able to
replicate the problem on one machine... I think I am going to try to
rebuild the driver on the machine itself, to see if that helps.

Hunter

> From: "Dave Cramer" <Dave@micro-automation.net>
> Organization: Micro Automation Inc
> Reply-To: <Dave@micro-automation.net>
> Date: Thu, 20 Dec 2001 20:19:10 -0500
> To: "'Hunter Hillegas'" <lists@lastonepicked.com>, "'Postgre JDBC'"
> <pgsql-jdbc@postgresql.org>
> Subject: RE: [JDBC] JDBC Driver Munging My Text?
>
> Hunter,
>
> I was unable to replicate the problem. Would it be possible for you to

> send a small piece of code that does replicate it?
>
> Here is the code I tried with
>
>     PreparedStatement pstmt = con.prepareStatement("insert into
> testcomma (id,info,info2,num) values
> (nextval('testcomma_id_seq'),?,?,?)");
>     pstmt.setString(1,"hello, how are you");
>     pstmt.setString(2,"how are you, today");
>     pstmt.setInt(3,1);
> pstmt.execute()
>
> My table looks like this
>
> create table testcomma (id serial,info text, info2 text,num int);
>
> Dave
>
> -----Original Message-----
> From: pgsql-jdbc-owner@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Hunter Hillegas
> Sent: Thursday, December 20, 2001 2:38 PM
> To: Postgre JDBC
> Subject: FW: [JDBC] JDBC Driver Munging My Text?
>
>
> Forgot to add the list...
>
>
> ------ Forwarded Message
> From: Hunter Hillegas <lists@lastonepicked.com>
> Date: Thu, 20 Dec 2001 09:54:41 -0800
> To: <Dave@micro-automation.net>
> Subject: Re: [JDBC] JDBC Driver Munging My Text?
>
> Sure...
>
> The Java code is like this:
>
> pst = con.prepareStatement("insert into news (rec_num, title, body,
> lead_in, location, source, display_order, date_of_entry, entered_by,
> active_status) values (nextval('news_seq'), ?, ?, ?, ?, ?, ?, ?, ?,
> ?)");
>
> The news table looks like this:
>
> CREATE TABLE news (
>   rec_num integer NOT NULL PRIMARY KEY,
>   title varchar(255),
>   body text,
>   lead_in text,
>   location varchar(255),
>   source varchar(255),
>   display_order integer,
>   date_of_entry date,
>   entered_by integer REFERENCES users,
>   active_status boolean
> );
>
>> From: "Dave Cramer" <Dave@micro-automation.net>
>> Organization: Micro Automation Inc
>> Reply-To: <Dave@micro-automation.net>
>> Date: Thu, 20 Dec 2001 12:52:08 -0500
>> To: "'Hunter Hillegas'" <lists@lastonepicked.com>, "'PostgreSQL'"
>> <pgsql-general@postgresql.org>, "'Postgre JDBC'"
>> <pgsql-jdbc@postgresql.org>
>> Subject: RE: [JDBC] JDBC Driver Munging My Text?
>>
>> Hunter,
>>
>> Can you provide the insert statement that inserts this
>>
>> Dave
>>
>> -----Original Message-----
>> From: pgsql-jdbc-owner@postgresql.org
>> [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Hunter Hillegas
>> Sent: Thursday, December 20, 2001 11:45 AM
>> To: PostgreSQL; Postgre JDBC
>> Subject: [JDBC] JDBC Driver Munging My Text?
>>
>>
>> We are seeing some strange behavior in our system that uses Postgres
>> 7.1.3 and JDBC. System: Red Hat Linux 7.1/Intel.
>>
>> Basically what we are seeing is that text stored in a VARCHAR is
>> entered like this: "hello, how are you" is stored like this: "hello
>> ,how are you". Notice the space and comma being transposed...
>>
>> The plot thickens...
>>
>> This is on a new server. The old server, also running 7.1.3, though
>> built quite a long time ago, does not exhibit this behavior.
>>
>> Any ideas? Known bug? Strange config? It is possible that I built the

>> JDBC driver on the old machine and just copied it to the new
>> machine... I can't remember but it shouldn't matter, should it?
>>
>> Thanks,
>> Hunter
>>
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 6: Have you searched our list archives?
>>
>> http://archives.postgresql.org
>>
>
> ------ End of Forwarded Message
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>