Greetings Fellas, I'm in need of a new architecture for the web server that I host. I'm currently running my application on the standard TomcatServlet container and use MySQL as my database. I'd like to create two separate databases that are structured quite different to efficiently handle two separate requests. However, I'd like to access both of these databases on a single Tomcat instance (I'd like to avoid clustering). Could anyone point me in the right direction on how I would go about accomplishing this? I noticed JOTM might be a solution, but it seems a bit of an overkill for what I want to do. I'm looking for a simpler solution, unless yall recommend JOTM. Any help would be appreciated.
posted 9 years ago
There is no restriction on accessing multiple databases in a single web application. You don't need JOTM for that.
JOTM is a transaction manager. Will your application have individual transactions that include operations on both databases? If so, JOTM may help manage the transactions.
Tell us more about your application, databases and transactions and we may be able to give you more information.