Mailing-List: contact user-help@geronimo.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@geronimo.apache.org
Received-SPF: pass (athena.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=Received:X-Yahoo-SMTP:X-YMail-OSG:X-Yahoo-Newman-Property:Message-Id:From:To:In-Reply-To:Content-Type:Content-Transfer-Encoding:Mime-Version:Subject:Date:References:X-Mailer;
  b=UZSCLR7pGGPwYqoLUeLgxWXS/6QfSXTdLJM+ddnYXDsIUwLT5884BkOz5DXArUm35wPh9GW+qgoihadACULYPgiKi+MF5uXd5C3B6zJjjObpLEwLfiJLKmLgT5oMAQPl5x39eyAr1XSb7lzmhavcoiCQUwuCmOUKlvzBUDFFCgU=
  ;
Message-Id: <ED631AAA-B680-4A53-BCCA-1C803C6EE063@yahoo.com>
From: David Jencks <david_jencks@yahoo.com>
To: user@geronimo.apache.org
In-Reply-To: <BA2009C3-A917-4D4C-AA76-7617AF466BD8@visi.com>
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0 (Apple Message framework v935.3)
Subject: Re: OpenEJB encountered an unknown system error in container:
Date: Wed, 1 Jul 2009 18:58:02 -0700
References: <4A40EAC1.5000808@optitool.de>
 <BA2009C3-A917-4D4C-AA76-7617AF466BD8@visi.com>

The tranql wrapper should be dealing with the autocommit state of the  
connection automatically.  Is there any chance your code called  
setAutocommit(true)?  Were there any sql errors before this?

Which tranql wrapper are you using? I expect its the generic one but  
it doesn't hurt to check.

thanks
david jencks

On Jul 1, 2009, at 4:11 PM, David Blevins wrote:

> On Jun 23, 2009, at 7:46 AM, Michael Simons wrote:
>
>> Caused by: javax.resource.spi.LocalTransactionException: Unable to  
>> rollback
>> 	at
>> org 
>> .tranql 
>> .connector 
>> .jdbc 
>> .ManagedJDBCConnection 
>> .localTransactionRollback(ManagedJDBCConnection.java:113)
>> 	at
>> org.tranql.connector.AbstractManagedConnection 
>> $LocalTransactionImpl.rollback(AbstractManagedConnection.java:197)
>> 	at  
>> org 
>> .apache 
>> .geronimo 
>> .connector.outbound.LocalXAResource.rollback(LocalXAResource.java:86)
>> 	... 20 more
>> Caused by: java.sql.SQLException: rollback() should not be called  
>> while in auto-commit mode.
>> 	at  
>> net 
>> .sourceforge 
>> .jtds.jdbc.ConnectionJDBC2.rollback(ConnectionJDBC2.java:2031)
>> 	at
>> org 
>> .tranql 
>> .connector 
>> .jdbc 
>> .ManagedJDBCConnection 
>> .localTransactionRollback(ManagedJDBCConnection.java:111)
>> 	... 22 more
>
> This seems to be the root exception right here.  Looks like the  
> driver is complaining that rollback should not be used when the  
> driver is setup with auto-commit enabled.  Not familiar with the  
> driver, but definitely auto-commit needs to be off for any  
> environment with a transaction manager.
>
> Hope this helps!
>
> -David
>