Sorry, what I just posted is in fact for the current version _9.1-901_
an it can be found here:
Stefan Reiser schrieb:
> Anton Bobov schrieb:
>> Hi folks.
>> I cant moveToInsertRow when use queries with assigned names in select
>> Following code works good:
>> stmt = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
>> rs = stmt.executeQuery("select id from test");
>> , but then I change query to "select id val from test" exception "The
>> column name id was not found in this ResultSet." raised on
>> Is it any limitation on updatable queries?
> 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:
> and here:
> 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").
> ... sorry, I'm not familiar with the versioning system - maybe one of
> the developers can take a look at my patch?
> Stefan Reiser
In response to
pgsql-jdbc by date
|Next:||From: Jack Douglas||Date: 2012-03-09 20:06:19|
|Subject: create function with dollar quoted body|
|Previous:||From: Stefan Reiser||Date: 2012-03-07 23:50:51|
|Subject: Re: Updatable query and column aliases|