java 如何找sql 密码,如何在java.sql.Connection中检索主机，端口，SID，用户和密码信息...

I have an Oracle connection (in a java.sql.Connection object) that is mounted from a properties file (ApplicationResources.properties).

How do I capture information about host, port, sid, user and password? (I need this information to call a specific database function through my java application)

Below my code:

private void conectaBanco() {

ServiceLocator sl = new ServiceLocator();

InitialContext ic = null;

DataSource dataSource = null;

try {

if (conn == null) {

ic = new InitialContext();

dataSource = (DataSource) ic.lookup(sl.getInfo().getString("JNDI"));

conn = dataSource.getConnection();

conn.setAutoCommit( true );

// I need host, port, sid and password information

System.out.println("USER " + conn.getMetaData().getUserName());

}

} catch (SQLException e) {

logger.error("Erro ao tentar abrir conexao com o banco de dados.", e);

} catch (NamingException e) {

logger.error("Erro ao tentar abrir conexao com o banco de dados.", e);

}

if(conn != null)

rastrear.definePredicate(conn);

}

解决方案

I solve this problem adding on my Weblogic configuration JDBC the additional parameters (host, user, port, sid - the password is returned automaticaly).

And I got this values throw this code below:

import weblogic.jdbc.wrapper.PoolConnection;

import java.util.Properties;

(...)

public Properties retornaPropriedadesConexao(){

PoolConnection pc = (PoolConnection)conn;

Properties p = pc.getConnectionEnv().getDriverProperties();

return p;

}