Single Database connection

[Dan Parsons]

I would like to create a single Database connection point that I can use for 4 classes in my Java Web Application.

Here is my ConnectionManager Class:

public class ConnectionManager {
    private static Connection activeConnection = null;
    public static Connection getConnection() {
        if (activeConnection = null) {
            Class.forName("OracleThinInfoHere...");
            activeConnection = DriverManager.getConnection("jdbc:oracle:thin:@myname:1234:orcl", "scott", "tiger");
        }
        return activeConnection;
    }
}

Now how would I access this in each one of my classes?

For example here is one:

public class MainClass
{
 
public ConnectionManager.getConnection();
public Connection connection;
 
//I tried my db connection as this and it didnt return any results
public MainClass(connection)
{
     this.connection = ConnectionManager.getConnection();
}
 
public int matcher(BeanClass abc)
{
     try
     {
         new OtherDbClass(connection).insertDbMethod(abc);
     }
     catch(Exception e)
     {
         e.printStackTrace();
     }
     finally
     { 
        //closing statements here
     }

Another Class looks like this:

public class OtherDbClass {
   private Connection connection;
   public OtherDbClass(Connection connection)
   { 
      this.connection = ConnectionManager.getConnection();
   }
 
public int insertDbMethod(BeanClass abc) 
{ 
...
...
}

Please advise.
[ October 17, 2007: Message edited by: Dan Parsons ]

[sudhir nim]

You don't need to pass connection from one class to another,
Instead whenever you need a connection in any of your class just call
ConnectionManager.getConnection() and it will return the active connection.

IF classes are going to be used by more than one threds, make the threadlocal connection inside ConnectionManager.

[Surasak Leenapongpanit]

You don't need to pass connection from one class to another

If your application need a transaction among the classes, you need to pass the connection through and set autocommit to false.