This week's book giveaway is in the Agile and other Processes forum.
We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund on-line!
See this thread for details.
The moose likes JDBC and the fly likes Should I embed Derby with apache tomcat? Need clarification please Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Should I embed Derby with apache tomcat? Need clarification please" Watch "Should I embed Derby with apache tomcat? Need clarification please" New topic
Author

Should I embed Derby with apache tomcat? Need clarification please

Mouza Ali
Ranch Hand

Joined: Oct 28, 2008
Posts: 39
Hi,

I'm working with apache tomcat server version 5.5 on elcipse IDE where I use Derby to create my database. However, the derby here is not embdeded with the tomcat, it is working on its separate server.

Should I integrate it with apache tomcat, or it is ok to have it running in its own server? Meaning, what are the advtgs and disadvtgs of having derby as a sperate server?

Anyone can help?
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 35252
    
    7
This seems more of a Derby/database question than a Tomcat question, so I'll move it to the JDBC forum.


Android appsImageJ pluginsJava web charts
Mouza Ali
Ranch Hand

Joined: Oct 28, 2008
Posts: 39
Any help?
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 35252
    
    7
That's really an architectural question, and we have too little information about your circumstances to give a definitive answer.

Embedding it in Tomcat should make for better performance (no network traffic between the application and the DB), but it also means that the DB will go down whenever Tomcat goes down. If the DB is only ever accessed from the Tomcat then that may not matter, but DBs have a tendency to develop other -standalone- clients for special purposes.

Note that you can run Derby on the same server as the Tomcat, but still as a standalone server. That way it's independent from the Tomcat, but you don't need a separate machine.
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: Should I embed Derby with apache tomcat? Need clarification please
 
Similar Threads
exception in login page using apache derby
Connecting jsp with derby
Logoff problem
Tomcat Error: Requested Resoure is not available
Help needed on SSL configuration