|
Hi. I'm playing with FB provider and have a question about
connection pool and this is the scenario: I have a main form which launches instances of other form
which has a data grid bound to dataset's table. The second form gets its
connection from public method on first form which, wrongly, is: Public
Function Conexion() As
FirebirdSql.Data.FirebirdClient.FbConnection Dim con As
FirebirdSql.Data.FirebirdClient.FbConnection = _ New
FirebirdSql.Data.FirebirdClient.FbConnection() con.ConnectionString = Global.WindowsApplication1.My.MySettings.Default.DATOS_ConnectionString Return con
End Function I said wrongly because each time Conexion() is called
new connection will be created. When I realize that I think that I will found a lot of
connections opened in my FB server but, surprise! Just 3 connections where
opened: one for IBExpert (where I see the opended connections), one for VS and
one for my running program. Question: Is provider checking if the same connection string is
used and not opening new connection, uses the already opened one? Or provider closes connection after rows where fetched? Regards. |
Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
