Problems enabling Oracle RAC with TranQL

[Donald Woods]

I'm trying to update the tranql-connector-oracle-local rar to support Oracle RAC/FCF support and am running into problems.

            // Enable ConnectionCaching
            ods.setConnectionCachingEnabled(true);
            // Setup FCF
            ods.setFastConnectionFailoverEnabled(true);
            // Setup Cache Name
            String cacheName = "wxen1Cache";

            // Setup ConnectionCaching Properties
            Properties prop = new Properties();
            prop.setProperty("InitialLimit", "5");
            prop.setProperty("MinLimit", "5");
            prop.setProperty("MaxLimit", "10");
            prop.setProperty("InactivityTimeout", "30");
            prop.setProperty("TimeToLiveTimeout", "60");
            prop.setProperty("AbandonedConnectionTimeout", "20");
            prop.setProperty("ConnectionWaitTimeout", "10");
            prop.setProperty("ValidateConnection", "true");
            ods.setConnectionCacheProperties(prop);
            // Setup ONS Config

ods.setONSConfiguration("nodes=192.168.1.11:6200,192.168.1.12:6200");


java.lang.NoSuchMethodError: oracle/ons/ONS.<init>(Ljava/lang/String;)V
        
oracle.jdbc.pool.OracleConnectionCacheManager$1.run(OracleConnectionCacheManager.java:245)
        java.security.AccessController.doPrivileged(AccessController.java:246)
        
oracle.jdbc.pool.OracleConnectionCacheManager.createCache(OracleConnectionCacheManager.java:237)
        
oracle.jdbc.pool.OracleDataSource.cacheInitialize(OracleDataSource.java:425)
        
oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:402)
        
oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:189)
        
org.tranql.connector.jdbc.AbstractLocalDataSourceMCF.getPhysicalConnection(AbstractLocalDataSourceMCF.java:70)
        
org.tranql.connector.jdbc.AbstractLocalDataSourceMCF.createManagedConnection(AbstractLocalDataSourceMCF.java:64)
        
org.apache.geronimo.connector.outbound.MCFConnectionInterceptor.getConnection(MCFConnectionInterceptor.java:48)
        
org.apache.geronimo.connector.outbound.LocalXAResourceInsertionInterceptor.getConnection(LocalXAResourceInsertionInterceptor.java:41)
        
org.apache.geronimo.connector.outbound.SinglePoolConnectionInterceptor.internalGetConnection(SinglePoolConnectionInterceptor.java:67)
        
org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionInterceptor.getConnection(AbstractSinglePoolConnectionInterceptor.java:78)
        
org.apache.geronimo.connector.outbound.TransactionEnlistingInterceptor.getConnection(TransactionEnlistingInterceptor.java:46)
        
org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.getConnection(TransactionCachingInterceptor.java:96)
        
org.apache.geronimo.connector.outbound.ConnectionHandleInterceptor.getConnection(ConnectionHandleInterceptor.java:43)
        
org.apache.geronimo.connector.outbound.TCCLInterceptor.getConnection(TCCLInterceptor.java:39)
        
org.apache.geronimo.connector.outbound.ConnectionTrackingInterceptor.getConnection(ConnectionTrackingInterceptor.java:66)
        
org.apache.geronimo.connector.outbound.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:87)
        org.tranql.connector.jdbc.DataSource.getConnection(DataSource.java:56)
        
org.apache.geronimo.samples.oraclerac.beans.DBManagerBean.getConnection(DBManagerBean.java:46)
        
org.apache.geronimo.samples.oraclerac.beans.DBManagerBean.<init>(DBManagerBean.java:37)
        
org.apache.jsp.oracle_002drac_jsp._jspService(oracle_002drac_jsp.java:76)
        org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:806)
        
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)
        org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
        org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:806)






-Donald

I have a simple Java app that I used to confirm the Oracle RAC setup and connection settings, but when I try to setup the TranQL connector to handle the additonal setup sets, like - ods.setConnectionCacheName("MyCache"); // has to be after FCF setup When I do something similar in tranql-connector-oracle-local with a config-property, I get the following exception - Is this due to Geronimo blocking the thread creation attempt of the Oracle ONS code???

smime.p7s
Description: S/MIME Cryptographic Signature