Dear Magnus,

On the Derby Wiki, I have posted the source for a DatabaseManager class that does this (among other things):

http://wiki.apache.org/db-derby/DatabaseManager

The current version of DatabaseManager does much more but unfortunately I am not free to post that source code.

Donald

On Jan 3, 2008 9:43 AM, Magnus Prime < magnusprime@hotmail.com> wrote:
 
Hi.
 
I am fairly new to derby, but I am enjoying it so far.  What I want to know, is there a way to connect to Derby, and check that the DB you want to use exists, and if not, then go create it.
 
I am using the embedded driver (in a Java program), and I know I can add the ;create flag to the URL, but does that have any adverse effects if the DB has already been created? 
 
The end result of what i am trying to accomplish, is that the first time the program is run, create the required DB and its tables/sample data, and from then on, dont create it if it already exists.