jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases and the fly likes Multiple databases Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Multiple databases" Watch "Multiple databases" New topic

Multiple databases

Tyler Scott Alexander

Joined: Dec 05, 2006
Posts: 2
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 Tomcat Servlet 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.

Scott Johnson
Ranch Hand

Joined: Aug 24, 2005
Posts: 518
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.
I agree. Here's the link: http://aspose.com/file-tools
subject: Multiple databases
It's not a secret anymore!