Hi,

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).

The problem:

>> 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.