Hi,

I have code that does,
try {
lock = new MyHBN(id, new Date());
db.save(lock);
db.flush();
success = true;
} catch (HibernateException hex) {

The MyHBN contains a column that must be unique. If a unique violation occurs during the db.flush, the HibernateException is caught,
so I can correctly handle it.

but the following Error is still logged,
[#|2010-03-08T13:10:32.577+0000|INFO|sun-appserver2.1|javax.enterprise.system.stream.out|_ThreadID=23;_ThreadName=httpSSLWorkerThread-8080-4;|08 Mar 2010 13:10:32,571 WARN hibernate.util.JDBCExceptionReporter:100 - SQL Error: 1, SQLState: 23000
|#]

[#|2010-03-08T13:10:32.586+0000|INFO|sun-appserver2.1|javax.enterprise.system.stream.out|_ThreadID=23;_ThreadName=httpSSLWorkerThread-8080-4;|08 Mar 2010 13:10:32,579 ERROR hibernate.util.JDBCExceptionReporter:101 - [sunm][Oracle JDBC Driver][Oracle]ORA-00001: unique constraint (RICHARDA.SYS_C007034) violated

[#|2010-03-08T13:10:32.605+0000|INFO|sun-appserver2.1|javax.enterprise.system.stream.out|_ThreadID=23;_ThreadName=httpSSLWorkerThread-8080-4;|08 Mar 2010 13:10:32,587 ERROR event.def.AbstractFlushingEventListener:324 - Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1028)
...
Caused by: com.sun.sql.jdbc.base.BaseBatchUpdateException: [sunm][Oracle JDBC Driver][Oracle]ORA-00001: unique constraint (RICHARDA.SYS_C007034) violated


How can I stop those errors being logged?

Thanks

Assuming that you are using log4j as logging system (=the most used),
you can define



in your log4j-configuration file if you don't get errors logged from this classes.