Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Subtransactions not support Exception

81 views
Skip to first unread message

asif.p...@accenture.com

unread,
Mar 26, 2008, 4:34:27 AM3/26/08
to
I am currently using custom Iframe Portlet and it makes a connection to the Oracle DB.<br />
Currently no nested transactions are occuring in it but it still i get a subtransaction not supported error. <br />
<br />
I am using Websphere Portal v6 and Oracle 10i and XADataSource and this error is occuring only in the Production Env. Makes me wonder this is any configuration setting issue and there is any flag to allow nested transaction.<br />
<br />
Any help on this would be greatly appreciated<br />
<br />
<strike>3/10/08 10:12:12:697 EDT</strike> 00000058 SystemErr R javax.transaction.NotSupportedException: Subtransactions not supported<br />
at com.ibm.ws.Transaction.JTA.UserTransactionImpl.begin(UserTransactionImpl.java(Compiled Code))<br />
at com.database.BaseDAO.openConnection(BaseDAO.java(Compiled Code))<br />
at com.entity.client.UserDAO.getUser(UserDAO.java:43)<br />
at com.entity.client.UserSessionService_DAOImpl.loadUser(UserSessionService_DAOImpl.java:187)<br />
at com.entity.client.UserSessionService_DAOImpl.login(UserSessionService_DAOImpl.java:85)<br />
at com.portlet.iframe.IFramePortlet.doView(IFramePortlet.java:162)

Jim Barnes

unread,
Mar 26, 2008, 10:37:46 AM3/26/08
to
From looking at some other issues, this can happen from the transaction manager when it is trying to restart after being stopped gracefully. <br />
What you might try and do is stop the server<br />
delete the tranlogs C:\IBM6013\WebSphere\profiles\wp_profile\tranlog<br />
then restart<br />
<br />
Jim<br />
<p />
<br>
IBM Certified System Administrator -- WebSphere Portal V6.0, V5.1, V5.0<br>
IBM Certified Solution Developer -- WebSphere Portal V5.1, v6.0<br>
<br>
The postings on this site are my own and do not necessarily represent the positions, strategies, or opinions of IBM

asif.p...@accenture.com

unread,
Mar 26, 2008, 12:58:56 PM3/26/08
to
Delete the tranlog is an temporary solution since it would again build up and again the error would show up.<br />
<br />
Do we have to give select grant permissions to pending_transactions help and after that should the oracle db restarted.

Jim Barnes

unread,
Mar 26, 2008, 7:15:57 PM3/26/08
to
well from the ones I saw they should only be building up when the server is shut down ungracefully, I will check more on this tomorrow<br />
<br />
0 new messages