Trouble Connecting to JavaDB - Desparately need HELP

[JosieH]

I'm doing a university project where I have to write an application with a backend database. I'm trying to use JavaDB.

I've created a simple JavaDB database in Netbeans. I've got the driver loaded but it's not connecting to the database.

I have the following code (GP_Demo, is the name of the database):


public static void main(String[] args) {
try {
// Load the JDBC driver
Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
System.out.println("Driver loaded");
} catch (Exception e) {
throw new RuntimeException("Could not load JavaDB JDBC driver");
}

try {
// Establish a connection
Connection con = DriverManager.getConnection("jdbc:derby:GP_Demo");
System.out.println("Database connected");

// Create a statement
Statement s = con.createStatement();

//Execute a statement
ResultSet rs = s.executeQuery("SELECT * FROM Students");

// Iterate through the result and print the student names
while(rs.next())
System.out.println(rs.getInt(1) + "\t"
+ rs.getString(2) + "\t"
+ rs.getString(3));

// Close the connection
con.close();
} catch(Exception e){
throw new RuntimeException("Could not connect to GP_Demo");
}

[ceyezumma]

I have created a derby db and connected.
I'm not sure what you have though.
Have you created tables?
and are you using xml or a properties sheet to get dbName etc?

[ceyezumma]

I couldn't create a embedded database at one time too, but I just had to add "create=true" this may be your simple solution to.

[JosieH]

Hi
Sorry, I forgot I'd posted this. I worked it out. Turns out I'd missed the whole bit about the .jar libraries.

But thanks anyways