This discussion is archived
4 Replies Latest reply: Jul 18, 2012 11:32 PM by 949607 RSS

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

949607 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Hi,

    Thanks. It is working now.

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

    Thanks for your help.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points