Hibernate version 3.2.0.CR2:

Hello I am getting the following exception when I try to use Hibernate on WebSphere 6.0.2.9:


My SessionFactory configuration file looks as follows:


I am aware of the former existence of this problem in Hibernate 3.0. But it appears it has been addressed: http://opensource.atlassian.com/projects/hibernate/browse/HHH-198.

Does anybody have a clue of what might be wrong? Shall I reopen HHH-198?

Regards,
Andrei.

Try using the following:

<property name="connection.datasource">[your websphere datasource name]</property>
<property name="dialect">org.hibernate.dialect.OracleDialect</property>
<property name="transaction.manager_lookup_class">org.hibernate.transaction.WebSphereExtendedJTATransactionLookup</property>
<property name="hibernate.transaction.factory_class">org.hibernate.transaction.JTATransactionFactory</property>
<property name="jta.UserTransaction">thisNode/servers/WebSphere_Portal/jta/usertransaction</property>

BMT enterprise beans and web components can use the Java Transaction API (JTA) UserTransaction interface to define the demarcation of a global transaction. The UserTransaction interface can be obtained by a JNDI lookup of java:comp/UserTransaction or from the SessionContext object using the getUserTransaction method..

The UserTransaction is not available to the following components:

* CMT enterprise beans. Any attempt by such beans to obtain the interface results in an exception in accordance with the EJB specification.
* Client applications running outside the Web and EJB containers.

Ensure that programs that perform a JNDI lookup of the UserTransaction interface, use an InitialContext that resolves to a local implementation of the interface. Also ensure that such programs use a JNDI location appropriate for the EJB version.


Regards F.meyer

That's fine, but if you've tried this in websphere app portal 6, you'd see comp/UserTransaction not available. Check out the associated bug/enhancement that was made to support websphere and their (mis)handling of JTA txns.

WebSphere WAR application has issues with finding UserTransaction


Environment: Hibernate 3.0.5, Oracle 10g, WebSphere 6.0.2, WAR application

The application is a WAR running on JBoss and WebLogic with no problems, but having issues with WebSphere.

The application is a workflow processing app, which uses Hibernate for persisting configuration and process audit information. The source of the problem is that the application needs to create and manage some threads which are therefore not managed by WebSphere (e.g. use of Quartz scheduler, enhanced queue reading), and these threads will be writing audit information. Due to the approach to safeguarding resources used by WebSphere, where access to JNDI resources may involve ThreadLocal bindings, these non-WAS-managed threads do not have access to the UserTransaction in the normal location of 'java:comp/UserTransaction'. Instead the UserTransaction is available at 'jta/usertransaction'. Unfortunately other code calls the same persistence code from within WebSphere managed threads (MDBs, servlets) and then the UserTransaction is at java:comp/UserTransaction' and not at 'jta/usertransaction'.

This is clearly a WebSphere issue rather than a Hibernate one - I raise it here to inform others of the situation and in the hope that someone might have a better workaround than me. My current solution is to use a 'negatively enhanced' copy of JTATransaction to look up in JNDI under both locations, and to use a revised copy of JTATransactionFactory to create these JTATransactions. This works so far in all situations but is deeply unpleasant, however other solutions do violence to the application architecture and so are currently undesirable.

This is tested and works on WebSphere 6.0.2, and I am on the point of testing on WebSphere 5.1.

Dear all,

I have read your comments, however i really didnt understand much.

First of all, where can i find WebSPhere_Portal JNDI name which is explained In one of the solutions, that is based on the new configuration property. We are usingWepshepre 6.1 network deployment. I dont know how to construct such a JNDI (which as i understood depends on the installation of portal server)? Do we need to install a new server, can we download it, is it already included, just a configuration is neened etc..?

Finally, the last solution, talks about "negatively enhanced" transaction lookup. Can you please elaborate on it with also attaching source codes?

I appreciate your help.

Thanks you all in advance( as usual i need emergent help as anyone else).

Regards,

Siyamed

Hi,

Sorry I should have prefixed my comments with some explanation.

I wasn't commenting directly on the previous posting, but wanted to inform anyone who was interested that I have run across a similar issue when using WebSphere, a WAR app and Hibernate inside managed and non-managed threads.

Negatively enhanced just meant using a very crap hack which however works for me for now:

JTATransaction.begin(InitialContext context, String utName):

try {
ut = (UserTransaction) context.lookup(utName);
}
catch (NamingException ne) {
try {
ut = (UserTransaction) context.lookup(WEBSPHERE_BACKUP_NAME);
}
catch (NamingException nemore) {
log.error("Could not find UserTransaction in JNDI: " + ne.getMessage() + " : " + nemore.getMessage(), nemore);
throw new TransactionException("Could not find UserTransaction in JNDI: ", nemore);
}
}

hibernate.cfg.xml
<property name="jta.UserTransaction">jta/usertransaction</property>

Spring config:
<bean id="transactionManager" class="org.springframework.transaction.jta.JtaTransactionManager">
<property name="userTransactionName"
value="jta/usertransaction" /> </bean>