Estou com este problema

2 respostas
mysql
W
[org.hibernate.jpa.internal.util.LogHelper] (ServerService Thread Pool  61) HHH000204: Processing PersistenceUnitInfo [

name: mercado-bd

]

10:27:24,493 INFO  [org.hibernate.Version] (ServerService Thread Pool  61) HHH000412: Hibernate Core {5.0.10.Final}

10:27:24,500 INFO  [org.hibernate.cfg.Environment] (ServerService Thread Pool  61) HHH000206: hibernate.properties not found

10:27:24,502 INFO  [org.hibernate.cfg.Environment] (ServerService Thread Pool  61) HHH000021: Bytecode provider name : javassist

10:27:24,572 INFO  [org.hibernate.annotations.common.Version] (ServerService Thread Pool  61) HCANN000001: Hibernate Commons Annotations {5.0.1.Final}

10:27:24,664 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-3) WFLYJCA0004: Deploying JDBC-compliant driver class com.microsoft.sqlserver.jdbc.SQLServerDriver (version 6.2)

10:27:24,671 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-3) WFLYJCA0005: Deploying non-JDBC-compliant driver class com.mysql.cj.jdbc.Driver (version 6.0)

10:27:24,672 WARN  [org.jboss.weld.deployer] (MSC service thread 1-3) WFLYWELD0013: Deployment deployment processo-seletivo-master.war contains CDI annotations but no bean archive was not found. (No beans.xml nor class with bean defining annotations)

10:27:24,705 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-4) WFLYJCA0018: Started Driver service with driver-name = processo-seletivo-master.war_com.mysql.cj.jdbc.Driver_6_0

10:27:24,710 INFO  [org.jboss.as.jpa] (ServerService Thread Pool  61) WFLYJPA0010: Starting Persistence Unit (phase 2 of 2) Service processo-seletivo-master.war#mercado-bd

10:27:24,717 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-3) WFLYJCA0018: Started Driver service with driver-name = processo-seletivo-master.war_com.microsoft.sqlserver.jdbc.SQLServerDriver_6_2

10:27:24,970 INFO  [org.hibernate.dialect.Dialect] (ServerService Thread Pool  61) HHH000400: Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect

10:27:25,022 INFO  [org.hibernate.envers.boot.internal.EnversServiceImpl] (ServerService Thread Pool  61) Envers integration enabled? : true

10:27:25,418 INFO  [org.hibernate.validator.internal.util.Version] (ServerService Thread Pool  61) HV000001: Hibernate Validator 5.2.4.Final

10:27:25,689 INFO  [org.hibernate.tool.hbm2ddl.SchemaUpdate] (ServerService Thread Pool  61) HHH000228: Running hbm2ddl schema update

10:27:25,705 INFO  [org.hibernate.tool.schema.extract.internal.InformationExtractorJdbcDatabaseMetaDataImpl] (ServerService Thread Pool  61) HHH000262: Table not found: FABRICANTE

10:27:25,706 INFO  [org.hibernate.tool.schema.extract.internal.InformationExtractorJdbcDatabaseMetaDataImpl] (ServerService Thread Pool  61) HHH000262: Table not found: FABRICANTE

10:27:25,712 INFO  [org.hibernate.tool.schema.extract.internal.InformationExtractorJdbcDatabaseMetaDataImpl] (ServerService Thread Pool  61) HHH000262: Table not found: PRODUTO

10:27:25,712 INFO  [org.hibernate.tool.schema.extract.internal.InformationExtractorJdbcDatabaseMetaDataImpl] (ServerService Thread Pool  61) HHH000262: Table not found: PRODUTO

10:27:25,731 INFO  [org.hibernate.dialect.Dialect] (ServerService Thread Pool  61) HHH000400: Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect

10:27:25,734 WARN  [org.hibernate.jpa.internal.schemagen.JpaSchemaGenerator] (ServerService Thread Pool  61) Hibernate hbm2ddl-auto setting was specified [update] in combination with JPA schema-generation; combination will likely cause trouble

10:27:25,737 INFO  [stdout] (ServerService Thread Pool  61) Hibernate:

10:27:25,737 INFO  [stdout] (ServerService Thread Pool  61)     create table FABRICANTE (

10:27:25,737 INFO  [stdout] (ServerService Thread Pool  61)         ID_FABRICANTE integer not null auto_increment,

10:27:25,737 INFO  [stdout] (ServerService Thread Pool  61)         NOME varchar(255),

10:27:25,737 INFO  [stdout] (ServerService Thread Pool  61)         primary key (ID_FABRICANTE)

10:27:25,737 INFO  [stdout] (ServerService Thread Pool  61)     ) ENGINE=InnoDB
10:27:25,738 ERROR [org.jboss.msc.service.fail] (ServerService Thread Pool  61) MSC000001: Failed to start service jboss.persistenceunit.processo-seletivo-master.war#mercado-bd: org.jboss.msc.service.StartException in service jboss.persistenceunit.processo-seletivo-master.war#mercado-bd: javax.persistence.PersistenceException: Unable to execute JPA schema generation create command [create table FABRICANTE (ID_FABRICANTE integer not null auto_increment, NOME varchar(255), primary key (ID_FABRICANTE)) ENGINE=InnoDB]

at org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1$1.run(PersistenceUnitServiceImpl.java:179)

at org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1$1.run(PersistenceUnitServiceImpl.java:121)

at org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:667)

at org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1.run(PersistenceUnitServiceImpl.java:193)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

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

at java.lang.Thread.run(Unknown Source)

at org.jboss.threads.JBossThread.run(JBossThread.java:320)

Caused by: javax.persistence.PersistenceException: Unable to execute JPA schema generation create command [create table FABRICANTE (ID_FABRICANTE integer not null auto_increment, NOME varchar(255), primary key (ID_FABRICANTE)) ENGINE=InnoDB]

at org.hibernate.jpa.internal.schemagen.GenerationTargetToDatabase.acceptCreateCommands(GenerationTargetToDatabase.java:47)

at org.hibernate.jpa.internal.schemagen.JpaSchemaGenerator.doGeneration(JpaSchemaGenerator.java:496)

at org.hibernate.jpa.internal.schemagen.JpaSchemaGenerator.access$300(JpaSchemaGenerator.java:55)

at org.hibernate.jpa.internal.schemagen.JpaSchemaGenerator$GenerationProcess.execute(JpaSchemaGenerator.java:171)

at org.hibernate.jpa.internal.schemagen.JpaSchemaGenerator.performGeneration(JpaSchemaGenerator.java:65)

at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:885)

at org.jboss.as.jpa.hibernate5.TwoPhaseBootstrapImpl.build(TwoPhaseBootstrapImpl.java:44)

at org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1$1.run(PersistenceUnitServiceImpl.java:161)

 7 more

Caused by: org.h2.jdbc.JdbcSQLException: Table FABRICANTE already exists; SQL statement:

create table FABRICANTE (ID_FABRICANTE integer not null auto_increment, NOME varchar(255), primary key (ID_FABRICANTE)) ENGINE=InnoDB [42101-173]

at org.h2.message.DbException.getJdbcSQLException(DbException.java:331)

at org.h2.message.DbException.get(DbException.java:171)

at org.h2.message.DbException.get(DbException.java:148)

at org.h2.command.ddl.CreateTable.update(CreateTable.java:109)

at org.h2.command.CommandContainer.update(CommandContainer.java:79)

at org.h2.command.Command.executeUpdate(Command.java:235)

at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:181)

at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:156)

at org.jboss.jca.adapters.jdbc.WrappedStatement.execute(WrappedStatement.java:198)

at org.hibernate.jpa.internal.schemagen.GenerationTargetToDatabase.acceptCreateCommands(GenerationTargetToDatabase.java:44)

 14 more
10:27:25,742 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation (deploy) failed - address: ([(deployment => processo-seletivo-master.war)]) - failure description: {

WFLYCTL0080: Failed services => {jboss.persistenceunit.processo-seletivo-master.war#mercado-bd”” => org.jboss.msc.service.StartException in service jboss.persistenceunit.processo-seletivo-master.war#mercado-bd: javax.persistence.PersistenceException: Unable to execute JPA schema generation create command [create table FABRICANTE (ID_FABRICANTE integer not null auto_increment, NOME varchar(255), primary key (ID_FABRICANTE)) ENGINE=InnoDB]

Caused by: javax.persistence.PersistenceException: Unable to execute JPA schema generation create command [create table FABRICANTE (ID_FABRICANTE integer not null auto_increment, NOME varchar(255), primary key (ID_FABRICANTE)) ENGINE=InnoDB]

Caused by: org.h2.jdbc.JdbcSQLException: Table FABRICANTE already exists; SQL statement:

create table FABRICANTE (ID_FABRICANTE integer not null auto_increment, NOME varchar(255), primary key (ID_FABRICANTE)) ENGINE=InnoDB [42101-173]},

WFLYCTL0412: Required services that are not installed: => [jboss.persistenceunit.processo-seletivo-master.war#mercado-bd””],

WFLYCTL0180: Services with missing/unavailable dependencies => undefined

}

10:27:25,765 INFO  [org.jboss.as.server] (ServerService Thread Pool  34) WFLYSRV0010: Deployed processo-seletivo-master.war (runtime-name : processo-seletivo-master.war)

10:27:25,769 INFO  [org.jboss.as.controller] (Controller Boot Thread) WFLYCTL0183: Service status report

WFLYCTL0186:   Services which failed to start:      service jboss.persistenceunit.processo-seletivo-master.war#mercado-bd: org.jboss.msc.service.StartException in service jboss.persistenceunit.processo-seletivo-master.war#mercado-bd: javax.persistence.PersistenceException: Unable to execute JPA schema generation create command [create table FABRICANTE (ID_FABRICANTE integer not null auto_increment, NOME varchar(255), primary key (ID_FABRICANTE)) ENGINE=InnoDB]
10:27:25,935 INFO  [org.jboss.as] (Controller Boot Thread) WFLYSRV0060: Http management interface listening on <a href="http://127.0.0.1:9990/management">http://127.0.0.1:9990/management</a>

10:27:25,935 INFO  [org.jboss.as] (Controller Boot Thread) WFLYSRV0051: Admin console listening on <a href="http://127.0.0.1:9990">http://127.0.0.1:9990</a>

10:27:25,936 ERROR [org.jboss.as] (Controller Boot Thread) WFLYSRV0026: WildFly Full 10.1.0.Final (WildFly Core 2.2.0.Final) started (with errors) in 16223ms - Started 406 of 666 services (9 services failed or missing dependencies, 405 services are lazy, passive or on-demand)

10:27:25,972 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-2) WFLYJCA0019: Stopped Driver service with driver-name = processo-seletivo-master.war_com.microsoft.sqlserver.jdbc.SQLServerDriver_6_2

10:27:25,973 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-1) WFLYJCA0019: Stopped Driver service with driver-name = processo-seletivo-master.war_com.mysql.cj.jdbc.Driver_6_0

10:27:25,975 INFO  [org.jboss.as.jpa] (ServerService Thread Pool  61) WFLYJPA0011: Stopping Persistence Unit (phase 1 of 2) Service ‘processo-seletivo-master.war#mercado-bd’

10:27:26,086 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-1) WFLYSRV0028: Stopped deployment processo-seletivo-master.war (runtime-name: processo-seletivo-master.war) in 118ms

10:27:26,155 WARN  [org.jboss.as.controller] (DeploymentScanner-threads - 1) WFLYCTL0357: Notification of type deployment-undeployed is not described for the resource at the address []

10:27:26,156 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 1) WFLYSRV0009: Undeployed “processo-seletivo-master.war” (runtime-name: “processo-seletivo-master.war”)

10:27:26,157 INFO  [org.jboss.as.controller] (DeploymentScanner-threads - 1) WFLYCTL0183: Service status report

WFLYCTL0184:    New missing/unsatisfied dependencies:

service jboss.deployment.unit.“processo-seletivo-master.war”.component.“com.sun.faces.config.ConfigureListener”.CREATE (missing) dependents: [service jboss.deployment.unit.“processo-seletivo-master.war”.component.“com.sun.faces.config.ConfigureListener”.START]

service jboss.deployment.unit.“processo-seletivo-master.war”.component.“com.sun.faces.config.ConfigureListener”.START (missing) dependents: [service jboss.undertow.deployment.default-server.default-host./processo-seletivo-master.UndertowDeploymentInfoService, service jboss.undertow.deployment.default-server.default-host./processo-seletivo-master, service jboss.deployment.unit.“processo-seletivo-master.war”.deploymentCompleteService]

service jboss.deployment.unit.“processo-seletivo-master.war”.component.“javax.faces.webapp.FacetTag”.CREATE (missing) dependents: [service jboss.deployment.unit.“processo-seletivo-master.war”.component.“javax.faces.webapp.FacetTag”.START]

service jboss.deployment.unit.“processo-seletivo-master.war”.component.“javax.faces.webapp.FacetTag”.START (missing) dependents: [service jboss.undertow.deployment.default-server.default-host./processo-seletivo-master.UndertowDeploymentInfoService, service jboss.undertow.deployment.default-server.default-host./processo-seletivo-master, service jboss.deployment.unit.“processo-seletivo-master.war”.deploymentCompleteService]

service jboss.deployment.unit.“processo-seletivo-master.war”.component.“javax.servlet.jsp.jstl.tlv.PermittedTaglibsTLV”.CREATE (missing) dependents: [service jboss.deployment.unit.“processo-seletivo-master.war”.component.“javax.servlet.jsp.jstl.tlv.PermittedTaglibsTLV”.START]

service jboss.deployment.unit.“processo-seletivo-master.war”.component.“javax.servlet.jsp.jstl.tlv.PermittedTaglibsTLV”.START (missing) dependents: [service jboss.undertow.deployment.default-server.default-host./processo-seletivo-master.UndertowDeploymentInfoService, service jboss.undertow.deployment.default-server.default-host./processo-seletivo-master, service jboss.deployment.unit.“processo-seletivo-master.war”.deploymentCompleteService]

service jboss.deployment.unit.“processo-seletivo-master.war”.component.“javax.servlet.jsp.jstl.tlv.ScriptFreeTLV”.CREATE (missing) dependents: [service jboss.deployment.unit.“processo-seletivo-master.war”.component.“javax.servlet.jsp.jstl.tlv.ScriptFreeTLV”.START]

service jboss.deployment.unit.“processo-seletivo-master.war”.component.“javax.servlet.jsp.jstl.tlv.ScriptFreeTLV”.START (missing) dependents: [service jboss.undertow.deployment.default-server.default-host./processo-seletivo-master.UndertowDeploymentInfoService, service jboss.undertow.deployment.default-server.default-host./processo-seletivo-master, service jboss.deployment.unit.“processo-seletivo-master.war”.deploymentCompleteService]

service jboss.deployment.unit.“processo-seletivo-master.war”.component.“org.glassfish.jersey.servlet.ServletContainer”.CREATE (missing) dependents: [service jboss.deployment.unit.“processo-seletivo-master.war”.component.“org.glassfish.jersey.servlet.ServletContainer”.START]

service jboss.deployment.unit.“processo-seletivo-master.war”.component.“org.glassfish.jersey.servlet.ServletContainer”.START (missing) dependents: [service jboss.undertow.deployment.default-server.default-host./processo-seletivo-master.UndertowDeploymentInfoService, service jboss.undertow.deployment.default-server.default-host./processo-seletivo-master, service jboss.deployment.unit.“processo-seletivo-master.war”.deploymentCompleteService]

service jboss.deployment.unit.“processo-seletivo-master.war”.ee.ComponentRegistry (missing) dependents: [service jboss.undertow.deployment.default-server.default-host./processo-seletivo-master.UndertowDeploymentInfoService]

service jboss.deployment.unit.“processo-seletivo-master.war”.jndiDependencyService (missing) dependents: [service jboss.deployment.unit.“processo-seletivo-master.war”.component.“org.glassfish.jersey.servlet.ServletContainer”.START, service jboss.deployment.unit.“processo-seletivo-master.war”.component.“javax.faces.webapp.FacetTag”.START, service jboss.deployment.unit.“processo-seletivo-master.war”.component.“com.sun.faces.config.ConfigureListener”.START, service jboss.deployment.unit.“processo-seletivo-master.war”.component.“javax.servlet.jsp.jstl.tlv.ScriptFreeTLV”.START, WFLYCTL0208:  and 2 more ]

service jboss.persistenceunit.“processo-seletivo-master.war#mercado-bd” (missing) dependents: [service jboss.undertow.deployment.default-server.default-host./processo-seletivo-master.UndertowDeploymentInfoService, service jboss.deployment.unit.“processo-seletivo-master.war”.component.“org.glassfish.jersey.servlet.ServletContainer”.START, service jboss.deployment.unit.“processo-seletivo-master.war”.component.“javax.faces.webapp.FacetTag”.START, service jboss.undertow.deployment.default-server.default-host./processo-seletivo-master, WFLYCTL0208:  and 5 more ]

service jboss.undertow.deployment.default-server.default-host./processo-seletivo-master (missing) dependents: [service jboss.deployment.unit.“processo-seletivo-master.war”.deploymentCompleteService]

service jboss.undertow.deployment.default-server.default-host./processo-seletivo-master.UndertowDeploymentInfoService (missing) dependents: [service jboss.undertow.deployment.default-server.default-host./processo-seletivo-master]

service jboss.undertow.deployment.default-server.default-host./processo-seletivo-master.codec (missing) dependents: [service jboss.undertow.deployment.default-server.default-host./processo-seletivo-master.UndertowDeploymentInfoService]

service jboss.undertow.deployment.default-server.default-host./processo-seletivo-master.session (missing) dependents: [service jboss.undertow.deployment.default-server.default-host./processo-seletivo-master.UndertowDeploymentInfoService]

service org.wildfly.request-controller.control-point.“processo-seletivo-master.war”.undertow (missing) dependents: [service jboss.undertow.deployment.default-server.default-host./processo-seletivo-master.UndertowDeploymentInfoService]

WFLYCTL0186:   Services which failed to start:      service jboss.persistenceunit.“processo-seletivo-master.war#mercado-bd”

10:27:30,822 INFO [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 1) WFLYDS0004: Found processo-seletivo-master.war in deployment directory. To trigger deployment create a file called processo-seletivo-master.war.dodeploy
10:35:21,883 INFO [org.jboss.as.server] (management-handler-thread - 6) WFLYSRV0236: Suspending server with no timeout.
10:35:21,892 INFO [org.jboss.as.server] (Management Triggered Shutdown) WFLYSRV0241: Shutting down in response to management operation ‘shutdown’
10:35:21,899 INFO [org.wildfly.extension.undertow] (MSC service thread 1-4) WFLYUT0008: Undertow HTTPS listener https suspending
10:35:21,901 INFO [org.wildfly.extension.undertow] (MSC service thread 1-4) WFLYUT0007: Undertow HTTPS listener https stopped, was bound to 127.0.0.1:8443
10:35:21,903 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-2) WFLYJCA0010: Unbound data source [java:jboss/datasources/ExampleDS]
10:35:21,903 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-2) WFLYJCA0010: Unbound data source [java:jboss/datasources/mercadoDS]
10:35:21,971 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-1) WFLYJCA0019: Stopped Driver service with driver-name = mysql
10:35:21,971 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-4) WFLYJCA0019: Stopped Driver service with driver-name = h2
10:35:21,972 INFO [org.wildfly.extension.undertow] (MSC service thread 1-4) WFLYUT0019: Host default-host stopping
10:35:21,973 INFO [org.wildfly.extension.undertow] (MSC service thread 1-4) WFLYUT0008: Undertow HTTP listener default suspending
10:35:21,974 INFO [org.wildfly.extension.undertow] (MSC service thread 1-4) WFLYUT0007: Undertow HTTP listener default stopped, was bound to 127.0.0.1:8080
10:35:21,976 INFO [org.wildfly.extension.undertow] (MSC service thread 1-2) WFLYUT0004: Undertow 1.4.0.Final stopping
10:35:22,021 INFO [org.jboss.as] (MSC service thread 1-4) WFLYSRV0050: WildFly Full 10.1.0.Final (WildFly Core 2.2.0.Final) stopped in 94ms

2 Respostas

darlan_machado

Se a tabela já existe, não poderá ser criada novamente.

FearX

Como você pode esperar que isso seja entendivel?

Primeiro: aprenda a ler e a interpretar um stacktrace. É básico para qualquer pessoa que queira se chamar de desenvolvedor.

Segundo: traga informações RELEVANTES sobre o problema.

Terceiro: “Estou com este problema” é um péssimo título. Se você está postando aqui, tem 95% de chance de você estar com algum problema ou dúvida. O título é para você sumarizar sua dúvida, enquanto o corpo do texto é usado para relatar e dar detalhes.

Sugiro que leia esse post e adeque os futuros.

[]'s

Criado 24 de julho de 2019
Ultima resposta 24 de jul. de 2019
Respostas 2
Participantes 3