Hi Matt,

That sounds like it's worth a try.  Got an example of how to use
absolute database names?

Regards,
Hiram

On 3/22/06, Matt Sanford <mzsanford@aol.com> wrote:
> Hello,
>
>     I currently use two separate databases from within the same JVM by
> specifying absolute database names (rather than derby.system.home and a
> relative path). This keeps my files separated and seems to work very
> well. Is there some monitor locking within Derby that is essentially
> synchronizing these under the covers ? I have seen a performance
> improvement so I suspect that if there is it is minimal.
>     In my case I found much of my time was spent waiting on my static DB
> class. To fix it I open multiple databases and choose them using a hash
> of one of my key fields. works like a charm.
>
> Cheers;
>   -- Matt Sanford
>
> David.Vancouvering@Sun.COM wrote:
> > Hi, Hiram.  You have hit on an issue that prevents multiple databases
> > from being run within the same VM.  This is something we want to fix
> > in Derby, but it's a fairly big effort.
> >
> > As it stands the only way to configure the Derby database home is with
> > system properties.  So all uses of Derby within a given VM must access
> > the same database home and use the same system-wide configuration.
> >
> > David
> >
> > Hiram Chirino wrote:
> >> Hi Everybody,
> >>
> >> ActiveMQ makes extensive use of Derby for storage of it's persistent
> >> messages.  You have have done a great job with Derby!  Thanks for the
> >> hard work!
> >>
> >> One of the things that ActiveMQ supports is running multiple brokers
> >> on 1 JVM.  In that case we would actually like to run 2 derby
> >> instances with different data directories.  It seems that currently we
> >> have to set the "derby.system.home" to configure where the data files
> >> should go.  This does not seem to lend itself to supporting multiple
> >> derby instances with each with it's own data directory.  Is it
> >> possible to fully configure derby without using System properties??
> >>
> >> --
> >> Regards,
> >> Hiram
>
> --
>
>
> We love flattery, even though we are not deceived by it,
> because it shows that we are of importance enough
> to be courted.
>
>     -Ralph Waldo Emerson, writer and philosopher (1803-1882)
>
>


--
Regards,
Hiram