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

Re: JDBC INSERT Problem

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: 4283F339.3090200@opencloud.com (view raw or flat)
Thread:
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.

-O

In response to

Responses

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-2014 The PostgreSQL Global Development Group