DDL with Hibernate

kumar_iyer · **Joined:** Tue Oct 17, 2006 10:34 am **Posts:** 3

Hi forum,

Does Hibernate support DDL statement execution, for eg; create database or create table statements?

I don't think HQL gives direct support for DDL, but can we not invoke Native SQL statements directly from Hibernate in the following way:

Code:

SQLQuery sql = session.createSQLQuery("create database " + dbName);
sql.executeUpdate();

However, in such a case I get an UnsupportedOperationException, because update operations are not allowed with SQLQuery objects!

Thanks in advance.

Regards,
Kumar Iyer.

max · **Posted:** Wed Dec 27, 2006 6:41 am

I don't recommend using native sql queries to do DDL operations; but in 3.2 it should be possible because here .executeUpdate() is suppored for native queries.

kumar_iyer · **Joined:** Tue Oct 17, 2006 10:34 am **Posts:** 3

Hi Max,

If not through Native SQL, how else can you execute DDL statements thru Hibernate?

Regards,
Kumar Iyer

lester · **Posted:** Wed Dec 27, 2006 7:53 am

You can get plain JDBC Connection from Hibernate Session, and execute DDL statement throuth it.