I've a situation in a project I'm working on where I'm not allowed to use anything other than tomcat to run CGI scripts. So basically the whole tomcat+CGI thing is settled, that's a given and it's part of the hypothesis(I know it's awkward but I can't change it).
Now every time a user decides to access some page, some cgi-bin/<scriptname>.pl is executed, makes a DB connection, processes data, throws it back to the client and then exists, and as it exists it also closes the DB connection.
If I would've been using Apache with mod_perl I could've used Apache::DBI to persist the connection, but I can't since I'm tied down to tomcat.
Is there any way to persist DBI connections which are made from CGI Perl scripts running on top of tomcat ?