RE: How can I logoff

[Marc Padberg]

Title: Re: How can I logoff

There are a lot of examples - just look up "connection pool" on yahoo

 

one example is: http://coldjava.hypermart.net/classes/dbpool.htm

 

If you want a concrete walk through example check out Java Servlets by Karl Moss. (Second Edition - third if it's available)

 

It does not cover CallableStatements though only inline SQL - to migrate to callable statements takes a little tweaking.

 

Also, what we did was abstract a class which was responsible for executing a query - it first tries to use the existing connection pool but if it does not exist it connects directly to the database.

 

Good luck.

 

Marc

-----Original Message-----
From: Christopher Raber [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 18, 2001 8:24 PM
To: '[EMAIL PROTECTED]'
Subject: Re: How can I logoff

Using jdbc connections per user is not advisable. You shoukd think in terms of connection pooling.
--------------------------
Chris Raber, Systems Engineer, AvantGo Inc.
v: 248-554-9330, cell: 810-839-3684
http://www.avantgo.com/
Sent wirelessly using AvantGo Enterprise & RIM!

-----Original Message-----
From: Blue, Neil <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Sent: Wed Jul 18 07:57:09 2001
Subject: How can I logoff

Hello,

I am using the JDBC sercurity on tomcat 3.3. I am able to logon (via basic
authentication) to view a secured .jsp page. however I can not see how a
user can logoff again so that a new user can logon. Please could someone
point me in the right direction.

Cheers
Neil