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

    jboss 7as mysql-connector issue

    kblurry grep Newbie

      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>