Hi,
today was debugging day...
I still have the problem that connections are not
closed in dbforms. This is not a connection pool problem but happens also with
direkt jdbc connection in dbforms.
This is my configuration:
jdk 1.3
tomcat 4.1.27
oracle 8.1.6.0.0
oracle jdbc thin driver 9.0.2.0.0
This is what I found out:
- I've downloaded dbforms 2.3 and set up a complete
new dummy project (with the devgui)
=> connections are not closed. (I've
tested that with jdk1.4)
- In my (real) Project, I use the dbFormsConfig.getConnection(String) in my JSPs and close them
afterwards for myself. In this case the connection is closed!
- This is the most interesting point: When rows fit
in only one page (that means in my case that navnextButton, navLastButton, ...
are not shown) the connection is closed in dbforms!
is the ResultSet not closed when Result doesn't fit
in one page?
I have the feeling that there is a ResultSet or
PreparedStatement hanging around which isn't closed?
Any ideas?
Cheers,
Jan.