I just updated the jdbc jar from postgres, and I can now get updates to work when calling w/ queryForObject. Using insert or update still throw the same exception.
On "postgresql.stat.result" a google found a poster elsewhere regarding postgres "In your function, you return 0. My guess is that it's being treated as a result set so that's why executeUpdate will not work." As I understand postgres, I have to have a return of some sort in a stored procedure, so with the above appears to be mucking the use of insert or update in ibatis. Anyhow, this works, though I don't know if it's ideal or not. Thanks again for your help (and ibatis). On Tue, 2005-01-04 at 10:27, Clinton Begin wrote: > What is "postgresql.stat.result"? > > > On Tue, 04 Jan 2005 10:13:18 -0800, Paul Woods <[EMAIL PROTECTED]> wrote: > > > > When using an insert, the exception is > > com.ibatis.common.jdbc.exception.NestedSQLException > > > > The stack reads: > > Exception in Polls.increment(): > > com.ibatis.common.jdbc.exception.NestedSQLException: > > --- The error occurred in com/nwnet/da/bean/maps.xml. > > --- The error occurred while applying a parameter map. > > --- Check the increment-InlineParameterMap. > > --- Check the statement (update procedure failed). > > --- Cause: postgresql.stat.result > > Caused by: postgresql.stat.result > > > > Thanks again. > > > > On Tue, 2005-01-04 at 09:41, Clinton Begin wrote: > > > What's the exception? > > > > > > > > > >
