Single DB connection

[francan00]

I would like to create a single Database connection point that I can
use for several of my 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("jdbcracle:thinmyname:1234rcl",
"scott", "tiger");
}
return activeConnection;
}
}

Now how would I access the ConnectionManager 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.

 

[Andrew Thompson]

Please advise.

Please refrain from reposting questions.

--
Andrew Thompson
http://www.athompson.info/andrew/

Message posted via JavaKB.com
http://www.javakb.com/Uwe/Forums.aspx/java-general/200710/1

 

[Lew]

Please refrain from reposting questions.

And reposting and reposting, multiple groups, reposting ...

 

[Andrew Thompson]

And reposting and reposting, multiple groups, ...

A *multi-poster*!
<gravely>
Bring forth, the /comfy/ chair.
</gravely>