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

From Rob W
Subject Re: JDBC: pl/pgsql function runs but does not do anything
Date
Msg-id 461779.26248.qm@web34601.mail.mud.yahoo.com
Whole thread Raw
In response to JDBC: pl/pgsql function runs but does not do anything  (Rob W <digital_illuminati@yahoo.com>)
Responses Re: JDBC: pl/pgsql function runs but does not do anything
List pgsql-novice


--- On Mon, 7/13/09, John DeSoi <desoi@pgedit.com> wrote:
>
> Are you running inside a transaction that is being
> cancelled or not committed?

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
truein a hurry! 

Thanks for the nudge in the right direction.

pgsql-novice by date:

Previous
From: John DeSoi
Date:
Subject: Re: JDBC: pl/pgsql function runs but does not do anything
Next
From: Thomas Kellerer
Date:
Subject: Re: JDBC: pl/pgsql function runs but does not do anything