Unknown Error When Creating MySQL JTA Data Source

[kwrobel]

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.

[sfcoy]

Are there any relevant messages in the server.log?

[kwrobel]

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

[kwrobel]

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

[juergen.zimmermann]

Take a look at this WildFly URL resp. doc DataSource configuration - WildFly 8 and http://www.mastertheboss.com/jboss-datasource/how-to-configure-a-datasource-with-jboss-7