From: books at ejurka.com (Kris Jurka)
Date: Wed, 5 Mar 2008 12:31:54 -0500 (EST)
Subject: [Pljava-dev] ResultSet is read-only error for Trigger?
In-Reply-To: <56DA5079467D1C48B857C6FE59D5D4FCF9A05F@prodeaserve.prodea.local>
References: <56DA5079467D1C48B857C6FE59D5D4FCF9A05F@prodeaserve.prodea.local>
Message-ID: <Pine.BSO.4.64.0803051226440.19761@leary.csoft.net>



On Wed, 5 Mar 2008, Mike Toler wrote:

> I'm trying to do a very simple trigger  before moving onto the complex
> stuff that I need pljava for.
>
> 		CREATE TRIGGER provisionorder_trigger
> 		  AFTER UPDATE
> 		  ON serviceproviderprovisioned
> 		  FOR EACH ROW
> 		  EXECUTE PROCEDURE provisionorder();
>
> When I update my row, I see the following error:
> ERROR:  org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature
> not supported: ResultSet is read-only
>

I think the problem is that you're using an after trigger instead of a 
before trigger.  Before the update you can manipulate the values and have 
them persisted, but after the update you get the values that did come 
through and it's read-only at that point.

Kris Jurka