Re: AS400 V5R2 - Using Transactions Errors

["Joe Sam Shirah" <jshirah@xxxxxxxxxxxxx>]

    Hi Maria,

>    My english is not good,

    Neither is my Spanish beyond standard and stupid phrases.  And it didn't
help that my computer translator converted one word to "tapeworm".    ;-)

    But the WLTC errors are Websphere specific, and you can find some
information by searching on LocalTransactionContainment.  I don't have the
time now to dig deeper ( mostly due to getting ready for hurricane
Frances ), especially since we have little to go on, but it appears that you
are using J2EE/EJB and having a confilict either in transaction settings or
transactions spanning multiple servlet requests.

    Take a look at these links to see if you can find something applicable:

Migrating to V5.0 Results in, "javax.servlet.ServletException:
LocalTransaction rolled-back due to setRollbackOnly"
<
http://www-1.ibm.com/support/docview.wss?rs=180&context=SSEQTP&q1=WLTC0032E&;
uid=swg21141640&loc=en_US&cs=utf-8&lang=en+en
>

Help! Global/Local Transactions, how to use UserTransaction
<
http://forum.java.sun.com/thread.jsp?forum=48&thread=533828
>

Usage of XA DataSource while working with single resource.
<
http://saloon.javaranch.com/cgi-bin/ubb/ultimatebb.cgi?ubb=get_topic&f=46&t=
002930
>

    You may also want to look over the information at "What Are
Transactions?" and "Controlling Transactions" in the "Entity Beans" section
of my "Getting Started with Enterprise JavaBeans" tutorial available at
developerWorks and from the conceptGO "Community" link at:

www.conceptgo.com/

    Sorry that these are all in English, but I hope it helps.   Best,


                                                         Joe Sam

Joe Sam Shirah -        http://www.conceptgo.com
conceptGO         -        Consulting/Development/Outsourcing
Java Filter Forum:       http://www.ibm.com/developerworks/java/
Just the JDBC FAQs: http://www.jguru.com/faq/JDBC
Going International?    http://www.jguru.com/faq/I18N
Que Java400?             http://www.jguru.com/faq/Java400


----- Original Message -----
From: "Maria del Carmen Castillo Martini" <mdccastillo@xxxxxxxxxxx>
To: <java400-l@xxxxxxxxxxxx>
Sent: Friday, September 03, 2004 11:52 AM
Subject: AS400 V5R2 - Using Transactions Errors


>    Hi,
>
>    My english is not good, buy i'll try:
>
>    I have a problem, because when I create my connection and call  then
>    method metadata.supportsTransactions()  it returns true, but when I set
>    the value
>
>    connection.setAutoCommit(false);
>
>    it throws me the error:
>
>    [3/09/04 10:46:18:219 CDT] 27df3990 LocalTransact E WLTC0033E: El
recurso
>    jdbc/ds400 se ha retrotraido en la limpieza de una
>    LocalTransactionContainment no resuelta.
>
>    [3/09/04 10:46:18:609 CDT] 27df3990 LocalTransact E WLTC0032E: Se han
>    retrotraido uno o mas recursos. Una LocalTransactionContainment no
>    resuelta tenia una accion no resuelta de retrotraccion.
>
>    [3/09/04 10:46:18:641 CDT] 27df3990 WebAppTransac E SRVE0183E:
>    LocalTransaction se ha retrotraido debido a setRollbackOnly
>
>    [3/09/04 10:46:18:656 CDT] 27df3990 WebGroup E SRVE0026E: [Error de
>    servlet]-[LocalTransaction rolled-back due to setRollbackOnly]:
>    com.ibm.ws.LocalTransaction.RolledbackException
>
>    at
>
com.ibm.ws.LocalTransaction.LocalTranCoordImpl.cleanup(LocalTranCoordImpl.ja
va:967)
>
>    at
>
com.ibm.ws.webcontainer.webapp.WebAppTransactionCollaborator.postInvoke(WebA
ppTransactionCollaborator.java:208)
>
>    at
>
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppReques
tDispatcher.java:673)
>
>    at
>
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequest
Dispatcher.java:176)
>
>    at
>
com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:79)
>
>    at
>
com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker
.java:201)
>
>    at
>
com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(C
achedInvocation.java:71)
>
>    at
>
com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(C
acheableInvocationContext.java:114)
>
>    at
>
com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletReq
uestProcessor.java:186)
>
>    at
>
com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListene
r.java:334)
>
>    at
>
com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.jav
a:56)
>
>    at
>
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:610)
>
>    at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:435)
>
>    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:593)
>
>    can someone help me?!
>
>    Thanks
>
>     Maria del Carmen
>