Question

我有这部法典,用于适当使用JBoss 5.1、Oracle 11、ojdbc6.jar。我正在按需要获得OracleConnection。

InitialContext ic = new InitialContext();
DataSource  ds = ( DataSource ) ic.lookup( "java:/" + dataSource );
Connection con = ds.getConnection();       
OracleConnection conn = con.unwrap( OracleConnection.class );

Not anymore using JBoss 7, Oracle 11, ojdbc6.jar. It says like this:

Connection Not a wrapper class for Oracle Connection

如果有任何想法,请帮助。

Answer 1

我将“OracleConnectionPoolDataSource”作为玻璃鱼的数据收集类别。

使用班级或组类。

Edit and Try:

public OracleConnection getOracleConnection(Connection connection) throws SQLException {
    OracleConnection oconn = null;
    try {
        if (connection.isWrapperFor(oracle.jdbc.OracleConnection.class)) {
            oconn = (OracleConnection) connection.unwrap(oracle.jdbc.OracleConnection.class)._getPC();
        }
    } catch (SQLException e) {
        throw e;
    }
    return oconn;
}

Answer 2

象此一样,利用它作为WrappedConnection

Connection con = ds.getConnection();
WrappedConnection wc = (WrappedConnection) con;
OracleConnection conn =  (OracleConnection) wc.getUnderlyingConnection();

友情链接