I'd like to use derby to manipulate my database in netbeans but I get this error:
java.lang.ClassNotFoundException: org.apach.derby.jdbc.ClientDriver To add the derby library, I have done:
Right click on "Libraries" then
On the list, i selected Java DB Driver
Here is the code of my class ConnexionDB.java
public class ConnexionDB { private Connection conx = null; private final String urlBDD = "jdbc:derby://localhost:1527/tennis;create=true;user=tennis;password=tennis"; private String MessageError = "No Errors ! "; public ConnexionDB() { this.openConnexion(); this.createDataBase(); } private String getMessageError() { return MessageError; } private void setMessageError(String MessageError) { this.MessageError = MessageError; } private void openConnexion() { try { Class.forName("org.apach.derby.jdbc.ClientDriver"); this.conx = DriverManager.getConnection(urlBDD); } catch (Exception ex) { this.setMessageError("BD_Connexion:ouvrirConnexion:Erreur::: " + ex.getMessage()); ex.printStackTrace(); } } public void closeConnexion() { try { this.conx.close(); } catch (SQLException ex) { this.setMessageErreur("BD_Connexion:fermerConnexion:Erreur::: " + ex.getMessage()); } } public Object[][] selectExe(String requete) { Object[][] data = new Object[1][1]; try { if (requete.toLowerCase().contains("select")) { Statement ReqExe = this.conx.createStatement(); ResultSet ReqRes = ReqExe.executeQuery(requete); int nbreColonne = ReqRes.getMetaData().getColumnCount(); int nbreLigne = this.nombreLigne(requete); data = new Object[nbreLigne + 1][nbreColonne]; for (int i = 1; i <= nbreColonne; i++) { data[0][i - 1] = ReqRes.getMetaData().getCatalogName(i); } int cmptr = 1; while (ReqRes.next()) { for (int i = 1; i <= nbreColonne; i++) { data[cmptr][i - 1] = ReqRes.getString(i); } cmptr++; } ReqRes.close(); ReqExe.close(); } } catch (Exception ex) { this.setMessageErreur("BD_Connexion:selectExe:Erreur::: " + ex.getMessage()); } return data; } private int nombreLigne(String requete) { int nbreLigne = 0; try { if (requete.toLowerCase().contains("select")) { Statement ReqExe = this.conx.createStatement(); ResultSet ReqRes = ReqExe.executeQuery(requete); // while (ReqRes.next()) { nbreLigne++; } ReqRes.close(); ReqExe.close(); } } catch (Exception ex) { this.setMessageErreur("BD_Connexion:nombreLigne:Erreur::: " + ex.getMessage()); } return nbreLigne; } public boolean updateExe(String requete) { boolean data = false; try { if (!requete.toLowerCase().contains("select")) { Statement ReqExe = this.conx.createStatement(); int reqInfo = ReqExe.executeUpdate(requete); if (reqInfo > 0) { data = true; } ReqExe.close(); } } catch (Exception ex) { this.setMessageErreur("BD_Connexion:updateExe:Erreur::: " + ex.getMessage()); } return data; } private void createDataBase() { try { Statement ReqExe = this.conx.createStatement(); String tableAdherent = "CREATE TABLE IF NOT EXISTS ADHERENT\n" + "(NUMEROADHERENT INTEGER PRIMARY KEY GENERATED ALWAYS AS IDENTITY\n" + "(START WITH 1, INCREMENT BY 1),\n" + "NOM VARCHAR(24) NOT NULL,\n" + "PRENOM VARCHAR(24) NOT NULL,\n" + "ADDRESSE VARCHAR(50),\n" + "TELEPHONE VARCHAR(24),\n" + "EMAIL VARCHAR(30) NOT NULL UNIQUE,\n" + "PASSWORD VARCHAR(35) NOT NULL);"; ReqExe.execute(tableAdherent); String tableTouroi = "CREATE TABLE IF NOT EXISTS TOURNOI\n" + "(CODETOURNOI INTEGER PRIMARY KEY AUTOINCREMENT,\n" + "NOM VARCHAR(24) NOT NULL,\n" + "DATE VARCHAR(30) NOT NULL,\n" + "LIEU VARCHAR(30));"; ReqExe.execute(tableTouroi); String tableInscription = "CREATE TABLE IF NOT EXISTS INSCRIPTION\n" + "(IDINSCRIPTION INTEGER PRIMARY KEY AUTOINCREMENT,\n" + "NUMEROADHERENT INTEGER NOT NULL,\n" + "CODETOURNOI INTEGER NOT NULL,\n" + "DATEINSCRIPTION VARCHAR(30) NOT NULL,\n" + "CONSTRAINT fk_numeroAdherent Foreign KEY (NUMEROADHERENT) references ADHERENT(NUMEROADHERENT),\n" + "CONSTRAINT fk_codeTournoi Foreign KEY (CODETOURNOI) references TOURNOI(CODETOURNOI));"; ReqExe.execute(tableInscription); ReqExe.close(); } catch (SQLException ex) { System.out.println("Echecs : Creation des tables"); Logger.getLogger(ConnexionDB.class.getName()).log(Level.SEVERE, null, ex); } } } Even if I change:
Class.forName("org.apach.derby.jdbc.ClientDriver"); to:
Class.forName("org.apach.derby.jdbc.client"); I always get an error!
