Hi,

I searched the documentation and the forum,
but still couldn't find a clear answer -

Can an object be deleted from the database without loading it first?
The id of the object is known in advance,
and it's a heavy and complicated object, so loading it just for deletion is inefficient.

Thanks,
Vitaliy

I suppose Session.delete(...) or Query.executeUpdate() can do the trick

Hi,

Thanks for replying,
but if I understand the documentation correctly,
both functions you've mentioned work on persistent or transient objects only -
that is objects that had been loaded before at some stage as on object in the first case, or as part of a collection in the second case.

This is not what I'm looking for - I need to delete an object from the database that had never been loaded before, and loading which just for deletion is highly inefficient.

Thanks,
Vitaliy

what about

This has no effect on the data.
I think you must path a from clause in the query.

Here's the code I've tried, like you suggested -

-------------------------------------------------------------------------------------
Session session;
Transaction transaction;
session = HibernateUtil.getSessionFactory().getCurrentSession();
transaction = session.beginTransaction();
session.createQuery("delete com.package.ClassName where id=7"); transaction.commit();
------------------------------------------------------------------------------------

and here's the regular HibernateUtil:
-------------------------------------------------------------------------------------
public class HibernateUtil
{

private static final SessionFactory sessionFactory;

static
{
try
{
// Create the SessionFactory from hibernate.cfg.xml

sessionFactory = new Configuration().configure().buildSessionFactory();

}
catch (Throwable ex) {
// Make sure you log the exception, as it might be swallowed
System.err.println("Initial SessionFactory creation failed." + ex);
throw new ExceptionInInitializerError(ex);
}

}

public static SessionFactory getSessionFactory() {
return sessionFactory;
}

}

-------------------------------------------------------------------------------------


Thanks,
Vitaliy

http://www.hibernate.org/hib_docs/v3/reference/en/html/batch.html#batch-direct states FROM clause is optional, after all it is HQL not SQL query.

the query above should work. could you please enable show_sql, and check return value from executeUpdate()?

I tried that, but it didn't seem to modify the data.
I'll give it another shot, and update this post when I get the results.

Thanks,
Vitaliy