Trying to connect to database in Java DB netbeans?

Question

I'm trying to connect to embedded database Java DB from NetBeans 7.1.

this is what I tried:

    try{
    String driver = "org.apache.derby.jdbc.EmbeddedDriver";
    String url = "jdbc:derby:market; create=true";
    String db = "/artikli";
    String user = "wolf";
    String pass = "wolf";
    String query = "SELECT * FROM artikli";
    Connection conn = null;

        Class.forName(driver);
        conn = DriverManager.getConnection(url + db, user, pass);
        java.sql.Statement stmt = conn.createStatement();
        ResultSet res = stmt.executeQuery(query); 

        System.out.println(res.getString("naziv")); // naziv = column name


        res.close();

    }catch(Exception e){

    }

My question is how to get data and print, or populate JTable with it, and is this connection good, thanks? thank you in advance.

I'm trying to connect to embedded database Java DB from NetBeans 7.1 -- I'm not familiar with Netbeans, but try looking in the menus. Perhaps you have a menu like "Databases" where you can select "Connect...". HTH. — aioobe
– aioobe, Commented Mar 23, 2012 at 14:24
I don't have error, just I don't get anything printed. I have already populated database table. My question is how to get data and print, or populate JTable with it, and is this connection good, thanks? — Wolf87
– Wolf87, Commented Mar 23, 2012 at 14:25
@Wolf87 - You do have an error, but your catch clause is swallowing it. As Oleg suggested, print the exception so you can see it... — Leigh
– Leigh, Commented Mar 24, 2012 at 0:57

erikjber · Accepted Answer · 2012-03-23 14:30:27Z

1

You must advance the result set to the first entry, like this:

while(res.next()){System.out.println(res.getString("naziv"));}

answered Mar 23, 2012 at 14:30

erikjber

111 bronze badge

Sign up to request clarification or add additional context in comments.

1 Comment

user800014 Over a year ago

Complementing: more info about JDBC in docs.oracle.com/javase/tutorial/jdbc/index.html

Oleg Mihailenko · Accepted Answer · 2012-03-23 14:30:20Z

0

look at your code, you even don't print expected errors, your catch block is empty, so print this exception and you will get the answer.

answered Mar 23, 2012 at 14:30

Oleg Mihailenko

912 bronze badges

Collectives™ on Stack Overflow

Trying to connect to database in Java DB netbeans?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related