File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Connection from DataSource
Joined: Sep 23, 2002
Jul 21, 2004 22:29:00
I have a question regarding the
Connection object from DataSource.
I have created the connection pooling in WAS 4.06 Application Server thr' administrative consol.
In my ConnectionWraper class, I am searching the data source object thr' JNDI search and then using datasource.getConnection() method to get the JDBC Connection object to perform Database SQLs.
When I complete the SQL execution, I am closing the resultset, statement and connection objects in respective methods.
Now, my question is, when I am closing the connection object with connection.close() method, will this connection object return to the connection pool or not?
author & internet detective
Joined: May 26, 2003
Jul 22, 2004 08:09:00
Yes, the connection is then returned to the pool.
OCA 8 book
How To Ask Questions The Smart Way
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
I agree. Here's the link:
subject: Connection from DataSource
jdbc objects in different JVM's
Passing References and Passing Values
JDBC connection pool
Design for DBInterface -- Feedback for proposed design
Is this good approach to design DB i/f?
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015