This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach 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 | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
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: 41052
    
  43
This seems more of a Derby/database question than a Tomcat question, so I'll move it to the JDBC forum.


Ping & DNS - my free Android networking tools app
Mouza Ali
Ranch Hand

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

Joined: Mar 22, 2005
Posts: 41052
    
  43
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.
 
 
subject: Should I embed Derby with apache tomcat? Need clarification please
 
Similar Threads
Connecting jsp with derby
exception in login page using apache derby
Help needed on SSL configuration
Tomcat Error: Requested Resoure is not available
Logoff problem