Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: pass (athena.apache.org: domain of mkienenb@gmail.com designates
 209.85.214.43 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <1352556723.25783.YahooMailNeo@web122302.mail.ne1.yahoo.com>
References: <1352502260.75442.YahooMailNeo@web122304.mail.ne1.yahoo.com>
 <CAA-upzpO6W8=DAyTDw=9f+gRNoaOdNMmGo3Yc8A68buHymoWRA@mail.gmail.com>
 <1352556723.25783.YahooMailNeo@web122302.mail.ne1.yahoo.com>
From: Mike Kienenberger <mkienenb@gmail.com>
Date: Sat, 10 Nov 2012 09:36:34 -0500
Message-ID: 
 <CAM1yOjb1fXwBEmVS=jhmpZRrgmPE3HYE5gQHTnkXbTq=BM9W_A@mail.gmail.com>
Subject: Re: createIfNoSchemaStrategy
To: user@cayenne.apache.org, emeka okafor <emeka_1978@yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

I haven't used H2 without schemas.

Normally I work using this:

jdbc:h2:~/database.file;SCHEMA_SEARCH_PATH=3Dschema1,schema2,schema3,etc

On Sat, Nov 10, 2012 at 9:12 AM, emeka okafor <emeka_1978@yahoo.com> wrote:
> Hello again,
>
> thank you for the help. I settled with h2database to begin with and now I=
 am getting this error when I try to run cayenne:
>
> Schema "TEST" not found; SQL statement: create blablabla....
>
>
> even though I have set the following:
>
> schema-update-strategy=3D"org.apache.cayenne.access.dbsync.CreateIfNoSche=
maStrategy"
>
>
> Any idea?
>
> ________________________________
>  From: Michael Gentry <mgentry@masslight.net>
> To: user@cayenne.apache.org; emeka okafor <emeka_1978@yahoo.com>
> Sent: Saturday, November 10, 2012 2:26 PM
> Subject: Re: testing with cayenne
>
> Hi Emeka,
>
> We've used http://h2database.com/ before to create a real in-memory
> database to run tests against.  H2 is small and fast and works pretty
> well, plus by creating your schema/data in-memory only, you don't have
> to worry about file permissions or cleanup when your tests are done
> running.
>
> mrg
>
>
> On Fri, Nov 9, 2012 at 6:04 PM, emeka okafor <emeka_1978@yahoo.com> wrote=
:
>> New cayenne user here. I am trying to use cayenne as the orm for an appl=
ication and I was wondering how you guys write your unit test? do you test =
with a real database or do you have predefined mock objectcontext and son o=
n to be able to write performant test?
>> Thank you.