Session wide jdbc connection

[TWR - Hauptuser <TW...@t-online.de>]

Hello to all,

this is just an informative question: what do you think of connecting a 
dbconnection session-wide, i.e. with scope "session"? I know it is pretty 
useless in public web pages (too many open connections) but does it make 
sense when having an intranet side? And is it possible to distinct between 
public access (connecting page-wide and using conn pool) and internal access 
via user-roles from JDBC Realm?

Eager to get opinions
   Thomas