How to create table in database dynamically using Hibernate?

Question

I am new to hibernate and I need to create database table on fly. Which means I will be taking table details from User from UI. Lets say we restrict the user on number of table attributes(column) to 5 or so.

I've gone through various tutorials on hibernate and I see we can create a table but for that we need a class beforehand. But in my case everything is going to be dynamic.

As compared to JDBC, we can directly shoot a CREATE TABLE query and pass the table parameters into the query in java code.

My web application uses a REST web service, spring 3 framework and MySQL as database.

Any tutorial links or sample code would be really helpful

Thanks

Ken Chan · Accepted Answer · 2012-03-12 03:10:51Z

2

I think you can make use of the SchemaExport class which has the method create() to generate table schema creation scripts from a set of given hibernate mapping files and then execute these scripts.

You should create the hibernate mapping XML pragmatically according to the information entered by user and feed this XML into the Configuration object that is passed to the SchemaExport object . Something likes this:

Configuration config = new Configuration();
// mappingClass.xml is generated according to the information entered by user
config.addResource("mappingClass.xml");  

SchemaExport schemaExport = new SchemaExport(config);
schemaExport.create(true,true)

answered Mar 12, 2012 at 3:10

Ken Chan

91.4k26 gold badges157 silver badges189 bronze badges

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

2 Comments

Dhruv Over a year ago

Thanks, is there a way I can atleast upload .csv or excel files via hibernate? By this i mean the table would get created on fly

Ken Chan Over a year ago

I think it cannot because hibernate does not understand the format of your .csv or excel file . You have to convert them to a format that hibernate can understand , which is the hibernate mapping XML .

wintersolutions · Accepted Answer · 2012-03-12 00:41:54Z

0

This is not the answer you want to hear, but I'm afraid hibernate can't create tables at runtime. As an alternative you could implement a key-value table, associate it with the user table and store attributes there. Thats how its usually done.

answered Mar 12, 2012 at 0:41

wintersolutions

5,3415 gold badges32 silver badges51 bronze badges

2 Comments

Dhruv Over a year ago

really! Then how I should achieve my task?

wintersolutions Over a year ago

@Dhruv: Read my answer to the end.

phanij · Accepted Answer · 2012-03-12 01:24:02Z

0

Take a look at Apache CouchDB. It looks like good fit in your case. By adding new tables through code, you are inviting trouble. If this for a production environment solution, I would humbly ask you to reconsider. You don't want to be doing DBA stuff through code.

answered Mar 12, 2012 at 1:24

phanij

462 bronze badges

Collectives™ on Stack Overflow

How to create table in database dynamically using Hibernate?

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related