release pooled connectoin-Pass by value or reference.

[quickcur]

I think this is a classic java question: Pass by
reference or by value. I have a DatabaseManager class
which takes care of getting conection from connection pool
and releasing the connectoin. I am not sure about the
release part. Here is my code:

class MyMainClass{

public static final void main(String[] args){

Connection connection =
DatabaseManager.getConnection();

....//jdbc work.

DatabaseManager.closeConnection(connection);
....
}


public class DatabaseManager {

public static Connection getConnection(){
Connection connection =
getConectionFromDataSource();

return connection;
}

public static void closeConnection(Connection
conn){
if (conn != null){
try{
conn.close();
}catch(SQLException sqle){
sqle.printStackTrace();
}
}
conn = null;
}}


I am not sure if the connection is released....


Thanks,

 

[Raymond DeCampo]

I think this is a classic java question: Pass by
reference or by value.

I don't see what this supposed dilemma has to due with the rest of your
post.

I have a DatabaseManager class
which takes care of getting conection from connection pool
and releasing the connectoin. I am not sure about the
release part. Here is my code:

class MyMainClass{

public static final void main(String[] args){

Connection connection =
DatabaseManager.getConnection();

....//jdbc work.

DatabaseManager.closeConnection(connection);
...
}

The call to DatabaseManager.closeConnection() should be in a finally
block, unless you like tormenting your DBAs.

public class DatabaseManager {

public static Connection getConnection(){
Connection connection =
getConectionFromDataSource();

return connection;
}

public static void closeConnection(Connection
conn){
if (conn != null){
try{
conn.close();
}catch(SQLException sqle){
sqle.printStackTrace();
}
}
conn = null;
}}


I am not sure if the connection is released....

Most connection pools work by wrapping the actual Connection
implementation with their own implementation. The pool's implementation
of Connection.close() will usually return the connection to the pool.
Refer to the documentation of your specific connection pool.

Thanks,

HTH,
Ray