Re: Does derby have an embedded Mode like Derby ? - Mailing list pgsql-general

From Bill Moran
Subject Re: Does derby have an embedded Mode like Derby ?
Date
Msg-id 20090804103608.81f2a746.wmoran@potentialtech.com
Whole thread Raw
In response to Re: Does derby have an embedded Mode like Derby ?  (Paul Taylor <ijabz@fastmail.fm>)
Responses Re: Does derby have an embedded Mode like Derby ?  (Paul Taylor <ijabz@fastmail.fm>)
List pgsql-general
In response to Paul Taylor <ijabz@fastmail.fm>:

> Bill Moran wrote:
> > In response to Paul Taylor <ijabz@fastmail.fm>:
> >
> >> Sam Mason wrote:
> >>
> >>> On Tue, Aug 04, 2009 at 01:37:34PM +0100, Paul Taylor wrote:
> >>>
> >>>
> >>>> Does postgres have an embedded mode to allow a database to be embedded
> >>>> with Java application without requiring seperate db manager, like the
> >>>> derby database does ?
> >>>>
> >>> No, and I think the consensus is that this would be bad.  See:
> >>>
> >>>   http://wiki.postgresql.org/wiki/FAQ#Can_PostgreSQL_be_embedded.3F
> >>>
> >> Thats a shame, I wanted to write junit test for a java program that
> >> queried a database, requiring a full database to be available for unit
> >> tests is not really an environment I want to have.
> >
> > Has it occurred to you that testing a DB client when there's no
> > DB isn't really a very accurate or realistic test?
>
> I am testing the code that extracts information from a read only
> database. These are UNIT tests so only interested in getting the right
> results given a particular set of data, anything else is a distraction.

Then replace the DB client class with a class that returns fabricated
data for the purpose of your test.

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/

pgsql-general by date:

Previous
From: Ivan Sergio Borgonovo
Date:
Subject: Re: parameters in functions and overlap with names of columns
Next
From: "Bayless Kirtley"
Date:
Subject: Re: Does derby have an embedded Mode like Derby ?