2 Replies Latest reply on Feb 29, 2012 9:22 AM by kblurry

    jboss 7as mysql-connector issue

    kblurry

      i did all everything in here: https://community.jboss.org/message/621516 but it till shows this error. Can someone help me out

       

      Calling C:\Users\Documents\jboss-as-7.0.2.Final\bin\standalone.conf.ba

       

      ===============================================================================

       

        JBoss Bootstrap Environment

       

        JBOSS_HOME: C:\Users\Documents\jboss-as-7.0.2.Final

       

        JAVA: C:\Program Files\Java\jre7\bin\java

       

        JAVA_OPTS: -Dprogram.name=standalone.bat -Xms64M -Xmx512M -XX:MaxPermSize=256M

      -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000

      -Dorg.jboss.resolver.warning=true -Djboss.modules.system.pkgs=org.jboss.byteman

      -server

       

      ===============================================================================

       

      16:49:47,284 INFO  [org.jboss.modules] JBoss Modules version 1.0.2.GA

      16:49:47,548 INFO  [org.jboss.msc] JBoss MSC version 1.0.1.GA

      16:49:47,604 INFO  [org.jboss.as] JBoss AS 7.0.2.Final "Arc" starting

      16:49:48,474 WARN  [org.jboss.as] No security realm defined for native managemen

      t service, all access will be unrestricted.

      16:49:48,484 INFO  [org.jboss.as] creating http management service using network

      interface (management) port (9990)

      16:49:48,486 WARN  [org.jboss.as] No security realm defined for http management

      service, all access will be unrestricted.

      16:49:48,497 INFO  [org.jboss.as.logging] Removing bootstrap log handlers

      16:49:48,517 INFO  [org.jboss.as.connector.subsystems.datasources] (Controller B

      oot Thread) Deploying JDBC-compliant driver class org.h2.Driver (version 1.2)

      16:49:48,525 INFO  [org.jboss.as.connector.subsystems.datasources] (Controller B

      oot Thread) Deploying non-JDBC-compliant driver class com.mysql.jdbc.Driver (ver

      sion 5.1)

      16:49:48,543 INFO  [org.jboss.as.clustering.infinispan.subsystem] (Controller Bo

      ot Thread) Activating Infinispan subsystem.

      16:49:48,649 INFO  [org.jboss.as.naming] (Controller Boot Thread) JBAS011800: Ac

      tivating Naming Subsystem

      16:49:48,662 INFO  [org.jboss.as.naming] (MSC service thread 1-6) JBAS011802: St

      arting Naming Service

      16:49:48,670 INFO  [org.jboss.as.osgi] (Controller Boot Thread) JBAS011910: Acti

      vating OSGi Subsystem

      16:49:48,696 INFO  [org.jboss.as.security] (Controller Boot Thread) Activating S

      ecurity Subsystem

      16:49:48,703 INFO  [org.jboss.remoting] (MSC service thread 1-1) JBoss Remoting

      version 3.2.0.Beta2

      16:49:48,717 INFO  [org.xnio] (MSC service thread 1-1) XNIO Version 3.0.0.Beta3

      16:49:48,734 INFO  [org.xnio.nio] (MSC service thread 1-1) XNIO NIO Implementati

      on Version 3.0.0.Beta3

      16:49:48,976 INFO  [org.apache.catalina.core.AprLifecycleListener] (MSC service

      thread 1-2) The Apache Tomcat Native library which allows optimal performance in

      production environments was not found on the java.library.path: C:\Program File

      s\Java\jre7\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\app\nM

      atutina\product\11.2.0\client_1;C:\app\nMatutina\product\11.2.0\client_1\bin;C:\

      Program Files (x86)\ImageMagick-6.7.3-Q16;C:\Program Files\ImageMagick-6.7.3-Q16

      ;C:\Ruby192\bin;C:\Ruby193\bin;C:\Windows\system32;C:\Windows;C:\Windows\System3

      2\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;c:\Program Files (x86)\Micros

      oft SQL Server\100\Tools\Binn\;c:\Program Files\Microsoft SQL Server\100\Tools\B

      inn\;c:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files (x86)\

      Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files (x86)\

      Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\;C:\Program Files (x86

      )\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files\TortoiseSVN\bin;C:\Program

      Files (x86)\Git\cmd;.

      16:49:48,989 INFO  [org.jboss.as.ee] (Controller Boot Thread) Activating EE subs

      ystem

      16:49:49,066 INFO  [org.jboss.as.remoting] (MSC service thread 1-2) Listening on

      /127.0.0.1:9999

      16:49:49,089 INFO  [org.jboss.as.jmx.JMXConnectorService] (MSC service thread 1-

      2) Starting remote JMX connector

      16:49:49,147 INFO  [org.apache.coyote.http11.Http11Protocol] (MSC service thread

      1-1) Starting Coyote HTTP/1.1 on http--127.0.0.1-8080

      16:49:49,207 INFO  [org.jboss.as.connector] (MSC service thread 1-5) Starting JC

      A Subsystem (JBoss IronJacamar 1.0.3.Final)

      16:49:49,537 INFO  [org.jboss.as.deployment] (MSC service thread 1-5) Started Fi

      leSystemDeploymentService for directory C:\Users\nmatutina\Documents\jboss-as-7.

      0.2.Final\standalone\deployments

      16:49:49,754 INFO  [org.jboss.as.controller] (Controller Boot Thread) Service st

      atus report

         New missing/unsatisfied dependencies:

            service jboss.jdbc-driver.com_mysql_jdbc_Driver (missing)

       

      16:49:52,344 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-5) Sta

      rting deployment of "TA.war"

      16:49:54,695 INFO  [org.jboss.jpa] (MSC service thread 1-1) read persistence.xml

      for TeamAssessmentPU

      16:49:54,713 INFO  [org.jboss.as.jpa] (MSC service thread 1-4) added javax.persi

      stence.api, javaee.api, org.jboss.as.jpa, org.javassist dependencies to TA.war

      16:49:54,715 INFO  [org.jboss.as.jpa] (MSC service thread 1-4) added (default pr

      ovider) org.hibernate dependency to application deployment (since 1 PU(s) didn't

      specify jboss.as.jpa.providerModule)

      16:49:54,716 INFO  [org.jboss.as.jpa] (MSC service thread 1-4) added org.hiberna

      te dependency to application deployment

      16:49:55,094 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-6) MSC0000

      1: Failed to start service jboss.deployment.unit."TA.war".INSTALL: org.jboss.msc

      .service.StartException in service jboss.deployment.unit."TA.war".INSTALL: Faile

      d to process phase INSTALL of deployment "TA.war"

              at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(Deplo

      ymentUnitPhaseService.java:121)

              at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(Se

      rviceControllerImpl.java:1824)

              at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceCont

      rollerImpl.java:1759)

              at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [:1

      .7.0_03]

              at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [:

      1.7.0_03]

              at java.lang.Thread.run(Unknown Source) [:1.7.0_03]

      Caused by: org.jboss.as.server.deployment.DeploymentUnitProcessingException: onl

      y one persistence provider can be packaged with an application [org.hibernate.ej

      b.HibernatePersistence, com.objectdb.jpa.Provider]

              at org.jboss.as.jpa.processor.PersistenceProviderProcessor.deploy(Persis

      tenceProviderProcessor.java:65)

              at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(Deplo

      ymentUnitPhaseService.java:115)

              ... 5 more

       

      16:49:55,313 INFO  [org.jboss.as.server.controller] (DeploymentScanner-threads -

      2) Deployment of "TA.war" was rolled back with failure message {"Failed service

      s" => {"jboss.deployment.unit.\"TA.war\".INSTALL" => "org.jboss.msc.service.Star

      tException in service jboss.deployment.unit.\"TA.war\".INSTALL: Failed to proces

      s phase INSTALL of deployment \"TA.war\""},"Services with missing/unavailable de

      pendencies" => ["jboss.naming.context.java.module.TA.TA.ValidatorFactory missing

      [ jboss.naming.context.java.module.TA.TA ]","jboss.naming.context.java.module.T

      A.TA.Validator missing [ jboss.naming.context.java.module.TA.TA ]"]}

      16:49:55,708 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-4) Sto

      pped deployment TA.war in 398ms

      16:49:55,711 ERROR [org.jboss.as.deployment] (DeploymentScanner-threads - 1) {"C

      omposite operation failed and was rolled back. Steps that failed:" => {"Operatio

      n step-2" => {"Failed services" => {"jboss.deployment.unit.\"TA.war\".INSTALL" =

      > "org.jboss.msc.service.StartException in service jboss.deployment.unit.\"TA.wa

      r\".INSTALL: Failed to process phase INSTALL of deployment \"TA.war\""},"Service

      s with missing/unavailable dependencies" => ["jboss.naming.context.java.module.T

      A.TA.ValidatorFactory missing [ jboss.naming.context.java.module.TA.TA ]","jboss

      .naming.context.java.module.TA.TA.Validator missing [ jboss.naming.context.java.

      module.TA.TA ]"]}}}

       

       

      Here's my standalone. xml

       

      <datasource

              jndi-name="java:/tat" pool-name="tat_pool"

              enabled="true" jta="true"

              use-java-context="true" use-ccm="true">

          <connection-url>

              jdbc:mysql://pcname.com:3306/TA

          </connection-url>

          <driver-class>

              com.mysql.jdbc.Driver

          </driver-class>

           <driver>mysql-connector-java-5.1.15.jar</driver>

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

            <pool>

      <min-pool-size>2</min-pool-size>

      <max-pool-size>30</max-pool-size>

      <prefill>true</prefill>

      <use-strict-min>false</use-strict-min>

      <flush-strategy>FailingConnectionOnly</flush-strategy>

      </pool>

          <security>

              <user-name>username</user-name>

              <password>password</password>

          </security>

          <statement>

              <prepared-statement-cache-size>

                  100

              </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 name="h2" module="com.h2database.h2">

                                  <xa-datasource-class>

                                      org.h2.jdbcx.JdbcDataSource

                                  </xa-datasource-class>

                              </driver>

                              <driver name=”mysql-connector-java-5.1.15.jar” module=”com.mysql”/>

                      </drivers>

        • 1. Re: jboss 7as mysql-connector issue
          jamezp

          I don't think your driver is set-up correctly. You have org.h2.jdbcx.JdbcDataSource for your MySQL driver which isn't right and neither is your data source class. You should probably be using com.mysql.jdbc.Driver and com.mysql.jdbc.jdbc2.optional.MysqlXADataSource.

           

          If that doesn't work you might have to add an import to javax.transactions.jta in your MySQL module.xml.

           

          --

          James R. Perkins

          1 of 1 people found this helpful
          • 2. Re: jboss 7as mysql-connector issue
            kblurry

            thanks james this worked fine. I changed the drivers as you said. I got another problem though, says cannot instantiate bean. ill make a new thread for it. thanks again