Hibernate shows ddl but does not create tables in the database

Asked

Viewed 152 times

0

When starting wildfly I expected the tables to be created in the database but in the console shows a log of create Tables but nothing happens in the database. Below I show it:

    14:15:00,462 INFO  [org.jboss.modules] (main) JBoss Modules version 1.5.1.Final
    14:15:00,880 INFO  [org.jboss.msc] (main) JBoss MSC version 1.2.6.Final
    14:15:00,999 INFO  [org.jboss.as] (MSC service thread 1-7) WFLYSRV0049: WildFly Full 10.0.0.Final (WildFly Core 2.0.10.Final) starting
    14:15:03,023 INFO  [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 1) WFLYDS0004: Found pokemax.war in deployment directory. To trigger deployment create a file called pokemax.war.dodeploy
    14:15:03,127 INFO  [org.jboss.as.server] (Controller Boot Thread) WFLYSRV0039: Creating http management service using socket-binding (management-http)
    14:15:03,171 INFO  [org.xnio] (MSC service thread 1-4) XNIO version 3.3.4.Final
    14:15:03,208 INFO  [org.xnio.nio] (MSC service thread 1-4) XNIO NIO Implementation Version 3.3.4.Final
    14:15:03,333 INFO  [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 33) WFLYJCA0004: Deploying JDBC-compliant driver class org.h2.Driver (version 1.3)
    14:15:03,333 INFO  [org.jboss.remoting] (MSC service thread 1-4) JBoss Remoting version 4.0.18.Final
    14:15:03,348 INFO  [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 38) WFLYCLINF0001: Activating Infinispan subsystem.
    14:15:03,387 INFO  [org.jboss.as.jsf] (ServerService Thread Pool -- 44) WFLYJSF0007: Activated the following JSF Implementations: [main]
    14:15:03,401 INFO  [org.wildfly.extension.io] (ServerService Thread Pool -- 37) WFLYIO001: Worker 'default' has auto-configured to 8 core threads with 64 task threads based on your 4 available processors
    14:15:03,425 INFO  [org.jboss.as.connector] (MSC service thread 1-8) WFLYJCA0009: Starting JCA Subsystem (WildFly/IronJacamar 1.3.2.Final)
    14:15:03,427 INFO  [org.jboss.as.naming] (ServerService Thread Pool -- 46) WFLYNAM0001: Activating Naming Subsystem
    14:15:03,460 WARN  [org.jboss.as.txn] (ServerService Thread Pool -- 54) WFLYTX0013: Node identifier property is set to the default value. Please make sure it is unique.
    14:15:03,487 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-4) WFLYJCA0018: Started Driver service with driver-name = h2
    14:15:03,721 INFO  [org.jboss.as.security] (ServerService Thread Pool -- 53) WFLYSEC0002: Activating Security Subsystem
    14:15:03,722 INFO  [org.jboss.as.webservices] (ServerService Thread Pool -- 56) WFLYWS0002: Activating WebServices Extension
    14:15:03,749 INFO  [org.jboss.as.security] (MSC service thread 1-4) WFLYSEC0001: Current PicketBox version=4.9.4.Final
    14:15:03,752 INFO  [org.jboss.as.naming] (MSC service thread 1-1) WFLYNAM0003: Starting Naming Service
    14:15:03,753 INFO  [org.jboss.as.mail.extension] (MSC service thread 1-2) WFLYMAIL0001: Bound mail session [java:jboss/mail/Default]
    14:15:03,797 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-7) WFLYUT0003: Undertow 1.3.15.Final starting
    14:15:03,810 INFO  [org.wildfly.extension.undertow] (ServerService Thread Pool -- 55) WFLYUT0003: Undertow 1.3.15.Final starting
    14:15:04,221 INFO  [org.wildfly.extension.undertow] (ServerService Thread Pool -- 55) WFLYUT0014: Creating file handler for path '/opt/wildfly-10.0.0.Final/welcome-content' with options [directory-listing: 'false', follow-symlink: 'false', case-sensitive: 'true', safe-symlink-paths: '[]']
    14:15:04,285 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-5) WFLYUT0012: Started server default-server.
    14:15:04,324 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-3) WFLYUT0018: Host default-host starting
    14:15:04,344 INFO  [org.jboss.as.ejb3] (MSC service thread 1-2) WFLYEJB0481: Strict pool slsb-strict-max-pool is using a max instance size of 64 (per class), which is derived from thread worker pool sizing.
    14:15:04,347 INFO  [org.jboss.as.ejb3] (MSC service thread 1-1) WFLYEJB0482: Strict pool mdb-strict-max-pool is using a max instance size of 16 (per class), which is derived from the number of CPUs on this host.
    14:15:04,517 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-7) WFLYUT0006: Undertow HTTP listener default listening on 127.0.0.1:8080
    14:15:04,999 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-7) WFLYJCA0001: Bound data source [java:jboss/datasources/ExampleDS]
    14:15:05,197 INFO  [org.jboss.as.server.deployment.scanner] (MSC service thread 1-3) WFLYDS0013: Started FileSystemDeploymentService for directory /opt/wildfly-10.0.0.Final/standalone/deployments
    14:15:05,202 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-7) WFLYSRV0027: Starting deployment of "pokemax.war" (runtime-name: "pokemax.war")
    14:15:05,575 INFO  [org.infinispan.factories.GlobalComponentRegistry] (MSC service thread 1-6) ISPN000128: Infinispan version: Infinispan 'Mahou' 8.1.0.Final
    14:15:05,594 INFO  [org.infinispan.factories.GlobalComponentRegistry] (MSC service thread 1-8) ISPN000128: Infinispan version: Infinispan 'Mahou' 8.1.0.Final
    14:15:05,573 INFO  [org.infinispan.factories.GlobalComponentRegistry] (MSC service thread 1-2) ISPN000128: Infinispan version: Infinispan 'Mahou' 8.1.0.Final
    14:15:05,571 INFO  [org.infinispan.factories.GlobalComponentRegistry] (MSC service thread 1-5) ISPN000128: Infinispan version: Infinispan 'Mahou' 8.1.0.Final
    14:15:05,836 INFO  [org.jboss.ws.common.management] (MSC service thread 1-1) JBWS022052: Starting JBossWS 5.1.3.Final (Apache CXF 3.1.4) 
    14:15:09,089 INFO  [org.jboss.as.jpa] (MSC service thread 1-6) WFLYJPA0002: Read persistence.xml for pokemax
    14:15:09,432 INFO  [org.jboss.as.jpa] (ServerService Thread Pool -- 59) WFLYJPA0010: Starting Persistence Unit (phase 1 of 2) Service 'pokemax.war#pokemax'
    14:15:09,469 INFO  [org.hibernate.jpa.internal.util.LogHelper] (ServerService Thread Pool -- 59) HHH000204: Processing PersistenceUnitInfo [
        name: pokemax
        ...]
    14:15:09,579 INFO  [org.jboss.weld.deployer] (MSC service thread 1-4) WFLYWELD0003: Processing weld deployment pokemax.war
    14:15:09,707 INFO  [org.hibernate.Version] (ServerService Thread Pool -- 59) HHH000412: Hibernate Core {5.0.7.Final}
    14:15:09,712 INFO  [org.hibernate.cfg.Environment] (ServerService Thread Pool -- 59) HHH000206: hibernate.properties not found
    14:15:09,722 INFO  [org.hibernate.cfg.Environment] (ServerService Thread Pool -- 59) HHH000021: Bytecode provider name : javassist
    14:15:09,843 INFO  [org.hibernate.orm.deprecation] (ServerService Thread Pool -- 59) HHH90000001: Found usage of deprecated setting for specifying Scanner [hibernate.ejb.resource_scanner]; use [hibernate.archive.scanner] instead
    14:15:09,848 INFO  [org.hibernate.validator.internal.util.Version] (MSC service thread 1-4) HV000001: Hibernate Validator 5.2.3.Final
    14:15:09,877 INFO  [org.hibernate.annotations.common.Version] (ServerService Thread Pool -- 59) HCANN000001: Hibernate Commons Annotations {5.0.1.Final}
    14:15:10,512 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-8) WFLYJCA0005: Deploying non-JDBC-compliant driver class com.mysql.cj.jdbc.Driver (version 6.0)
    14:15:10,514 INFO  [org.jboss.weld.deployer] (MSC service thread 1-8) WFLYWELD0006: Starting Services for CDI deployment: pokemax.war
    14:15:10,554 INFO  [org.jboss.weld.Version] (MSC service thread 1-8) WELD-000900: 2.3.2 (Final)
    14:15:10,612 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-5) WFLYJCA0018: Started Driver service with driver-name = pokemax.war_com.mysql.cj.jdbc.Driver_6_0
    14:15:10,613 INFO  [org.jboss.weld.deployer] (MSC service thread 1-7) WFLYWELD0009: Starting weld service for deployment pokemax.war
    14:15:10,922 INFO  [org.jboss.as.jpa] (ServerService Thread Pool -- 59) WFLYJPA0010: Starting Persistence Unit (phase 2 of 2) Service 'pokemax.war#pokemax'
    14:15:11,235 INFO  [org.hibernate.dialect.Dialect] (ServerService Thread Pool -- 59) HHH000400: Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect
    14:15:11,297 INFO  [org.hibernate.envers.boot.internal.EnversServiceImpl] (ServerService Thread Pool -- 59) Envers integration enabled? : true
    14:15:12,082 INFO  [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 59) HHH000227: Running hbm2ddl schema export
    14:15:12,091 INFO  [stdout] (ServerService Thread Pool -- 59) Hibernate: 
    14:15:12,092 INFO  [stdout] (ServerService Thread Pool -- 59)     drop table if exists tb_habilidade
    14:15:12,093 INFO  [stdout] (ServerService Thread Pool -- 59) Hibernate: 
    14:15:12,094 INFO  [stdout] (ServerService Thread Pool -- 59)     drop table if exists tb_pokemon
    14:15:12,095 INFO  [stdout] (ServerService Thread Pool -- 59) Hibernate: 
    14:15:12,095 INFO  [stdout] (ServerService Thread Pool -- 59)     create table tb_habilidade (
    14:15:12,095 INFO  [stdout] (ServerService Thread Pool -- 59)         id bigint not null auto_increment,
    14:15:12,096 INFO  [stdout] (ServerService Thread Pool -- 59)         descricao varchar(150) not null,
    14:15:12,096 INFO  [stdout] (ServerService Thread Pool -- 59)         efeito_secundario varchar(255),
    14:15:12,096 INFO  [stdout] (ServerService Thread Pool -- 59)         nome varchar(20) not null,
    14:15:12,097 INFO  [stdout] (ServerService Thread Pool -- 59)         primary key (id)
    14:15:12,097 INFO  [stdout] (ServerService Thread Pool -- 59)     ) ENGINE=InnoDB
    14:15:12,108 INFO  [stdout] (ServerService Thread Pool -- 59) Hibernate: 
    14:15:12,108 INFO  [stdout] (ServerService Thread Pool -- 59)     create table tb_pokemon (
    14:15:12,108 INFO  [stdout] (ServerService Thread Pool -- 59)         id bigint not null auto_increment,
    14:15:12,108 INFO  [stdout] (ServerService Thread Pool -- 59)         ataque bigint not null,
    14:15:12,109 INFO  [stdout] (ServerService Thread Pool -- 59)         ataque_especial bigint not null,
    14:15:12,109 INFO  [stdout] (ServerService Thread Pool -- 59)         defesa bigint not null,
    14:15:12,109 INFO  [stdout] (ServerService Thread Pool -- 59)         defesa_especial bigint not null,
    14:15:12,109 INFO  [stdout] (ServerService Thread Pool -- 59)         descricao varchar(150) not null,
    14:15:12,109 INFO  [stdout] (ServerService Thread Pool -- 59)         hp bigint not null,
    14:15:12,110 INFO  [stdout] (ServerService Thread Pool -- 59)         nome varchar(20) not null,
    14:15:12,110 INFO  [stdout] (ServerService Thread Pool -- 59)         numeroDex bigint not null,
    14:15:12,110 INFO  [stdout] (ServerService Thread Pool -- 59)         tipoDois varchar(20),
    14:15:12,110 INFO  [stdout] (ServerService Thread Pool -- 59)         tipoUm varchar(20) not null,
    14:15:12,110 INFO  [stdout] (ServerService Thread Pool -- 59)         velocidade bigint not null,
    14:15:12,111 INFO  [stdout] (ServerService Thread Pool -- 59)         primary key (id)
    14:15:12,111 INFO  [stdout] (ServerService Thread Pool -- 59)     ) ENGINE=InnoDB
    14:15:12,113 INFO  [stdout] (ServerService Thread Pool -- 59) Hibernate: 
    14:15:12,113 INFO  [stdout] (ServerService Thread Pool -- 59)     alter table tb_pokemon 
    14:15:12,114 INFO  [stdout] (ServerService Thread Pool -- 59)         add constraint UKa1g6imng0eltmqxv6v110t0go unique (nome, numeroDex)
    14:15:12,115 INFO  [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 59) HHH000230: Schema export complete
    14:15:13,520 INFO  [javax.enterprise.resource.webcontainer.jsf.config] (ServerService Thread Pool -- 58) Inicializando Mojarra 2.2.12-jbossorg-2 20150729-1131 para o contexto '/pokemax'
    14:15:15,948 INFO  [org.primefaces.webapp.PostConstructApplicationEventListener] (ServerService Thread Pool -- 58) Running on PrimeFaces 5.3
    14:15:15,980 INFO  [org.wildfly.extension.undertow] (ServerService Thread Pool -- 58) WFLYUT0021: Registered web context: /pokemax
    14:15:16,053 INFO  [org.jboss.as.server] (ServerService Thread Pool -- 34) WFLYSRV0010: Deployed "pokemax.war" (runtime-name : "pokemax.war")
    14:15:16,271 INFO  [org.jboss.as] (Controller Boot Thread) WFLYSRV0060: Http management interface listening on http://127.0.0.1:9990/management
    14:15:16,273 INFO  [org.jboss.as] (Controller Boot Thread) WFLYSRV0051: Admin console listening on http://127.0.0.1:9990
    14:15:16,273 INFO  [org.jboss.as] (Controller Boot Thread) WFLYSRV0025: WildFly Full 10.0.0.Final (WildFly Core 2.0.10.Final) started in 16424ms - Started 368 of 657 services (382 services are lazy, passive or on-demand)

My persistence.xml file:

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="2.1"
    xmlns="http://xmlns.jcp.org/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd">
    <persistence-unit name="pokemax" transaction-type="RESOURCE_LOCAL">
    <provider>org.hibernate.jpa.HibernatePersistenceProvider</provider>
        <properties>
            <property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5InnoDBDialect" />
            <property name="hibernate.connection.url" value="jdbc:mysql://localhost/pokemax" />
            <property name="hibernate.connection.driver" value="com.mysql.jdbc.Driver" />
            <property name="hibernate.connection.username" value="pokemax" />
            <property name="hibernate.connection.password" value="pokemax2" />
            <property name="hibernate.show_sql" value="true" />
            <property name="hibernate.format_sql" value="true" />
            <property name="hibernate.hbm2ddl.auto" value="create-drop" />
        </properties>
    </persistence-unit>
</persistence>

And my class Util:

package br.com.pokemax.util;

import java.util.logging.Logger;

import javax.enterprise.inject.Produces;
import javax.enterprise.inject.spi.InjectionPoint;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;

public class HibernateUtil {

    @Produces
    @PersistenceContext
    private EntityManager em;

    @Produces
    public Logger produceLog(InjectionPoint injectionPoint) {
        return Logger.getLogger(injectionPoint.getMember().getDeclaringClass().getName());
    }

}

I even put a wrong password to see if you are opening connection but apparently not because I see no error referring.

Can someone help solve this problem?

1 answer

1


Note that in your file persistence.xml has the line:

<property name="hibernate.hbm2ddl.auto" value="create-drop" />

Worth create-drop Hibernate will delete all tables, create new tables and at the end of the session delete all tables again. Switch to create or update, that the tables continued in the database even after the application ended.

For example:

<property name="hibernate.hbm2ddl.auto" value="create" />

Worth create Hibernate will erase all tables at the beginning and create new tables, erasing all your data that was in the database before the application starts. If you want the data not to be erased use update.

Maybe that’s it, if it’s not commented here in the answer please!

Browser other questions tagged

You are not signed in. Login or sign up in order to post.