connection à une base de données Oracle par un code java
je développe un application graphique en java qui doit se connecter à une base de données Oracle et y executer des requettes de lecture (select) voila mes codes
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
Connection con = null;
DatabaseConnection conn = new DatabaseConnection();
conn.getConnection();
//sql request
query = "select" + jTextField2.getText() + "from" + jTextField1.getText() + ";";
try {
Statement stmt = con.createStatement();
rs = stmt.executeQuery(query);
}
catch (SQLException ex) {
Logger.getLogger(Guiapplet.class.getName()).log(Level.SEVERE, null, ex);
System.out.println("exception due a la requete");
} |
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
|
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package my.guifordatabase.pkg;
import java.sql.*;
public class DatabaseConnection {
private Connection connection = null;
private String log;
private String pass;
public Connection getConnection() {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//login and password
log = "hr";
pass = "hr";
//connection string
connection = DriverManager.getConnection("jdbc:odbc//xe",log,pass);
}
catch (Exception ex) {
ex.printStackTrace();
}
return connection;
}
} |
et voila l'erreur que j'ai
Citation:
java.sql.SQLException: [Microsoft][Gestionnaire de pilotes ODBC] Source de données introuvable et nom de pilote non spécifié
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3073)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:323)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at my.guifordatabase.pkg.DatabaseConnection.getConnection(DatabaseConnection.java:28)
at my.guifordatabase.pkg.Guiapplet.jButton1MouseClicked(Guiapplet.java:206)
at my.guifordatabase.pkg.Guiapplet.access$100(Guiapplet.java:18)
at my.guifordatabase.pkg.Guiapplet$2.mouseClicked(Guiapplet.java:82)
at java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:253)
at java.awt.Component.processMouseEvent(Component.java:6044)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
at java.awt.Component.processEvent(Component.java:5806)
at java.awt.Container.processEvent(Container.java:2058)
at java.awt.Component.dispatchEventImpl(Component.java:4413)
at java.awt.Container.dispatchEventImpl(Container.java:2116)
at java.awt.Component.dispatchEvent(Component.java:4243)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3995)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
at java.awt.Container.dispatchEventImpl(Container.java:2102)
at java.awt.Component.dispatchEvent(Component.java:4243)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
Exception in thread "AWT-EventQueue-1" java.lang.NullPointerException
at my.guifordatabase.pkg.Guiapplet.jButton1MouseClicked(Guiapplet.java:212)
at my.guifordatabase.pkg.Guiapplet.access$100(Guiapplet.java:18)
at my.guifordatabase.pkg.Guiapplet$2.mouseClicked(Guiapplet.java:82)
at java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:253)
at java.awt.Component.processMouseEvent(Component.java:6044)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
at java.awt.Component.processEvent(Component.java:5806)
at java.awt.Container.processEvent(Container.java:2058)
at java.awt.Component.dispatchEventImpl(Component.java:4413)
at java.awt.Container.dispatchEventImpl(Container.java:2116)
at java.awt.Component.dispatchEvent(Component.java:4243)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3995)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
at java.awt.Container.dispatchEventImpl(Container.java:2102)
at java.awt.Component.dispatchEvent(Component.java:4243)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
