ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ejaz X Mohammed <ejaz.moham...@jpmorgan.com>
Subject RE: DB Error
Date Thu, 28 May 2009 15:48:32 GMT
I get same error with Sybase 12.5, but when I call a stored proc which has begin tran / end

when I execute same stored proc directly via jdbc, I don't get "SET CHAINED  ..." error

Should be something with driver ...jconn2.jar


From: Glenn Barnard [mailto:barnardglenn@gmail.com]
Sent: Thursday, May 28, 2009 10:44 AM
To: user-java@ibatis.apache.org
Subject: DB Error

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 jobs run fine on our development boxes without connection pooling (i.e.,
as Junit processes). But when I try to run them from the webserver, I get a few of these errors
and then all the connections become useless quickly and I have to restart the webserver. The
errors start with the message:

Unable to set AutoCommit property.SET CHAINED command not allowed within multi-statement transaction.

Then as the connections become useless, the following messages start coming out. This message
I would expect after the pool is exhausted.

Error in allocating a connection. Cause: In-use connections equal max-pool-size and expired
max-wait-time. Cannot allocate more connections

What's really perplexing me is that this happens on SELECT statements, and not just INSERT
or UPDATE statements.

I've Googled this error and am not getting anywhere. I've also reviewed the connection pool
settings and no amount of tweaking improves the situation.

Any help would be most appreciated.

Our environment consists of:

            Java 1.6
            Spring 2.5
            Glassfish/ Sun Java System Application Server 9.1 (build b58g-fcs) (webserver)
            Sybase 12.5

This email is confidential and subject to important disclaimers and
conditions including on offers for the purchase or sale of
securities, accuracy and completeness of information, viruses,
confidentiality, legal privilege, and legal entity disclaimers,
available at http://www.jpmorgan.com/pages/disclosures/email.  
View raw message