Postgres Pro
Downloads
Home   >   mailing lists

Thread: RTRIM always used with JDBC?

RTRIM always used with JDBC?

From
David Teran
Date:
Hi,

i am using Postgres 7.4.2 with jdbc. Every time i try to select a
varchar the SQL generated by the jdbc driver uses RTRIM(t0.columnname)
which breaks an existing application. Is this normal, can we disable
the RTRIM usage?

regards David

Re: RTRIM always used with JDBC?

From
Kris Jurka
Date:

On Sun, 16 May 2004, David Teran wrote:

> i am using Postgres 7.4.2 with jdbc. Every time i try to select a
> varchar the SQL generated by the jdbc driver uses RTRIM(t0.columnname)
> which breaks an existing application. Is this normal, can we disable
> the RTRIM usage?

I assume from this bold claim that you have written an SQL query like
"SELECT t0.columnname FROM ..." and enabled statement logging in the
server and seen the executed query come through as "SELECT
RTRIM(t0.columnname)  FROM ...".  If this is the case then you are not
using the community supported jdbc driver because it never uses rtrim, and
you need to contact whoever wrote the jdbc driver you are using.

If you are having some unspecified problem with trailing spaces you need
to provide a description of your actual problem and ideally a test case
rather than jumping to conclusions about the JDBC driver and RTRIM.

Kris Jurka

Re: RTRIM always used with JDBC?

From
David Teran
Date:
Hi Kris,


>> i am using Postgres 7.4.2 with jdbc. Every time i try to select a
>> varchar the SQL generated by the jdbc driver uses RTRIM(t0.columnname)
>> which breaks an existing application. Is this normal, can we disable
>> the RTRIM usage?
>
> I assume from this bold claim that you have written an SQL query like
> "SELECT t0.columnname FROM ..." and enabled statement logging in the
> server and seen the executed query come through as "SELECT
> RTRIM(t0.columnname)  FROM ...".  If this is the case then you are not
> using the community supported jdbc driver because it never uses rtrim,
> and
> you need to contact whoever wrote the jdbc driver you are using.
>
I use the JDBC driver from the postgres742 installation. But i am also
using a middleware / eor tool named webobjects from apple ... and one
of our sourcecodes superclasses generated the rtrim. Thanks for your
hint, it works now.

Regards David