jboss 7as mysql-connector issue
kblurry Feb 28, 2012 4:59 PMi 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>