Wiem, że większość z was nie zna Jboss, ale bardzo mi zależy na rozwiązaniu tego problemu i umieszczam go na rożnych forach.
Przejrzałem wiele porad w internecie, ale żadna nie działa.
Nie mogę połączyć serwera z MySQL.
Mój obecny plik standalone.xml
<subsystem xmlns="urn:jboss:domain:datasources:2.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;DB_CLOSE_ON_EXIT=FALSE</connection-url>
<driver>h2</driver>
<security>
<user-name>sa</user-name>
<password>sa</password>
</security>
</datasource>
<datasource jta="true" jndi-name="java:/newdatabase" pool-name="newdatabase" enabled="true" use-java-context="true" use-ccm="true">
<connection-url>jdbc:mysql://localhost:3306/newdatabase</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<driver>mysql</driver>
<security>
<user-name>chowniec</user-name>
<password>password2</password>
</security>
</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"/>
</drivers>
</datasources>
</subsystem>
Przy starcie systemu serwera mam takie błędy:
pioflor@pioflor-IdeaPad-S210-Touch:~$ Pobrane/wildfly-8.2.0.Final/bin/standalone.sh
=========================================================================
JBoss Bootstrap Environment
JBOSS_HOME: /home/pioflor/Pobrane/wildfly-8.2.0.Final
JAVA: java
JAVA_OPTS: -server -Xms64m -Xmx512m -XX:MaxPermSize=256m -Djava.net.preferIPv4Stack=true -Djboss.modules.system.pkgs=org.jboss.byteman -Djava.awt.headless=true
=========================================================================
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=256m; support was removed in 8.0
22:55:05,200 INFO [org.jboss.modules] (main) JBoss Modules version 1.3.3.Final
22:55:05,651 INFO [org.jboss.msc] (main) JBoss MSC version 1.2.2.Final
22:55:05,787 INFO [org.jboss.as] (MSC service thread 1-1) JBAS015899: WildFly 8.2.0.Final "Tweek" starting
22:55:07,871 INFO [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 1) JBAS015003: Found jsf-managedBean-and-ejb.war in deployment directory. To trigger deployment create a file called jsf-managedBean-and-ejb.war.dodeploy
22:55:07,902 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS015888: Creating http management service using socket-binding (management-http)
22:55:07,950 INFO [org.xnio] (MSC service thread 1-2) XNIO version 3.3.0.Final
22:55:07,982 INFO [org.xnio.nio] (MSC service thread 1-2) XNIO NIO Implementation Version 3.3.0.Final
22:55:08,089 INFO [org.wildfly.extension.io] (ServerService Thread Pool -- 31) WFLYIO001: Worker 'default' has auto-configured to 4 core threads with 32 task threads based on your 2 available processors
22:55:08,095 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 32) JBAS010280: Activating Infinispan subsystem.
22:55:08,180 INFO [org.jboss.remoting] (MSC service thread 1-2) JBoss Remoting version 4.0.6.Final
22:55:08,199 INFO [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 27) JBAS010403: Deploying JDBC-compliant driver class org.h2.Driver (version 1.3)
22:55:08,216 INFO [org.jboss.as.jsf] (ServerService Thread Pool -- 38) JBAS012615: Activated the following JSF Implementations: [main]
22:55:08,232 INFO [org.jboss.as.naming] (ServerService Thread Pool -- 40) JBAS011800: Activating Naming Subsystem
22:55:08,238 INFO [org.jboss.as.connector.logging] (MSC service thread 1-3) JBAS010408: Starting JCA Subsystem (IronJacamar 1.1.9.Final)
22:55:08,265 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 27) JBAS014613: Operation ("add") failed - address: ([
("subsystem" => "datasources"),
("jdbc-driver" => "mysql")
]) - failure description: "JBAS010441: Failed to load module for driver [com.mysql]"
22:55:08,261 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-1) JBAS010417: Started Driver service with driver-name = h2
22:55:08,388 INFO [org.jboss.as.security] (ServerService Thread Pool -- 45) JBAS013171: Activating Security Subsystem
22:55:08,415 WARN [org.jboss.as.txn] (ServerService Thread Pool -- 46) JBAS010153: Node identifier property is set to the default value. Please make sure it is unique.
22:55:08,425 INFO [org.jboss.as.naming] (MSC service thread 1-4) JBAS011802: Starting Naming Service
22:55:08,428 INFO [org.jboss.as.security] (MSC service thread 1-3) JBAS013170: Current PicketBox version=4.0.21.Final
22:55:08,431 INFO [org.jboss.as.mail.extension] (MSC service thread 1-4) JBAS015400: Bound mail session [java:jboss/mail/Default]
22:55:08,460 INFO [org.wildfly.extension.undertow] (ServerService Thread Pool -- 47) JBAS017502: Undertow 1.1.0.Final starting
22:55:08,464 INFO [org.jboss.as.webservices] (ServerService Thread Pool -- 48) JBAS015537: Activating WebServices Extension
22:55:08,472 INFO [org.wildfly.extension.undertow] (MSC service thread 1-1) JBAS017502: Undertow 1.1.0.Final starting
22:55:08,689 INFO [org.wildfly.extension.undertow] (ServerService Thread Pool -- 47) JBAS017527: Creating file handler for path /home/pioflor/Pobrane/wildfly-8.2.0.Final/welcome-content
22:55:09,087 INFO [org.wildfly.extension.undertow] (MSC service thread 1-3) JBAS017525: Started server default-server.
22:55:09,157 INFO [org.wildfly.extension.undertow] (MSC service thread 1-2) JBAS017531: Host default-host starting
22:55:09,346 INFO [org.wildfly.extension.undertow] (MSC service thread 1-1) JBAS017519: Undertow HTTP listener default listening on /127.0.0.1:8080
22:55:09,691 INFO [org.jboss.as.server.deployment.scanner] (MSC service thread 1-3) JBAS015012: Started FileSystemDeploymentService for directory /home/pioflor/Pobrane/wildfly-8.2.0.Final/standalone/deployments
22:55:09,745 INFO [org.jboss.as.server.deployment] (MSC service thread 1-3) JBAS015876: Starting deployment of "jsf-managedBean-and-ejb.war" (runtime-name: "jsf-managedBean-and-ejb.war")
22:55:10,006 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-4) JBAS010400: Bound data source [java:jboss/datasources/ExampleDS]
22:55:10,552 INFO [org.jboss.ws.common.management] (MSC service thread 1-2) JBWS022052: Starting JBoss Web Services - Stack CXF Server 4.3.2.Final
22:55:10,900 INFO [org.jboss.as.jpa] (MSC service thread 1-1) JBAS011401: Read persistence.xml for jsf-managedBean-and-ejb
22:55:11,076 INFO [org.jboss.as.jpa] (ServerService Thread Pool -- 50) JBAS011409: Starting Persistence Unit (phase 1 of 2) Service 'jsf-managedBean-and-ejb.war#jsf-managedBean-and-ejb'
22:55:11,090 INFO [org.hibernate.jpa.internal.util.LogHelper] (ServerService Thread Pool -- 50) HHH000204: Processing PersistenceUnitInfo [
name: jsf-managedBean-and-ejb
...]
22:55:11,208 INFO [org.hibernate.Version] (ServerService Thread Pool -- 50) HHH000412: Hibernate Core {4.3.7.Final}
22:55:11,215 INFO [org.hibernate.cfg.Environment] (ServerService Thread Pool -- 50) HHH000206: hibernate.properties not found
22:55:11,217 INFO [org.hibernate.cfg.Environment] (ServerService Thread Pool -- 50) HHH000021: Bytecode provider name : javassist
22:55:11,590 INFO [org.jboss.weld.deployer] (MSC service thread 1-1) JBAS016002: Processing weld deployment jsf-managedBean-and-ejb.war
22:55:11,689 INFO [org.hibernate.validator.internal.util.Version] (MSC service thread 1-1) HV000001: Hibernate Validator 5.1.3.Final
22:55:11,805 INFO [org.jboss.as.ejb3.deployment.processors.EjbJndiBindingsDeploymentUnitProcessor] (MSC service thread 1-1) JNDI bindings for session bean named CalculatorImpl in deployment unit deployment "jsf-managedBean-and-ejb.war" are as follows:
java:global/jsf-managedBean-and-ejb/CalculatorImpl!org.superbiz.jsf.Calculator
java:app/jsf-managedBean-and-ejb/CalculatorImpl!org.superbiz.jsf.Calculator
java:module/CalculatorImpl!org.superbiz.jsf.Calculator
java:jboss/exported/jsf-managedBean-and-ejb/CalculatorImpl!org.superbiz.jsf.Calculator
java:global/jsf-managedBean-and-ejb/CalculatorImpl
java:app/jsf-managedBean-and-ejb/CalculatorImpl
java:module/CalculatorImpl
22:55:12,436 INFO [org.jboss.weld.deployer] (MSC service thread 1-3) JBAS016005: Starting Services for CDI deployment: jsf-managedBean-and-ejb.war
22:55:12,492 INFO [org.jboss.weld.Version] (MSC service thread 1-3) WELD-000900: 2.2.6 (Final)
22:55:12,567 INFO [org.jboss.weld.deployer] (MSC service thread 1-4) JBAS016008: Starting weld service for deployment jsf-managedBean-and-ejb.war
22:55:12,837 INFO [org.jboss.as.jpa] (ServerService Thread Pool -- 50) JBAS011409: Starting Persistence Unit (phase 2 of 2) Service 'jsf-managedBean-and-ejb.war#jsf-managedBean-and-ejb'
22:55:12,970 INFO [org.hibernate.annotations.common.Version] (ServerService Thread Pool -- 50) HCANN000001: Hibernate Commons Annotations {4.0.4.Final}
22:55:13,669 INFO [org.hibernate.dialect.Dialect] (ServerService Thread Pool -- 50) HHH000400: Using dialect: org.hibernate.dialect.H2Dialect
22:55:13,702 WARN [org.hibernate.dialect.H2Dialect] (ServerService Thread Pool -- 50) HHH000431: Unable to determine H2 database version, certain features may not work
22:55:13,771 INFO [org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory] (ServerService Thread Pool -- 50) HHH000397: Using ASTQueryTranslatorFactory
22:55:16,489 INFO [javax.enterprise.resource.webcontainer.jsf.config] (MSC service thread 1-2) Initializing Mojarra 2.2.8-jbossorg-1 20140822-1131 for context '/jsf-managedBean-and-ejb'
22:55:18,191 INFO [org.wildfly.extension.undertow] (MSC service thread 1-2) JBAS017534: Registered web context: /jsf-managedBean-and-ejb
22:55:18,204 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) JBAS014613: Operation ("add") failed - address: ([
("subsystem" => "datasources"),
("data-source" => "newdatabase")
]) - failure description: {"JBAS014771: Services with missing/unavailable dependencies" => [
"jboss.driver-demander.java:/newdatabase is missing [jboss.jdbc-driver.mysql]",
"jboss.data-source.java:/newdatabase is missing [jboss.jdbc-driver.mysql]"
]}
22:55:18,210 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) JBAS014613: Operation ("add") failed - address: ([
("subsystem" => "datasources"),
("data-source" => "newdatabase")
]) - failure description: {
"JBAS014771: Services with missing/unavailable dependencies" => [
"jboss.driver-demander.java:/newdatabase is missing [jboss.jdbc-driver.mysql]",
"jboss.data-source.java:/newdatabase is missing [jboss.jdbc-driver.mysql]"
],
"JBAS014879: One or more services were unable to start due to one or more indirect dependencies not being available." => {
"Services that were unable to start:" => [
"jboss.data-source.reference-factory.newdatabase",
"jboss.naming.context.java.newdatabase"
],
"Services that may be the cause:" => ["jboss.jdbc-driver.mysql"]
}
}
22:55:18,323 INFO [org.jboss.as.server] (ServerService Thread Pool -- 28) JBAS018559: Deployed "jsf-managedBean-and-ejb.war" (runtime-name : "jsf-managedBean-and-ejb.war")
22:55:18,326 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.driver-demander.java:/newdatabase, service jboss.data-source.java:/newdatabase]
22:55:18,424 INFO [org.jboss.as] (Controller Boot Thread) JBAS015961: Http management interface listening on http://127.0.0.1:9990/management
22:55:18,425 INFO [org.jboss.as] (Controller Boot Thread) JBAS015951: Admin console listening on http://127.0.0.1:9990
22:55:18,425 ERROR [org.jboss.as] (Controller Boot Thread) JBAS015875: WildFly 8.2.0.Final "Tweek" started (with errors) in 13728ms - Started 739 of 796 services (4 services failed or missing dependencies, 92 services are lazy, passive or on-demand)