4 Replies Latest reply on Apr 8, 2014 7:48 AM by Juergen Zimmermann

    Unknown Error When Creating MySQL JTA Data Source

    Kay Wrobel Newbie

      I am trying to create a JTA Data Source for a MySQL database connection. After I create a new data source and click on the Connection tab and put a check box inside JTA and then save, when I try to enable that data source, I get a "Unkown Error" message at the top of the page. The data source stays disabled. I tried to restart the server and then enable the new data source, it worked. Then magically, the entire new data source disappeared. Completely!

       

      This is with the latest WildFly 8.0 Final release and a mysql connector that is part of my Debian Wheezy repository. I am using Debian 7 Wheezy 64-Bit and openjdk 7.

       

      This used to work without a hitch under JBoss AS 7.1.1. Any help is much appreciated.

        • 1. Re: Unknown Error When Creating MySQL JTA Data Source
          Stephen Coy Master

          Are there any relevant messages in the server.log?

          • 2. Re: Unknown Error When Creating MySQL JTA Data Source
            Kay Wrobel Newbie

            Well, I started the server in standalone mode from a shell, and it displays an error as I hit "enable" on the data source after I changed it to JTA. Here is the exception shown on the console:

             

            00:34:20,441 ERROR [org.jboss.as.connector.subsystems.datasources.AbstractDataSourceService$AS7DataSourceDeployer] (MSC service thread 1-2) Error during the deployment of java:jboss/datasources/kayds: java.lang.IllegalStateException

              at org.jboss.msc.value.InjectedValue.getValue(InjectedValue.java:47)

              at org.jboss.as.connector.subsystems.datasources.AbstractDataSourceService$AS7DataSourceDeployer.getTransactionIntegration(AbstractDataSourceService.java:409)

              at org.jboss.as.connector.subsystems.datasources.AbstractDataSourceService$AS7DataSourceDeployer.createMcf(AbstractDataSourceService.java:461)

              at org.jboss.jca.deployers.common.AbstractDsDeployer.deployDataSource(AbstractDsDeployer.java:430)

              at org.jboss.jca.deployers.common.AbstractDsDeployer.createObjectsAndInjectValue(AbstractDsDeployer.java:283)

              at org.jboss.as.connector.subsystems.datasources.AbstractDataSourceService$AS7DataSourceDeployer.deploy(AbstractDataSourceService.java:310)

              at org.jboss.as.connector.subsystems.datasources.AbstractDataSourceService.start(AbstractDataSourceService.java:124)

              at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1948)

              at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1881)

              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_51]

              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_51]

              at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_51]

             

            00:34:20,465 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-2) MSC000001: Failed to start service jboss.data-source.java:jboss/datasources/kayds: org.jboss.msc.service.StartException in service jboss.data-source.java:jboss/datasources/kayds: JBAS010433: Error during the deployment of KAYDS

              at org.jboss.as.connector.subsystems.datasources.AbstractDataSourceService.start(AbstractDataSourceService.java:131)

              at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1948) [jboss-msc-1.2.0.Final.jar:1.2.0.Final]

              at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1881) [jboss-msc-1.2.0.Final.jar:1.2.0.Final]

              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_51]

              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_51]

              at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_51]

            Caused by: org.jboss.msc.service.StartException in anonymous service: JBAS010432: Unable to start the ds because it generated more than one cf

              at org.jboss.as.connector.subsystems.datasources.AbstractDataSourceService.start(AbstractDataSourceService.java:126)

              ... 5 more

             

            00:34:20,513 INFO  [org.jboss.as.controller] (XNIO-1 task-7) JBAS014774: Service status report

            JBAS014775:    New missing/unsatisfied dependencies:

                  service jboss.data-source-config.KAYDS (missing) dependents: [service jboss.data-source.java:jboss/datasources/kayds]

            JBAS014777:   Services which failed to start:      service jboss.data-source.java:jboss/datasources/kayds

            • 3. Re: Unknown Error When Creating MySQL JTA Data Source
              Kay Wrobel Newbie

              Any chance this could get looked at? I am currently evaluating various Java EE servers for compatibility with my PrimeFaces CRUD Generator.