tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrew Laughlin <>
Subject Implementing Connection Pooling
Date Thu, 01 Jul 2010 21:35:55 GMT
Just started using Tomcat 6.0.26 connected to MySQL 5.1.  The MySql server
contains a database for each organization.  Each user that logs in,
specifies an organization and is directed to the corresponding DB.  I would
like to employ connection pooling, with a small pool allocated to each
database.  The application authenticates users, users are not authenticated
at the database level.  Here is the current setup in context.xml:

 <Resource name="jdbc/DB"
              url="jdbc:mysql://localhost:3306" />

Notice no username or password entry exists.  Here's the code to get a

Context ctx = new InitialContext();
org.apache.tomcat.dbcp.dbcp.BasicDataSource ds =
"java:comp/env/jdbc/DB" );

// These must be set before the call to getConnection(), since getConnection
actually creates the pool.
ds.setDefaultCatalog( orgID );
ds.setUsername( orgID );
ds.setPassword( orgID );

try{ connection = ds.getConnection(); }
catch( SQLException e ) ...

My question is, does this accomplish the goal of an efficient connection
pooling mechanism using multiple databases?  Are there glaring errors in the
above config? Is there a better method?

Best Regards,

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message