HIbernate creating database table

Question

I am in the process of learning JPA - Hibernate.

I am following this article In Dog.java it is mentioned as @Table(name = "dog"). In persistence.xml I have the following

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

Does this creates table dog in database? I have not created table Dog in database. So in production environment this could be dangerous though. In such scenarios what should be ideal value for hibernate.hbm2ddl.auto?

Any suggestions?

Luis Ramirez-Monterosa · Accepted Answer · 2012-08-20 18:51:50Z

4

it's dangerous in all senses, your application user should not have DDL permissions (alter table, create tables) your application user should only do DML (SELECT, INSERT,UPDATE,DELETE, etc)

answered Aug 20, 2012 at 18:51

Luis Ramirez-Monterosa

2,24220 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jacob Over a year ago

If application user should do only DML, then what should be the value for hibernate.hbm2ddl.auto? Is it none? Thanks

Luis Ramirez-Monterosa Over a year ago

just don't add it, comment it out. Reason behind is someone can manipulate that connection in order to drop a table or something. more secure if you don't manipulate with same user.

Reimeus · Accepted Answer · 2012-08-20 19:23:39Z

2

Yes, it does create the new table every time that your app is deployed. Better to use:

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

if you already have data in place.

Here are the possible options:

validate: validate the schema, makes no changes to the database.
update: update the schema.
create: creates the schema, destroying previous data(!)
create-drop: drop the schema at the end of the session(!)

edited Aug 20, 2012 at 19:23

answered Aug 20, 2012 at 18:48

Reimeus

160k16 gold badges225 silver badges282 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 12:34:33Z

1

Do not set <property name="hibernate.hbm2ddl.auto" value="create"/> in production, because whenever you restart the server, all tables will be deleted and newly created again. You can make use of this property(hibernate feature) if you are migrating from one database to another.

If you want to set then set <property name="hibernate.hbm2ddl.auto" value="update"/> in development(not in production). This will update the schema if there are any changes you have made in pojo classes(annotations).

Also check : Hibernate: hbm2ddl.auto=update in production?

Hibernate hbm2ddl.auto possible values and what they do?

edited May 23, 2017 at 12:34

CommunityBot

11 silver badge

answered Aug 20, 2012 at 18:48

Nandkumar Tekale

16.2k8 gold badges60 silver badges86 bronze badges

Comments

Matt · Accepted Answer · 2012-08-20 19:55:26Z

1

Set it to "none" in a production environment.

edited Aug 20, 2012 at 19:55

answered Aug 20, 2012 at 18:49

Matt

11.8k2 gold badges28 silver badges35 bronze badges

Collectives™ on Stack Overflow

HIbernate creating database table

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related