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

Re: Large Objects

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: daniel(dot)fisher(at)vt(dot)edu
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Large Objects
Date: 2001-07-29 20:20:14
Message-ID: 2324.996438014@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-jdbc
Daniel Fisher <dfisher(at)vt(dot)edu> writes:
> I'm having some trouble inserting a large object into the database.
> I'm fairly certain that the problem is in my java code because I wrote some quick PHP code and it worked fine.
> The main problem is I'm not getting any errors, so I'm kinda stumped.
> The code appears to run fine, but nothing is being inserted into the database.

The query trace shows that you are starting a transaction (with BEGIN)
and never committing it (no COMMIT or END).  So when you close the
connection, the transaction is rolled back, and its effects go away.

I suppose that having done "conn.setAutoCommit(false)", you need to add
a command to explicitly commit the transaction, but I don't know JDBC
well enough to know how you do that...

			regards, tom lane

In response to

Responses

pgsql-jdbc by date

Next:From: Dave CramerDate: 2001-07-29 20:37:54
Subject: RE: Large Objects
Previous:From: Nils O. =?iso-8859-1?q?Sel=E5sdal?=Date: 2001-07-27 19:44:03
Subject: Re: Large Objects

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