From: mike.toler at prodeasystems.com (Mike Toler) Date: Wed, 5 Mar 2008 12:09:47 -0600 Subject: [Pljava-dev] ResultSet is read-only error for Trigger? In-Reply-To: Message-ID: <56DA5079467D1C48B857C6FE59D5D4FCF9A0D6@prodeaserve.prodea.local> Yep. That was it. Thanks. Now I'm onto the more complex issues. Michael > -----Original Message----- > From: Kris Jurka [mailto:books at ejurka.com] > Sent: Wednesday, March 05, 2008 11:32 AM > To: Mike Toler > Cc: pljava-dev at pgfoundry.org > Subject: Re: [Pljava-dev] ResultSet is read-only error for Trigger? > > > > 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 This message is confidential to Prodea Systems, Inc unless otherwise indicated or apparent from its nature. This message is directed to the intended recipient only, who may be readily determined by the sender of this message and its contents. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient:(a)any dissemination or copying of this message is strictly prohibited; and(b)immediately notify the sender by return message and destroy any copies of this message in any form(electronic, paper or otherwise) that you have.The delivery of this message and its information is neither intended to be nor constitutes a disclosure or waiver of any trade secrets, intellectual property, attorney work product, or attorney-client communications. The authority of the individual sending this message to legally bind Prodea Systems is neither apparent nor implied,and must be independently verified.