On 2002.06.10 10:34:04 -0400 Blas Rodriguez Somoza wrote:

> Hello
>
> If each MCF is valid for a url, and to avoid errors, I think there
> must be two patches in the ManagedConnectionFactory
>
> 1.- Because the database can be only one, then it is an error to change
> the database, and the MCF must throw an exception if the
> setDatabase method tries to change the database.
> 2.- If a connection tries to be created before the database is set, then
> an exception must be throw.

I'm not sure these are high priority, but they are fine with me.

>
> I suppose, but I'm not sure, that if we add all the connection
> parameters to CRI including the URL, the ManagedConnectionFactory
> can manage connections to any accesible FB database with only one
> ManagedConnectionFactory instance.
>
> I analyze that because the connection times for repeated connection
> to the same database through FBDriver are to high. After
> some search the problem appears because for each connection a MCF is
> created, and so there is no caching.
>
> If each MCF is valid for all the connections to a url, then FBDriver
> must create a collection (URL,MCF) and reuse MCF. The
> connection parameters excluding url are in the CRI and it seems that MCF
> can manage different CRI's.

This is really against what the jca spec recommends. I think it is a
better idea to cache mcf in the FBDriver using all the supplied properties
that are set as mcf properties. You would also have to substantially
modify the isSameRM() method and might well have to deal with combining
jta/xa support with internal firebird xa support. This is something that is
so complicated with no apparent benefits that I will not work on it. Please
try the simple solution of caching by properties in mcf first. If you
pursue adding the URL to CRI against my advice please explain how the
interactions between a jta tx manager and the firebird tx manager will
work.

thanks
david jencks

>
> Regards
> Blas Rodriguez Somoza
>
> ----- Original Message -----
> From: "David Jencks" <davidjencks@...>
> To: <Firebird-Java@yahoogroups.com>
> Sent: Monday, June 10, 2002 3:28 PM
> Subject: Re: [Firebird-Java] JCA Question
>
>
> > Each instance of a ManagedConnectionFactory should connect to one
> instance
> > of the EIS. The instance of the EIS should be specified somehow in the
> > ManagedConnectionFactory configuration properties: the spec suggests
> some
> > properties such as server, and url as I recall. I interpreted
> "instance of
> > EIS" to mean firebird database, as this seems to me to be what is
> implied
> > by several passages in the spec. If we changed to mean "firebird
> server"
> > or "firebird server accessible through any chain of firebird servers
> from
> > an original server" we would be relying on firebird internal 2pc
> > capabilities and internal transaction manager as well as an external
> jta
> > transaction manager. I don't see any reason to try to do this, even if
> it
> > is possible.
> >
> > david jencks
> >
> >
> > On 2002.06.10 09:11:53 -0400 Blas Rodriguez Somoza wrote:
> > > Hello
> > >
> > > I have a doubt about ManagedConnectionFactory, I don't know if
> one
> > > ManagedConnectionFactory can be used for several Firebird
> > > Databases or there must be one ManagedConnectionFactory instance for
> each
> > > database (url).
> > >
> > > According to specification it seems that one
> ManagedConnectionFactory
> > > can be used to connect to every resource of the same type,
> > > but if this is true it seems that there is a bug in the driver.
> > >
> > > Regards
> > > Blas Rodriguez Somoza.
> > >
> > >
> > >
> > >
> > >
> > > To unsubscribe from this group, send an email to:
> > > Firebird-Java-unsubscribe@yahoogroups.com
> > >
> > >
> > >
> > > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> > >
> > >
> > >
> > >
> > >
> >
> >
> > To unsubscribe from this group, send an email to:
> > Firebird-Java-unsubscribe@yahoogroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>