Dear all, Anyone knows how I can access the Derby Database from Eclipse ? I followed the instructions on http://db.apache.org/derby/integrate/plugin_howto.html about Derby under Eclipse. But once I try to connect to the Database conform the instructions here http://db.apache.org/derby/integrate/plugin_help/ij.html connect 'jdbc:derby://localhost:1527/ofbiz;create=true;user=ofbiz;password=ofbiz'; does connect to a database that is created in the workspace of Eclipse, but that is not what I want. I tried this commando connect 'jdbc:der by:ofbiz;create=true;user=ofbiz;password=ofbiz';but that is giving me an error. Now the Derby database is embedded so that is probably the problem. Has anyone succeeded accessing the database from within Eclipse ? regards, Danny
Free Online Photosharing - Share your photos online with your friends and family!
Visit http://www.inbox.com/photosharing to find out more! |
You have to have Derby running in a separate process, not in an embedded mode. -David On Nov 17, 2006, at 1:52 PM, Danny Gaethofs wrote: > Dear all, > > Anyone knows how I can access the Derby Database from Eclipse ? > > I followed the instructions on http://db.apache.org/derby/integrate/ > plugin_howto.html about Derby under Eclipse. > > But once I try to connect to the Database conform the instructions > here http://db.apache.org/derby/integrate/plugin_help/ij.html > > connect 'jdbc:derby://localhost:1527/ > ofbiz;create=true;user=ofbiz;password=ofbiz'; does connect to a > database that is created in the workspace of Eclipse, but that is > not what I want. > > I tried this commando connect > 'jdbc:derby:ofbiz;create=true;user=ofbiz;password=ofbiz'; > > but that is giving me an error. Now the Derby database is embedded > so that is probably the problem. Has anyone succeeded accessing the > database from within Eclipse ? > > regards, > > Danny > > Free Online Photosharing - Share your photos online with your > friends and family! > Visit http://www.inbox.com/photosharing to find out more! |
How Can I get the OFBIZ Derby database run in a separate process ?
> -----Original Message----- > From: [hidden email] > Sent: Fri, 17 Nov 2006 15:08:49 -0700 > To: [hidden email] > Subject: Re: Access Derby Database separately from Eclipse > > > You have to have Derby running in a separate process, not in an > embedded mode. > > -David > > > On Nov 17, 2006, at 1:52 PM, Danny Gaethofs wrote: > >> Dear all, >> >> Anyone knows how I can access the Derby Database from Eclipse ? >> >> I followed the instructions on http://db.apache.org/derby/integrate/ >> plugin_howto.html about Derby under Eclipse. >> >> But once I try to connect to the Database conform the instructions >> here http://db.apache.org/derby/integrate/plugin_help/ij.html >> >> connect 'jdbc:derby://localhost:1527/ >> ofbiz;create=true;user=ofbiz;password=ofbiz'; does connect to a >> database that is created in the workspace of Eclipse, but that is >> not what I want. >> >> I tried this commando connect >> 'jdbc:derby:ofbiz;create=true;user=ofbiz;password=ofbiz'; >> >> but that is giving me an error. Now the Derby database is embedded >> so that is probably the problem. Has anyone succeeded accessing the >> database from within Eclipse ? >> >> regards, >> >> Danny >> >> Free Online Photosharing - Share your photos online with your >> friends and family! >> Visit http://www.inbox.com/photosharing to find out more! |
There isn't anything special about how Derby is used in OFBiz. We simply access it through the Derby JDBC driver using the embedded uri. In other words, all you have to do is run Derby as is normal for the software. For more information on Derby I recommend checking out the Apache Derby site and the documentation and such there: http://db.apache.org/derby/ -David On Nov 20, 2006, at 12:22 PM, Danny Gaethofs wrote: > How Can I get the OFBIZ Derby database run in a separate process ? > > >> -----Original Message----- >> From: [hidden email] >> Sent: Fri, 17 Nov 2006 15:08:49 -0700 >> To: [hidden email] >> Subject: Re: Access Derby Database separately from Eclipse >> >> >> You have to have Derby running in a separate process, not in an >> embedded mode. >> >> -David >> >> >> On Nov 17, 2006, at 1:52 PM, Danny Gaethofs wrote: >> >>> Dear all, >>> >>> Anyone knows how I can access the Derby Database from Eclipse ? >>> >>> I followed the instructions on http://db.apache.org/derby/integrate/ >>> plugin_howto.html about Derby under Eclipse. >>> >>> But once I try to connect to the Database conform the instructions >>> here http://db.apache.org/derby/integrate/plugin_help/ij.html >>> >>> connect 'jdbc:derby://localhost:1527/ >>> ofbiz;create=true;user=ofbiz;password=ofbiz'; does connect to a >>> database that is created in the workspace of Eclipse, but that is >>> not what I want. >>> >>> I tried this commando connect >>> 'jdbc:derby:ofbiz;create=true;user=ofbiz;password=ofbiz'; >>> >>> but that is giving me an error. Now the Derby database is embedded >>> so that is probably the problem. Has anyone succeeded accessing the >>> database from within Eclipse ? >>> >>> regards, >>> >>> Danny >>> >>> Free Online Photosharing - Share your photos online with your >>> friends and family! >>> Visit http://www.inbox.com/photosharing to find out more! |
Free forum by Nabble | Edit this page |