DB Error

2009-05-28 Thread Glenn Barnard
Hi, all…I’ve been using Ibatis for several months now to build an internal web application. We’re using connection pooling and so far so good. So now I’m trying to use the same connection pools for batch applications that are scheduled to run via a chron type function from the same webserver. Those

Re: DB Error

2009-05-28 Thread Glenn Barnard
wrote: > 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

Re: Help reuires regarding huge data retrieval

2009-06-22 Thread Glenn Barnard
Jahan, You're exceeding memory because Ibatis wants to create an object for each row returned--not much use in that. There are 2 things you need to consider 1. If you're displaying the data, no one can see millions of rows, so consider SET ROWCOUNT X before the SELECT and make sure you SET RO

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: Prepared Statement cache

2009-07-21 Thread Glenn Barnard
restart your webservers! On Tue, Jul 21, 2009 at 5:00 PM, Michael Schall wrote: > We run are running iBATIS within WebSphere 6.1 on Windows using JNDI > against a DB2 database. During a performance tuning session we found a > query using an index that did not have a vital column. We added the m

Ibatis in the cloud

2010-01-18 Thread Glenn Barnard
Does anyone have experience using Ibatis in an application that is deployed in a "cloud" environment? What, if any, customization or other constraints should I be facing? Thanks!