Is dropping table possible?

deQuire · **Joined:** Mon Jan 01, 2007 10:37 am **Posts:** 3

Hello

I am changing my application to use hibernate and so far it looks great. Have only one problem, though. I went trough documentation and forums, but maybe I'm searching in a wrong way. I hope you can help me.

Is it possible to DROP TABLE with Hibernate?

(yes, it's needed, as I map the same class to many tables, and at some point of time some tables become not needed anymore)

Thanks in advance,
Marek

ajay516 · **Joined:** Mon Dec 25, 2006 3:14 pm **Posts:** 18

Sure, you can use sql query

SQLQuery query = session.createSQLQuery("drop table xyz");

http://www.hibernate.org/hib_docs/v3/ap ... ang.String)

deQuire · **Joined:** Mon Jan 01, 2007 10:37 am **Posts:** 3

ajay516 wrote:

Sure, you can use sql query

SQLQuery query = session.createSQLQuery("drop table xyz");

http://www.hibernate.org/hib_docs/v3/ap ... ang.String)

Hey

Thank, of course manual query works. But is there any db-independent method, which will always work?

Marek

jazir1979 · **Joined:** Wed Aug 03, 2005 2:13 am **Posts:** 16

Hi,

I don't believe there is.

Hibernate is not generally geared to performing DDL type operations at runtime. The Hibernate Tools Schema Export can do a drop (of the entire schema!) but I guess this isn't what you're after.

Just use the SQL query, I don't think DROP syntax varies much between databases, the only real downside is that you are hard-coding the table name and can't use the Hibernate entity name.

deQuire wrote:

ajay516 wrote:

Sure, you can use sql query

SQLQuery query = session.createSQLQuery("drop table xyz");

http://www.hibernate.org/hib_docs/v3/ap ... ang.String)

Hey

Thank, of course manual query works. But is there any db-independent method, which will always work?

Marek

pasha · **Joined:** Sat Nov 27, 2004 4:13 am **Posts:** 137

mmm, the downside is creating other tables (I believe dropping tables at runtime requires creating other tables then), and mapping your entity to other table (which requires changing SessionFactory's metadata).

ajay516 · **Joined:** Mon Dec 25, 2006 3:14 pm **Posts:** 18

> mmm, the downside is creating other tables (I believe dropping tables at runtime requires creating other tables then), and mapping
your entity to other table (which requires changing SessionFactory's metadata).

I don't think he is trying to drop the mapped tables, thats really bad idea.

fabio.fiol · **Joined:** Fri Dec 29, 2006 2:28 pm **Posts:** 11

Hi there!
I have to drop the table SPECTRA in my db. It is the mapping of my Spectra class in package popolamento. Here is my code:

Code:

Session session = HibernateUtil.getSessionFactory().getCurrentSession();
session.beginTransaction();
session.createQuery("delete popolamento.Spectra").executeUpdate();
session.getTransaction().commit();
HibernateUtil.getSessionFactory().close();

It works and is a db-independent method :-)