Falha ao subir aplicação no wildfly[RESOLVIDO]

Valli · Julho 9, 2017, 3:13pm

Oi pessoal.

Sempre que tento subir a aplicação o console do eclipse retorna que existe dependencias pendentes, porém mesmo que eu utilize o recurso do maven para atualizar o mesmo problema ocorre.
Além disso, notei que existe logs mencionando sobre a minha base de dados ser desconhecida. Como estou usando JPA com hibernate para criá-la não vejo o motivo disso ocorrer.

Abaixo estou apresentando minha configuração no standalone-full.xml do wildfly:

                <datasource jndi-name="java:jboss/datasources/tasklistDS" pool-name="tasklistDS" enabled="true" use-java-context="true">
                    <connection-url>jdbc:mysql://localhost:3306/tasklist</connection-url>
                    <driver>mysql</driver>
                    <security>
                        <user-name>root</user-name>
                        <password>u98h7w</password>
                    </security>
                </datasource>
                <drivers>
                    <driver name="mysql" module="com.mysql">
                        <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
                    </driver>
                </drivers>

E por fim minha configuração do module.xml que faz a referencia do jar do mysql:

<?xml version="1.0" encoding="UTF-8"?>
<module xmlns="urn:jboss:module:1.3" name="com.mysql">

    <resources>
        <resource-root path="mysql-connector-java-5.1.42-bin.jar"/>
    </resources>
    <dependencies>
        <module name="javax.api"/>
        <module name="javax.transaction.api"/>
        <module name="javax.servlet.api" optional="true"/>
    </dependencies>
</module>

Não sei se isso também é importante, mas estou com uma leve impressão que seja nesse arquivo persistence.xml

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<persistence xmlns="http://xmlns.jcp.org/xml/ns/persistence"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="2.1"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd">

	<persistence-unit name="tasklist-dev" transaction-type="JTA">
		<description>Dev Persistence unit</description>
		<provider>org.hibernate.ejb.HibernatePersistence</provider>
		<jta-data-source>java:jboss/datasources/tasklistDS</jta-data-source>
		<properties>
			<property name="hibernate.hbm2ddl.auto" value="update"/>
			<property name="hibernate.show_sql" value="true"/>
			<property name="hibernate.format_sql" value="true"/>
			<property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5InnoDBDialect"/>
		</properties>
	</persistence-unit>
</persistence>

Agradeço quem puder ajudar com meu problema.

Valli · Julho 9, 2017, 3:15pm

Galera, para mais detalhes, estou encaminhando o meu log:

11:56:05,505 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("deploy") failed - address: ([("deployment" => "tasklist.war")]) - failure description: {
    "WFLYCTL0080: Failed services" => {"jboss.persistenceunit.\"tasklist.war#tasklist-dev\"" => "org.jboss.msc.service.StartException in service jboss.persistenceunit.\"tasklist.war#tasklist-dev\": javax.persistence.PersistenceException: [PersistenceUnit: tasklist-dev] Unable to build Hibernate SessionFactory
    Caused by: javax.persistence.PersistenceException: [PersistenceUnit: tasklist-dev] Unable to build Hibernate SessionFactory
    Caused by: org.hibernate.tool.schema.spi.SchemaManagementException: Unable to open JDBC connection for schema management target
    Caused by: java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/tasklistDS
    Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/tasklistDS
    Caused by: javax.resource.ResourceException: IJ031084: Unable to create connection
    Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'tasklist'"},
    "WFLYCTL0412: Required services that are not installed:" => ["jboss.persistenceunit.\"tasklist.war#tasklist-dev\""],
    "WFLYCTL0180: Services with missing/unavailable dependencies" => undefined
}
11:56:05,557 INFO  [org.jboss.as.server] (ServerService Thread Pool -- 37) WFLYSRV0010: Deployed "tasklist.war" (runtime-name : "tasklist.war")
11:56:05,563 INFO  [org.jboss.as.controller] (Controller Boot Thread) WFLYCTL0183: Service status report
WFLYCTL0186:   Services which failed to start:      service jboss.persistenceunit."tasklist.war#tasklist-dev": org.jboss.msc.service.StartException in service jboss.persistenceunit."tasklist.war#tasklist-dev": javax.persistence.PersistenceException: [PersistenceUnit: tasklist-dev] Unable to build Hibernate SessionFactory

11:56:05,768 INFO  [org.jboss.as] (Controller Boot Thread) WFLYSRV0060: Http management interface listening on http://127.0.0.1:9990/management
11:56:05,769 INFO  [org.jboss.as] (Controller Boot Thread) WFLYSRV0051: Admin console listening on http://127.0.0.1:9990
11:56:05,770 ERROR [org.jboss.as] (Controller Boot Thread) WFLYSRV0026: WildFly Full 10.1.0.Final (WildFly Core 2.2.0.Final) started (with errors) in 13520ms - Started 457 of 723 services (18 services failed or missing dependencies, 420 services are lazy, passive or on-demand)
11:56:05,839 INFO  [org.jboss.as.jpa] (ServerService Thread Pool -- 65) WFLYJPA0011: Stopping Persistence Unit (phase 1 of 2) Service 'tasklist.war#tasklist-dev'
11:56:05,908 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-5) WFLYSRV0028: Stopped deployment tasklist.war (runtime-name: tasklist.war) in 85ms
11:56:05,992 WARN  [org.jboss.as.controller] (DeploymentScanner-threads - 2) WFLYCTL0357: Notification of type deployment-undeployed is not described for the resource at the address []
11:56:05,996 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2) WFLYSRV0009: Undeployed "tasklist.war" (runtime-name: "tasklist.war")
11:56:06,000 INFO  [org.jboss.as.controller] (DeploymentScanner-threads - 2) WFLYCTL0183: Service status report
WFLYCTL0184:    New missing/unsatisfied dependencies:
      service jboss.deployment.unit."tasklist.war".WeldBootstrapService (missing) dependents: [service jboss.deployment.unit."tasklist.war".component."org.jboss.weld.servlet.WeldInitialListener".WeldInstantiator, service jboss.deployment.unit."tasklist.war".CdiValidatorFactoryService, service jboss.deployment.unit."tasklist.war".component."javax.faces.webapp.FacetTag".WeldInstantiator, service jboss.deployment.unit."tasklist.war".WeldStartService, WFLYCTL0208: ... and 5 more ] 
      service jboss.deployment.unit."tasklist.war".WeldStartService (missing) dependents: [service jboss.deployment.unit."tasklist.war".CdiValidatorFactoryService, service jboss.deployment.unit."tasklist.war".component."javax.faces.webapp.FacetTag".WeldInstantiator, service jboss.undertow.deployment.default-server.default-host./tasklist, service jboss.deployment.unit."tasklist.war".component."org.jboss.weld.servlet.WeldTerminalListener".WeldInstantiator, WFLYCTL0208: ... and 4 more ] 
      service jboss.deployment.unit."tasklist.war".component."com.sun.faces.config.ConfigureListener".CREATE (missing) dependents: [service jboss.deployment.unit."tasklist.war".component."com.sun.faces.config.ConfigureListener".START] 
      service jboss.deployment.unit."tasklist.war".component."com.sun.faces.config.ConfigureListener".START (missing) dependents: [service jboss.undertow.deployment.default-server.default-host./tasklist.UndertowDeploymentInfoService, service jboss.deployment.unit."tasklist.war".deploymentCompleteService, service jboss.undertow.deployment.default-server.default-host./tasklist] 
      service jboss.deployment.unit."tasklist.war".component."com.sun.faces.config.ConfigureListener".WeldInstantiator (missing) dependents: [service jboss.deployment.unit."tasklist.war".component."com.sun.faces.config.ConfigureListener".START] 
      service jboss.deployment.unit."tasklist.war".component."javax.faces.webapp.FacetTag".CREATE (missing) dependents: [service jboss.deployment.unit."tasklist.war".component."javax.faces.webapp.FacetTag".START] 
      service jboss.deployment.unit."tasklist.war".component."javax.faces.webapp.FacetTag".START (missing) dependents: [service jboss.undertow.deployment.default-server.default-host./tasklist.UndertowDeploymentInfoService, service jboss.deployment.unit."tasklist.war".deploymentCompleteService, service jboss.undertow.deployment.default-server.default-host./tasklist] 
      service jboss.deployment.unit."tasklist.war".component."javax.faces.webapp.FacetTag".WeldInstantiator (missing) dependents: [service jboss.deployment.unit."tasklist.war".component."javax.faces.webapp.FacetTag".START] 
      service jboss.deployment.unit."tasklist.war".component."javax.servlet.jsp.jstl.tlv.PermittedTaglibsTLV".CREATE (missing) dependents: [service jboss.deployment.unit."tasklist.war".component."javax.servlet.jsp.jstl.tlv.PermittedTaglibsTLV".START] 
      service jboss.deployment.unit."tasklist.war".component."javax.servlet.jsp.jstl.tlv.PermittedTaglibsTLV".START (missing) dependents: [service jboss.undertow.deployment.default-server.default-host./tasklist.UndertowDeploymentInfoService, service jboss.deployment.unit."tasklist.war".deploymentCompleteService, service jboss.undertow.deployment.default-server.default-host./tasklist] 
      service jboss.deployment.unit."tasklist.war".component."javax.servlet.jsp.jstl.tlv.PermittedTaglibsTLV".WeldInstantiator (missing) dependents: [service jboss.deployment.unit."tasklist.war".component."javax.servlet.jsp.jstl.tlv.PermittedTaglibsTLV".START] 
      service jboss.deployment.unit."tasklist.war".component."javax.servlet.jsp.jstl.tlv.ScriptFreeTLV".CREATE (missing) dependents: [service jboss.deployment.unit."tasklist.war".component."javax.servlet.jsp.jstl.tlv.ScriptFreeTLV".START] 
      service jboss.deployment.unit."tasklist.war".component."javax.servlet.jsp.jstl.tlv.ScriptFreeTLV".START (missing) dependents: [service jboss.undertow.deployment.default-server.default-host./tasklist.UndertowDeploymentInfoService, service jboss.deployment.unit."tasklist.war".deploymentCompleteService, service jboss.undertow.deployment.default-server.default-host./tasklist] 
      service jboss.deployment.unit."tasklist.war".component."javax.servlet.jsp.jstl.tlv.ScriptFreeTLV".WeldInstantiator (missing) dependents: [service jboss.deployment.unit."tasklist.war".component."javax.servlet.jsp.jstl.tlv.ScriptFreeTLV".START] 
      service jboss.deployment.unit."tasklist.war".component."org.jboss.weld.servlet.WeldInitialListener".CREATE (missing) dependents: [service jboss.deployment.unit."tasklist.war".component."org.jboss.weld.servlet.WeldInitialListener".START] 
      service jboss.deployment.unit."tasklist.war".component."org.jboss.weld.servlet.WeldInitialListener".START (missing) dependents: [service jboss.undertow.deployment.default-server.default-host./tasklist.UndertowDeploymentInfoService, service jboss.deployment.unit."tasklist.war".deploymentCompleteService, service jboss.undertow.deployment.default-server.default-host./tasklist] 
      service jboss.deployment.unit."tasklist.war".component."org.jboss.weld.servlet.WeldInitialListener".WeldInstantiator (missing) dependents: [service jboss.deployment.unit."tasklist.war".component."org.jboss.weld.servlet.WeldInitialListener".START] 
      service jboss.deployment.unit."tasklist.war".component."org.jboss.weld.servlet.WeldTerminalListener".CREATE (missing) dependents: [service jboss.deployment.unit."tasklist.war".component."org.jboss.weld.servlet.WeldTerminalListener".START] 
      service jboss.deployment.unit."tasklist.war".component."org.jboss.weld.servlet.WeldTerminalListener".START (missing) dependents: [service jboss.undertow.deployment.default-server.default-host./tasklist.UndertowDeploymentInfoService, service jboss.deployment.unit."tasklist.war".deploymentCompleteService, service jboss.undertow.deployment.default-server.default-host./tasklist] 
      service jboss.deployment.unit."tasklist.war".component."org.jboss.weld.servlet.WeldTerminalListener".WeldInstantiator (missing) dependents: [service jboss.deployment.unit."tasklist.war".component."org.jboss.weld.servlet.WeldTerminalListener".START] 
      service jboss.deployment.unit."tasklist.war".ee.ComponentRegistry (missing) dependents: [service jboss.undertow.deployment.default-server.default-host./tasklist.UndertowDeploymentInfoService] 
      service jboss.deployment.unit."tasklist.war".jndiDependencyService (missing) dependents: [service jboss.deployment.unit."tasklist.war".component."javax.faces.webapp.FacetTag".START, service jboss.deployment.unit."tasklist.war".component."org.jboss.weld.servlet.WeldInitialListener".START, service jboss.deployment.unit."tasklist.war".component."com.sun.faces.config.ConfigureListener".START, service jboss.deployment.unit."tasklist.war".WeldStartService, WFLYCTL0208: ... and 4 more ] 
      service jboss.persistenceunit."tasklist.war#tasklist-dev" (missing) dependents: [service jboss.deployment.unit."tasklist.war".component."javax.faces.webapp.FacetTag".START, service jboss.undertow.deployment.default-server.default-host./tasklist.UndertowDeploymentInfoService, service jboss.deployment.unit."tasklist.war".deploymentCompleteService, service jboss.undertow.deployment.default-server.default-host./tasklist, WFLYCTL0208: ... and 5 more ] 
      service jboss.undertow.deployment.default-server.default-host./tasklist (missing) dependents: [service jboss.deployment.unit."tasklist.war".deploymentCompleteService] 
      service jboss.undertow.deployment.default-server.default-host./tasklist.UndertowDeploymentInfoService (missing) dependents: [service jboss.undertow.deployment.default-server.default-host./tasklist] 
      service jboss.undertow.deployment.default-server.default-host./tasklist.codec (missing) dependents: [service jboss.undertow.deployment.default-server.default-host./tasklist.UndertowDeploymentInfoService] 
      service jboss.undertow.deployment.default-server.default-host./tasklist.session (missing) dependents: [service jboss.undertow.deployment.default-server.default-host./tasklist.UndertowDeploymentInfoService] 
      service org.wildfly.request-controller.control-point."tasklist.war".undertow (missing) dependents: [service jboss.undertow.deployment.default-server.default-host./tasklist.UndertowDeploymentInfoService] 
WFLYCTL0186:   Services which failed to start:      service jboss.persistenceunit."tasklist.war#tasklist-dev"

11:56:10,622 INFO  [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 1) WFLYDS0004: Found tasklist.war in deployment directory. To trigger deployment create a file called tasklist.war.dodeploy

Valli · Julho 9, 2017, 4:43pm

Pessoal.

Eu resolvi o problema criando a tabela previamente no banco de dados… Contudo, a referencia(https://www.casadocodigo.com.br/products/livro-javaee) que estou usando não realiza essa etapa de criar o banco. Já que isso foi definido na própria configuração do wildfly pelo arquivo standalone-full.xml.

Alguém saberia me dizer o que ocorreu de “errado”? O motivo pelo qual a aplicação não criou de maneira automática o banco no mysql?

Falha ao subir aplicação no wildfly[RESOLVIDO]

Cursos de Mobile

Cursos de Programação

Cursos de Front-end

Cursos de DevOps

Cursos de Design & UX

Cursos de Business

Cursos de Data & BI