geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Donald Woods <dwo...@apache.org>
Subject Problems enabling Oracle RAC with TranQL
Date Tue, 29 Jan 2008 22:06:49 GMT
I'm trying to update the tranql-connector-oracle-local rar to support 
Oracle RAC/FCF support and am running into problems.

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 -
             // Enable ConnectionCaching
             ods.setConnectionCachingEnabled(true);
             // Setup FCF
             ods.setFastConnectionFailoverEnabled(true);
             // Setup Cache Name
             String cacheName = "wxen1Cache";
             ods.setConnectionCacheName("MyCache");   // has to be after 
FCF setup
             // 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");

When I do something similar in tranql-connector-oracle-local with a 
config-property, I get the following exception -
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)



Is this due to Geronimo blocking the thread creation attempt of the 
Oracle ONS code???


-Donald


Mime
View raw message