Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » EMF "Technology" (Ecore Tools, EMFatic, etc)  » [TENEO] Multiple instances using concurrently the same database?
[TENEO] Multiple instances using concurrently the same database? [message #93383] Wed, 15 August 2007 16:32 Go to next message
Eclipse UserFriend
Originally posted by: ovcharov.us.ibm.com

This is a multipart message in MIME format.
--=_alternative 005AFF7DC2257338_=
Content-Type: text/plain; charset="US-ASCII"

Hello,

I am planning to use Teneo/jpox in an environment where multiple Teneo
instances use the same database instance (DB2) at the same time. Is this
supported?

If yes, are there any restrictions or characteristics of Teneo in this
regard that I must consider? For example, are there any potential problems
with concurrent read and update operations from different Teneo instances?
Do I need to setup/configure Teneo specially for this and do I need to use
it in a special fashion? Also, a single Teneo instance - is it thread safe
or do I need to take care about synchronization?

Thank you in advance!

Regards,
Stanislav Ovcharov.

--=_alternative 005AFF7DC2257338_=
Content-Type: text/html; charset="US-ASCII"


<br><font size=1 face="sans-serif">Hello,</font>
<br><font size=1 face="sans-serif">&nbsp;</font>
<br><font size=1 face="sans-serif">I am planning to use Teneo/jpox in an
environment where multiple Teneo instances use the same database instance
(DB2) at the same time. Is this supported? </font>
<br>
<br><font size=1 face="sans-serif">If yes, are there any restrictions or
characteristics of Teneo in this regard that I must consider? For example,
are there any potential problems with concurrent read and update operations
from different Teneo instances? Do I need to setup/configure Teneo specially
for this and do I need to use it in a special fashion? Also, a single Teneo
instance - is it thread safe or do I need to take care about synchronization?</font>
<br>
<br><font size=1 face="sans-serif">Thank you in advance!</font>
<br><font size=1 face="sans-serif">&nbsp;</font>
<br><font size=1 face="sans-serif">Regards,</font>
<br><font size=1 face="sans-serif">Stanislav Ovcharov.</font>
<br>
--=_alternative 005AFF7DC2257338_=--
Re: [TENEO] Multiple instances using concurrently the same database? [message #93416 is a reply to message #93383] Thu, 16 August 2007 17:42 Go to previous messageGo to next message
Martin Taal is currently offline Martin TaalFriend
Messages: 5468
Registered: July 2009
Senior Member
Hi Stanislav,
See comments inline.

gr. Martin

ovcharov@us.ibm.com wrote:
>
> Hello,
>
> I am planning to use Teneo/jpox in an environment where multiple Teneo
> instances use the same database instance (DB2) at the same time. Is this
> supported?
MT>> Teneo does not pose limitations on other programs accessing the db directly.

>
> If yes, are there any restrictions or characteristics of Teneo in this
> regard that I must consider? For example, are there any potential
> problems with concurrent read and update operations from different Teneo
> instances?
MT>> No more problems than with any other multi-user db.

> Do I need to setup/configure Teneo specially for this and do
> I need to use it in a special fashion?
MT>> No not afaics

> Also, a single Teneo instance -
> is it thread safe or do I need to take care about synchronization?
MT>> The initialization should be synchronised, getting the session or persistencemanager is thread
safe. One session or persistence manager should be used by one thread.

>
> Thank you in advance!
>
> Regards,
> Stanislav Ovcharov.


--

With Regards, Martin Taal

Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@springsite.com - mtaal@elver.org
Web: www.springsite.com - www.elver.org
Re: [TENEO] Multiple instances using concurrently the same database? [message #93492 is a reply to message #93416] Fri, 17 August 2007 08:50 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: ovcharov.us.ibm.com

This is a multipart message in MIME format.
--=_alternative 0030C4E5C225733A_=
Content-Type: text/plain; charset="US-ASCII"

Hello Martin,

Thank you for your response!

On my first question you answer that there should not be any problems with
several Teneo instances working with the same database. Is this still the
case if these Teneo instances use absolutely the same object model and
respectively they use the same database tables for concurrent reads and
updates? Is there anything that I need to take care about in this regard?

Best regards,
Stanislav.
--=_alternative 0030C4E5C225733A_=
Content-Type: text/html; charset="US-ASCII"


<br><font size=1 face="sans-serif">Hello Martin,</font>
<br>
<br><font size=1 face="sans-serif">Thank you for your response!</font>
<br>
<br><font size=1 face="sans-serif">On my first question you answer that
there should not be any problems with several Teneo instances working with
the same database. Is this still the case if these Teneo instances use
absolutely the same object model and respectively they use the same database
tables for concurrent reads and updates? Is there anything that I need
to take care about in this regard?</font>
<br>
<br><font size=1 face="sans-serif">Best regards,</font>
<br><font size=1 face="sans-serif">Stanislav.</font>
--=_alternative 0030C4E5C225733A_=--
Re: [TENEO] Multiple instances using concurrently the same database? [message #93535 is a reply to message #93492] Fri, 17 August 2007 13:45 Go to previous message
Martin Taal is currently offline Martin TaalFriend
Messages: 5468
Registered: July 2009
Senior Member
Hi Stanislav,
Yes also if they use the same database/set of tables. There are no more problems than with any other
multi-user access to one database/one set of tables. With any multi-user access to one database/set
of tables you can have concurency issues but teneo does not make this worse (or better).

gr. Martin

ovcharov@us.ibm.com wrote:
>
> Hello Martin,
>
> Thank you for your response!
>
> On my first question you answer that there should not be any problems
> with several Teneo instances working with the same database. Is this
> still the case if these Teneo instances use absolutely the same object
> model and respectively they use the same database tables for concurrent
> reads and updates? Is there anything that I need to take care about in
> this regard?
>
> Best regards,
> Stanislav.


--

With Regards, Martin Taal

Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@springsite.com - mtaal@elver.org
Web: www.springsite.com - www.elver.org
Re: [TENEO] Multiple instances using concurrently the same database? [message #609472 is a reply to message #93383] Thu, 16 August 2007 17:42 Go to previous message
Martin Taal is currently offline Martin TaalFriend
Messages: 5468
Registered: July 2009
Senior Member
Hi Stanislav,
See comments inline.

gr. Martin

ovcharov@us.ibm.com wrote:
>
> Hello,
>
> I am planning to use Teneo/jpox in an environment where multiple Teneo
> instances use the same database instance (DB2) at the same time. Is this
> supported?
MT>> Teneo does not pose limitations on other programs accessing the db directly.

>
> If yes, are there any restrictions or characteristics of Teneo in this
> regard that I must consider? For example, are there any potential
> problems with concurrent read and update operations from different Teneo
> instances?
MT>> No more problems than with any other multi-user db.

> Do I need to setup/configure Teneo specially for this and do
> I need to use it in a special fashion?
MT>> No not afaics

> Also, a single Teneo instance -
> is it thread safe or do I need to take care about synchronization?
MT>> The initialization should be synchronised, getting the session or persistencemanager is thread
safe. One session or persistence manager should be used by one thread.

>
> Thank you in advance!
>
> Regards,
> Stanislav Ovcharov.


--

With Regards, Martin Taal

Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@springsite.com - mtaal@elver.org
Web: www.springsite.com - www.elver.org
Re: [TENEO] Multiple instances using concurrently the same database? [message #609477 is a reply to message #93416] Fri, 17 August 2007 08:50 Go to previous message
Eclipse UserFriend
Originally posted by: ovcharov.us.ibm.com

This is a multipart message in MIME format.
--=_alternative 0030C4E5C225733A_=
Content-Type: text/plain; charset="US-ASCII"

Hello Martin,

Thank you for your response!

On my first question you answer that there should not be any problems with
several Teneo instances working with the same database. Is this still the
case if these Teneo instances use absolutely the same object model and
respectively they use the same database tables for concurrent reads and
updates? Is there anything that I need to take care about in this regard?

Best regards,
Stanislav.
--=_alternative 0030C4E5C225733A_=
Content-Type: text/html; charset="US-ASCII"


<br><font size=1 face="sans-serif">Hello Martin,</font>
<br>
<br><font size=1 face="sans-serif">Thank you for your response!</font>
<br>
<br><font size=1 face="sans-serif">On my first question you answer that
there should not be any problems with several Teneo instances working with
the same database. Is this still the case if these Teneo instances use
absolutely the same object model and respectively they use the same database
tables for concurrent reads and updates? Is there anything that I need
to take care about in this regard?</font>
<br>
<br><font size=1 face="sans-serif">Best regards,</font>
<br><font size=1 face="sans-serif">Stanislav.</font>
--=_alternative 0030C4E5C225733A_=--
Re: [TENEO] Multiple instances using concurrently the same database? [message #609480 is a reply to message #93492] Fri, 17 August 2007 13:45 Go to previous message
Martin Taal is currently offline Martin TaalFriend
Messages: 5468
Registered: July 2009
Senior Member
Hi Stanislav,
Yes also if they use the same database/set of tables. There are no more problems than with any other
multi-user access to one database/one set of tables. With any multi-user access to one database/set
of tables you can have concurency issues but teneo does not make this worse (or better).

gr. Martin

ovcharov@us.ibm.com wrote:
>
> Hello Martin,
>
> Thank you for your response!
>
> On my first question you answer that there should not be any problems
> with several Teneo instances working with the same database. Is this
> still the case if these Teneo instances use absolutely the same object
> model and respectively they use the same database tables for concurrent
> reads and updates? Is there anything that I need to take care about in
> this regard?
>
> Best regards,
> Stanislav.


--

With Regards, Martin Taal

Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@springsite.com - mtaal@elver.org
Web: www.springsite.com - www.elver.org
Previous Topic:[Teneo] Problem with the length of element names
Next Topic:[Teneo] Proxies in 0.7.5?
Goto Forum:
  


Current Time: Sun Oct 02 23:13:30 GMT 2022

Powered by FUDForum. Page generated in 0.06031 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top