Hi,

Can anybody give me some suggestion on this problem I am facing?

I have websphere which uses XA driver to connect to Oracle database.
My Hibernate is cofigured to to the jndi name of the websphere connection resource.

Each time I am opening a session through Hibernate.

Now when I am running a stored procedure, I am getting an error

WTRN0063E: An illegal attempt to commit a one phase capable resource with existing two phase capable resources has occurred.

This problem is said to occur for global connection.

I felt that the same jdbc connection is serving diferent session, and our stored procedure uses a Temporary table which may be the one "one phase capable resource". So I planed to issue a transaction.begintransaction and transaction.commit for every session so that all two phase and one phase commits remain seperate. But I find transaction is also not supported for global connection.

I need to solve the issue, even if there is some workaround. Can I just close the connection explicitly while closing the session?



I am desperately in need of a suggestion.

Thanks
Neil