Re: Updateable ResultSet doesn't fetch sequence-generated values

Поиск
Список
Период
Сортировка
От Kris Jurka
Тема Re: Updateable ResultSet doesn't fetch sequence-generated values
Дата
Msg-id alpine.BSO.2.00.0907270224270.10084@leary.csoft.net
обсуждение исходный текст
Ответ на Updateable ResultSet doesn't fetch sequence-generated values  (Clemens Eisserer <linuxhippy@gmail.com>)
Ответы Re: Updateable ResultSet doesn't fetch sequence-generated values
Список pgsql-jdbc

On Sun, 26 Jul 2009, Clemens Eisserer wrote:

> I am using a library which is using the JDBCRowSet API, in order to bind
> a user-interface with a SQL database. The library relies on auto
> generated primary keys (I am using sequences for this task), however
> after inserting, the key-column with the server-side generated value is
> set to 0. I am porting the application from MySQL-5.0 to PostgreSQL-8.3,
> and MySQL sets the key-column to the value generated by auto_increment.
>
> Am I doing something wrong here, or is it a bug? Is that behaviour
> specified at all?

I don't know whether it's unspecified or a bug, but the PG driver doesn't
do this at the moment.

http://pgfoundry.org/tracker/index.php?func=detail&aid=1010520&group_id=1000224&atid=857

Kris Jurka


В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Clemens Eisserer
Дата:
Сообщение: Re: [GENERAL] Implicit sequence with start value?
Следующее
От: Kris Jurka
Дата:
Сообщение: Re: No suitable driver found