Probleme No data found avec odbc et access
Bonjour,
j'ai créer une base de donnée access et je désire me connecter a celle ci via une application java.
voici le code que j'utilise pour me connecter à la base
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
|
public ConnectionAcess() {
// TODO Auto-generated constructor stub
try{
/**
* chargement du driver
*/
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
/**
* connexion au server
*/
String login = "";
String password = "";
String URL = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBN=BaseDeDonnee\\mabase.mdb";
conn = DriverManager.getConnection(URL, login, password);
System.out.println("Connexion établie!!!!!");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
Message mess = new Message("Erreur lors de la connexion");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
Message mess = new Message("Erreur lors de la connexion");
} catch (InstantiationException e) {
// TODO Auto-generated catch block
e.printStackTrace();
Message mess = new Message("Erreur lors de la connexion");
} catch (IllegalAccessException e) {
// TODO Auto-generated catch block
e.printStackTrace();
Message mess = new Message("Erreur lors de la connexion");
}
}//ConnectionAcess |
et voici l'erreur que j'obtiens :
java.sql.SQLException: No data found
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at connection.ConnectionAcess.<init>(ConnectionAcess.java:28)
at fenetres.FenetreConnection$1.actionPerformed(FenetreConnection.java:151)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
quelqu'un peut il m'éclairer car je ne vois pas ce qui cloche dans mon code
merci
Ogtraba