Project: XPages Extension Library (Managed by Philippe Riand, Niklas Heidloff, Dave Delay, Akihiro Kosugi, Maire Kehoe, Tony McGuckin, John Piermarini, Martin Donnelly, James Quill, Darin Egan, Padraic Edwards, Andrejus Chaliapinas, Lorcan McDonald, Simon McLoughlin, Paul Hannan)
@jdbc -> As400 files in use
eros monzani on 07/30/2012 at 02:32 PM
following the example for Oracle, i made a osgi plugin for the jdbc driver JTOpen 7.7.1
Installed it without problems. I'm using it (dev server).
>> using the @jdbcExecute
It creates many connections as the number of queries on xpage, leaving them opened ("minor" problem).
If you reload the page, it'll reuse the previous created connections, BUT leave the files/tables on the AS400 in use (huge problem).
>> using the @jdbcGetConnection (doing the classic conn->stmt->rs -> rs.close->stmt.close->conn.close)
It creates 1 connection (1 even if i call it many times -> conn.close is working correctly), BUT i'm seeing that the 1 connection remain opened in the end (??? i'm closing it), plus the previous huge problem: files remains in use.
I'm doing something wrong ?
Now i'm trying with an url like this "...;socket timeout=30000;threads used=false" (no results...)
Thank You for any response or ideas.
PS: on the production site, i'm using JTOpen for about 2 years (xpages first release) (pure java: java mgr -> js helper -> xpage) without problems, but it's slower than this one.
|Entered 30-Jul-2012 14:32 by eros monzani. Last Modified <none> by Niklas Heidloff.|
Check out other projects