Re: how to access connection object in another class?

On 19/02/13 08:18, xodepp shrestha wrote:


I think you probably need something like this

public class ConnectionManager{

    public Connection getNewConnection() throws ...{
    Connection conn = null;
         //get your connection then return it
         ...
         return conn;
    }

    public void closeConnection(connection conn) throws ...{
       //manage the close connection process
       ...
    }
}

now you can do as you wish e.g

class SomeClass{

    public SomeType someMethod(){

       //should really be a singleton but what the heck
       ConnectionManager connections = new Connectionmanager();

       Connection conn = connections.getNewConnection();
       ...
       //use the connection
       ...
       //close it
       ...
       connections.closeConnection(conn);
       ...
       // etc
    }
}

HTH

lipska

--
Lipska the Kat?: Troll hunter, sandbox destroyer
and farscape dreamer of Aeryn Sun