Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:
3.0.2

How to delete an object with not-null="true" properties ?

I have a uset table where the user name is not-null="true"

I would like to delete the user without getting it from the db first.

I try :

UserBean userBean = new UserBean();
userBean.setId(new Long(1));
try {
session.delete(userBean);
session.flush();
} catch (StaleStateException e) {
// TODO
} catch (ConstraintViolationException e) {
// TODO
} catch (HibernateException e) {
throw new WrappedException(e);
}

but hibernate complains that the user name is null...

I can get it to work by doing this :

UserBean userBean = new UserBean();
userBean.setId(new Long(1));
userBean.setName("just something");
try {
session.delete(userBean);
session.flush();
} catch (StaleStateException e) {
// TODO
} catch (ConstraintViolationException e) {
// TODO
} catch (HibernateException e) {
throw new WrappedException(e);
}

or by doing this :

UserBean userBean = userBean = (UserBean) session.get(UserBean.class, new Long(1));
try {
session.delete(userBean);
session.flush();
} catch (StaleStateException e) {
// TODO
} catch (ConstraintViolationException e) {
// TODO
} catch (HibernateException e) {
throw new WrappedException(e);
}


What is the best way to do it ?

If UserBean is proxiable use load(), not get(), followed by the delete()

I am quit new to hibernate, what do you mean by proxiable ?

You say I should use load, but when I read the documentation for the load is says :

You should not use this method to determine if an instance exists (use get() instead). Use this only to retrieve an instance that you assume exists, where non-existence would be an actual error.

And the there is no check on that the object should exist .

Sure, use get() if you want to actually have a select prior to the delete. Perhaps I'm just overly performance minded.

So I put this in my UserBean class :

@hibernate.class
table = "USER"
proxy="UserBean"

and delete a user like this :

try {
UserBean userBean = (UserBean) session.load(UserBean.class, theUserToDelete.getId());
session.delete(userBean);
session.flush();
} catch (StaleStateException e) {
throw new ObjectNotFoundException(theUserToDelete);
} catch (ConstraintViolationException e) {
throw new DatabaseException(TextResource.getText("DELETE_CONSTRAINT_VIOLATION_EXCEPTION"), theUserToDelete);
} catch (HibernateException e) {
throw new WrappedException(e);
}