File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Multiple databases Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Multiple databases" Watch "Multiple databases" New topic
Author

Multiple databases

Tyler Scott Alexander
Greenhorn

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.

-Tyler
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