I am not familiar with the problem you are having, but have you tried the patch that Mark posted in response to issue #66?
If you have not, please do so, and see if it resolves the issue for you as well. If it does, let us know, and we will get it into the next release. Larry On Sun, 6 Feb 2005 06:08:26 +0100 (CET), Sridhar Vijendran (JIRA) <[email protected]> wrote: > iBatis hanging > -------------- > > Key: IBATIS-67 > URL: http://issues.apache.org/jira/browse/IBATIS-67 > Project: iBatis for Java > Type: Bug > Components: SQL Maps, DAO > Versions: 2.0.8, 2.0.9 > Environment: Websphere Application Server 5.0 on Windows > iBatis DAO framwork and SQL Maps 2.0.8 > Informix JDBC driver 2.21 JC3 > Reporter: Sridhar Vijendran > Priority: Blocker > > We are using both iBatis DAO framework and SQL Maps. > > iBatis configuration: > The DAO framework is configured to use SQLMAP as transaction manager. > > The SQL Maps is configured to use JDBC transaction manager SIMPLE datasource. > However the issue occurs also for JDBC transaction manager JNDI datasource > and for EXTERNAL transaction manager JNDI datasource. > > Coding Pattern: We are using SqlMapDaoTemplate provided with iBatis. The > coding pattern is exactly identical to JPetStore 4 > sample of iBatis. > > Manifestation of the issue: > The application works fine for several thousand database calls > through iBatis. After a while, suddenly it hangs whenever it is tries to > access the database through iBatis. > > How we figured out to be an iBatis issue: > We wrote a test jsp that accesses the database through > 1.Simple JDBC 2. JDBC with JNDI/Connecion Pooling > 3. A new instance of iBatis DAO manager > 4. iBatis DAO manager instantiated in the static block during the first > database call through iBatis. > > The first 3 calls work fine. The last one hangs forever. > > We are not able to determine if the issue is due to > iBatis DAO framework or iBatis SQL Maps DAO or it is an > issue due to iBatis SQL Map DAO template. > > We are in QA stage and we are using quirky solution of having > a pool of iBatis DAO managers and creating new instances > of DAO manager after a certain time of usage. > > Any clue to getting this issue resolved is highly appreciated. > Also I would request the users/authors of iBatis to recommend > the usage patterns of iBatis that is proven to work in solid and roubust way > in production environment. > > -- > This message is automatically generated by JIRA. > - > If you think it was sent incorrectly contact one of the administrators: > http://issues.apache.org/jira/secure/Administrators.jspa > - > If you want more information on JIRA, or have a bug to report see: > http://www.atlassian.com/software/jira > >
