Thread: Java DB embedded

Hi,

I am trying to create a Java based quiz game on Netbeans IDE. What I've been trying to do is to have questions and answers in a database, draw information from there whenever it's required and print the questions/answers in labels in a jFrame. Now, I've tried it with the local MySQL Server and it's working fine. However, to distribute this application, I need to have an embedded DB.

I would be highly grateful if someone could give me a step by step guide or point me to a detailed tutorial on how exactly I should do that (all the tutorials I've encountered have been for CRUD Desktop Applications...not useful for me). I would request you all not give me vague replies (like just use Java Derby!! duh!!). I'm kinda a newbie so specifics would be great like what files to import in the library and everything. I have The Netbeans 7.0 ALL BUNDLE and standard JDK. I would also be very very grateful if the instructions were very basic - like -

1. Start with opening the services tab in Tools.

I am new to JDBC and this forum so please forgive me if I haven't adhered to certain forum protocols.

Thanks a lot,
Please do reply,
P

Crossposted on http://www.coderanch.com/t/545853/JD...va-DB-embedded

All you should need to do is add the derby.jar library to your project. From there, you should be to obtain a database connection using JDBC (see Trail: JDBC(TM) Database Access (The Java™ Tutorials) ). See the following for different ways to point to your local database location: Database connection examples
Be sure to use the create=true flag if you need to initially create the database. From there, you can use the connection to create your table structure and insert the data.

Hi copeg,

Thanks for the tips. Funnily enough I had arrived at the same conclusion and so that's what I had tried earlier. I added derby.jar in the library for my app and then created a table in the APP schema of a database called db1 from the services tab of Netbeans IDE. Then I tried to print it's contents and it gave me the error

java.sql.SQLSyntaxErrorException: Table/View 'APP.TB1' does not exist.

Here is the code of the function

void see()
    {
        try{ 
        Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
}catch(ClassNotFoundException e){
            System.out.println(e);
        }
 
         try{
       Connection con = DriverManager.getConnection("jdbc:derby:db1","test","test");
        Statement stmt = con.createStatement();
 
        ResultSet rs = stmt.executeQuery("SELECT * FROM APP.TB1");
 
        while (rs.next()) {
        String s = rs.getString("Name");
        float n = rs.getFloat("Id");
        System.out.println(n + "   " + s);
    }
        }catch(SQLException e){
            System.err.println(e);
        }      
 
 
        con.close();
 
    }

Please let me know what I'm doing wrong.

Also I tried to create a table using the following code which worked fine and it said table created but I don't know under which schema the table actually is. I also tried printing the data in the table Employee11(the one I created in the following code) and the output box remained unchanged.

void see2()
    {
        try{ 
        Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
            }
        catch(ClassNotFoundException e){
            System.out.println(e);
        }
 
        try{
            Connection con = DriverManager.getConnection("jdbc:derby:db1","test","test");
  Statement st = con.createStatement();
  String table = 
  "CREATE TABLE Employee11(Emp_code integer, Emp_name varchar(10))";
  st.executeUpdate(table);
  System.out.println("Table created successfully!");
 
  }
  catch(SQLException s){
  System.out.println("Table already exists!");
  }
 
 
        con.close();
 
    }

Please do reply
P