Re: JDBC: pl/pgsql function runs but does not do anything

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: JDBC: pl/pgsql function runs but does not do anything
Date: 2009-07-13 16:05:33
Message-ID: h3fm0d$45a$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Rob W wrote on 13.07.2009 16:46:
> I was not explicitly beginning or ending a transaction. However, this
> response inspired me to try the obvious (in hindsight):
>
> connection.setAutocommit(true)
>
> And hey presto, it worked. The odd thing is that not one single
> example/tutorial I looked at anywhere explicitly sets autocommit, so figuring
> this out was a guessing game. On the bright side, I won't forget about
> setting autocommit to true in a hurry!

I guess those examples have a connection.commit() somewhere ;)

Thomas

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message MF Hull 2009-07-14 01:43:43 queries per second script
Previous Message Rob W 2009-07-13 14:46:03 Re: JDBC: pl/pgsql function runs but does not do anything