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 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.

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/
>
>
>