CMP with postgres not rolling back!

[mjremijan]

Hi,

I have a local session bean that does two things. One, get a local entity bean to update database data. Two, send a JMS message to a topic.

The local session bean method has a REQUIRED transaction. The local entity beans have SUPPORTED.

I wanted to test the ACID operation of the local session bean method call, so I intentionally tried throwing a exception after entity bean operation. I expected NO database data to be commited, but despite throwing the exception the data is commited to the database.

Have other people using Postgresql experienced this problem? What did you do to resolve it?

Thanks
Mike

[raja05]

Just to make sure, you arent throwing an application exception, are you?

[mjremijan]

I have some additional information. My test was throwing a NamingException. When I changed this to be an EjbException, the data did not commit to the database.

Does the transaction manager only recognize EJBExceptions?

[raja05]

Yes, EJBException is a Runtime exception whereas NamingException is a checked one.
IF you are throwing a NamingException, call the setRollbackonly() before throwing the exception.