db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David Van Couvering" <da...@vancouvering.com>
Subject Re: Fwd: [nbusers] netbeans 6.0 RC1 SQLSyntaxException: table/view does not exist
Date Mon, 26 Nov 2007 20:48:36 GMT
Very good!  I'll write a blog linking to your source, people do want
to know how to do this.

David

On Nov 22, 2007 2:31 AM, Alan Burlison <Alan.Burlison@sun.com> wrote:
> David Van Couvering wrote:
>
> > It sure would be great if somebody wrote up a tutorial or blog or
> > whatever describing the different ways to initialize an embedded
> > database for the first time (e.g. using JDBC, JPA, or by including a
> > "starting" database in your JAR file that you copy over...)
>
> No tutorial, but some working code:
>
> http://src.opensolaris.org/source/xref/website/auth/trunk/AuthDB/src/org/opensolaris/auth/db/DbManager.java
>
> This runs inside Tomcat and creates a new database the first time it is
> run, subsequent runs use the existing database.  The database runs in
> embedded server mode, so whilst Tomcat is running you can access it
> externally as well.
>
> The database is initialised via SQL script files that are contained in
> the application WAR file, using the ij utility (derbytools.jar).  ij can
> be run from inside an application as well as from the command-line, and
> ij + SQL scripts is the easiest way I've found so far of setting up a
> database, because the SQL scripts can be debugged from the command-line
> before being embedded in the app.
>
> --
> Alan Burlison
> --
>



-- 
David W. Van Couvering
http://davidvancouvering.blogspot.com

Mime
View raw message