Hi, all.
I'm planning to use Jakarta Slide in my J2EE application.
In my test, after a series of calls to retrieve the
noderevisioncontents, the J2EE application server generates SQL read
timeout exception, and the operation fails.
After some investigation, the problem was that all the connections in
the J2EE pool was occupied and not released.
in the source code
${jakarta-slide}/src/stores/org/apache/slide/store/impl/rdbms/AbstractRDBMSStore.java
in successful calls to some methods after getNewConnection() they
don't release the connection explicitly unless there have been errors.
In J2EE environment, we use the data source connection pool and the
release of connection should occur explicitly.
I added the connection.close() statement after each successful jdbc
calls, and the problem was fixed.How do you think about adding explicit close statement after each jdbc calls? Regards, Yoon Kyung Koo -- -- -------------------- Java Architect yoonforh at gmail dot com PGP http://www.javadom.com/personal/yoonforhatyahoodotcom.asc --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
