14 Replies Latest reply on Jul 26, 2014 10:42 AM by Nuwan Karunathilaka

    JBAS014775: New missing/unsatisfied dependencies:

    xsa lefter Newbie

      I knew that there is a lot of question like this when deploying MySQL JDBC driver but, instead of hiject another member's thread, I'll start my own thread. This is happen even when I only configure the JNDI datasouce and not yet deploying my application to JBoss AS 7.1.1 server:

       

      {code}

      16:26:44,509 INFO  [org.jboss.modules] JBoss Modules version 1.1.1.GA

      16:26:44,695 INFO  [org.jboss.msc] JBoss MSC version 1.0.2.GA

      16:26:44,741 INFO  [org.jboss.as] JBAS015899: JBoss AS 7.1.1.Final "Brontes" starting

      16:26:45,432 INFO  [org.xnio] XNIO Version 3.0.3.GA

      16:26:45,434 INFO  [org.jboss.as.server] JBAS015888: Creating http management service using socket-binding (management-http)

      16:26:45,445 INFO  [org.xnio.nio] XNIO NIO Implementation Version 3.0.3.GA

      16:26:45,453 INFO  [org.jboss.remoting] JBoss Remoting version 3.2.3.GA

      16:26:45,482 INFO  [org.jboss.as.logging] JBAS011502: Removing bootstrap log handlers

      16:26:45,487 INFO  [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 31) JBAS010280: Activating Infinispan subsystem.

      16:26:45,509 INFO  [org.jboss.as.configadmin] (ServerService Thread Pool -- 26) JBAS016200: Activating ConfigAdmin Subsystem

      16:26:45,512 INFO  [org.jboss.as.security] (ServerService Thread Pool -- 44) JBAS013101: Activating Security Subsystem

      16:26:45,519 INFO  [org.jboss.as.webservices] (ServerService Thread Pool -- 48) JBAS015537: Activating WebServices Extension

      16:26:45,524 INFO  [org.jboss.as.osgi] (ServerService Thread Pool -- 39) JBAS011940: Activating OSGi Subsystem

      16:26:45,526 INFO  [org.jboss.as.connector] (MSC service thread 1-15) JBAS010408: Starting JCA Subsystem (JBoss IronJacamar 1.0.9.Final)

      16:26:45,529 INFO  [org.jboss.as.naming] (ServerService Thread Pool -- 38) JBAS011800: Activating Naming Subsystem

      16:26:45,539 INFO  [org.jboss.as.security] (MSC service thread 1-10) JBAS013100: Current PicketBox version=4.0.7.Final

      16:26:45,612 INFO  [org.jboss.as.naming] (MSC service thread 1-13) JBAS011802: Starting Naming Service

      16:26:45,637 INFO  [org.jboss.as.mail.extension] (MSC service thread 1-14) JBAS015400: Bound mail session [java:jboss/mail/Default]

      16:26:45,652 INFO  [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 27) JBAS010403: Deploying JDBC-compliant driver class org.h2.Driver (version 1.3)

      16:26:45,707 INFO  [org.jboss.ws.common.management.AbstractServerConfig] (MSC service thread 1-3) JBoss Web Services - Stack CXF Server 4.0.2.GA

      16:26:46,002 INFO  [org.apache.coyote.http11.Http11Protocol] (MSC service thread 1-15) Starting Coyote HTTP/1.1 on http-localhost-127.0.0.1-8080

      16:26:46,052 INFO  [org.jboss.as.server.deployment.scanner] (MSC service thread 1-3) JBAS015012: Started FileSystemDeploymentService for directory D:\JavaPlatform\ApplicationServer\jboss-as-7.1.1.Final\standalone\deployments

      16:26:46,059 INFO  [org.jboss.as.remoting] (MSC service thread 1-13) JBAS017100: Listening on /127.0.0.1:9999

      16:26:46,059 INFO  [org.jboss.as.remoting] (MSC service thread 1-5) JBAS017100: Listening on localhost/127.0.0.1:4447

      16:26:46,093 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-10) JBAS010400: Bound data source [java:jboss/datasources/ExampleDS]

      16:26:46,325 INFO  [org.jboss.as.controller] (Controller Boot Thread) JBAS014774: Service status report

      JBAS014775:    New missing/unsatisfied dependencies:

            service jboss.jdbc-driver.com_mysql (missing) dependents: [service jboss.data-source.java:jboss/datasources/mysqlDS]

       

       

      16:26:46,335 INFO  [org.jboss.as] (Controller Boot Thread) JBAS015951: Admin console listening on http://127.0.0.1:9990

      16:26:46,336 ERROR [org.jboss.as] (Controller Boot Thread) JBAS015875: JBoss AS 7.1.1.Final "Brontes" started (with errors) in 2052ms - Started 134 of 212 services (2 services failed or missing dependencies, 74 services are passive or on-demand)

      {code}

       

       

      This is a snippet from my standalone.xml:

       

      {code:xml}
              <subsystem xmlns="urn:jboss:domain:datasources:1.0">

                  <datasources>

                      <datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="true">

                          <connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1</connection-url>

                          <driver>h2</driver>

                          <security>

                              <user-name>sa</user-name>

                              <password>sa</password>

                          </security>

                      </datasource>

                      <datasource jndi-name="java:jboss/datasources/mysqlDS" pool-name="mysqlDS" enabled="true" use-java-context="true">

                          <connection-url>jdbc:mysql://localhost:3306/taskroller_dev</connection-url>

                              <driver>com.mysql</driver>

                          <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>

                          <pool>

                              <min-pool-size>10</min-pool-size>

                              <max-pool-size>100</max-pool-size>

                              <prefill>true</prefill>

                          </pool>

                          <security>

                              <user-name>root</user-name>

                              <password>admin</password>

                          </security>

                          <statement>

                              <prepared-statement-cache-size>32</prepared-statement-cache-size>

                              <share-prepared-statements />

                          </statement>

                      </datasource>

                      <drivers>

                          <driver name="h2" module="com.h2database.h2">

                              <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>

                          </driver>

                          <driver name="mysql" module="com.mysql">

                              <driver-class>com.mysql.jdbc.Driver</driver-class>

                              <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>

                          </driver>

                      </drivers>

                  </datasources>

              </subsystem>

      {code:xml}

       

      This is my module.xml:

       

      {code:xml}

      <?xml version="1.0" encoding="UTF-8"?>

       

      <module xmlns="urn:jboss:module:1.1" name="com.mysql">

          <resources>

              <resource-root path="mysql-connector-java-5.1.21.jar" />

          </resources>

          <dependencies>

              <module name="javax.api" />

              <module name="javax.transaction" />

          </dependencies>

      </module>

      {code:xml}

       

      And this is sreenshot from <jboss-install-dir>/modules/com/mysql/main:

      com-mysql-main.PNG

       

      My question is, did I miss something?

       

      Message was edited by: xsa lefter. Reason: Code formatting.

        • 1. Re: JBAS014775: New missing/unsatisfied dependencies:
          Nicklas Karlsson Master

          try <driver>mysql</driver> (it's by name)

          • 2. Re: JBAS014775: New missing/unsatisfied dependencies:
            Tomaz Cerar Master

            Hi,

             

            you have driver defined under name="mysql"

            but in datasource configuruation your are referencing it as "com.mysql" just change that to match the name of the driver, in this case  "mysql"

             

             

            --

            tomaz

            • 3. Re: JBAS014775: New missing/unsatisfied dependencies:
              xsa lefter Newbie

              @Nicklas, @Tomaz, Yups, It was typo, thanks. But unfortunately, still doesn't work on my machine, with same error messages. Removing this line:

               

              {code:xml}

              <driver-class>com.mysql.jdbc.Driver</driver-class>

              {code:xml}

               

              still doesn't work.

              • 4. Re: JBAS014775: New missing/unsatisfied dependencies:
                Nicklas Karlsson Master

                I see the line

                 

                16:26:45,652 INFO  [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 27) JBAS010403: Deploying JDBC-compliant driver class org.h2.Driver (version 1.3)

                 

                One would think the mysql driver would produce some output, too. If it's not JDBC-compliant, I think you need the driver-class

                 

                Have you tried the CLI to deploy the driver in case it would give more details?

                • 5. Re: JBAS014775: New missing/unsatisfied dependencies:
                  xsa lefter Newbie

                  I got this message in console:

                   

                  {code}

                  17:30:25,884 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-1) JBAS015876: Starting deployment of "mysql-connector-java-5.1.21.jar"

                  17:30:25,936 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-13) JBAS010404: Deploying non-JDBC-compliant driver class com.mysql.jdbc.Driver (version 5.1)

                  17:30:25,975 INFO  [org.jboss.as.server] (management-handler-thread - 4) JBAS018565: Replaced deployment "mysql-connector-java-5.1.21.jar" with deployment "mysql-connector-java-5.1.21.jar"

                  {code}

                   

                  I don't think that the message above is an indicating of server startup is Ok now, so I restart the server, but got the same message:

                   

                  {code}

                  17:32:57,508 INFO  [org.jboss.modules] JBoss Modules version 1.1.1.GA

                  17:32:57,710 INFO  [org.jboss.msc] JBoss MSC version 1.0.2.GA

                  17:32:57,760 INFO  [org.jboss.as] JBAS015899: JBoss AS 7.1.1.Final "Brontes" starting

                  17:32:58,499 INFO  [org.jboss.as.server] JBAS015888: Creating http management service using socket-binding (management-http)

                  17:32:58,500 INFO  [org.xnio] XNIO Version 3.0.3.GA

                  17:32:58,514 INFO  [org.xnio.nio] XNIO NIO Implementation Version 3.0.3.GA

                  17:32:58,523 INFO  [org.jboss.remoting] JBoss Remoting version 3.2.3.GA

                  17:32:58,547 INFO  [org.jboss.as.logging] JBAS011502: Removing bootstrap log handlers

                  17:32:58,553 INFO  [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 31) JBAS010280: Activating Infinispan subsystem.

                  17:32:58,602 INFO  [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 27) JBAS010403: Deploying JDBC-compliant driver class org.h2.Driver (version 1.3)

                  17:32:58,611 INFO  [org.jboss.as.naming] (ServerService Thread Pool -- 38) JBAS011800: Activating Naming Subsystem

                  17:32:58,614 INFO  [org.jboss.as.security] (ServerService Thread Pool -- 44) JBAS013101: Activating Security Subsystem

                  17:32:58,626 INFO  [org.jboss.as.webservices] (ServerService Thread Pool -- 48) JBAS015537: Activating WebServices Extension

                  17:32:58,663 INFO  [org.jboss.as.osgi] (ServerService Thread Pool -- 39) JBAS011940: Activating OSGi Subsystem

                  17:32:58,677 INFO  [org.jboss.as.configadmin] (ServerService Thread Pool -- 26) JBAS016200: Activating ConfigAdmin Subsystem

                  17:32:58,678 INFO  [org.jboss.as.naming] (MSC service thread 1-8) JBAS011802: Starting Naming Service

                  17:32:58,686 INFO  [org.jboss.as.connector] (MSC service thread 1-9) JBAS010408: Starting JCA Subsystem (JBoss IronJacamar 1.0.9.Final)

                  17:32:58,688 INFO  [org.jboss.as.security] (MSC service thread 1-4) JBAS013100: Current PicketBox version=4.0.7.Final

                  17:32:58,695 INFO  [org.jboss.as.mail.extension] (MSC service thread 1-14) JBAS015400: Bound mail session [java:jboss/mail/Default]

                  17:32:58,795 INFO  [org.jboss.ws.common.management.AbstractServerConfig] (MSC service thread 1-6) JBoss Web Services - Stack CXF Server 4.0.2.GA

                  17:32:59,165 INFO  [org.apache.coyote.http11.Http11Protocol] (MSC service thread 1-5) Starting Coyote HTTP/1.1 on http-localhost-127.0.0.1-8080

                  17:32:59,219 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-7) JBAS015876: Starting deployment of "mysql-connector-java-5.1.21.jar"

                  17:32:59,221 INFO  [org.jboss.as.server.deployment.scanner] (MSC service thread 1-15) JBAS015012: Started FileSystemDeploymentService for directory D:\JavaPlatform\ApplicationServer\jboss-as-7.1.1.Final\standalone\deployments

                  17:32:59,228 INFO  [org.jboss.as.remoting] (MSC service thread 1-4) JBAS017100: Listening on localhost/127.0.0.1:4447

                  17:32:59,228 INFO  [org.jboss.as.remoting] (MSC service thread 1-3) JBAS017100: Listening on /127.0.0.1:9999

                  17:32:59,276 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-7) JBAS010400: Bound data source [java:jboss/datasources/ExampleDS]

                  17:32:59,415 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-11) JBAS010404: Deploying non-JDBC-compliant driver class com.mysql.jdbc.Driver (version 5.1)

                  17:32:59,652 INFO  [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Deployed "mysql-connector-java-5.1.21.jar"

                  17:32:59,654 INFO  [org.jboss.as.controller] (Controller Boot Thread) JBAS014774: Service status report

                  JBAS014775:    New missing/unsatisfied dependencies:

                        service jboss.jdbc-driver.mysql (missing) dependents: [service jboss.data-source.java:jboss/datasources/mysqlDS]

                   

                   

                  17:32:59,671 INFO  [org.jboss.as] (Controller Boot Thread) JBAS015951: Admin console listening on http://127.0.0.1:9990

                  17:32:59,672 ERROR [org.jboss.as] (Controller Boot Thread) JBAS015875: JBoss AS 7.1.1.Final "Brontes" started (with errors) in 2398ms - Started 155 of 235 services (2 services failed or missing dependencies, 76 services are passive or on-demand)

                  {code}

                  • 7. Re: JBAS014775: New missing/unsatisfied dependencies:
                    Nicklas Karlsson Master

                    Although https://zorq.net/b/2011/07/12/adding-a-mysql-datasource-to-jboss-as-7/ indicates it might work anyway. Did you create the module from scratch or by copying existing? Does the .index-file re-generate if you remove it and restart?

                    • 8. Re: JBAS014775: New missing/unsatisfied dependencies:
                      xsa lefter Newbie

                      Nicklas Karlsson wrote:

                       

                      Is the driver-class there or not?

                      Yes, I'd re-add the driver class declaration.

                       

                      Although https://zorq.net/b/2011/07/12/adding-a-mysql-datasource-to-jboss-as-7/ indicates it might work anyway. Did you create the module from scratch or by copying existing? Does the .index-file re-generate if you remove it and restart?

                      And yes, the .index file in com/mysql/main directory was generated in the server restarted. This is another info from JBoss Tools (from the "server view").

                       

                      jbosstools.PNG

                       

                      I think the problem is arround:

                      driver-class:undefined.

                       

                      But I don't understand why.

                       

                      Oh and another things is that, I'm always force delete directory:

                      • <jboss-install-dir>/standalone/data
                      • <jboss-install-dir>/standalone/tmp
                      • <jboss-install-dir>/standalone/log
                      • <jboss-install-dir>/standalone/configuration/standalone_xml_history

                      When I found my configuration is causing server fail to started. Not sure whether this is causing a problem.

                       

                      However, do you know whether JBoss 7 create some temporary in OS's users/tmp/** directory or somewhere?

                      • 9. Re: JBAS014775: New missing/unsatisfied dependencies:
                        Nicklas Karlsson Master

                        I don't think it writes anywhere else. Have you tried disabling the auto-cleanup of stuff?

                        • 10. Re: JBAS014775: New missing/unsatisfied dependencies:
                          Nicklas Karlsson Master

                          What does the server view of datasources/jdbc-driver show?

                          • 11. Re: JBAS014775: New missing/unsatisfied dependencies:
                            xsa lefter Newbie

                            Nick, this is how jdbc-driver server view looks like.

                            driver-class.PNG

                             

                            However, I just delete all <jboss-install-dir> and download fresh new jboss-as-7.1.1.zip, then add the same configuration I'd added before. Unfortunately got the same error.

                            • 12. Re: JBAS014775: New missing/unsatisfied dependencies:
                              Jon Austen Newbie

                              I also see this exact same problem using JBoss EAP 6.0.1  but , when I login to the http://localhost:9990/console  interface and look at the JNDI connectors, they look healthy from there.   This makes me think this error is a red herring that doesn't actually cause a problem???  ( May 3, 2013)

                              • 13. Re: JBAS014775: New missing/unsatisfied dependencies:
                                Gustavo Seixas Newbie

                                Is the version of driver. Change for a new version. Believe, is only it!!!

                                • 14. Re: JBAS014775: New missing/unsatisfied dependencies:
                                  Nuwan Karunathilaka Newbie

                                  maybe this is soooo late reply. But if someone has the same issue, you can try below. standalone.xml configuration is explained well above. I used the same for mine.   I'm a newbie too.

                                  1. {jboss-home}/modules/com/mysql/main // this folder should be there. earlier i tried without this and didn't work.

                                  2. copy your mysql connector jar file here.

                                  3. create a module.xml with below content.

                                   

                                  <?xml version="1.0" encoding="UTF-8"?>

                                  <module xmlns="urn:jboss:module:1.0" name="com.mysql">

                                    <resources>

                                      <resource-root path="mysql-connector-java-5.1.23-bin.jar"/>

                                    </resources>

                                    <dependencies>

                                      <module name="javax.api"/>

                                      <module name="javax.transaction.api"/>

                                    </dependencies>

                                  </module>

                                   

                                  4. you can use below thread to learn how to make j connector jdbs type 4 compliant.

                                  https://community.jboss.org/wiki/DataSourceConfigurationInAS7