• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Should I embed Derby with apache tomcat? Need clarification please

 
Mouza Ali
Ranch Hand
Posts: 39
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Rancher
Posts: 42968
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This seems more of a Derby/database question than a Tomcat question, so I'll move it to the JDBC forum.
 
Mouza Ali
Ranch Hand
Posts: 39
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Any help?
 
Ulf Dittmer
Rancher
Posts: 42968
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic