Hi, I'm trying to do a simple database search but netbeans will keep telling me that "org.apache.derby does not exist".

Now, I've been all day looking around trying to find an answer but so far, nothing.

I have added derby.jar to the libraries and when typing netbeans suggests "org.apache.derby.jdbc.EmbeddedDriver", but then the error says it doesn't exist

I'm sorry, I have no idea what to do next so.... can anyone help?

Class.forName(org.apache.derby.jdbc.EmbeddedDriver );
Connection con = DriverManager.getConnection("jdbc:derby://localhost:1527/Armas", "sala", "armas");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT APELLIDO FROM APP.CAD WHERE APELLIDO = 'Stupenengo'");
String str = rs.getString("APELLIDO");