geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Jencks <david_jen...@yahoo.com>
Subject Re: Transactions are commited only when Server shuts down.
Date Wed, 03 Sep 2008 17:09:02 GMT

On Sep 3, 2008, at 5:46 AM, MichaelHaeublein wrote:

>
> Well we use OpenJPA not Tranql...
> Next problem is, I'm a beginner concerning Geronimo, EJB3.0 and  
> Transaction
> stuff...
> I don't really know how to debug through "foreign" code.
>
> I recently found out, that if I only restart the connection pool in  
> the
> Geronimo Admin Console,
> the changes are also commited/written to database. So maybe the  
> connection
> or transaction is not closed properly? But as we use container managed
> entities this should happen autmaticaly, or did I get anything wrong  
> about
> that?
> Could It be a problem with the version of the OJDBC Driver?

Can you show your persistence.xml and any plans used to deploy a  
datasource, along with which adapter you are using?

thanks
david jencks

>
>
>
>
> djencks wrote:
>>
>> 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.
>>>
>>
>>
>>
>
> -- 
> View this message in context: http://www.nabble.com/Transactions-are-commited-only-when-Server-shuts-down.-tp19251568s134p19288501.html
> Sent from the Apache Geronimo - Users mailing list archive at  
> Nabble.com.
>


Mime
View raw message