Re: connection pooling with servlets

Use a static method to get the connection instead of the session.

Dave
On 27-Apr-06, at 8:02 PM, J. wrote:

> I am a novice, but thought it would make more sense to post this
> here. I'm trying to write a basic webstore app for a school
> project and I'm having trouble getting more than one servlet to
> access the database connection. I tried the method described on
> the PostgreSQL site - as I understood it. That entailed opening a
> connection in one servlet and then having code like this in other
> servlets that need connections:
>
> Connection grabConnection(HttpSession userSession){
> ds = (Jdbc3PoolingDataSource) userSession.getAttribute
> ("dSource");
> Connection con = null;
>
> try {
> con = ds.getConnection();
> // use connection
> } catch(SQLException e) {
> // log error
> } finally {
> if(con != null) {
> try {con.close();}catch(SQLException e) {}
> }
> }
> return con;
> }
>
> The trouble is (I'm sure you see it already) that passing a
> dataSource object in a session doesn't seem to work. If I don't
> have a dataSource, then I can't make a connection and if I try to
> create a new connection, I get the error that is something like
> "Connection with that name already exists". Any help and I'd be
> gratefull. Thanks.
>
> Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls.
> Great rates starting at 1¢/min.