Re[2]: Using Slide transaction's connection

[Lukasz Kowalczyk <lu...@jazzpolice.pl>]

Tuesday, August 27, 2002, 10:08:04 PM, you wrote:

TW> Lukasz,

TW> The database connections are completely hidden by each store implementation.
TW> I suggest you can modify the store impl (e.g. J2EEDescriptorsStore) and add
TW> a pointer to the connection in the thread context.  This way you can
TW> retrieve the same connection used by Slide store from the thread context
TW> when updating your own data.

Thanks for idea. It looks like a major hack ;)  I was also thinking
about plugging my own TransactionManager (or my own Transaction, not
sure yet). Does this sound feasible to you?

TW> Tom Wang
TW> Panscopic Corporation
TW> Web Reporting, Just Add Data
TW> http://www.panscopic.com/


>> -----Original Message-----
>> From: Lukasz Kowalczyk [mailto:lukasz@jazzpolice.pl]
>> Sent: Tuesday, August 27, 2002 7:40 AM
>> To: slide-user@jakarta.apache.org
>> Subject: Using Slide transaction's connection
>>
>>
>> I have a few tables in the same database that Slide keeps its tables
>> in and those tables are updated together with modifications in Slide's
>> repository.
>>
>> I need to keep changes to Slide and to my tables in synchronization.
>> My first thought was to use 2-phase commit but PostgreSQL doesn't
>> support it and I don't know of any other free RDBMS which does (and
>> which runs on Windows).
>>
>> Having explained this - is there a way to obtain Slide's connection to
>> the database after calling NamespaceAccessToken.begin()? This way I
>> could rollback or commit all changes at once.
>>
>> --
>> Łukasz Kowalczyk
>>
>>
>> --
>> To unsubscribe, e-mail:
>> <ma...@jakarta.apache.org>
>> For additional commands, e-mail:
>> <ma...@jakarta.apache.org>
>>
>>


TW> --
TW> To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
TW> For additional commands, e-mail: <ma...@jakarta.apache.org>




-- 
Łukasz Kowalczyk


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

Re[4]: Using Slide transaction's connection

[Lukasz Kowalczyk <lu...@jazzpolice.pl>]

Wednesday, August 28, 2002, 5:36:01 PM, you wrote:

TW> Whoo ..  that sounds a lot of work but I probably don't fully understand
TW> what you mean by plug in.  Slide's transaction framework supports XA

I simply meant to replace Slide's TransactionManager with a patched or
brand new version. I have a few services (built upon Jakarta Fulcrum)
and all of them are using the same database. I also put together a
little neat service on top of Slide and that's why I thought of making
a common transaction manager for all the services.

TW> transactions and is a well done grand piece of work (my hat off to the
TW> developers).  Also, at the app layer you only have access to
TW> NameSpaceAccessToken (represents a UserTransaction) so you'll need to get
TW> hold of the transaction somehow.  That's why I suggested using thread
TW> context.

-- 
Łukasz Kowalczyk


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

RE: Re[2]: Using Slide transaction's connection

[Tom Wang <to...@panscopic.com>]

Whoo ..  that sounds a lot of work but I probably don't fully understand
what you mean by plug in.  Slide's transaction framework supports XA
transactions and is a well done grand piece of work (my hat off to the
developers).  Also, at the app layer you only have access to
NameSpaceAccessToken (represents a UserTransaction) so you'll need to get
hold of the transaction somehow.  That's why I suggested using thread
context.

Tom Wang
Panscopic Corporation
Report All That You Can Report
http://www.panscopic.com/download


> -----Original Message-----
> From: Lukasz Kowalczyk [mailto:lukasz@jazzpolice.pl]
> Sent: Wednesday, August 28, 2002 3:38 AM
> To: Slide Users Mailing List; tomw@panscopic.com
> Subject: Re[2]: Using Slide transaction's connection
>
>
> Tuesday, August 27, 2002, 10:08:04 PM, you wrote:
>
> TW> Lukasz,
>
> TW> The database connections are completely hidden by each store
> implementation.
> TW> I suggest you can modify the store impl (e.g.
> J2EEDescriptorsStore) and add
> TW> a pointer to the connection in the thread context.  This way you can
> TW> retrieve the same connection used by Slide store from the
> thread context
> TW> when updating your own data.
>
> Thanks for idea. It looks like a major hack ;)  I was also thinking
> about plugging my own TransactionManager (or my own Transaction, not
> sure yet). Does this sound feasible to you?
>
> TW> Tom Wang
> TW> Panscopic Corporation
> TW> Web Reporting, Just Add Data
> TW> http://www.panscopic.com/
>
>
> >> -----Original Message-----
> >> From: Lukasz Kowalczyk [mailto:lukasz@jazzpolice.pl]
> >> Sent: Tuesday, August 27, 2002 7:40 AM
> >> To: slide-user@jakarta.apache.org
> >> Subject: Using Slide transaction's connection
> >>
> >>
> >> I have a few tables in the same database that Slide keeps its tables
> >> in and those tables are updated together with modifications in Slide's
> >> repository.
> >>
> >> I need to keep changes to Slide and to my tables in synchronization.
> >> My first thought was to use 2-phase commit but PostgreSQL doesn't
> >> support it and I don't know of any other free RDBMS which does (and
> >> which runs on Windows).
> >>
> >> Having explained this - is there a way to obtain Slide's connection to
> >> the database after calling NamespaceAccessToken.begin()? This way I
> >> could rollback or commit all changes at once.
> >>
> >> --
> >> Łukasz Kowalczyk
> >>
> >>
> >> --
> >> To unsubscribe, e-mail:
> >> <ma...@jakarta.apache.org>
> >> For additional commands, e-mail:
> >> <ma...@jakarta.apache.org>
> >>
> >>
>
>
> TW> --
> TW> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
TW> For additional commands, e-mail:
<ma...@jakarta.apache.org>




--
Łukasz Kowalczyk


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>



--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>