Conexão Oracle 11 XE

2 respostas
marciofermino

Amigos, nunca trabalhei com Oracle. criei uma conexão mais estou recebendo a mensagem:


java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
 
	at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
	at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:480)
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:413)
	at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508)
	at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)
	at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at conexao.ConnectionFactory.getConnectionMysql(ConnectionFactory.java:16)
	at principal.main(principal.java:24)
Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
 
	at oracle.net.ns.NSProtocol.connect(NSProtocol.java:361)
	at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:966)
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:292)
	... 8 more
Codigo:
public static Connection getConnectionMysql() throws SQLException {
		try {

			
			Class.forName("oracle.jdbc.driver.OracleDriver");
			return DriverManager.getConnection(
					"jdbc:oracle:thin:@127.0.0.1:1521:bd", "SYSTEM", "123");
					
		
		} catch (ClassNotFoundException e) {
			throw new SQLException(e.getMessage());
		}
	}

Gostaria de ajuda com download drive e exemplo da conexão se possível. Obrigado.

2 Respostas

drsmachado

Veja isto
http://dbsmon.fnal.gov/cdf/12505.html

As versões XE do oracle não permitem que haja mais que uma instância, no caso, a padrão possui nome XE.
Então, tua url deveria ser:

jdbc:oracle:thin:@127.0.0.1:1521:XE

ao invés de

jdbc:oracle:thin:@127.0.0.1:1521:bd
marciofermino

Obrigado resolveu era a instancia.!

Criado 20 de dezembro de 2011
Ultima resposta 20 de dez. de 2011
Respostas 2
Participantes 2