Re: DB Error

2009-07-21 Thread Glenn Barnard
, May 28, 2009 12:05 PM > *To:* user-java@ibatis.apache.org > *Subject:* RE: DB Error > > I noticed this problem with straight SQL too (insert / update) … > > > > If I open connection with autocommit(false), and then try to commit / > rollback; I get the same error >

RE: DB Error

2009-07-21 Thread Shannon, Bryan
Hope this helps! From: Ejaz X Mohammed [mailto:ejaz.moham...@jpmorgan.com] Sent: Thursday, May 28, 2009 12:05 PM To: user-java@ibatis.apache.org Subject: RE: DB Error I noticed this problem with straight SQL too (insert / update) ... If I open connection with a

RE: DB Error

2009-05-28 Thread Ejaz X Mohammed
@ibatis.apache.org Subject: Re: DB Error There are a number of articles on this problem with SP's. However, I'm using straight SQL. I'm not sure this is the issue, but I am using the N+1 technique to add child records to the master. On Thu, May 28, 2009 at 11:48 AM, Ejaz X Mohammed ma

Re: DB Error

2009-05-28 Thread Glenn Barnard
There are a number of articles on this problem with SP's. However, I'm using straight SQL. I'm not sure this is the issue, but I am using the N+1 technique to add child records to the master. On Thu, May 28, 2009 at 11:48 AM, Ejaz X Mohammed < ejaz.moham...@jpmorgan.com> wrote: > I get same erro

RE: DB Error

2009-05-28 Thread Ejaz X Mohammed
I get same error with Sybase 12.5, but when I call a stored proc which has begin tran / end tran when I execute same stored proc directly via jdbc, I don't get "SET CHAINED ..." error Should be something with driver ...jconn2.jar Ejaz From: Glenn Barnard [mailto:barnardgl...@gmail.com] Sent