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


From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: hiuguis(at)iteso(dot)mx
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: JDBC INSERT Problem
Date: 2005-05-13 00:22:17
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
hiuguis(at)iteso(dot)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.


In response to


pgsql-jdbc by date

Next:From: hiuguisDate: 2005-05-13 00:42:18
Subject: Re: JDBC INSERT Problem
Previous:From: hiuguisDate: 2005-05-13 00:07:01
Subject: JDBC INSERT Problem

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