Meaningless Drivel is fun!
The moose likes JDBC and Relational Databases and the fly likes Help with connection statement Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Help with connection statement" Watch "Help with connection statement" New topic

Help with connection statement

nash avin
Ranch Hand

Joined: Nov 13, 2003
Posts: 96
I want the initialization of the database i.e.,

Connection connection = DriverManager.getConnection(DEFAULT_URL);

To be done in one method (in a class) and other methods should use this connection object inside.Is it possible to do something like this.Hope that you got my question correctly.
A reply would be appreciated.
Also adding,
What will be the return type of a method that will return a connection.Let me know thanks
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

Have a look at using a DataSource instead (if you're using an aplication server) or use a ConnectionPool otherwise. (the ConnectionPool is usually hidden behind the DataSource in app servers. You get it for free)
They both allow you to put all the other 'stuff' elsewhere and just serve Connections.
subject: Help with connection statement
It's not a secret anymore!