Fwd: Re: [Glorp-development] Multiple Glorp Sessions on one database connection ?

X-Mailer: QUALCOMM Windows Eudora Version 7.1.0.9
Date: Wed, 13 Dec 2006 11:37:53 -0500
To: "Mark Plas" <[hidden email]>,
        <[hidden email]>
From: Alan Knight <[hidden email]>
X-magma-MailScanner-Information: Magma Mailscanner Service
X-magma-MailScanner: Clean
X-Spam-Status:
X-Spam-Score: 1.7 (+)
X-Spam-Report: Spam Filtering performed by sourceforge.net.
        See http://spamassassin.org/tag/ for more details.
        Report problems to
         http://sf.net/tracker/?func=add&group_id=1&atid=200001
        1.0 FORGED_RCVD_HELO       Received: contains a forged HELO
        0.2 HTML_TEXT_AFTER_BODY BODY: HTML contains text after BODY close tag
        0.0 HTML_MESSAGE           BODY: HTML included in message
        0.5 HTML_20_30             BODY: Message is 20% to 30% HTML
Subject: Re: [Glorp-development] Multiple Glorp Sessions on one database
 connection ?
X-BeenThere: [hidden email]
X-Mailman-Version: 2.1.8
List-Id: <glorp-development.lists.sourceforge.net>
List-Unsubscribe: < https://lists.sourceforge.net/lists/listinfo/glorp-development >,
         <[hidden email] >
List-Archive: < http://sourceforge.net/mailarchive/forum.php?forum=glorp-development >
List-Post: <[hidden email]>
List-Help: <[hidden email] >
List-Subscribe: < https://lists.sourceforge.net/lists/listinfo/glorp-development >,
         <[hidden email] >
Sender: [hidden email]
X-pstn-levels:     (S:99.90000/99.90000 R:95.9108 P:95.9108 M:97.0282 C:98.6951 )

Yes, that should be fine. I actually do something like that now, in that StoreForGlorp by default for most operations uses the current open Store connection. That's not two Glorp sessions at the same time (although if you did two StoreGlorp operations at once, it would be) but sharing a connection with the Store codebase. That seems to have no problems as long as you're not trying to have both of them access the connection at once.

At 09:19 AM 12/13/2006, Mark Plas wrote:

My sessions would not access the database connection concurrently (as it would undoubtedly result in crashes if they would). Would it be allowed to use the sessions in such a way ?
 
Thanks,
Mark
 

---

From: [hidden email] [ [hidden email]] On Behalf Of Alan Knight
Sent: woensdag 13 december 2006 15:07
To: Mark Plas; [hidden email]
Subject: Re: [Glorp-development] Multiple Glorp Sessions on one database connection ?
 
It is possible, but I think it's probably not a good idea. I don't know that there's any mutual exclusion at the EXDI layer. I've certainly seen issues with the postgresql connect if two connections try to use it at the same time. I'm not sure about other connects that are calling out to C libraries. But beyond basic mutual exclusion, the database connection is what keeps track of your transaction context. Sharing that with other people is not going to work at all when writing, and could be problematic even reading. It would likely be better to have a connection pooling mechanism.

At 04:49 AM 12/13/2006, Mark Plas wrote:

Content-class: urn:content-classes:message
Content-Type: multipart/alternative;
         boundary="----_=_NextPart_001_01C71E9C.0515B0AC"

Hi,
 
This mail is part of a set of glorp questions I have (see some other mails I've sent recently).
 
The question I would like to address here is:
 
Is it possible to have multipe Glorp Sessions working on the same database connection ? It seems to be so, but I haven’t tried it.
 
Thanks,
Mark
 
 
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Glorp-development mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/glorp-development

--
Alan Knight [|], Cincom Smalltalk Development
[hidden email]
[hidden email]
http://www.cincom.com/smalltalk

"The Static Typing Philosophy: Make it fast. Make it right. Make it run." - Niall Ross

--
Alan Knight [|], Cincom Smalltalk Development
[hidden email]
[hidden email]
http://www.cincom.com/smalltalk

"The Static Typing Philosophy: Make it fast. Make it right. Make it run." - Niall Ross
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Glorp-development mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/glorp-development

Is there existing code that will do connection pooling for EXDI?  I am
working on a Seaside application that needs a database and I'd like to do
this as efficiently as I can.

Thanks,

-Carl Gundel
http://www.runbasic.com 

ODBC has connection pooling support as of some recent version of
VisualWorks,

ODBCConnection connectionPooling: true.

Others I suspect you'll need to implement yourself, although in most
cases I'd go the simple route and address the problem if it ever becomes
one, which may not even be the case.

Cheers!

-Boris

--
+1.604.689.0322
DeepCove Labs Ltd.
4th floor 595 Howe Street
Vancouver, Canada V6C 2T5
http://tinyurl.com/r7uw4

[hidden email]

CONFIDENTIALITY NOTICE

This email is intended only for the persons named in the message
header. Unless otherwise indicated, it contains information that is
private and confidential. If you have received it in error, please
notify the sender and delete the entire message including any
attachments.

Thank you.

> -----Original Message-----
> From: Carl Gundel [mailto:[hidden email]]
> Sent: Monday, June 25, 2007 5:32 PM
> To: [hidden email]
> Subject: EXDI connection pooling?
>
> Is there existing code that will do connection pooling for EXDI?  I am
> working on a Seaside application that needs a database and I'd like to
do
> this as efficiently as I can.
>
> Thanks,
>
> -Carl Gundel
> http://www.runbasic.com
>

also the Oracle EXDI supports connection pooling: load OracleThapiCPEXDI

HTH
Helge

-----Ursprüngliche Nachricht-----
Von: Boris Popov [mailto:[hidden email]]
Gesendet: Dienstag, 26. Juni 2007 02:36
An: Carl Gundel; [hidden email]
Betreff: RE: EXDI connection pooling?

ODBC has connection pooling support as of some recent version of VisualWorks,

ODBCConnection connectionPooling: true.

Others I suspect you'll need to implement yourself, although in most cases I'd go the simple route and address the problem if it ever becomes one, which may not even be the case.

Cheers!

-Boris

--
+1.604.689.0322
DeepCove Labs Ltd.
4th floor 595 Howe Street
Vancouver, Canada V6C 2T5
http://tinyurl.com/r7uw4

[hidden email]

CONFIDENTIALITY NOTICE

This email is intended only for the persons named in the message header. Unless otherwise indicated, it contains information that is private and confidential. If you have received it in error, please notify the sender and delete the entire message including any attachments.

Thank you.

> -----Original Message-----
> From: Carl Gundel [mailto:[hidden email]]
> Sent: Monday, June 25, 2007 5:32 PM
> To: [hidden email]
> Subject: EXDI connection pooling?
>
> Is there existing code that will do connection pooling for EXDI?  I am
> working on a Seaside application that needs a database and I'd like to
do
> this as efficiently as I can.
>
> Thanks,
>
> -Carl Gundel
> http://www.runbasic.com
>