connexion impossible jdbc
Bonjours
après plusieurs tentatives j'arrive pas a me connecté a la base de donné, si vous pouvez m'aider
mon code :
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
String url= "jdbc:oracle:thin:@adresseIP:1521:toto";
String usr= "usr";
String pwd= "pwd";
String driver="oracle.jdbc.driver.OracleDriver";
String query = "SELECT * FROM maTable";
ResultSet results;
try
{
Class.forName(driver).newInstance();
DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());
Connection ConnexionOracle = DriverManager.getConnection(url,usr,pwd);
Statement stmt = ConnexionOracle.createStatement();
results = stmt.executeQuery(query);
while(results.next()){
System.out.print(results.getString("champ1"));
}
ConnexionOracle.close(); |
voici les exception que j'obtiens
Code:
1
2
3
4
5
6
7
8
9
10
11
|
java.sql.SQLException: Exception d'E/S: The Network Adapter could not establish the connection
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:404)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at Graph.PaintGraph.main(PaintGraph.java:29) |
