Re: JDBC: pl/pgsql function runs but does not do anything - Mailing list pgsql-novice

From Thomas Kellerer
Subject Re: JDBC: pl/pgsql function runs but does not do anything
Date
Msg-id h3fm0d$45a$1@ger.gmane.org
Whole thread Raw
In response to Re: JDBC: pl/pgsql function runs but does not do anything  (Rob W <digital_illuminati@yahoo.com>)
List 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



pgsql-novice by date:

Previous
From: Rob W
Date:
Subject: Re: JDBC: pl/pgsql function runs but does not do anything
Next
From: MF Hull
Date:
Subject: queries per second script