CODEWITHSUNDEEP
javahibernatemaven
ru51an
ru51an

Reputation: 111

Hibernate rebuilds tables of DB

I have very simple maven + hibernate project.

I want to retrieve data and print it in console with the command "select * from product". But each time i launch my app, it rebuilds all tables in db, as a result all data is removed.

What should I do so tables are not rerebuilt each time I launch my app?

Main.java

public class Main {

static final Logger logger = LogManager.getLogger(Main.class);

public static void main(String[] args) {
    SessionFactory sessionFactory = HibernateUtil.getSessionFactory();
    Session session = sessionFactory.openSession();
    List<Object> products = null;

    try {
        session.beginTransaction();

        SQLQuery query = session.createSQLQuery("select * from product");
        query.addEntity(Product.class);
        products = query.list();

        session.getTransaction().commit();
    } catch (Exception e) {
        session.getTransaction().rollback();
        e.printStackTrace();
    } finally {
        session.close();
        sessionFactory.close();
    }

    System.out.println("Hello");

    for (Iterator iterator = products.iterator(); iterator.hasNext(); ) {
        Product product = (Product) iterator.next();
        logger.info("Hello");
    }
}

hibernate.cfg.xml

<?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">org.postgresql.Driver</property>
        <property name="hibernate.connection.url">jdbc:postgresql://localhost:5432/hibernate</property>
        <property name="hibernate.connection.username">postgres</property>
        <property name="hibernate.connection.password">****</property>
        <property name="hibernate.dialect">org.hibernate.dialect.PostgreSQLDialect</property>
        <property name="show_sql">true</property>
        <property name="hbm2ddl.auto">create</property>
        <property name="hibernate.jdbc.lob.non_contextual_creation">true</property>

        <mapping class="models.User"/>
        <mapping class="models.Role"/>
        <mapping class="models.Product"/>
        <mapping class="models.ProductCategory"/>
        <mapping class="models.Order" />
    </session-factory>
</hibernate-configuration>

Upvotes: 1

Views: 58

Answers (2)

Sudhir Ojha
Sudhir Ojha

Reputation: 3305

Use following code in your hibernate.cfg.xml file

 <property name="hbm2ddl.auto">Update</property>

instead of

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

Upvotes: 1

jklee
jklee

Reputation: 2268

Change your line 

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

by

 <property name="hbm2ddl.auto">validate</property>

Look also https://docs.jboss.org/hibernate/orm/5.2/userguide/html_single/Hibernate_User_Guide.html#configurations-hbmddl

Upvotes: 1

Related Questions