Discussion :

[roki-rakat]

Bonjour,
Je suis en train d'essayer de me connecter à ma BDD. Voilà le résultat de l'exécution. Pourquoi ce problème ?

Driver O.K.
url dec
user dec
pass dec
con dec
Driver O.K.
url dec
user dec
pass dec
con dec
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:389)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:454)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:802)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at Connect.main(Connect.java:20)

java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:389)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:454)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:802)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at Connect.main(Connect.java:20)

Voilà mon code :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
public static void main(String[] args) {
 
		try {
		Class.forName("oracle.jdbc.driver.OracleDriver");
		System.out.println("Driver O.K.");
		String url = "jdbc:oracle:thin:@//127.0.0.1:1521/orcl";
		System.out.println("url dec");
		String user = "......";
		System.out.println("user  dec");
		String passwd = ".....";
		System.out.println("pass dec");
		Connection conn ;
		System.out.println("con  dec");
		conn= DriverManager.getConnection(url, user,passwd);
		System.out.println("Connexion effective !");
		} catch (Exception e) {
		e.printStackTrace();
 
	}
 
}

[Alkhan]

bonjour,
Il y a de forte chance que ton URL ne soit pas correct, ou que le listener ne soit pas démarré !
Oracle est il bien démarré sur ta machine ?
Est ce bien le port 1521 ?
Et le service est il orcl ?