Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (asf.osuosl.org: local policy)
Date: Mon, 10 Oct 2005 16:29:14 +0200
From: Xavier Vigouroux <Xavier-Francois.Vigouroux@Sun.COM>
Subject: Re: transient priviledgeException
In-reply-to: <x1ofwtklfpm0.fsf@atum11.norway.sun.com>
To: Derby Discussion <derby-user@db.apache.org>
Message-id: <0148e67b180903b56799083563ba827f@sun.com>
MIME-version: 1.0 (Apple Message framework v623)
Content-type: text/plain; charset=ISO-8859-1; format=flowed
Content-transfer-encoding: QUOTED-PRINTABLE
References: <02f29e1edfe80e671e61cf73dd6be2d7@sun.com>
 <x1of8xx9nfbe.fsf@clustra.norway.sun.com>
 <5888c9913640e16156181e4994c43d45@sun.com>
 <200510051149.08338.msegel@segel.com>
 <257cd592d7d5c57e54dffb9dc69bb79f@sun.com>
 <x1ofwtklfpm0.fsf@atum11.norway.sun.com>


Le 10 oct. 05, =E0 15:50, =D8ystein Gr=F8vlen a =E9crit :

>>>>>> "XV" =3D=3D Xavier Vigouroux <Xavier-Francois.Vigouroux@Sun.CO=
M>=20
>>>>>> writes:
>
>     XV> If I  understand you, you  propose to improve  my call to p=
ing=20
>  with a
>     XV> loop on  the creation  (ie. url with  create=3Dtrue) of a =
=20
> *FAKE* schema
>     XV> until it succeeds.
>
>
>     XV> Then I  have to delete  all the associated  files..... This=
 is=20
>  what I
>     XV> call a work-around :-)
>
> Xavier,
>
> What if you try to connect to a non-existing database without
> 'create=3Dtrue'?  In that case, no files will be created.  I have n=
ot
> tried this out myself, but maybe you will be able to observe a
> different behavior when the db is ready to create a database.  E.g,
> you get priviledgeException if not yet ready and "Database not foun=
d"
> when it is ready.  In that case you will be able to loop without
> having to clean up any files.

that's a good point!!! I will try
>
> Another alternative could be to try do this in the server VM instea=
d
> of/in addition to ping().  If you are lucky, your getConnection wil=
l
> in that case not return until it is possible to create a database.
>

that would be great indeed !!!

I keep you inform... thanks

> --=20
> =D8ystein
>
>
--=20
Xavier VIGOUROUX - sun microsystems