Access Derby Database separately from Eclipse

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Access Derby Database separately from Eclipse

Danny Gaethofs-2

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!
Reply | Threaded
Open this post in threaded view
|

Re: Access Derby Database separately from Eclipse

David E Jones-2

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!

Reply | Threaded
Open this post in threaded view
|

Re: Access Derby Database separately from Eclipse

Danny Gaethofs-2
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!
Reply | Threaded
Open this post in threaded view
|

Re: Access Derby Database separately from Eclipse

David E Jones-2

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!