4 Replies Latest reply: Jul 19, 2012 1:32 AM by 949607 RSS

    Can I Use Oracle DB 11g Express Edition with Atomikos  Transactions.

    949607
      Hi,

      Any Help is appreciated.

      Im able to use Oracle 11g Standard/Enterprise Edition with Atomikos for XA transactions.(XADMS).

      My question is Can I Use Oracle DB 11g Express Edition with Atomikos for XA Transactions.

      Thanks,
      kensuser
        • 1. Re: Can I Use Oracle DB 11g Express Edition with Atomikos  Transactions.
          Udo
          Hi kensuser,
          My question is Can I Use Oracle DB 11g Express Edition with Atomikos for XA Transactions.
          Yes. JDBC drivers and the different Oracle transaction models are available in XE as well.

          -Udo
          • 2. Re: Can I Use Oracle DB 11g Express Edition with Atomikos  Transactions.
            949607
            Hi,
            Thanks for the answer.What jdbc drivers should I use. Because still Im getting exception when using Oracle 11g XE.
            But the same application runs with Oracle 11g Standard/Enterprise Edition.

            Here is my Exception trace: Sorry, I'm a first time user, so pasting the exception as it is, will find out how to format the same, as use this forum. ant help is appreciated. Thanks in Advance


            SEVERE: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
            org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'UIToolAdminkit': Invocation of init method failed; nested exception is com.atomikos.datasource.ResourceException: XA resource 'EXXADBMS': resume for XID '3139322E3136382E35352E31382E746D30303030313030313937:3139322E3136382E35352E31382E746D31' raised -3: the XA resource detected an internal error
                 at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:135)
                 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:393)
                 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1437)
                 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:518)
                 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:455)
                 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
                 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
                 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
                 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
                 at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:585)
                 at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:913)
                 at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:464)
                 at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:381)
                 at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:283)
                 at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111)
                 at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)
                 at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)
                 at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
                 at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
                 at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
                 at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
                 at org.apache.catalina.core.StandardService.start(StandardService.java:525)
                 at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
                 at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
                 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
                 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
                 at java.lang.reflect.Method.invoke(Unknown Source)
                 at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
                 at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
            Caused by: com.atomikos.datasource.ResourceException: XA resource 'EXXADBMS': resume for XID '3139322E3136382E35352E31382E746D30303030313030313937:3139322E3136382E35352E31382E746D31' raised -3: the XA resource detected an internal error
                 at com.atomikos.datasource.xa.XAResourceTransaction.resume(XAResourceTransaction.java:500)
                 at com.atomikos.datasource.xa.session.BranchEnlistedStateHandler.<init>(BranchEnlistedStateHandler.java:57)
                 at com.atomikos.datasource.xa.session.NotInBranchStateHandler.checkEnlistBeforeUse(NotInBranchStateHandler.java:66)
                 at com.atomikos.datasource.xa.session.TransactionContext.checkEnlistBeforeUse(TransactionContext.java:85)
                 at com.atomikos.datasource.xa.session.SessionHandleState.notifyBeforeUse(SessionHandleState.java:176)
                 at com.atomikos.jdbc.AtomikosConnectionProxy.enlist(AtomikosConnectionProxy.java:204)
                 at com.atomikos.jdbc.AtomikosConnectionProxy.invoke(AtomikosConnectionProxy.java:138)
                 at $Proxy13.prepareStatement(Unknown Source)
                 at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
                 at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
                 at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
                 at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1573)
                 at org.hibernate.loader.Loader.doQuery(Loader.java:696)
                 at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
                 at org.hibernate.loader.Loader.doList(Loader.java:2228)
                 at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
                 at org.hibernate.loader.Loader.list(Loader.java:2120)
                 at org.hibernate.hql.classic.QueryTranslatorImpl.list(QueryTranslatorImpl.java:935)
                 at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
                 at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148)
                 at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
                 at org.springframework.orm.hibernate3.HibernateTemplate$30.doInHibernate(HibernateTemplate.java:921)
                 at org.springframework.orm.hibernate3.HibernateTemplate$30.doInHibernate(HibernateTemplate.java:1)
                 at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
                 at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
                 at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:912)
                 at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:904)
                 at com.kensho.common.UIbundlDAOImpl.findAll(UIbundlDAOImpl.java:13)
                 at com.kensho.common.UIbundlDAOImpl$$FastClassByCGLIB$$6f2db14b.invoke(<generated>)
                 at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
                 at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)
                 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
                 at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
                 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
                 at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
                 at com.kensho.common.UIbundlDAOImpl$$EnhancerByCGLIB$$8797972a.findAll(<generated>)
                 at com.kensho.common.UIToolKitAdminBBean.getAllBundleItems(UIToolKitAdminBBean.java:37)
                 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
                 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
                 at java.lang.reflect.Method.invoke(Unknown Source)
                 at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:346)
                 at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:299)
                 at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:132)
                 ... 29 more
            • 3. Re: Can I Use Oracle DB 11g Express Edition with Atomikos  Transactions.
              Udo
              Hi,
              Because still Im getting exception when using Oracle 11g XE.
              You didn't mention any error in your first post. It would have been nice to know that you've already tried but failed. ;)
              And you could also mention WHEN you receive this error, i.e. what kind of operation does your code perform to raise it.
              What jdbc drivers should I use.
              Which one do you use right now?
              I recommend to use at least 11.2.0.2 or even 11.2.0.3 drivers, e.g. downloadable at [url http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html]OTN JDBC drivers home page.
              But the same application runs with Oracle 11g Standard/Enterprise Edition.
              Which version? 11g XE corresponds to 11.2.0.2

              -Udo
              • 4. Re: Can I Use Oracle DB 11g Express Edition with Atomikos  Transactions.
                949607
                Hi,

                Thanks. It is working now.

                Used ojdbc5.jar and Oracle10gDialect in our application for the Oracle11g XE edition.

                Thanks for your help.