Re: JDBC INSERT Problem

Поиск
Список
Период
Сортировка
От hiuguis@iteso.mx
Тема Re: JDBC INSERT Problem
Дата
Msg-id 1115944938.4283f7ea3dd90@iteso.mx
обсуждение исходный текст
Ответ на Re: JDBC INSERT Problem  (Oliver Jowett <oliver@opencloud.com>)
Список pgsql-jdbc
Thank you very much Oliver. Now its working fine even for bytea fields.

Regards.


Mensaje citado por Oliver Jowett <oliver@opencloud.com>:

> hiuguis@iteso.mx wrote:
>
> > Im new with PostgreSQL. Im migrating an SQLServer DB to PostgreSQL and Im
> having
> > some problems with insertions. The problem consist only with the SQL INSERT
> > function via the JDBC driver. When I try to insert some data to some table
> It
> > seems that everithing its working fine, but I cannot see the new data in
> the
> > table.
>
> Perhaps your connection pool is giving you a connection with autocommit
> off. Your code does not commit the transaction containing the INSERT,
> and presumably when you return the connection to the pool it is rolling
> back the uncommitted transaction.
>
> -O
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>




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

Предыдущее
От: Oliver Jowett
Дата:
Сообщение: Re: JDBC INSERT Problem
Следующее
От: David Gagnon
Дата:
Сообщение: Re: PostgreSQL/Tomcat JNDI Datasource Questions