Re: deploying derby db via tomcat
Here's what I did: Have the db data live in a separate directory, totally outside of the Tomcat deployment dir. Just make sure that whatever service you are running Tomcat as has access to that dir. The derby libarary jars should live either in Tomcat Shared libs or in your application's web-inf/lib. For my dev and prod servers, I have the db living in a similar place. The location string (the path) is stored as a variable that is substituted at runtime. Dan Jue On 12/27/06, Amir Michail [EMAIL PROTECTED] wrote: Hi, I'm building a gwt app using derby db under eclipse. I'm looking for simple step-by-step instructions for deploying this app via tomcat. So far, I have managed to deploy the gwt app via tomcat excluding derby db. Amir
Re: deploying derby db via tomcat
I'm looking for simple step-by-step instructions for deploying this app via tomcat. Here's a nice article about using Derby via Tomcat: http://db.apache.org/derby/integrate/DerbyTomcat5512JPetStor.html thanks, bryan
Re: deploying derby db via tomcat
Hi, I can't start the derby server outside of Eclipse properly. Using the startNetworkServer command, I get this error: ij select * from links; ERROR 42Y07: Schema 'AMICHAIL' does not exist But using the corresponding menu item in Eclipse works fine. Any hints on how to fix this? Amir On 12/27/06, Daniel Jue [EMAIL PROTECTED] wrote: Here's what I did: Have the db data live in a separate directory, totally outside of the Tomcat deployment dir. Just make sure that whatever service you are running Tomcat as has access to that dir. The derby libarary jars should live either in Tomcat Shared libs or in your application's web-inf/lib. For my dev and prod servers, I have the db living in a similar place. The location string (the path) is stored as a variable that is substituted at runtime. Dan Jue On 12/27/06, Amir Michail [EMAIL PROTECTED] wrote: Hi, I'm building a gwt app using derby db under eclipse. I'm looking for simple step-by-step instructions for deploying this app via tomcat. So far, I have managed to deploy the gwt app via tomcat excluding derby db. Amir
Re: deploying derby db via tomcat
On 12/27/06, Amir Michail [EMAIL PROTECTED] wrote: Hi, I can't start the derby server outside of Eclipse properly. Using the startNetworkServer command, I get this error: ij select * from links; ERROR 42Y07: Schema 'AMICHAIL' does not exist This turned out to be a db path problem. The path given with the connect command is with respect to the location where the startNetworkServer command is started. I also had a security problem with the connect that I solved like this: http://forum.java.sun.com/thread.jspa?threadID=653424messageID=3840697 Amir But using the corresponding menu item in Eclipse works fine. Any hints on how to fix this? Amir On 12/27/06, Daniel Jue [EMAIL PROTECTED] wrote: Here's what I did: Have the db data live in a separate directory, totally outside of the Tomcat deployment dir. Just make sure that whatever service you are running Tomcat as has access to that dir. The derby libarary jars should live either in Tomcat Shared libs or in your application's web-inf/lib. For my dev and prod servers, I have the db living in a similar place. The location string (the path) is stored as a variable that is substituted at runtime. Dan Jue On 12/27/06, Amir Michail [EMAIL PROTECTED] wrote: Hi, I'm building a gwt app using derby db under eclipse. I'm looking for simple step-by-step instructions for deploying this app via tomcat. So far, I have managed to deploy the gwt app via tomcat excluding derby db. Amir
Re: deploying derby db via tomcat
On 12/27/06, Amir Michail [EMAIL PROTECTED] wrote: ... I also had a security problem with the connect that I solved like this: http://forum.java.sun.com/thread.jspa?threadID=653424messageID=3840697 And yet another security problem (this one unrelated to derby db) fixed like this: http://groups.google.ca/group/weblogic.developer.interest.security/browse_thread/thread/7706619183922375 My app finally works! Amir Amir But using the corresponding menu item in Eclipse works fine. Any hints on how to fix this? Amir On 12/27/06, Daniel Jue [EMAIL PROTECTED] wrote: Here's what I did: Have the db data live in a separate directory, totally outside of the Tomcat deployment dir. Just make sure that whatever service you are running Tomcat as has access to that dir. The derby libarary jars should live either in Tomcat Shared libs or in your application's web-inf/lib. For my dev and prod servers, I have the db living in a similar place. The location string (the path) is stored as a variable that is substituted at runtime. Dan Jue On 12/27/06, Amir Michail [EMAIL PROTECTED] wrote: Hi, I'm building a gwt app using derby db under eclipse. I'm looking for simple step-by-step instructions for deploying this app via tomcat. So far, I have managed to deploy the gwt app via tomcat excluding derby db. Amir