Registering a JDBC ConnectionPoolDataSource for Client Access
I am trying to create a JDBC Connection pool using poolman found at http://www.codestudio.com/ . I choose this because it was suggested on this forum. I have read the the JDBC Tutorial many times in regards to DataSource Objects and ConnectionPoolDataSource Objects. I think I am missing something. All documentation from poolman and JDBC seems to show how to access remotely pooled JDBC Connections, datasource.getConnection(), but not how to set up the server environment so they are accessible.
What I can't seem to figure out is how I create an RMI server, or any type of service provider, which allows a client to run code like this, from JDBC tutorial:
// client code
ctx = new InitialContext();
ds = (DataSource)ctx.lookup("jdbc/fastCoffeeDB");
try {
Connection con = ds.getConnection("myLogin", "myPassword");
// ... code to use the pooled connection con
}
catch (Exception ex {
// . . . code to handle exceptions
}
finally {
if(con != null) con.close();
}
I just can't seem to figure out how to set up the server code and associated properties files, if needed? Sun has a tendency to be scatter-brained when it comes to documentation, clear cut examples in some cases can be hard to find.
Any wisdom or thoughts on this would be greatly appreciated.
