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