Re: JDBC INSERT Problem - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: JDBC INSERT Problem
Date
Msg-id 4283F339.3090200@opencloud.com
Whole thread Raw
In response to JDBC INSERT Problem  (hiuguis@iteso.mx)
Responses Re: JDBC INSERT Problem
List pgsql-jdbc
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

pgsql-jdbc by date:

Previous
From: hiuguis@iteso.mx
Date:
Subject: JDBC INSERT Problem
Next
From: hiuguis@iteso.mx
Date:
Subject: Re: JDBC INSERT Problem