Help setting up JavaDB

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..

Code:

---

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

---

Thanks :)

Quote:

---

Originally Posted by 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..

Code:

---

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