| From: | hiuguis(at)iteso(dot)mx |
|---|---|
| To: | Oliver Jowett <oliver(at)opencloud(dot)com>, pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: JDBC INSERT Problem |
| Date: | 2005-05-13 00:42:18 |
| Message-ID: | 1115944938.4283f7ea3dd90@iteso.mx |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Thank you very much Oliver. Now its working fine even for bytea fields.
Regards.
Mensaje citado por Oliver Jowett <oliver(at)opencloud(dot)com>:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Gagnon | 2005-05-13 00:57:03 | Re: PostgreSQL/Tomcat JNDI Datasource Questions |
| Previous Message | Oliver Jowett | 2005-05-13 00:22:17 | Re: JDBC INSERT Problem |