4 Replies Latest reply on Jan 30, 2007 4:28 PM by Vinaya Tirikkovalluru

    Cannot obtain type mapping from: jboss.jdbc:datasource=<data

    Vinaya Tirikkovalluru Newbie

      Hi,

      I am trying to start up Jboss using run.bat.
      I am getting an error ,the stack says:

      13:17:09,300 INFO [WrapperDataSourceService] Bound ConnectionManager 'jboss.jca:service=DataSourceB
      inding,name=NextPahse' to JNDI name 'java:NextPahse'
      13:17:10,238 ERROR [GeneralPurposeDatabasePersistencePlugin] Cannot create timer table
      java.lang.IllegalStateException: Cannot obtain type mapping from: jboss.jdbc:datasource=NextPahse,se
      rvice=metadata
      at org.jboss.ejb.txtimer.GeneralPurposeDatabasePersistencePlugin.createTableIfNotExists(Gene
      ralPurposeDatabasePersistencePlugin.java:117)
      at org.jboss.ejb.txtimer.DatabasePersistencePolicy.startService(DatabasePersistencePolicy.ja
      va:95)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
      at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:196)
      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.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:995)
      at $Proxy0.start(Unknown Source)
      at org.jboss.system.ServiceController.start(ServiceController.java:417)
      at org.jboss.system.ServiceController.start(ServiceController.java:435)
      at org.jboss.system.ServiceController.start(ServiceController.java:435)
      at org.jboss.system.ServiceController.start(ServiceController.java:435)
      at org.jboss.system.ServiceController.start(ServiceController.java:435)
      at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
      at $Proxy4.start(Unknown Source)
      at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
      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.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
      at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
      at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterce
      ptor.java:142)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
      at $Proxy42.start(Unknown Source)
      at org.jboss.deployment.XSLSubDeployer.start(XSLSubDeployer.java:197)
      at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
      at sun.reflect.GeneratedMethodAccessor24.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
      at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
      at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterce
      ptor.java:142)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
      at $Proxy8.deploy(Unknown Source)
      at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)
      at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeplo
      ymentScanner.java:263)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentSca
      nner.java:336)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)

      at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
      at $Proxy0.start(Unknown Source)
      at org.jboss.system.ServiceController.start(ServiceController.java:417)
      at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
      at $Proxy4.start(Unknown Source)
      at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
      at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766)
      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.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
      at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
      at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterce
      ptor.java:142)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
      at $Proxy5.deploy(Unknown Source)
      at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)
      at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
      at org.jboss.Main.boot(Main.java:200)
      at org.jboss.Main$1.run(Main.java:490)
      at java.lang.Thread.run(Thread.java:595)
      13:17:10,785 WARN [ServiceController] Problem starting service jboss:service=KeyGeneratorFactory,ty
      pe=HiLo
      java.sql.SQLException: ORA-01031: insufficient privileges


      I appriciate any help on this.

      Thanks
      Vinaya

        • 1. Re: Cannot obtain type mapping from: jboss.jdbc:datasource=<
          Weston M. Price Master

          Your underlying DB, in this case Oracle, is simply telling you that you don't have the necessary permissions to perform a particular operation:

          java.sql.SQLException: ORA-01031: insufficient privileges
          


          You will need to consult with your DBA about what rights you have for your DB, particular for DDL based opertaions (ie create table, drop table etc).



          • 2. Re: Cannot obtain type mapping from: jboss.jdbc:datasource=<
            Vinaya Tirikkovalluru Newbie

            I have fixed the permissions issue.
            I am getting the following error now:

            14:46:42,863 INFO [WrapperDataSourceService] Bound ConnectionManager 'jboss.jca:service=DataSourceB
            inding,name=NextPhase' to JNDI name 'java:NextPhase'
            14:46:44,269 ERROR [GeneralPurposeDatabasePersistencePlugin] Cannot create timer table
            java.lang.IllegalStateException: Cannot obtain type mapping from: jboss.jdbc:datasource=NextPhase,se
            rvice=metadata
            at org.jboss.ejb.txtimer.GeneralPurposeDatabasePersistencePlugin.createTableIfNotExists(Gene
            ralPurposeDatabasePersistencePlugin.java:117)
            at org.jboss.ejb.txtimer.DatabasePersistencePolicy.startService(DatabasePersistencePolicy.ja
            va:95)
            at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
            at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:196)
            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.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
            at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
            at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
            at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
            at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
            at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:995)
            at $Proxy0.start(Unknown Source)
            at org.jboss.system.ServiceController.start(ServiceController.java:417)
            at org.jboss.system.ServiceController.start(ServiceController.java:435)
            at org.jboss.system.ServiceController.start(ServiceController.java:435)
            at org.jboss.system.ServiceController.start(ServiceController.java:435)
            at org.jboss.system.ServiceController.start(ServiceController.java:435)
            at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:585)
            at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
            at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
            at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
            at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
            at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
            at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
            at $Proxy4.start(Unknown Source)
            at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
            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.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
            at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
            at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
            at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
            at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterce
            ptor.java:142)
            .......................
            ...............................
            .........................
            14:47:08,269 ERROR [URLDeploymentScanner] Incomplete Deployment listing:

            --- Incompletely deployed packages ---
            org.jboss.deployment.DeploymentInfo@15db041a { url=file:/C:/jboss-4.0.5.GA/server/default/deploy/jm
            /oracle-xa-ds.xml }
            deployer: org.jboss.deployment.XSLSubDeployer@738dcb
            status: Deployment FAILED reason: Trying to install an already registered mbean: jboss.jca:servic
            =XATxCM,name=NextPhase
            state: FAILED
            watch: file:/C:/jboss-4.0.5.GA/server/default/deploy/jms/oracle-xa-ds.xml
            altDD: null
            lastDeployed: 1170186427457
            lastModified: 1170186427394
            mbeans:

            org.jboss.deployment.DeploymentInfo@e8a13cfb { url=file:/C:/jboss-4.0.5.GA/server/default/deploy/or
            cle-xa-ds.xml }
            deployer: org.jboss.deployment.XSLSubDeployer@738dcb
            status: Deployment FAILED reason: Trying to install an already registered mbean: jboss.jca:servic
            =XATxCM,name=NextPhase
            state: FAILED
            watch: file:/C:/jboss-4.0.5.GA/server/default/deploy/oracle-xa-ds.xml
            altDD: null
            lastDeployed: 1170186427644
            lastModified: 1170186427613
            mbeans:

            --- MBeans waiting for other MBeans ---
            ObjectName: jboss.mq:service=PersistenceManager
            State: FAILED
            Reason: org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recover
            may not be accurate; - nested throwable: (org.jboss.util.NestedSQLException: Could not enlist in t
            ansaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: j
            va.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImpl:XidImp
            [FormatId=257, GlobalId=1BREDDY1/3, BranchQual=, localId=3]); - nested throwable: (org.jboss.resour
            e.JBossResourceException: Could not enlist in transaction on entering meta-aware object!; - nested
            hrowable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see
            he previous warnings. tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=1BREDDY1/3, BranchQual=, lo
            alId=3])))
            I Depend On:
            jboss.jca:service=DataSourceBinding,name=NextPhase
            Depends On Me:
            jboss.mq:service=DestinationManager

            --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
            ObjectName: jboss.mq:service=PersistenceManager
            State: FAILED
            Reason: org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recover
            may not be accurate; - nested throwable: (org.jboss.util.NestedSQLException: Could not enlist in t
            ansaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: j
            va.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImpl:XidImp
            [FormatId=257, GlobalId=1BREDDY1/3, BranchQual=, localId=3]); - nested throwable: (org.jboss.resour
            e.JBossResourceException: Could not enlist in transaction on entering meta-aware object!; - nested
            hrowable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see
            he previous warnings. tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=1BREDDY1/3, BranchQual=, lo
            alId=3])))
            I Depend On:
            jboss.jca:service=DataSourceBinding,name=NextPhase
            Depends On Me:
            jboss.mq:service=DestinationManager

            I have Oracle 8 database and I am trying to configure a XA datasource.

            Thanks
            Vinaya



            • 3. Re: Cannot obtain type mapping from: jboss.jdbc:datasource=<
              Elias Ross Master

              If you turn on log4j debug, you might be able to see the details.

              It looks like there's some sort of transaction recovery taking place and it failed. Are you using an XA database?

              • 4. Re: Cannot obtain type mapping from: jboss.jdbc:datasource=<
                Vinaya Tirikkovalluru Newbie

                I am using Oracle 8.1.6.3. I think this is an XA database.