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
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
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
, 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
>
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
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!