"hibernate.hbm2ddl.auto">create - to generate DB Tables

Hello,

I am developing a program with Hibernate and Oracle and I want to reproduce the same application using MySQL. I want to generate de database tables using:

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

from the ("Oracle") domain code, but I can only create one table out of four. Does anyone have an idea what I am doing wrong?

Regards.

M. Marin.

We'll probably need a bit more information. Are you getting any errors?

If you can do one, then try to do just two. See if you can get two to work. Maybe even scale it back to table name and primary key for two tables. Then incrementally do more until you find the setting that might be causing the problem.

Just an approach. Any errors? Bizarre table mappings? I'm betting the three tables are dependent on each other?

Thank you for the answer. I followed the instructions and It helped to locate the problem. Oracle allowed me to use the word "KEY" as a field name and MySQL did not like it, so I guess "KEY" is a reserved keyword in MySQL. So I changed the field name and now it works.

from:

@Length(max=80)
@Column(name="KEY", length=80)
public String getKey() {
return key;
}

public void setKey(String key) {
this.key = key;
}

to:

@Length(max=80)
@Column(name="PKEY", length=80)
public String getPkey() {
return pkey;
}

public void setPkey(String pkey) {
this.pkey = pkey;
}

now it works, so great. Thank you for the quick help.

M. Marin.

Good sleuthing, Greenhorn! And thanks for the post-back. You'll be surprised by how many people will have that exact problem and have it subsequently solved by your hard work.

I know a guy that wrote an entire book using a table named "User" and a MySQL database, only to discover none of the examples worked as promised in certain databases because User is a reserved word. What a drag!

-Cameron McKenzie

M Marin wrote:Hello,

I am developing a program with Hibernate and Oracle and I want to reproduce the same application using MySQL. I want to generate the database tables using:

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

from the ("Oracle") domain code, but I can only create one table out of four. Does anyone have an idea what I am doing wrong?

Regards.

M. Marin.

Hi,

can you please post your bean class and persistence.xml and the settings what you are using to execute this program..because I am facing the same problem and struggling for one week to create tables in database automatically.

Thanks in Advance,

Best Regards,
Raja.

I am not using persistance.xml for the project. I use hibernate.cfg.xml:

(This is a simplified version)

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.password">mypassword</property>
<property me="hibernate.connection.url">jdbc:mysql://localhost:3306/mydb</property>
<property name="hibernate.connection.username">root</property>
<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="hibernate.search.autoregister_listeners">false</property>
<property name="hibernate.hbm2ddl.auto">create</property>
<property name="hibernate.show_sql">true</property>
<mapping class="data.Customer" />
</session-factory>
</hibernate-configuration>

Try whether that works

Marin

Add also the schema name manually to de database, just leave the tables to be automatically generated.

M Marin wrote:Add also the schema name manually to de database, just leave the tables to be automatically generated.

I did what you said..but still its not creating any tables in database and its printing this on console:

10:24:07,513 INFO [SessionFactoryObjectFactory] Bound factory to JNDI name: persistence.unit:unitName=ernst-app-ear-1.0.ear/persistenceImpl-app-1.0.war#DefaultDS
10:24:07,513 WARN [SessionFactoryObjectFactory] InitialContext did not implement EventContext
10:24:07,528 INFO [SchemaUpdate] Running hbm2ddl schema update
10:24:07,528 INFO [SchemaUpdate] fetching database metadata
10:24:07,528 INFO [SchemaUpdate] updating schema
10:24:07,528 INFO [SchemaUpdate] schema update complete
10:24:07,544 INFO [NamingHelper] JNDI InitialContext properties:{java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming

rg.jnp.interfaces}

can you please tell me what you have done other than creating hbm.xml, persistence.xml and entitiy beans..can you please check it.

10:24:07,528 INFO [SchemaUpdate] updating schema
10:24:07,528 INFO [SchemaUpdate] schema update complete

Looks like its updating the schema.

(NB: "entity beans" are a EJB2 technology. When you say you created entity beans did you really mean entity beans? )

Paul Sturrock wrote:

10:24:07,528 INFO [SchemaUpdate] updating schema
10:24:07,528 INFO [SchemaUpdate] schema update complete

Looks like its updating the schema.

(NB: "entity beans" are a EJB2 technology. When you say you created entity beans did you really mean entity beans? )

hi, this is my class..can you please check it..

package com.ernst.persistenceImpl.beanImpl;

import com.ernst.persistenceAPI.beanAPI.NrKreiseBeanAPI;
import com.ernst.persistenceAPI.localBeanAPI.NrKreiseLocalBeanAPI;
import com.ernst.persistenceAPI.remoteBeanAPI.NrKreiseRemoteBeanAPI;

import javax.persistence.*;
import java.io.Serializable;

@Entity
@Table(name = "NR_KREISE")
public class NrKreiseBean implements NrKreiseBeanAPI, NrKreiseLocalBeanAPI, NrKreiseRemoteBeanAPI, Serializable {

@Id
    @GeneratedValue
    @Column(name = "nr_kreise_id", nullable = false)
    private int nr_kreise_id;

@Column(name = "fk_nr_typ")
    private int fk_nr_typ;

@Column(name = "data_ref_von")
    private int data_ref_von;

@Column(name = "data_ref_von")
    private int data_ref_bis;

@Column(name = "data_ref_von")
    private int data_ref;

@Column(name = "data_ref_von")
    private int msg_ref_von;

@Column(name = "data_ref_von")
    private int msg_ref_bis;

@Column(name = "data_ref_von")
    private int msg_ref;

@Column(name = "data_ref_von")
    private String desc;

public int getNr_kreise_id() {
        return nr_kreise_id;
    }

public void setNr_kreise_id(int nr_kreise_id) {
        this.nr_kreise_id = nr_kreise_id;
    }

public int getFk_nr_typ() {
        return fk_nr_typ;
    }

public void setFk_nr_typ(int fk_nr_typ) {
        this.fk_nr_typ = fk_nr_typ;
    }

public int getData_ref_von() {
        return data_ref_von;
    }

public void setData_ref_von(int data_ref_von) {
        this.data_ref_von = data_ref_von;
    }

public int getData_ref_bis() {
        return data_ref_bis;
    }

public void setData_ref_bis(int data_ref_bis) {
        this.data_ref_bis = data_ref_bis;
    }

public int getData_ref() {
        return data_ref;
    }

public void setData_ref(int data_ref) {
        this.data_ref = data_ref;
    }

public int getMsg_ref_von() {
        return msg_ref_von;
    }

public void setMsg_ref_von(int msg_ref_von) {
        this.msg_ref_von = msg_ref_von;
    }

public int getMsg_ref_bis() {
        return msg_ref_bis;
    }

public void setMsg_ref_bis(int msg_ref_bis) {
        this.msg_ref_bis = msg_ref_bis;
    }

public int getMsg_ref() {
        return msg_ref;
    }

public void setMsg_ref(int msg_ref) {
        this.msg_ref = msg_ref;
    }

public String getDesc() {
        return desc;
    }

public void setDesc(String desc) {
        this.desc = desc;
    }
}

M Marin wrote:Add also the schema name manually to de database, just leave the tables to be automatically generated.

what I found one interesting fact is..when jboss runs persistence.xml its not generating any create table queries..thats why its not creating any tables..how to generate the create table queries automatically.

This appears to be a duplicate. Please continue the discussion in your other topic.