🚀 go-pugleaf

estrin!kswanson (Kevin Swanson) writes:

>I'm working on an application that uses dbkit along with sybase.
>I've come across the problem that my application makes two and sometimes
>three connections to the sybase server, when it really should only need
>a single connection.

>Has anyone who has worked with dbkit experienced any problems like this?

  Yes, actually.  The problem is that DBBinder defaults to use non-shared
context (this is where the connection is stored) when you really want it to
share the context.  You can set the context sharing with 

  [aBinder setSharesContext: flag];

  What I did to get around this problem was to impelement a subclass of
DBBinder called SharedBinder that goes something like:

#import <dbkit/dbkit.h>

@interface SharedBinder : DBBinder
{
}
- init;
- setSharesContext: (BOOL) flag
@end

@implementation SharedBinder
- init
{
  return [[super init] setSharesContext: YES];
}

- setSharesContext: (BOOL) flag
{
  return [super setSharesContext: YES];
}
@end

   To get this to effect the binders that DBKit sets up for you, you will
have to do a:

   [SharedBinder poseAs: [DBBinder class]];

  before they are allocated.  The best place is probably in you *_main.m
file or in your appWillInit: method. 
   
   You will want to note that sharing context with other DBBinders disables
flushing.  I haven't experienced any problems with this, but depending upon
what you are doing, you might.

>thanks,
>kevin


>kswanson@rdr.com


Timothy J. Wood
The Omni Group
DBKit Consulting

estrin!kswanson (Kevin Swanson) writes:

>I'm working on an application that uses dbkit along with sybase.
>I've come across the problem that my application makes two and sometimes
>three connections to the sybase server, when it really should only need
>a single connection.

>Has anyone who has worked with dbkit experienced any problems like this?

>thanks,
>kevin


>kswanson@rdr.com


I've experienced similar problems. At one point it seemed that every
instance of RecordList make a separate connections to sybase.

fouad

In article <C0q3w5.2Lq@unix.portal.com> pyramid@shell.portal.com (Fouad Habboub) writes:
>estrin!kswanson (Kevin Swanson) writes:
>
>>I'm working on an application that uses dbkit along with sybase.
>>I've come across the problem that my application makes two and sometimes
>>three connections to the sybase server, when it really should only need
>>a single connection.
>
>>Has anyone who has worked with dbkit experienced any problems like this?
>
>>thanks,
>>kevin
>
>
>>kswanson@rdr.com
>
>
>I've experienced similar problems. At one point it seemed that every
>instance of RecordList make a separate connections to sybase.
>
>fouad
>

no, only instances of DBDatabase create new tcp connections to the
db server.

George