You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@geronimo.apache.org by Tim McConnell <ti...@gmail.com> on 2010/06/17 20:40:22 UTC
System Derby Database question
Hi, I'd like to configure and use the Geronimo embedded Derby database
outside the default \var\derby directory, and actually outside the
Geronimo installation directory. Does anyone know if this is possible ??
If so has anyone done this ??
--
Thanks,
Tim McConnell
Re: System Derby Database question
Posted by Tim McConnell <ti...@gmail.com>.
Not a problem Luciano, I maybe wasn't as clear as I should have been.
Thanks for the info....
On 6/17/2010 3:35 PM, Luciano Salotto wrote:
> Sorry, I thought you wanted to place ur own db somewhere else, not the
> Geronimo System db. My apologies for the confussion.
> Luciano
>
> On Thu, Jun 17, 2010 at 4:29 PM, Kevan Miller <kevan.miller@gmail.com
> <ma...@gmail.com>> wrote:
>
>
> On Jun 17, 2010, at 2:40 PM, Tim McConnell wrote:
>
> > Hi, I'd like to configure and use the Geronimo embedded Derby
> database
> > outside the default \var\derby directory, and actually outside the
> > Geronimo installation directory. Does anyone know if this is
> possible ?? If so has anyone done this ??
>
> I've never tried this, but you can override the default
> 'derbySystemHome' attribute on the DerbySystem GBean. Find the
> system-database module in config.xml and make it something like:
>
> <module name="org.apache.geronimo.configs/system-database/2.1.5/car">
> <gbean name="DerbyNetwork">
> <attribute name="host">${ServerHostname}</attribute>
> <attribute name="port">${DerbyPort + PortOffset}</attribute>
> </gbean>
> <gbean name="DerbySystem">
> <attribute name="derbySystemHome">var/derby</attribute>
> </gbean>
> </module>
>
> I would assume that derbySystemHome can be configured to an explicit
> location, rather than a relative location...
>
> --kevan
>
>
--
Thanks,
Tim McConnell
Re: System Derby Database question
Posted by Luciano Salotto <ls...@gmail.com>.
Sorry, I thought you wanted to place ur own db somewhere else, not the
Geronimo System db. My apologies for the confussion.
Luciano
On Thu, Jun 17, 2010 at 4:29 PM, Kevan Miller <ke...@gmail.com>wrote:
>
> On Jun 17, 2010, at 2:40 PM, Tim McConnell wrote:
>
> > Hi, I'd like to configure and use the Geronimo embedded Derby database
> > outside the default \var\derby directory, and actually outside the
> > Geronimo installation directory. Does anyone know if this is possible ??
> If so has anyone done this ??
>
> I've never tried this, but you can override the default 'derbySystemHome'
> attribute on the DerbySystem GBean. Find the system-database module in
> config.xml and make it something like:
>
> <module name="org.apache.geronimo.configs/system-database/2.1.5/car">
> <gbean name="DerbyNetwork">
> <attribute name="host">${ServerHostname}</attribute>
> <attribute name="port">${DerbyPort + PortOffset}</attribute>
> </gbean>
> <gbean name="DerbySystem">
> <attribute name="derbySystemHome">var/derby</attribute>
> </gbean>
> </module>
>
> I would assume that derbySystemHome can be configured to an explicit
> location, rather than a relative location...
>
> --kevan
>
>
Re: System Derby Database question
Posted by chi runhua <ch...@gmail.com>.
Updated for both 2.1 and 2.2 doc.
See:
[1].
https://cwiki.apache.org/GMOxDOC21/configuring-databases-in-geronimo.html
[2].
https://cwiki.apache.org/GMOxDOC22/configuring-databases-in-geronimo.html
Jeff
On Fri, Jun 18, 2010 at 10:18 AM, chi runhua <ch...@gmail.com> wrote:
> I'll doc this and post here the linkage.
> Thank you all!
>
> Jeff
>
> On Jun 18, 2010 4:00 AM, "Tim McConnell" <ti...@gmail.com> wrote:
>
> Thanks Kevan, this works beautifully -- both relative and explicit
> locations !!
>
>
>
> On 6/17/2010 3:29 PM, Kevan Miller wrote:
> >
> >
> > On Jun 17, 2010, at 2:40 PM, Tim McConnell wrote:
> ...
> --
> Thanks,
> Tim McConnell
>
>
Re: System Derby Database question
Posted by chi runhua <ch...@gmail.com>.
I'll doc this and post here the linkage.
Thank you all!
Jeff
On Jun 18, 2010 4:00 AM, "Tim McConnell" <ti...@gmail.com> wrote:
Thanks Kevan, this works beautifully -- both relative and explicit locations
!!
On 6/17/2010 3:29 PM, Kevan Miller wrote:
>
>
> On Jun 17, 2010, at 2:40 PM, Tim McConnell wrote:
...
--
Thanks,
Tim McConnell
Re: System Derby Database question
Posted by Tim McConnell <ti...@gmail.com>.
Thanks Kevan, this works beautifully -- both relative and explicit
locations !!
On 6/17/2010 3:29 PM, Kevan Miller wrote:
>
> On Jun 17, 2010, at 2:40 PM, Tim McConnell wrote:
>
>> Hi, I'd like to configure and use the Geronimo embedded Derby database
>> outside the default \var\derby directory, and actually outside the
>> Geronimo installation directory. Does anyone know if this is possible ?? If so has anyone done this ??
>
> I've never tried this, but you can override the default 'derbySystemHome' attribute on the DerbySystem GBean. Find the system-database module in config.xml and make it something like:
>
> <module name="org.apache.geronimo.configs/system-database/2.1.5/car">
> <gbean name="DerbyNetwork">
> <attribute name="host">${ServerHostname}</attribute>
> <attribute name="port">${DerbyPort + PortOffset}</attribute>
> </gbean>
> <gbean name="DerbySystem">
> <attribute name="derbySystemHome">var/derby</attribute>
> </gbean>
> </module>
>
> I would assume that derbySystemHome can be configured to an explicit location, rather than a relative location...
>
> --kevan
>
--
Thanks,
Tim McConnell
Re: System Derby Database question
Posted by Kevan Miller <ke...@gmail.com>.
On Jun 17, 2010, at 2:40 PM, Tim McConnell wrote:
> Hi, I'd like to configure and use the Geronimo embedded Derby database
> outside the default \var\derby directory, and actually outside the
> Geronimo installation directory. Does anyone know if this is possible ?? If so has anyone done this ??
I've never tried this, but you can override the default 'derbySystemHome' attribute on the DerbySystem GBean. Find the system-database module in config.xml and make it something like:
<module name="org.apache.geronimo.configs/system-database/2.1.5/car">
<gbean name="DerbyNetwork">
<attribute name="host">${ServerHostname}</attribute>
<attribute name="port">${DerbyPort + PortOffset}</attribute>
</gbean>
<gbean name="DerbySystem">
<attribute name="derbySystemHome">var/derby</attribute>
</gbean>
</module>
I would assume that derbySystemHome can be configured to an explicit location, rather than a relative location...
--kevan
Re: System Derby Database question
Posted by Luciano Salotto <ls...@gmail.com>.
You can do that by specifying the path in the connetion string, something
like
jdbc:derby:/path/to/db;create=true
Hope this helps...
Luciano
On Thu, Jun 17, 2010 at 3:52 PM, Tim McConnell <ti...@gmail.com>wrote:
> Very nice -- thanks Luciano
>
>
> On 6/17/2010 2:46 PM, Luciano Salotto wrote:
>
>> yes, it is possible to do so... have done it in the past, but don't
>> recall how did I do it. will look for that and let you know.
>>
>> On Thu, Jun 17, 2010 at 3:40 PM, Tim McConnell <tim.mcconne@gmail.com
>> <ma...@gmail.com>> wrote:
>>
>> Hi, I'd like to configure and use the Geronimo embedded Derby database
>> outside the default \var\derby directory, and actually outside the
>> Geronimo installation directory. Does anyone know if this is
>> possible ?? If so has anyone done this ??
>>
>> --
>> Thanks,
>> Tim McConnell
>>
>>
>>
> --
> Thanks,
> Tim McConnell
>
Re: System Derby Database question
Posted by Tim McConnell <ti...@gmail.com>.
Very nice -- thanks Luciano
On 6/17/2010 2:46 PM, Luciano Salotto wrote:
> yes, it is possible to do so... have done it in the past, but don't
> recall how did I do it. will look for that and let you know.
>
> On Thu, Jun 17, 2010 at 3:40 PM, Tim McConnell <tim.mcconne@gmail.com
> <ma...@gmail.com>> wrote:
>
> Hi, I'd like to configure and use the Geronimo embedded Derby database
> outside the default \var\derby directory, and actually outside the
> Geronimo installation directory. Does anyone know if this is
> possible ?? If so has anyone done this ??
>
> --
> Thanks,
> Tim McConnell
>
>
--
Thanks,
Tim McConnell
Re: System Derby Database question
Posted by Luciano Salotto <ls...@gmail.com>.
yes, it is possible to do so... have done it in the past, but don't recall
how did I do it. will look for that and let you know.
On Thu, Jun 17, 2010 at 3:40 PM, Tim McConnell <ti...@gmail.com>wrote:
> Hi, I'd like to configure and use the Geronimo embedded Derby database
> outside the default \var\derby directory, and actually outside the
> Geronimo installation directory. Does anyone know if this is possible ?? If
> so has anyone done this ??
>
> --
> Thanks,
> Tim McConnell
>