Folks, I'm struggling with a connection pooling problem. I have a single host server (or server cluster) that's servicing multiple accounts (or instances of the website). Depending on who has logged in, I need their beans to access different databases. For example, if a customer logs in for site A, their OrderHistory beans would need to access database A. If a customer logs in for site B, their OrderHistory beans would need to access database B. Databases A and B might be the same database server or a different one, but they need to use different JDBC connect strings. So far, it's not too tricky; I just register the beans as using both connection pools (datasources for A and B). How do I dynamically add a new site, though? It's not as simple as adding a new data source; I also need to register each bean to use that new data source. So if I have several hundred web sites and several hundred data sources, I'd need each of several dozen beans to use each database. This is a bit of an administration headache, right? Thoughts? The reason behind this is that I'm trying to have one host machine service multiple accounts, kind of an ASP model. If someone signs up for our service, I don't want to have to edit a bazillion configuration files to add one new schema or instance of the database. All help is appreciated. I've looked around for this, and I can't find anyone who's trying something similar. Thanks, Ben -- -------------------------------------------------------------- To subscribe: [EMAIL PROTECTED] To unsubscribe: [EMAIL PROTECTED] Problems?: [EMAIL PROTECTED]
