Joined: Tue Oct 18, 2005 2:51 am Posts: 14 Location: Chennai, India
|
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
|
|