Conexão Oracle 11 XE

Assuntos Gerais
#1

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

[code]
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

[/code]

Codigo:[code]
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());
	}
}[/code]

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

#2

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
#3

Obrigado resolveu era a instancia.!

#4