Re: RTRIM always used with JDBC? - Mailing list pgsql-general

From David Teran
Subject Re: RTRIM always used with JDBC?
Date
Msg-id 0FE6B61C-A7CB-11D8-8934-000A95C496AC@cluster9.com
Whole thread Raw
In response to Re: RTRIM always used with JDBC?  (Kris Jurka <books@ejurka.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Function with RETURN TYPE RECORD Called From JAVA
Next
From: Greg Stark
Date:
Subject: Re: fsync = true beneficial on ext3?