creating a new db

I want to create a new Derby database using jdbc on the first time an application is run. I am using the following command connect 'jdbc:derby:db;create=true;user=user;password=password'

This works fine but I want to know when the table is created so I can execute the create tables SQL. I can execute a simple SQL query and then catch the "42Y07" error and run the script if the table does not exist, but this does not seem like a good solution. I want to just know when the table is created so I don't have to deal with any errors being thrown.

Thanks in Advance,

Mike

[598 byte] By [Mike_Calgooa] at [2007-11-27 6:03:42]
# 1
Just create a separate application which creates the database. Either the user or your install runs it once.
jschella at 2007-7-12 16:46:45 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...