Too many connections to Oracle

[Migrated From Jforum.net]

Hello,

We have detected that there is always at least 10 open/inactive connections from JForum to our Oracle database. Is this normal?

Also, the connections are not always closed when the web server is shut down, obviously resulting in too many connections.

We use JForum 2.1.6 and Oracle 9.2.0.7

I saw here https://coderanch.com/t/576429 that there might be a problem with version 2.1.6 and Oracle. Could this be the problem here?

Any comments?
[originally posted on jforum.net by frankern]

[Migrated From Jforum.net]

If you're using a connection poll, then it's normal to have inactive connections. If the servlet container crashes, then JForum won't be able to release the connections.

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Our problem is that Tomcat often is unwilling to shut down gracefully.

Any tips to how we can deal with this? Perhaps a minor modification in JForum is enough...
[originally posted on jforum.net by frankern]