From: | Oliver Jowett <oliver(at)opencloud(dot)com> |
---|---|
To: | Daniel Henrique Alves Lima <email_daniel_h(at)yahoo(dot)com(dot)br> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Is it safe to use 8.0.14 server and 7.4 driver ? |
Date: | 2008-01-12 22:45:31 |
Message-ID: | 4789430B.1070003@opencloud.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Daniel Henrique Alves Lima wrote:
> The only way that i found to avoid break old applications is to
> use the driver pg74.216.jdbc3.jar (the driver
> pg73jdbc3.jar has a "set autocommit" issue) to access a 8.0.14 server.
This may or may not work but it's not supported.
> Which one of these behaviors is the right one ? Thanks in advance !
Both are equally correct, I believe. I think the JDBC spec is silent
about which column you get back if there is ambiguity.
The difference is because earlier drivers did a simple search through
the resultset column names on every access while newer drivers populate
a map of column names -> column indexes once. Doing a search every time
has performance problems.
I think your only hope is to change the query so the column names of the
resultset are not ambiguous.
-O
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Lazarus | 2008-01-13 04:47:38 | Re: Update ResultSet |
Previous Message | Silvio Bierman | 2008-01-12 22:13:46 | Howto set UUID parameter for PGSQL 8.3rc1 / postgresql-8.3dev-602.jdbc3.jar |