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
