Skip site navigation (1) Skip section navigation (2)

Re: Updatable query and column aliases

From: Stefan Reiser <s(dot)reiser(at)tu-braunschweig(dot)de>
To: Anton Bobov <bobov_a(at)sibsac(dot)ru>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Updatable query and column aliases
Date: 2012-03-08 00:02:17
Message-ID: 4F57F709.6000704@tu-braunschweig.de (view raw or flat)
Thread:
Lists: pgsql-jdbc
Sorry, what I just posted is in fact for the current version _9.1-901_ 
an it can be found here:

    
http://home.arcor.de/stefanreiser/docs/postgresql/9.1-901/AbstractJdbc2ResultSet.java


Stefan Reiser schrieb:
> Anton Bobov schrieb:
>> Hi folks.
>>
>> I cant moveToInsertRow when use queries with assigned names in select
>> list.
>>
>> Following code works good:
>>
>>     stmt = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
>>                                       ResultSet.CONCUR_UPDATABLE);
>>     rs = stmt.executeQuery("select id from test");
>>     rs.moveToInsertRow();
>>
>> , but then I change query to "select id val from test" exception "The
>> column name id was not found in this ResultSet." raised on
>> moveToInsertRow.
>>
>> Is it any limitation on updatable queries?
>>
>> -- 
>> Anton
>>
>>
> Hello Anton,
>
> yes, the limitations are:
> 1) query must only use one table
> 2) no column aliases can be used
>
> Point 2 is a bug which I have described here:
>    http://archives.postgresql.org/pgsql-jdbc/2010-12/msg00084.php
> and here:
>    http://archives.postgresql.org/pgsql-jdbc/2011-08/msg00077.php
>
> The patch mentioned above does not work anymore since some things have 
> changed in later versions of the driver.
>
> Here is a patch for version 9.0.801 (the only file that has to be 
> changed is "AbstractJdbc2ResultSet").
>
>    
> http://home.arcor.de/stefanreiser/docs/postgresql/9.0.801/AbstractJdbc2ResultSet.java
>
> ... sorry, I'm not familiar with the versioning system - maybe one of 
> the developers can take a look at my patch?
>
> Regards
> Stefan Reiser
>




In response to

pgsql-jdbc by date

Next:From: Jack DouglasDate: 2012-03-09 20:06:19
Subject: create function with dollar quoted body
Previous:From: Stefan ReiserDate: 2012-03-07 23:50:51
Subject: Re: Updatable query and column aliases

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group