Help setting up JavaDB

[java_beginner]

Hi

I'm trying to set up and use JavaDB with Netbeans. I set up a JavaDBEmbedded library in Netbeans and the small piece of code I have wont run. The current error is
java.sql.SQLException: Database 'TestDB' not found.

I didn't think JavaDB needed much setting up but I've since gone back and read about setting the CLASSPATH and DERBY_HOME variable. What I've read all say to set it temporarily and do it at the command line. I'm not sure how to go about this since I'm using Netbeans. Can anyone offer any advice how to get it up and working??

The code I'm using is..

Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
            Connection con = DriverManager.getConnection("jdbc:derby:TestDB","user", "password");

Thanks :)

[JosAH]

Hi

I'm trying to set up and use JavaDB with Netbeans. I set up a JavaDBEmbedded library in Netbeans and the small piece of code I have wont run. The current error is
java.sql.SQLException: Database 'TestDB' not found.

I didn't think JavaDB needed much setting up but I've since gone back and read about setting the CLASSPATH and DERBY_HOME variable. What I've read all say to set it temporarily and do it at the command line. I'm not sure how to go about this since I'm using Netbeans. Can anyone offer any advice how to get it up and working??

The code I'm using is..

Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
            Connection con = DriverManager.getConnection("jdbc:derby:TestDB","user", "password");

Thanks :)

If you don't have that testDB yet append the string ";create=true" to your url.

kind regards,

Jos