jump to navigation

Enhydra XA DataSource September 30, 2008

Posted by Phill in General J2EE.
Tags: , ,
trackback

Just a quick follow up to my last post. xapool.jar comes included with JOTM. I just used the version of xapool which came with it… however, we’ve been having a number of impossible to reproduce problems where the data access layer throws an exception “Connection Closed”.

It turns out that the version of xapool.jar which is included with JOTM is out of date! I’d suggest switching to a newer version – 1.5.0 is the latest stable version, or there’s 1.6 beta.

I unfortunately can’t say for sure whether it has fixed the issue (due to its rather random nature), but it’s probably worth being on the newer version anyway.

Update: it didn’t fix the problem, or at least we had similar problems with it. I would not recommend using the Enhydra connection pool.

Advertisements

Comments

1. CQ - April 16, 2009

We were able to get the xapool working by setting checkLevelObject to 2 and then setting jdbcTestStmt to select 1 from sysibm.sysdummy1. This works for DB2. Maybe these settings will help others. Thanks.


Sorry comments are closed for this entry

%d bloggers like this: