You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@geronimo.apache.org by ericp56 <er...@twcable.com> on 2008/12/03 22:45:15 UTC

Trying to configure Oracle XA

Hello,

I'm trying to configure an Oracle XA database pool in Geronimo.

I've tried various ways to fill out the information, but I haven't
succeeded.  I'm currently getting a "java.sql.SQLException: Io exception:
Unknown host specified" exception. 

When I tried to follow some other posts, I couldn't even deploy the pool. 
GBean deployment fails because of an invalid string operation (CharAt on an
empty string).  I'll open a JIRA ticket for this with the steps to
reproduce, exception output, etc.

Is there any documenation for org.tranql.connector.oracle.XAMCF?  I'm
stabbing blindly on how to configure the database pool - not fun;)

Eric
-- 
View this message in context: http://www.nabble.com/Trying-to-configure-Oracle-XA-tp20822347s134p20822347.html
Sent from the Apache Geronimo - Users mailing list archive at Nabble.com.

Re: Trying to configure Oracle XA

Posted by ericp56 <er...@twcable.com>.
The error shows up in the console only.

I delete the database pool, and then I add it again using the command line:

Dec 4, 2008 10:33:24 AM oracle.jdbc.driver.OracleDriver registerMBeans
SEVERE: Error while registering Oracle JDBC Diagnosability MBean.
javax.management.InstanceAlreadyExistsException:
com.oracle.jdbc:type=diagnosability,name=[org.apache.geronimo.kernel.classloader.JarFileClassLoader
idconsole.dbpool/SchedulerDB/1.0/rar]
	at
com.sun.jmx.mbeanserver.RepositorySupport.addMBean(RepositorySupport.java:452)
	at
com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.internal_addObject(DefaultMBeanServerInterceptor.java:1410)
	at
com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerObject(DefaultMBeanServerInterceptor.java:936)
	at
com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerMBean(DefaultMBeanServerInterceptor.java:337)
	at
com.sun.jmx.mbeanserver.JmxMBeanServer.registerMBean(JmxMBeanServer.java:497)
	at oracle.jdbc.driver.OracleDriver.registerMBeans(OracleDriver.java:305)
	at oracle.jdbc.driver.OracleDriver$1.run(OracleDriver.java:213)
	at java.security.AccessController.doPrivileged(Native Method)
	at oracle.jdbc.driver.OracleDriver.<clinit>(OracleDriver.java:209)
	at oracle.jdbc.pool.OracleDataSource.<clinit>(OracleDataSource.java:94)
	at org.tranql.connector.oracle.XAMCF.<init>(XAMCF.java:40)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
	at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
	at java.lang.Class.newInstance0(Class.java:350)
	at java.lang.Class.newInstance(Class.java:303)
	at
org.apache.geronimo.connector.outbound.ManagedConnectionFactoryWrapper.<init>(ManagedConnectionFactoryWrapper.java:116)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
	at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
	at
org.apache.geronimo.gbean.runtime.GBeanInstance.createInstance(GBeanInstance.java:948)
	at
org.apache.geronimo.gbean.runtime.GBeanInstanceState.attemptFullStart(GBeanInstanceState.java:268)
	at
org.apache.geronimo.gbean.runtime.GBeanInstanceState.start(GBeanInstanceState.java:102)
	at
org.apache.geronimo.gbean.runtime.GBeanInstance.start(GBeanInstance.java:541)
	at
org.apache.geronimo.gbean.runtime.GBeanDependency.attemptFullStart(GBeanDependency.java:111)
	at
org.apache.geronimo.gbean.runtime.GBeanDependency.addTarget(GBeanDependency.java:146)
	at
org.apache.geronimo.gbean.runtime.GBeanDependency$1.running(GBeanDependency.java:120)
	at
org.apache.geronimo.kernel.basic.BasicLifecycleMonitor.fireRunningEvent(BasicLifecycleMonitor.java:176)
	at
org.apache.geronimo.kernel.basic.BasicLifecycleMonitor.access$300(BasicLifecycleMonitor.java:44)
	at
org.apache.geronimo.kernel.basic.BasicLifecycleMonitor$RawLifecycleBroadcaster.fireRunningEvent(BasicLifecycleMonitor.java:254)
	at
org.apache.geronimo.gbean.runtime.GBeanInstanceState.attemptFullStart(GBeanInstanceState.java:294)
	at
org.apache.geronimo.gbean.runtime.GBeanInstanceState.start(GBeanInstanceState.java:102)
	at
org.apache.geronimo.gbean.runtime.GBeanInstanceState.startRecursive(GBeanInstanceState.java:124)
	at
org.apache.geronimo.gbean.runtime.GBeanInstance.startRecursive(GBeanInstance.java:555)
	at
org.apache.geronimo.kernel.basic.BasicKernel.startRecursiveGBean(BasicKernel.java:379)
	at
org.apache.geronimo.kernel.config.ConfigurationUtil.startConfigurationGBeans(ConfigurationUtil.java:456)
	at
org.apache.geronimo.kernel.config.KernelConfigurationManager.start(KernelConfigurationManager.java:188)
	at
org.apache.geronimo.kernel.config.SimpleConfigurationManager.startConfiguration(SimpleConfigurationManager.java:562)
	at
org.apache.geronimo.kernel.config.SimpleConfigurationManager.startConfiguration(SimpleConfigurationManager.java:543)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	at
org.apache.geronimo.gbean.runtime.ReflectionMethodInvoker.invoke(ReflectionMethodInvoker.java:34)
	at
org.apache.geronimo.gbean.runtime.GBeanOperation.invoke(GBeanOperation.java:124)
	at
org.apache.geronimo.gbean.runtime.GBeanInstance.invoke(GBeanInstance.java:867)
	at
org.apache.geronimo.kernel.basic.BasicKernel.invoke(BasicKernel.java:239)
	at org.apache.geronimo.kernel.KernelGBean.invoke(KernelGBean.java:342)
	at sun.reflect.GeneratedMethodAccessor151.invoke(Unknown Source)
	at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	at
org.apache.geronimo.gbean.runtime.ReflectionMethodInvoker.invoke(ReflectionMethodInvoker.java:34)
	at
org.apache.geronimo.gbean.runtime.GBeanOperation.invoke(GBeanOperation.java:124)
	at
org.apache.geronimo.gbean.runtime.GBeanInstance.invoke(GBeanInstance.java:867)
	at
org.apache.geronimo.kernel.basic.BasicKernel.invoke(BasicKernel.java:239)
	at
org.apache.geronimo.system.jmx.MBeanGBeanBridge.invoke(MBeanGBeanBridge.java:172)
	at
com.sun.jmx.mbeanserver.DynamicMetaDataImpl.invoke(DynamicMetaDataImpl.java:213)
	at com.sun.jmx.mbeanserver.MetaDataImpl.invoke(MetaDataImpl.java:220)
	at
com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:815)
	at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:784)
	at
javax.management.remote.rmi.RMIConnectionImpl.doOperation(RMIConnectionImpl.java:1410)
	at
javax.management.remote.rmi.RMIConnectionImpl.access$100(RMIConnectionImpl.java:81)
	at
javax.management.remote.rmi.RMIConnectionImpl$PrivilegedOperation.run(RMIConnectionImpl.java:1247)
	at java.security.AccessController.doPrivileged(Native Method)
	at
javax.management.remote.rmi.RMIConnectionImpl.doPrivilegedOperation(RMIConnectionImpl.java:1350)
	at
javax.management.remote.rmi.RMIConnectionImpl.invoke(RMIConnectionImpl.java:784)
	at sun.reflect.GeneratedMethodAccessor140.invoke(Unknown Source)
	at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:294)
	at sun.rmi.transport.Transport$1.run(Transport.java:153)
	at java.security.AccessController.doPrivileged(Native Method)
	at sun.rmi.transport.Transport.serviceCall(Transport.java:149)
	at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:466)
	at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:707)
	at java.lang.Thread.run(Thread.java:595)
10:33:25,504 ERROR [RecoveryController] javax.transaction.xa.XAException

-- 
View this message in context: http://www.nabble.com/Trying-to-configure-Oracle-XA-tp20822347s134p20835877.html
Sent from the Apache Geronimo - Users mailing list archive at Nabble.com.

Re: Trying to configure Oracle XA

Posted by David Jencks <da...@yahoo.com>.
Is there any other info or a stack trace from that?  If the pool is  
otherwise working I wouldn't automatically this is a configuration  
problem.... but I could easily be wrong.

thanks
david jencks

On Dec 3, 2008, at 7:06 PM, ericp56 wrote:

>
> Success!
>
> I entered the "TNS Entry Name" as follows:
> (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(Host =  
> oracleserver.abc.com)(Port
> = 1521))(CONNECT_DATA = (SID = DEVDB)))
>
> I basically took the definition from my TNSNAMES.ORA file.
>
> I'm still getting an error when deploying the DB pool:
> 22:01:30,211 ERROR [RecoveryController]  
> javax.transaction.xa.XAException
>
> I'll have to try removing info from the other fields to make it go  
> away.
>
>
> -- 
> View this message in context: http://www.nabble.com/Trying-to-configure-Oracle-XA-tp20822347s134p20826419.html
> Sent from the Apache Geronimo - Users mailing list archive at  
> Nabble.com.
>

Re: Trying to configure Oracle XA

Posted by ericp56 <er...@twcable.com>.
Success!

I entered the "TNS Entry Name" as follows:
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(Host = oracleserver.abc.com)(Port
= 1521))(CONNECT_DATA = (SID = DEVDB)))

I basically took the definition from my TNSNAMES.ORA file.  

I'm still getting an error when deploying the DB pool:
22:01:30,211 ERROR [RecoveryController] javax.transaction.xa.XAException

I'll have to try removing info from the other fields to make it go away.


-- 
View this message in context: http://www.nabble.com/Trying-to-configure-Oracle-XA-tp20822347s134p20826419.html
Sent from the Apache Geronimo - Users mailing list archive at Nabble.com.

Re: Trying to configure Oracle XA

Posted by ericp56 <er...@twcable.com>.
Thanks for the reference.  The examples are always helpful.

If I used the same information you did in your jdbc/TradeDataSource data
source, I believe the GBean deployment will fail.  I submitted this to JIRA: 
https://issues.apache.org/jira/browse/GERONIMO-4444
https://issues.apache.org/jira/browse/GERONIMO-4444 

I got it working as mentioned above, and the Exception noted above doesn't
seem to affect the application or database resources.  I was able to use all
of my defined web services without a hitch.

Eric
-- 
View this message in context: http://www.nabble.com/Trying-to-configure-Oracle-XA-tp20822347s134p20838290.html
Sent from the Apache Geronimo - Users mailing list archive at Nabble.com.

Re: Trying to configure Oracle XA

Posted by Donald Woods <dw...@apache.org>.
Have you looked at the DayTrader sample plan for Oracle XA under -
https://svn.apache.org/repos/asf/geronimo/daytrader/trunk/README
https://svn.apache.org/repos/asf/geronimo/daytrader/trunk/plans/dayTrader-oracle-XA-plan.xml

The last time I deployed DayTrader with the Oracle 10 XA RAR, it was 
back in 2.0 days using the above plan (not the Console), but it worked 
without problems....


-Donald


ericp56 wrote:
> Hello,
> 
> I'm trying to configure an Oracle XA database pool in Geronimo.
> 
> I've tried various ways to fill out the information, but I haven't
> succeeded.  I'm currently getting a "java.sql.SQLException: Io exception:
> Unknown host specified" exception. 
> 
> When I tried to follow some other posts, I couldn't even deploy the pool. 
> GBean deployment fails because of an invalid string operation (CharAt on an
> empty string).  I'll open a JIRA ticket for this with the steps to
> reproduce, exception output, etc.
> 
> Is there any documenation for org.tranql.connector.oracle.XAMCF?  I'm
> stabbing blindly on how to configure the database pool - not fun;)
> 
> Eric