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-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=MG1A0cxJ24jdw5xm56m/aMZejm9pCbvnsn+RF6WagHQFzMUPjpZ39Fd17Uuxw2mKGlLMX+akvHbWg38tVb3588ZSf1H866dPnXlIn3vQrWmYCIFYeQCjqhFzshJOYxekvUDcPAcn6fUgOKvy0smhkw1Z6W5NOf8luN98cUSJeRM=
  ;
Message-Id: <38A5EC4E-EA19-438B-AC07-EFA1306CF54A@yahoo.com>
From: David Jencks <david_jencks@yahoo.com>
To: user@geronimo.apache.org
In-Reply-To: <19283314.post@talk.nabble.com>
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0 (Apple Message framework v926)
Subject: Re: Transactions are commited only when Server shuts down.
Date: Tue, 2 Sep 2008 23:40:50 -0700
References: <19251568.post@talk.nabble.com> <48BDDEFB.2090103@apache.org>
 <19283314.post@talk.nabble.com>

I really think the most likely explanation for this is that the  
commitBeforeAutocommit value you are supplying is not getting to the  
tranql connector.  If I was investigating this I would debug through  
the tranql code to see if the code does try to commit.

thanks
david jencks

On Sep 2, 2008, at 10:55 PM, MichaelHaeublein wrote:

>
> Hi,
>
> We are using neither of them. We use a JDBC driver (ojdbc-14.jar)  
> for the
> connectionn pool.
>
>
> Donald Woods-2 wrote:
>>
>> Are you using the provided tranql-connector-oracle-local-1.3.rar or
>> tranql-connector-oracle-xa-1.3.rar for the server db connection pool?
>>
>>
>> -Donald
>>
>> MichaelHaeublein wrote:
>>> Hello,
>>>
>>> Me any my colleauge are working on client-server-application,
>>> which is using geronimo as an application server and an client
>>> using Swing.
>>>
>>> For Database Access we use Beans (EJB 3.0).
>>> The problem is, all transactions (Updates, Inserts, Deletes)
>>> are not commited to the database after the transaction is closed.
>>> Only when shutting down the server all previously made changes
>>> are commited to the database.
>>>
>>> We allready found this thread here
>>> http://www.nabble.com/transaction-behaviour-td2470965s134.html#a2470965
>>>
>>> We tried to set the option CommitBeforeAutocommit to true as  
>>> suggested
>>> there,
>>> but this didn't have any effect.
>>>
>>>
>>>
>>> Some techniqual details about the project:
>>>
>>> Server: Geronimo Version 2.1.1
>>> Database: Oracle 9.1
>>> Connection-Pool with: Oracle Thin Driver (oracle.jdbc.OracleDriver)
>>>
>>> Here's one of the Methodes which is not beeing commited as expected.
>>> ---------------------------------------------------------------------
>>> @Stateless
>>> @Remote(AccessRemote.class)
>>> @Local(Access.class)
>>> public class AccessSessionBean implements Access {
>>>
>>>  @PersistenceContext(unitName = "FMDBPU")
>>>  EntityManager manager;
>>>
>>>  @TransactionAttribute(TransactionAttributeType.REQUIRED)
>>>  public void updateUserPassword(UserValueObject uservo)
>>>    throws NotFoundException, Exception {
>>>    UserBean bb = manager.find(UserBean.class, uservo.getUserId());
>>>    bb.setPass(uservo.getPass());
>>>    manager.flush();
>>>  }
>>> }
>>> ---------------------------------------------------------------------
>>>
>>> Any ideas what's going wrong?
>>
>>
>>
>
> -- 
> View this message in context: http://www.nabble.com/Transactions-are-commited-only-when-Server-shuts-down.-tp19251568s134p19283314.html
> Sent from the Apache Geronimo - Users mailing list archive at  
> Nabble.com.
>