Hi, We've developed our own application session server functionality, (with our own proprietry data access layer) to process user requests; and based on their user details, direct the request to that users appropriate database to either retrieve or update data. We've hundreds of clients, therefore hundreds of databases (MS SQL Server), 1 per customer. All requests are driven by the 1 application server - which comprises the web server (JRUN) and a session server - our own implementation.
We're now about to start evaluating other application servers on the market - mainly JBoss, with a view to use CMP. My problem is how could we configure or manage multiple databases with JBoss. For example, would JBoss know how to differentiate between a 'client' object with a primary key of '1' from one database and the same 'client' object type from a different database with a primary key of '1'? How would JBoss handle this? The option to incorporate all databases into one 'mother of all databases' is not an option. Any help or ideas would be greatly appreciated. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3879118#3879118 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3879118 ------------------------------------------------------- SF.Net email is sponsored by: GoToMeeting - the easiest way to collaborate online with coworkers and clients while avoiding the high cost of travel and communications. There is no equipment to buy and you can meet as often as you want. Try it free.http://ads.osdn.com/?ad_id=7402&alloc_id=16135&op=click _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user