Return-Path: Delivered-To: apmail-geronimo-user-archive@www.apache.org Received: (qmail 26043 invoked from network); 29 Jan 2008 22:07:24 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 29 Jan 2008 22:07:24 -0000 Received: (qmail 15508 invoked by uid 500); 29 Jan 2008 22:07:14 -0000 Delivered-To: apmail-geronimo-user-archive@geronimo.apache.org Received: (qmail 14928 invoked by uid 500); 29 Jan 2008 22:07:13 -0000 Mailing-List: contact user-help@geronimo.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: user@geronimo.apache.org List-Id: Delivered-To: mailing list user@geronimo.apache.org Received: (qmail 14917 invoked by uid 99); 29 Jan 2008 22:07:13 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 29 Jan 2008 14:07:13 -0800 X-ASF-Spam-Status: No, hits=-2.8 required=10.0 tests=RCVD_IN_DNSWL_MED,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [32.97.182.144] (HELO e4.ny.us.ibm.com) (32.97.182.144) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 29 Jan 2008 22:06:44 +0000 Received: from d01relay04.pok.ibm.com (d01relay04.pok.ibm.com [9.56.227.236]) by e4.ny.us.ibm.com (8.13.8/8.13.8) with ESMTP id m0TM6o3J023740 for ; Tue, 29 Jan 2008 17:06:50 -0500 Received: from d01av01.pok.ibm.com (d01av01.pok.ibm.com [9.56.224.215]) by d01relay04.pok.ibm.com (8.13.8/8.13.8/NCO v8.7) with ESMTP id m0TM6okX228370 for ; Tue, 29 Jan 2008 17:06:50 -0500 Received: from d01av01.pok.ibm.com (loopback [127.0.0.1]) by d01av01.pok.ibm.com (8.12.11.20060308/8.13.3) with ESMTP id m0TM6oVZ021352 for ; Tue, 29 Jan 2008 17:06:50 -0500 Received: from [9.44.16.126] ([9.44.16.126]) by d01av01.pok.ibm.com (8.12.11.20060308/8.12.11) with ESMTP id m0TM6n0O021342 for ; Tue, 29 Jan 2008 17:06:49 -0500 Message-ID: <479FA379.3050507@apache.org> Date: Tue, 29 Jan 2008 17:06:49 -0500 From: Donald Woods User-Agent: Thunderbird 2.0.0.6 (X11/20070812) MIME-Version: 1.0 To: user@geronimo.apache.org Subject: Problems enabling Oracle RAC with TranQL Content-Type: multipart/signed; protocol="application/x-pkcs7-signature"; micalg=sha1; boundary="------------ms080002030401020507050400" X-Virus-Checked: Checked by ClamAV on apache.org This is a cryptographically signed message in MIME format. --------------ms080002030401020507050400 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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.(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.(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 --------------ms080002030401020507050400 Content-Type: application/x-pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" Content-Description: S/MIME Cryptographic Signature MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIJAzCC AtwwggJFoAMCAQICEGl0fFJRFoUogDNHr2j130gwDQYJKoZIhvcNAQEFBQAwYjELMAkGA1UE BhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMT I1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA3MDQwMzE5MDgwOFoX DTA4MDQwMjE5MDgwOFowQzEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEgMB4G CSqGSIb3DQEJARYRZHdvb2RzQGFwYWNoZS5vcmcwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAw ggEKAoIBAQDENBaTcon2Q3/v2plog9ympNR5IWM94JDvXhWanc1Qz07/sIerwI99WZ4z0AAV wBelazRFCsXkFCaNDM1sOJ0gx4I+KISb5XoX/omAhYIs+Cwac2hitDraZE2Q7x281nLn4TPR d29GVpUZVKsaDvmvnDAagGTEkOfHBx/yUihzshJn4S6n6vahimEWWXn5Qw4Oj5Muvz8iKGoA MilrHZrfSKvCqT0LhGaFnZhrMvqeCguf0/IlP6YJ2kBmouV3XHFUaiai4PQZ7ahtbW7meKb4 b25QUjIFJHIr0KhJXqoGADRAlBgTaqWBIKbdTmYBsr55aasjp5TU+XAxiqFr1FoTAgMBAAGj LjAsMBwGA1UdEQQVMBOBEWR3b29kc0BhcGFjaGUub3JnMAwGA1UdEwEB/wQCMAAwDQYJKoZI hvcNAQEFBQADgYEAJReGzfwY5+BY6PuXJQLURKni6kBaFi7Z7b+tjn6iTdlZhbSF9YHazHIJ 9J6oaOzfG28JroaAlk9PeAvbC38f2kaU4bWQgm6yp6308ZRyM8V3CHXe6Wm9bXiJeZCRTpix Mvxo+mWG2Jq0vnfjWxt+Fbi0ic1xl3I+1UguMfAfAggwggLcMIICRaADAgECAhBpdHxSURaF KIAzR69o9d9IMA0GCSqGSIb3DQEBBQUAMGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3 dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJl ZW1haWwgSXNzdWluZyBDQTAeFw0wNzA0MDMxOTA4MDhaFw0wODA0MDIxOTA4MDhaMEMxHzAd BgNVBAMTFlRoYXd0ZSBGcmVlbWFpbCBNZW1iZXIxIDAeBgkqhkiG9w0BCQEWEWR3b29kc0Bh cGFjaGUub3JnMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAxDQWk3KJ9kN/79qZ aIPcpqTUeSFjPeCQ714Vmp3NUM9O/7CHq8CPfVmeM9AAFcAXpWs0RQrF5BQmjQzNbDidIMeC PiiEm+V6F/6JgIWCLPgsGnNoYrQ62mRNkO8dvNZy5+Ez0XdvRlaVGVSrGg75r5wwGoBkxJDn xwcf8lIoc7ISZ+Eup+r2oYphFll5+UMODo+TLr8/IihqADIpax2a30irwqk9C4RmhZ2YazL6 ngoLn9PyJT+mCdpAZqLld1xxVGomouD0Ge2obW1u5nim+G9uUFIyBSRyK9CoSV6qBgA0QJQY E2qlgSCm3U5mAbK+eWmrI6eU1PlwMYqha9RaEwIDAQABoy4wLDAcBgNVHREEFTATgRFkd29v ZHNAYXBhY2hlLm9yZzAMBgNVHRMBAf8EAjAAMA0GCSqGSIb3DQEBBQUAA4GBACUXhs38GOfg WOj7lyUC1ESp4upAWhYu2e2/rY5+ok3ZWYW0hfWB2sxyCfSeqGjs3xtvCa6GgJZPT3gL2wt/ H9pGlOG1kIJusqet9PGUcjPFdwh13ulpvW14iXmQkU6YsTL8aPplhtiatL5341sbfhW4tInN cZdyPtVILjHwHwIIMIIDPzCCAqigAwIBAgIBDTANBgkqhkiG9w0BAQUFADCB0TELMAkGA1UE BhMCWkExFTATBgNVBAgTDFdlc3Rlcm4gQ2FwZTESMBAGA1UEBxMJQ2FwZSBUb3duMRowGAYD VQQKExFUaGF3dGUgQ29uc3VsdGluZzEoMCYGA1UECxMfQ2VydGlmaWNhdGlvbiBTZXJ2aWNl cyBEaXZpc2lvbjEkMCIGA1UEAxMbVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIENBMSswKQYJ KoZIhvcNAQkBFhxwZXJzb25hbC1mcmVlbWFpbEB0aGF3dGUuY29tMB4XDTAzMDcxNzAwMDAw MFoXDTEzMDcxNjIzNTk1OVowYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25z dWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJ c3N1aW5nIENBMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDEpjxVc1X7TrnKmVoeaMB1 BHCd3+n/ox7svc31W/Iadr1/DDph8r9RzgHU5VAKMNcCY1osiRVwjt3J8CuFWqo/cVbLrzwL B+fxH5E2JCoTzyvV84J3PQO+K/67GD4Hv0CAAmTXp6a7n2XRxSpUhQ9IBH+nttE8YQRAHmQZ cmC3+wIDAQABo4GUMIGRMBIGA1UdEwEB/wQIMAYBAf8CAQAwQwYDVR0fBDwwOjA4oDagNIYy aHR0cDovL2NybC50aGF3dGUuY29tL1RoYXd0ZVBlcnNvbmFsRnJlZW1haWxDQS5jcmwwCwYD VR0PBAQDAgEGMCkGA1UdEQQiMCCkHjAcMRowGAYDVQQDExFQcml2YXRlTGFiZWwyLTEzODAN BgkqhkiG9w0BAQUFAAOBgQBIjNFQg+oLLswNo2asZw9/r6y+whehQ5aUnX9MIbj4Nh+qLZ82 L8D0HFAgk3A8/a3hYWLD2ToZfoSxmRsAxRoLgnSeJVCUYsfbJ3FXJY3dqZw5jowgT2Vfldr3 94fWxghOrvbqNOUQGls1TXfjViF4gtwhGTXeJLHTHUb/XV9lTzGCA2QwggNgAgEBMHYwYjEL MAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAq BgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBAhBpdHxSURaFKIAz R69o9d9IMAkGBSsOAwIaBQCgggHDMBgGCSqGSIb3DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZI hvcNAQkFMQ8XDTA4MDEyOTIyMDY0OVowIwYJKoZIhvcNAQkEMRYEFHsK9hXhPGsv3wLggnr2 48T7jC59MFIGCSqGSIb3DQEJDzFFMEMwCgYIKoZIhvcNAwcwDgYIKoZIhvcNAwICAgCAMA0G CCqGSIb3DQMCAgFAMAcGBSsOAwIHMA0GCCqGSIb3DQMCAgEoMIGFBgkrBgEEAYI3EAQxeDB2 MGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQu MSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQQIQaXR8UlEW hSiAM0evaPXfSDCBhwYLKoZIhvcNAQkQAgsxeKB2MGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQK ExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29u YWwgRnJlZW1haWwgSXNzdWluZyBDQQIQaXR8UlEWhSiAM0evaPXfSDANBgkqhkiG9w0BAQEF AASCAQAtsUusXpXpP4jsb8CmuXo8bIvCvEIjzt5vpW2wYcNNWntz4a7aWor0bjpovebSZ3e3 EGeoQaPafIx7UNeaat/dM6KAQ4PNg/168rEFJWWrjqz1zr5f9k3fCYekowDIpFDmJ92C9gFF nOwxaV5FqZFgxMOlJ5QS05ocNtuliG/lzK73V4mAW9oisxy8KpMh/Xa9fZCF+ZU/qrm6HFt1 hNwKlpqgY3/to9duKtbgyuThLdJ5yEAF25AVimQHcuJ6eVvWnPoor6wht/B0GoYun14QfbTd 7kIg0u2iXDRhuYMSLBQoALOtHwcCaGpJPl2ODs7gWmeLgI3ZDzRQJfVD9gRmAAAAAAAA --------------ms080002030401020507050400--