Examples with OPAQUE oracle.sql.OPAQUE used on opensource projects

Example 1 with OPAQUE

use of oracle.sql.OPAQUE in project eclipselink by eclipse-ee4j.

the class StoredFunctionXMLTypeTest method test.

@Override
public void test() throws Exception {
    // 12.1 works with both OracleTypes.OPAQUE and Types.SQLXML
    // 11.2.0.3 - only with OracleTypes.OPAQUE
    // 11.2.0.2 - with both OracleTypes.OPAQUE and Types.SQLXML
    // int sqlType = Types.SQLXML;
    int sqlType = OracleTypes.OPAQUE;
    // see the stored function definition in XMLTypeEmployeeSystem
    StoredFunctionCall call = new StoredFunctionCall(sqlType, "XMLTYPE", String.class);
    call.setProcedureName("STOREDFUNCTION_XMLTYPE");
    if (sqlType == OracleTypes.OPAQUE && (getAbstractSession().isClientSession() || getAbstractSession().getDatasourceLogin().shouldUseExternalConnectionPooling())) {
        // UnwrapConnectionXDBTestModel uses external connection pooling. In this case transaction is required to keep the same connection open until the string is extracted.
        getAbstractSession().beginTransaction();
    }
    try {
        List result = getSession().executeSelectingCall(call);
        Object xmlResult = ((AbstractRecord) result.get(0)).getValues().get(0);
        String str;
        if (xmlResult instanceof OPAQUE) {
            str = ((XMLTypeFactory) Class.forName("org.eclipse.persistence.internal.platform.database.oracle.xdb.XMLTypeFactoryImpl").getConstructor().newInstance()).getString((OPAQUE) xmlResult);
        } else {
            str = JavaPlatform.getStringAndFreeSQLXML(xmlResult);
        }
        StringBuffer strBuffer = new StringBuffer();
        for (int i = 0; i < str.length(); i++) {
            char ch = str.charAt(i);
            if (charsToIgnore.indexOf(ch) == -1) {
                strBuffer.append(ch);
            }
        }
        String strWithoutSpaces = strBuffer.toString();
        if (!strWithoutSpaces.equals("<jb><data>BLAH</data></jb>")) {
            throw new TestErrorException("unexpected string: " + str);
        }
    } finally {
        if (getAbstractSession().isInTransaction()) {
            getAbstractSession().rollbackTransaction();
        }
    }
}