A couple of months ago, we experimented the same problem.
We upgraded to ibatis 2.3.4 / ibatis dao 2.2.0 as you recommended and the
throttle error disappeared. However, we are getting now an error with the
connection pool (we use the jboss datasource via ibatis): “there are no more
connections available”, it means our application is taking all the
connections and remains waiting for the answer.
We have deployed the same code in two different machines, and this error
happens only in one of them (the one which receives less requests...). Our
support team has told us, requests to database remains waiting. We have
checked we are finishing transactions
try {
start transaction
do work
commit transaction
} finally {
end transaction
}
Do we have to do the same with "select" requests to database.
Thanks.
María
