Execute sql CREATE TABLE query in Hibernate

Question

I need to dynamically create a table using a Java method and tranform all its rows into a list of Mapping class objects. The questions are..

Is there a way to execute CREATE TABLE query dynamically?
I saw some examples using doInHibernate() but it didn't work when I tried it. Can I do this without the particular method?

Chris · Accepted Answer · 2011-11-16 21:46:17Z

5

You could just execute a native sql query: session.createSQLQuery("create table .....").executeUpdate(); where "session" is your Hibernate session.

If you already have the mapping files, though, you can just set the hibernate.hbm2ddl.auto property in your hibernate configuration to generate the schema based on the mapping files.

answered Nov 16, 2011 at 21:46

Chris

23.2k4 gold badges58 silver badges50 bronze badges

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

Comments

dbrin · Accepted Answer · 2011-11-16 21:45:39Z

2

Try this:

session.createSQLQuery(query).executeUpdate();

another possibility would be:

createStatement().execute(someddl);

answered Nov 16, 2011 at 21:45

dbrin

15.7k4 gold badges59 silver badges85 bronze badges

Collectives™ on Stack Overflow

Execute sql CREATE TABLE query in Hibernate

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related