4 Replies Latest reply on Mar 3, 2009 10:44 AM by Anthon Ranullo

    MySQL 5.0 deployed as DS doesn't seem to work properly with

    Anthon Ranullo Newbie

      My specs:
      JBoss 5.0.0.GA
      MySQL 5.0.41
      MySQL Connector J 5.0.5

      My EAR's session beans works with transactions successfully when using datasource from DefaultDS (Hypersonic DB), but throws an exception when using MySQL as my datasource.

      Please refer to this link to -> http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4214075#4214075

      The point of interest on those exception:

      14:55:21,796 ERROR [lifecycle] JSF1054: (Phase ID: INVOKE_APPLICATION 5, View ID: /login.html) Excep
      tion thrown during phase execution: javax.faces.event.PhaseEvent[source=com.sun.faces.lifecycle.Life
      cycleImpl@c68e03]
      14:55:21,796 ERROR [[Faces Config]] Servlet.service() for servlet Faces Config threw exception
      java.lang.IllegalStateException: BaseClassLoader@1f30e51{vfszip:/C:/Software/Server/jboss-5.0.0.GA/s
      erver/default/deploy/demoproj-ear.ear} classLoader is not connected to a domain (probably undeployed
      ?) for class java.sql.SQLWarning
       at org.jboss.classloader.spi.base.BaseClassLoader.loadClassFromDomain(BaseClassLoader.java:730)
       at org.jboss.classloader.spi.base.BaseClassLoader.loadClass(BaseClassLoader.java:378)
       at java.lang.ClassLoader.loadClass(Unknown Source)
       at java.lang.ClassLoader.loadClassInternal(Unknown Source)
       at com.mysql.jdbc.Connection.getMutex(Connection.java:3714)
       at com.mysql.jdbc.Connection.rollback(Connection.java:5186)
       at org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.rollback(LocalManagedConnection.jav
      a:97)
       at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.rollback(TxConnectionMa
      nager.java:1105)
       at com.arjuna.ats.internal.jta.resources.arjunacore.XAOnePhaseResource.rollback(XAOnePhaseResource.
      java:138)
      


      Could anyone confirm to me if there should not be any problems with mysql as my datasource.

      Any help is much appreciated.

      Thanks

        • 1. Re: MySQL 5.0 deployed as DS doesn't seem to work properly w
          Peter Johnson Master

          I use with MySQL and PostgreSQL as datasources in JBoss AS 5.0.x without any issues.

          Was there a "caused by" clause for your exception?

          Also, please post the *-ds.xml file for your data source. Remember to place the xml text within code tags (select the text and click the Code button above the editor). And click Preview to ensure htat the formatting is correct before submitting.

          Also post your persistence.xml file.

          • 2. Re: MySQL 5.0 deployed as DS doesn't seem to work properly w
            Anthon Ranullo Newbie

            I've got some more accurate exception when I configured my datasource, it now throws:

            17:22:11,156 INFO [JBossASKernel] Created KernelDeployment for: demoproj-ejb.jar
            17:22:11,156 INFO [JBossASKernel] installing bean: jboss.j2ee:ear=demoproj-ear.ear,jar=demoproj-ejb.jar,name=UserAccountsBean,service=EJB3
            17:22:11,156 INFO [JBossASKernel] with dependencies:
            17:22:11,156 INFO [JBossASKernel] and demands:
            17:22:11,156 INFO [JBossASKernel] persistence.unit:unitName=demoproj-ear.ear/demoproj-ejb.jar#demoproj-unit
            17:22:11,156 INFO [JBossASKernel] jboss.ejb:service=EJBTimerService
            17:22:11,156 INFO [JBossASKernel] and supplies:
            17:22:11,156 INFO [JBossASKernel] jndi:demoproj-ear/UserAccountsBean/remote
            17:22:11,156 INFO [JBossASKernel] Class:tonsky.demoproj.dao.UserAccountsLocal
            17:22:11,156 INFO [JBossASKernel] jndi:demoproj-ear/UserAccountsBean/local-tonsky.demoproj.dao.UserAccountsLocal
            17:22:11,156 INFO [JBossASKernel] Class:tonsky.demoproj.dao.UserAccountsRemote
            17:22:11,156 INFO [JBossASKernel] jndi:demoproj-ear/UserAccountsBean/local
            17:22:11,156 INFO [JBossASKernel] jndi:demoproj-ear/UserAccountsBean/remote-tonsky.demoproj.dao.UserAccountsRemote
            17:22:11,156 INFO [JBossASKernel] Added bean(jboss.j2ee:ear=demoproj-ear.ear,jar=demoproj-ejb.jar,name=UserAccountsBean,service=EJB3) to KernelDeployment of: demoproj-ejb.jar
            17:22:11,186 INFO [PersistenceUnitDeployment] Starting persistence unit persistence.unit:unitName=demoproj-ear.ear/demoproj-ejb.jar#demoproj-unit
            17:22:11,340 WARN [Ejb3Configuration] Persistence provider caller does not implement the EJB3 spec correctly. PersistenceUnitInfo.getNewTempClassLoader() is null.
            17:22:11,340 INFO [Configuration] configuring from resource: hibernate.cfg.xml
            17:22:11,340 INFO [Configuration] Configuration resource: hibernate.cfg.xml
            17:22:11,415 INFO [Configuration] Configured SessionFactory: demoproj-session-factory
            17:22:11,419 INFO [AnnotationBinder] Binding entity from annotated class: tonsky.demoproj.entities.PersonalInfo
            17:22:11,419 INFO [EntityBinder] Bind entity tonsky.demoproj.entities.PersonalInfo on table PersonalInfo
            17:22:11,422 INFO [AnnotationBinder] Binding entity from annotated class: tonsky.demoproj.entities.Role
            17:22:11,422 INFO [EntityBinder] Bind entity tonsky.demoproj.entities.Role on table Role
            17:22:11,424 INFO [AnnotationBinder] Binding entity from annotated class: tonsky.demoproj.entities.UserAccount
            17:22:11,424 INFO [QueryBinder] Binding Named query: getByUsername => from UserAccount u where u.username = :username
            17:22:11,424 INFO [EntityBinder] Bind entity tonsky.demoproj.entities.UserAccount on table UserAccount
            17:22:11,429 INFO [AnnotationBinder] Binding entity from annotated class: tonsky.demoproj.entities.SimpleEntity
            17:22:11,429 INFO [EntityBinder] Bind entity tonsky.demoproj.entities.SimpleEntity on table SimpleEntity
            17:22:11,430 INFO [CollectionBinder] Mapping collection: tonsky.demoproj.entities.PersonalInfo.userAccounts -> UserAccount
            17:22:11,474 INFO [HibernateSearchEventListenerRegister] Unable to find org.hibernate.search.event.FullTextIndexEventListener on the classpath. Hibernate Search is not enabled.
            17:22:11,483 INFO [ConnectionProviderFactory] Initializing connection provider: org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider
            17:22:11,485 INFO [InjectedDataSourceConnectionProvider] Using provided datasource
            17:22:11,485 WARN [SettingsFactory] Could not obtain connection metadata
            org.jboss.util.NestedSQLException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57ff57:d3dc:49ab4c06:c09 status: ActionStatus.ABORTING >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57ff57:d3dc:49ab4c06:c09 status: ActionStatus.ABORTING >)
             at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)
             at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:46)
             at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:111)
             at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2101)
             at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1325)
             at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)
             at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669)
             at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:132)
             at org.jboss.jpa.deployment.PersistenceUnitDeployment.start(PersistenceUnitDeployment.java:311)
             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.jboss.reflect.plugins.introspection.ReflectionUtils.invoke(ReflectionUtils.java:59)
             at org.jboss.reflect.plugins.introspection.ReflectMethodInfoImpl.invoke(ReflectMethodInfoImpl.java:150)
             at org.jboss.joinpoint.plugins.BasicMethodJoinPoint.dispatch(BasicMethodJoinPoint.java:66)
             at org.jboss.kernel.plugins.dependency.KernelControllerContextAction$JoinpointDispatchWrapper.execute(KernelControllerContextAction.java:241)
             at org.jboss.kernel.plugins.dependency.ExecutionWrapper.execute(ExecutionWrapper.java:47)
             at org.jboss.kernel.plugins.dependency.KernelControllerContextAction.dispatchExecutionWrapper(KernelControllerContextAction.java:109)
             at org.jboss.kernel.plugins.dependency.KernelControllerContextAction.dispatchJoinPoint(KernelControllerContextAction.java:70)
             at org.jboss.kernel.plugins.dependency.LifecycleAction.installActionInternal(LifecycleAction.java:221)
             at org.jboss.kernel.plugins.dependency.InstallsAwareAction.installAction(InstallsAwareAction.java:54)
             at org.jboss.kernel.plugins.dependency.InstallsAwareAction.installAction(InstallsAwareAction.java:42)
             at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)
             at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)
             at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)
             at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
             at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)
             at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
             at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)
             at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
             at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:774)
             at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:540)
             at org.jboss.deployers.vfs.deployer.kernel.BeanMetaDataDeployer.deploy(BeanMetaDataDeployer.java:121)
             at org.jboss.deployers.vfs.deployer.kernel.BeanMetaDataDeployer.deploy(BeanMetaDataDeployer.java:51)
             at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)
             at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:50)
             at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:171)
             at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1439)
             at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1157)
             at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1178)
             at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1210)
             at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1098)
             at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
             at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)
             at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
             at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)
             at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
             at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
             at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
             at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:781)
             at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:545)
             at org.jboss.system.server.profileservice.hotdeploy.HDScanner.scan(HDScanner.java:290)
             at org.jboss.system.server.profileservice.hotdeploy.HDScanner.run(HDScanner.java:221)
             at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
             at java.util.concurrent.FutureTask$Sync.innerRunAndReset(Unknown Source)
             at java.util.concurrent.FutureTask.runAndReset(Unknown Source)
             at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(Unknown Source)
             at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(Unknown Source)
             at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
             at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
             at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
             at java.lang.Thread.run(Unknown Source)
            Caused by: javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57ff57:d3dc:49ab4c06:c09 status: ActionStatus.ABORTING >
             at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:370)
             at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
             at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
             at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
             ... 62 more
            17:22:11,488 INFO [Dialect] Using dialect: org.hibernate.dialect.MySQL5Dialect
            17:22:11,488 INFO [TransactionFactoryFactory] Transaction strategy: org.hibernate.ejb.transaction.JoinableCMTTransactionFactory
            17:22:11,489 INFO [TransactionManagerLookupFactory] instantiating TransactionManagerLookup: org.hibernate.transaction.JBossTransactionManagerLookup
            17:22:11,491 INFO [TransactionManagerLookupFactory] instantiated TransactionManagerLookup
            17:22:11,491 INFO [SettingsFactory] Automatic flush during beforeCompletion(): disabled
            17:22:11,491 INFO [SettingsFactory] Automatic session close at end of transaction: disabled
            17:22:11,491 INFO [SettingsFactory] Scrollable result sets: disabled
            17:22:11,491 INFO [SettingsFactory] JDBC3 getGeneratedKeys(): disabled
            17:22:11,491 INFO [SettingsFactory] Connection release mode: auto
            17:22:11,491 INFO [SettingsFactory] Maximum outer join fetch depth: 2
            17:22:11,491 INFO [SettingsFactory] Default batch fetch size: 1
            17:22:11,491 INFO [SettingsFactory] Generate SQL with comments: disabled
            17:22:11,491 INFO [SettingsFactory] Order SQL updates by primary key: disabled
            17:22:11,491 INFO [SettingsFactory] Order SQL inserts for batching: disabled
            17:22:11,491 INFO [SettingsFactory] Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
            17:22:11,493 INFO [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory
            17:22:11,493 INFO [SettingsFactory] Query language substitutions: {}
            17:22:11,493 INFO [SettingsFactory] JPA-QL strict compliance: enabled
            17:22:11,493 INFO [SettingsFactory] Second-level cache: enabled
            17:22:11,493 INFO [SettingsFactory] Query cache: disabled
            17:22:11,493 INFO [SettingsFactory] Cache region factory : org.hibernate.cache.impl.bridge.RegionFactoryCacheProviderBridge
            17:22:11,494 INFO [RegionFactoryCacheProviderBridge] Cache provider: org.hibernate.cache.HashtableCacheProvider
            17:22:11,496 INFO [SettingsFactory] Optimize cache for minimal puts: disabled
            17:22:11,496 INFO [SettingsFactory] Cache region prefix: persistence.unit:unitName=demoproj-ear.ear/demoproj-ejb.jar#demoproj-unit
            17:22:11,496 INFO [SettingsFactory] Structured second-level cache entries: disabled
            17:22:11,496 INFO [SettingsFactory] Echoing all SQL to stdout
            17:22:11,496 INFO [SettingsFactory] Statistics: disabled
            17:22:11,496 INFO [SettingsFactory] Deleted entity synthetic identifier rollback: disabled
            17:22:11,496 INFO [SettingsFactory] Default entity-mode: pojo
            17:22:11,496 INFO [SettingsFactory] Named query checking : enabled
            17:22:11,511 INFO [SessionFactoryImpl] building session factory
            17:22:11,559 INFO [SessionFactoryObjectFactory] Factory name: persistence.unit:unitName=demoproj-ear.ear/demoproj-ejb.jar#demoproj-unit
            17:22:11,559 INFO [NamingHelper] JNDI InitialContext properties:{java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces}
            17:22:11,595 INFO [SessionFactoryObjectFactory] Bound factory to JNDI name: persistence.unit:unitName=demoproj-ear.ear/demoproj-ejb.jar#demoproj-unit
            17:22:11,596 WARN [SessionFactoryObjectFactory] InitialContext did not implement EventContext
            17:22:11,596 INFO [NamingHelper] JNDI InitialContext properties:{java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces}
            17:22:11,751 INFO [SessionSpecContainer] Starting jboss.j2ee:ear=demoproj-ear.ear,jar=demoproj-ejb.jar,name=UserAccountsBean,service=EJB3
            17:22:11,752 INFO [EJBContainer] STARTED EJB: tonsky.demoproj.dao.UserAccountsBean ejbName: UserAccountsBean
            17:22:11,779 INFO [JndiSessionRegistrarBase] Binding the following Entries in Global JNDI:
            
             demoproj-ear/UserAccountsBean/remote - EJB3.x Default Remote Business Interface
             demoproj-ear/UserAccountsBean/remote-tonsky.demoproj.dao.UserAccountsRemote - EJB3.x Remote Business Interface
             demoproj-ear/UserAccountsBean/local - EJB3.x Default Local Business Interface
             demoproj-ear/UserAccountsBean/local-tonsky.demoproj.dao.UserAccountsLocal - EJB3.x Local Business Interface
            
            17:22:11,797 WARN [DatabasePersistencePolicy] Unable to get timer handles for containerId: jboss.j2ee:ear=demoproj-ear.ear,jar=demoproj-ejb.jar,name=UserAccountsBean,service=EJB3
            org.jboss.util.NestedSQLException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57ff57:d3dc:49ab4c06:c09 status: ActionStatus.ABORTING >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57ff57:d3dc:49ab4c06:c09 status: ActionStatus.ABORTING >)
             at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)
             at org.jboss.ejb.txtimer.GeneralPurposeDatabasePersistencePlugin.selectTimers(GeneralPurposeDatabasePersistencePlugin.java:254)
             at org.jboss.ejb.txtimer.DatabasePersistencePolicy.listTimerHandles(DatabasePersistencePolicy.java:165)
             at sun.reflect.GeneratedMethodAccessor378.invoke(Unknown Source)
             at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
             at java.lang.reflect.Method.invoke(Unknown Source)
             at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)
             at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)
             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:668)
             at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
             at $Proxy90.listTimerHandles(Unknown Source)
             at org.jboss.ejb.txtimer.EJBTimerServiceImpl.restoreTimers(EJBTimerServiceImpl.java:458)
             at sun.reflect.GeneratedMethodAccessor377.invoke(Unknown Source)
             at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
             at java.lang.reflect.Method.invoke(Unknown Source)
             at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)
             at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)
             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:668)
             at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
             at $Proxy969.restoreTimers(Unknown Source)
             at org.jboss.ejb3.timerservice.jboss.JBossTimerServiceFactory.restoreTimerService(JBossTimerServiceFactory.java:128)
             at org.jboss.ejb3.stateless.StatelessContainer.lockedStart(StatelessContainer.java:251)
             at org.jboss.ejb3.EJBContainer.start(EJBContainer.java:879)
             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.jboss.reflect.plugins.introspection.ReflectionUtils.invoke(ReflectionUtils.java:59)
             at org.jboss.reflect.plugins.introspection.ReflectMethodInfoImpl.invoke(ReflectMethodInfoImpl.java:150)
             at org.jboss.joinpoint.plugins.BasicMethodJoinPoint.dispatch(BasicMethodJoinPoint.java:66)
             at org.jboss.kernel.plugins.dependency.KernelControllerContextAction$JoinpointDispatchWrapper.execute(KernelControllerContextAction.java:241)
             at org.jboss.kernel.plugins.dependency.ExecutionWrapper.execute(ExecutionWrapper.java:47)
             at org.jboss.kernel.plugins.dependency.KernelControllerContextAction.dispatchExecutionWrapper(KernelControllerContextAction.java:109)
             at org.jboss.kernel.plugins.dependency.KernelControllerContextAction.dispatchJoinPoint(KernelControllerContextAction.java:70)
             at org.jboss.kernel.plugins.dependency.LifecycleAction.installActionInternal(LifecycleAction.java:221)
             at org.jboss.kernel.plugins.dependency.InstallsAwareAction.installAction(InstallsAwareAction.java:54)
             at org.jboss.kernel.plugins.dependency.InstallsAwareAction.installAction(InstallsAwareAction.java:42)
             at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)
             at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)
             at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)
             at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
             at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)
             at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
             at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)
             at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
             at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:774)
             at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:540)
             at org.jboss.deployers.vfs.deployer.kernel.BeanMetaDataDeployer.deploy(BeanMetaDataDeployer.java:121)
             at org.jboss.deployers.vfs.deployer.kernel.BeanMetaDataDeployer.deploy(BeanMetaDataDeployer.java:51)
             at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)
             at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:50)
             at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:171)
             at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1439)
             at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1157)
             at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1178)
             at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1210)
             at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1098)
             at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
             at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)
             at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
             at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)
             at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
             at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
             at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
             at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:781)
             at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:545)
             at org.jboss.system.server.profileservice.hotdeploy.HDScanner.scan(HDScanner.java:290)
             at org.jboss.system.server.profileservice.hotdeploy.HDScanner.run(HDScanner.java:221)
             at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
             at java.util.concurrent.FutureTask$Sync.innerRunAndReset(Unknown Source)
             at java.util.concurrent.FutureTask.runAndReset(Unknown Source)
             at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(Unknown Source)
             at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(Unknown Source)
             at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
             at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
             at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
             at java.lang.Thread.run(Unknown Source)
            Caused by: javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57ff57:d3dc:49ab4c06:c09 status: ActionStatus.ABORTING >
             at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:370)
             at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
             at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
             at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
             ... 80 more
            17:22:11,817 INFO [PersistenceUnitDeployment] Starting persistence unit persistence.unit:unitName=demoproj-ear.ear/demoproj-ejb.jar#demoproj-dev-unit
            17:22:11,819 ERROR [AbstractKernelController] Error installing to Start: name=persistence.unit:unitName=demoproj-ear.ear/demoproj-ejb.jar#demoproj-dev-unit state=Create
            java.lang.RuntimeException: Specification violation [EJB3 JPA 6.2.1.2] - You have not defined a jta-data-source for a JTA enabled persistence context named: demoproj-dev-unit
             at org.jboss.jpa.deployment.PersistenceUnitInfoImpl.<init>(PersistenceUnitInfoImpl.java:115)
             at org.jboss.jpa.deployment.PersistenceUnitDeployment.start(PersistenceUnitDeployment.java:285)
             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.jboss.reflect.plugins.introspection.ReflectionUtils.invoke(ReflectionUtils.java:59)
             at org.jboss.reflect.plugins.introspection.ReflectMethodInfoImpl.invoke(ReflectMethodInfoImpl.java:150)
             at org.jboss.joinpoint.plugins.BasicMethodJoinPoint.dispatch(BasicMethodJoinPoint.java:66)
             at org.jboss.kernel.plugins.dependency.KernelControllerContextAction$JoinpointDispatchWrapper.execute(KernelControllerContextAction.java:241)
             at org.jboss.kernel.plugins.dependency.ExecutionWrapper.execute(ExecutionWrapper.java:47)
             at org.jboss.kernel.plugins.dependency.KernelControllerContextAction.dispatchExecutionWrapper(KernelControllerContextAction.java:109)
             at org.jboss.kernel.plugins.dependency.KernelControllerContextAction.dispatchJoinPoint(KernelControllerContextAction.java:70)
             at org.jboss.kernel.plugins.dependency.LifecycleAction.installActionInternal(LifecycleAction.java:221)
             at org.jboss.kernel.plugins.dependency.InstallsAwareAction.installAction(InstallsAwareAction.java:54)
             at org.jboss.kernel.plugins.dependency.InstallsAwareAction.installAction(InstallsAwareAction.java:42)
             at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)
             at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)
             at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)
             at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
             at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)
             at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
             at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)
             at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
             at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:774)
             at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:540)
             at org.jboss.deployers.vfs.deployer.kernel.BeanMetaDataDeployer.deploy(BeanMetaDataDeployer.java:121)
             at org.jboss.deployers.vfs.deployer.kernel.BeanMetaDataDeployer.deploy(BeanMetaDataDeployer.java:51)
             at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)
             at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:50)
             at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:171)
             at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1439)
             at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1157)
             at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1178)
             at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1210)
             at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1098)
             at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
             at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)
             at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
             at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)
             at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
             at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
             at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
             at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:781)
             at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:545)
             at org.jboss.system.server.profileservice.hotdeploy.HDScanner.scan(HDScanner.java:290)
             at org.jboss.system.server.profileservice.hotdeploy.HDScanner.run(HDScanner.java:221)
             at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
             at java.util.concurrent.FutureTask$Sync.innerRunAndReset(Unknown Source)
             at java.util.concurrent.FutureTask.runAndReset(Unknown Source)
             at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(Unknown Source)
             at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(Unknown Source)
             at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
             at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
             at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
             at java.lang.Thread.run(Unknown Source)
            17:22:14,643 INFO [TomcatDeployment] deploy, ctxPath=/demoproj, vfsUrl=demoproj-ear.ear/demoproj.war
            17:22:18,396 INFO [[/demoproj]] [****** Demo Project ******]Initialization Started
            17:22:18,397 INFO [[/demoproj]] Adding username Tonsky password Tonskytotsky...
            17:22:18,417 WARN [InterceptorsFactory] EJBTHREE-1246: Do not use InterceptorsFactory with a ManagedObjectAdvisor, InterceptorRegistry should be used via the bean container
            17:22:18,418 WARN [InterceptorsFactory] EJBTHREE-1246: Do not use InterceptorsFactory with a ManagedObjectAdvisor, InterceptorRegistry should be used via the bean container
            17:22:18,445 WARN [InterceptorRegistry] applicable interceptors is non-existent for public void tonsky.demoproj.dao.UserAccountsBean.deleteUserAccount(tonsky.demoproj.entities.UserAccount) throws tonsky.demoproj.dao.UserAccountsBean$UserDoesNotExistException
            17:22:18,490 WARN [InterceptorRegistry] applicable interceptors is non-existent for public java.util.List tonsky.demoproj.dao.UserAccountsBean.getUserAccountsByExample(tonsky.demoproj.entities.UserAccount)
            17:22:18,532 WARN [InterceptorRegistry] applicable interceptors is non-existent for public java.lang.String tonsky.demoproj.dao.UserAccountsBean.test()
            17:22:18,567 WARN [InterceptorRegistry] applicable interceptors is non-existent for public tonsky.demoproj.entities.SimpleEntity tonsky.demoproj.dao.UserAccountsBean.getSimpleEntityById(long)
            17:22:18,604 WARN [InterceptorRegistry] applicable interceptors is non-existent for public tonsky.demoproj.entities.UserAccount tonsky.demoproj.dao.UserAccountsBean.getUserAccountById(long) throws tonsky.demoproj.dao.UserAccountsBean$UserDoesNotExistException
            17:22:18,653 WARN [InterceptorRegistry] applicable interceptors is non-existent for public void tonsky.demoproj.dao.UserAccountsBean.updateUserAccount(tonsky.demoproj.entities.UserAccount) throws tonsky.demoproj.dao.UserAccountsBean$UserDoesNotExistException
            17:22:18,685 WARN [InterceptorRegistry] applicable interceptors is non-existent for public tonsky.demoproj.entities.UserAccount tonsky.demoproj.dao.UserAccountsBean.getUserAccountByUsername(java.lang.String) throws tonsky.demoproj.dao.UserAccountsBean$UserDoesNotExistException
            17:22:18,720 WARN [InterceptorRegistry] applicable interceptors is non-existent for public void tonsky.demoproj.dao.UserAccountsBean.addUserAccount(tonsky.demoproj.entities.UserAccount) throws tonsky.demoproj.dao.UserAccountsBean$UserAlreadyExistsException
            17:22:18,750 WARN [InterceptorRegistry] applicable interceptors is non-existent for public void tonsky.demoproj.dao.UserAccountsBean.deleteUserAccount(tonsky.demoproj.entities.UserAccount) throws tonsky.demoproj.dao.UserAccountsBean$UserDoesNotExistException
            17:22:18,779 WARN [InterceptorRegistry] applicable interceptors is non-existent for public java.util.List tonsky.demoproj.dao.UserAccountsBean.getUserAccountsByExample(tonsky.demoproj.entities.UserAccount)
            17:22:18,808 WARN [InterceptorRegistry] applicable interceptors is non-existent for public java.lang.String tonsky.demoproj.dao.UserAccountsBean.test()
            17:22:18,836 WARN [InterceptorRegistry] applicable interceptors is non-existent for public tonsky.demoproj.entities.SimpleEntity tonsky.demoproj.dao.UserAccountsBean.getSimpleEntityById(long)
            17:22:18,864 WARN [InterceptorRegistry] applicable interceptors is non-existent for public tonsky.demoproj.entities.UserAccount tonsky.demoproj.dao.UserAccountsBean.getUserAccountById(long) throws tonsky.demoproj.dao.UserAccountsBean$UserDoesNotExistException
            17:22:18,894 WARN [InterceptorRegistry] applicable interceptors is non-existent for public void tonsky.demoproj.dao.UserAccountsBean.updateUserAccount(tonsky.demoproj.entities.UserAccount) throws tonsky.demoproj.dao.UserAccountsBean$UserDoesNotExistException
            17:22:18,923 WARN [InterceptorRegistry] applicable interceptors is non-existent for public tonsky.demoproj.entities.UserAccount tonsky.demoproj.dao.UserAccountsBean.getUserAccountByUsername(java.lang.String) throws tonsky.demoproj.dao.UserAccountsBean$UserDoesNotExistException
            17:22:18,953 WARN [InterceptorRegistry] applicable interceptors is non-existent for public void tonsky.demoproj.dao.UserAccountsBean.addUserAccount(tonsky.demoproj.entities.UserAccount) throws tonsky.demoproj.dao.UserAccountsBean$UserAlreadyExistsException
            17:22:19,253 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: null
            17:22:19,253 ERROR [JDBCExceptionReporter] Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57ff57:d3dc:49ab4c06:c09 status: ActionStatus.ABORTING >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57ff57:d3dc:49ab4c06:c09 status: ActionStatus.ABORTING >)
            17:22:19,281 ERROR [TxPolicy] javax.ejb.EJBTransactionRolledbackException: org.hibernate.exception.GenericJDBCException: Cannot open connection
            17:22:19,362 ERROR [[/demoproj]] Exception sending context initialized event to listener instance of class tonsky.demoproj.web.listeners.Initializer
            javax.ejb.EJBTransactionRolledbackException: org.hibernate.exception.GenericJDBCException: Cannot open connection
             at org.jboss.ejb3.tx.Ejb3TxPolicy.handleInCallerTx(Ejb3TxPolicy.java:115)
             at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:130)
             at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:194)
             at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
             at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)
             at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
             at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42)
             at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
             at org.jboss.ejb3.security.RoleBasedAuthorizationInterceptorv2.invoke(RoleBasedAuthorizationInterceptorv2.java:201)
             at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
             at org.jboss.ejb3.security.Ejb3AuthenticationInterceptorv2.invoke(Ejb3AuthenticationInterceptorv2.java:159)
             at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
             at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:41)
             at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
             at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
             at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
             at org.jboss.ejb3.BlockContainerShutdownInterceptor.invoke(BlockContainerShutdownInterceptor.java:65)
             at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
             at org.jboss.aspects.currentinvocation.CurrentInvocationInterceptor.invoke(CurrentInvocationInterceptor.java:67)
             at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
             at org.jboss.ejb3.session.SessionSpecContainer.invoke(SessionSpecContainer.java:219)
             at org.jboss.ejb3.proxy.handler.ProxyInvocationHandlerBase.invoke(ProxyInvocationHandlerBase.java:261)
             at org.jboss.ejb3.proxy.handler.session.SessionSpecProxyInvocationHandlerBase.invoke(SessionSpecProxyInvocationHandlerBase.java:101)
             at $Proxy972.addUserAccount(Unknown Source)
             at tonsky.demoproj.web.listeners.Initializer.contextInitialized(Initializer.java:35)
             at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3910)
             at org.apache.catalina.core.StandardContext.start(StandardContext.java:4393)
             at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeployInternal(TomcatDeployment.java:367)
             at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeploy(TomcatDeployment.java:146)
             at org.jboss.web.deployers.AbstractWarDeployment.start(AbstractWarDeployment.java:460)
             at org.jboss.web.deployers.WebModule.startModule(WebModule.java:118)
             at org.jboss.web.deployers.WebModule.start(WebModule.java:96)
             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.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)
             at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)
             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:668)
             at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:206)
             at $Proxy36.start(Unknown Source)
             at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:42)
             at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:37)
             at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)
             at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)
             at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)
             at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
             at org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:286)
             at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)
             at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
             at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)
             at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
             at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
             at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
             at org.jboss.system.ServiceController.doChange(ServiceController.java:688)
             at org.jboss.system.ServiceController.start(ServiceController.java:460)
             at org.jboss.system.deployers.ServiceDeployer.start(ServiceDeployer.java:146)
             at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:104)
             at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:45)
             at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)
             at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:50)
             at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:171)
             at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1439)
             at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1157)
             at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1178)
             at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1210)
             at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1098)
             at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
             at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)
             at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
             at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)
             at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
             at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
             at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
             at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:781)
             at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:545)
             at org.jboss.system.server.profileservice.hotdeploy.HDScanner.scan(HDScanner.java:290)
             at org.jboss.system.server.profileservice.hotdeploy.HDScanner.run(HDScanner.java:221)
             at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
             at java.util.concurrent.FutureTask$Sync.innerRunAndReset(Unknown Source)
             at java.util.concurrent.FutureTask.runAndReset(Unknown Source)
             at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(Unknown Source)
             at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(Unknown Source)
             at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
             at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
             at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
             at java.lang.Thread.run(Unknown Source)
            Caused by: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Cannot open connection
             at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614)
             at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:76)
             at tonsky.demoproj.dao.UserAccountsBean.addUserAccount(UserAccountsBean.java:99)
             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.jboss.aop.joinpoint.MethodInvocation.invokeTarget(MethodInvocation.java:122)
             at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:111)
             at org.jboss.ejb3.EJBContainerInvocationWrapper.invokeNext(EJBContainerInvocationWrapper.java:69)
             at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.invoke(InterceptorSequencer.java:73)
             at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.aroundInvoke(InterceptorSequencer.java:59)
             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.jboss.aop.advice.PerJoinpointAdvice.invoke(PerJoinpointAdvice.java:174)
             at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
             at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.fillMethod(InvocationContextInterceptor.java:72)
             at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_fillMethod_30371868.invoke(InvocationContextInterceptor_z_fillMethod_30371868.java)
             at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
             at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.setup(InvocationContextInterceptor.java:88)
             at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_setup_30371868.invoke(InvocationContextInterceptor_z_setup_30371868.java)
             at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
             at org.jboss.ejb3.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:62)
             at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
             at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:56)
             at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
             at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
             at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
             at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42)
             at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
             at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:68)
             at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
             at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126)
             ... 87 more
            Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection
             at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
             at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
             at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
             at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)
             at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)
             at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
             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.loader.hql.QueryLoader.list(QueryLoader.java:401)
             at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:361)
             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.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:67)
             ... 120 more
            Caused by: org.jboss.util.NestedSQLException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57ff57:d3dc:49ab4c06:c09 status: ActionStatus.ABORTING >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57ff57:d3dc:49ab4c06:c09 status: ActionStatus.ABORTING >)
             at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)
             at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:46)
             at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
             ... 134 more
            Caused by: javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57ff57:d3dc:49ab4c06:c09 status: ActionStatus.ABORTING >
             at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:370)
             at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
             at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
             at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
             ... 136 more
            17:22:19,367 ERROR [StandardContext] Error listenerStart
            17:22:19,642 ERROR [StandardContext] Context [/demoproj] startup failed due to previous errors
            17:22:19,645 ERROR [AbstractKernelController] Error installing to Start: name=jboss.web.deployment:war=/demoproj state=Create mode=Manual requiredState=Installed
            org.jboss.deployers.spi.DeploymentException: URL file:/C:/Software/Server/jboss-5.0.0.GA/server/default/tmp/deploy/demoproj3254014908209652941-exp.war/ deployment failed
             at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeployInternal(TomcatDeployment.java:388)
             at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeploy(TomcatDeployment.java:146)
             at org.jboss.web.deployers.AbstractWarDeployment.start(AbstractWarDeployment.java:460)
             at org.jboss.web.deployers.WebModule.startModule(WebModule.java:118)
             at org.jboss.web.deployers.WebModule.start(WebModule.java:96)
             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.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)
             at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)
             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:668)
             at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:206)
             at $Proxy36.start(Unknown Source)
             at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:42)
             at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:37)
             at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)
             at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)
             at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)
             at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
             at org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:286)
             at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)
             at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
             at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)
             at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
             at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
             at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
             at org.jboss.system.ServiceController.doChange(ServiceController.java:688)
             at org.jboss.system.ServiceController.start(ServiceController.java:460)
             at org.jboss.system.deployers.ServiceDeployer.start(ServiceDeployer.java:146)
             at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:104)
             at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:45)
             at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)
             at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:50)
             at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:171)
             at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1439)
             at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1157)
             at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1178)
             at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1210)
             at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1098)
             at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
             at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)
             at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
             at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)
             at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
             at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
             at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
             at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:781)
             at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:545)
             at org.jboss.system.server.profileservice.hotdeploy.HDScanner.scan(HDScanner.java:290)
             at org.jboss.system.server.profileservice.hotdeploy.HDScanner.run(HDScanner.java:221)
             at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
             at java.util.concurrent.FutureTask$Sync.innerRunAndReset(Unknown Source)
             at java.util.concurrent.FutureTask.runAndReset(Unknown Source)
             at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(Unknown Source)
             at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(Unknown Source)
             at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
             at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
             at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
             at java.lang.Thread.run(Unknown Source)


            My new datasource:
            <?xml version="1.0" encoding="UTF-8"?>
            <!DOCTYPE datasources PUBLIC "-//JBoss//DTD JBOSS JCA Config 5.0//EN" "http://www.jboss.org/j2ee/dtd/jboss-ds_5_0.dtd" >
            <datasources>
             <local-tx-datasource>
             <jndi-name>demoproj</jndi-name>
             <connection-url>
             jdbc:mysql://localhost:3306/mydemoproject
             </connection-url>
             <driver-class>com.mysql.jdbc.Driver</driver-class>
             <user-name>root</user-name>
             <password>root</password>
            
             <min-pool-size>5</min-pool-size>
             <max-pool-size>20</max-pool-size>
            
             <!-- Additional Props -->
             <new-connection-sql>
             select 1;
             </new-connection-sql>
             <check-valid-connection-sql>
             SELECT 1;
             </check-valid-connection-sql>
             <valid-connection-checker-class-name>
             com.mysql.jdbc.integration.jboss.MysqlValidConnectionChecker
             </valid-connection-checker-class-name>
             <exception-sorter-class-name>
             com.mysql.jdbc.integration.jboss.ExtendedMysqlExceptionSorter
             </exception-sorter-class-name>
             <!-- End of Additional Props -->
             <!-- -->
             <metadata>
             <type-mapping>mySQL</type-mapping>
             </metadata>
             <!-- -->
             </local-tx-datasource>
            </datasources>
            


            My persistence.xml

            <?xml version="1.0" encoding="UTF-8"?>
            <persistence version="1.0"
             xmlns="http://java.sun.com/xml/ns/persistence"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd ">
             <persistence-unit name="demoproj-unit" transaction-type="JTA">
             <provider>org.hibernate.ejb.HibernatePersistence</provider>
             <jta-data-source>java:/demoproj</jta-data-source>
             <properties>
             <property name="hibernate.ejb.cfgfile" value="hibernate.cfg.xml" />
             </properties>
             </persistence-unit>
            </persistence>
            


            My hibernate.cfg.xml

            <?xml version="1.0" encoding="UTF-8"?>
            <!DOCTYPE hibernate-configuration PUBLIC
             "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
             "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
            <hibernate-configuration>
             <session-factory name="demoproj-session-factory">
            
             <!-- JTA Datasource config -->
             <property name="hibernate.transaction.manager_lookup_class">
             org.hibernate.transaction.JBossTransactionManagerLookup
             </property>
             <property name="hibernate.transaction.factory_class">
             org.hibernate.transaction.JTATransactionFactory
             </property>
             <!-- JNDI location of Datasource -->
             <property name="hibernate.connection.datasource">java:/demoproj</property>
            
             <!-- Other props -->
             <property name="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</property>
             <property name="hibernate.show_sql">true</property>
             <property name="hibernate.connection.autocommit">false</property>
            
             <!-- Mapping classes -->
             <mapping class="tonsky.demoproj.entities.PersonalInfo"/>
             <mapping class="tonsky.demoproj.entities.Role"/>
             <mapping class="tonsky.demoproj.entities.UserAccount"/>
             <mapping class="tonsky.demoproj.entities.SimpleEntity"/>
            
             </session-factory>
            </hibernate-configuration>
            


            I hope these help

            • 3. Re: MySQL 5.0 deployed as DS doesn't seem to work properly w
              Anthon Ranullo Newbie

              It looks like I couldn't obtain a manage transaction because it couldn't open a connection, but when I try looking up the datasource myself through JNDI I am successful obtaining a connection.

              Thanks PeterJ

              • 4. Re: MySQL 5.0 deployed as DS doesn't seem to work properly w
                Anthon Ranullo Newbie

                I updated my connector j to 5.0.8 from 5.0.5 and now its working. But I would be grateful to know what went wrong. If 5.0.5 was at fault, then it might mean during those times JTA users couldn't use MySQL. I wonder how did the developers worked with JTA in jboss using connector 5.0.5.

                I've got to let this out, $%@#! @#$%! @#$@#!#@@!!!! I've spent 3 days just to find out that my connector j is stvp1d @#$%! that was great