Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.

ID: 16116, Interbase connection pool

by Marcelo Lopez Ruiz Email: Anonymous

This is a unit which can be used to implement a pool of Interbase
connections in a process.
Download Details
FTP  download also available
CDN Login Required to Download. (You will be redirected to the login page if you click on the Download Link)
To download this, you must have registered:
A free membership

For Delphi, Version 5.0  to 5.0 749 downloads
Copyright: No significant restrictions

Size: 3,280 bytes
Updated on Thu, 10 May 2001 06:32:02 GMT
Originally uploaded on Thu, 10 May 2001 06:31:06 GMT
SHA1 Hash: 0C08F54F7D5E6D1805E3A4CACAEE4C9CF2F87E69
MD5 Hash: 3DBF5CDD4E565A62BADA649D365BEF48

    Explore the files in this upload

The unit implements a pool of Interbase connections, and is meant to be accessed by two routines: ConnectDatabaseFromPool and DisconnectDatabaseToPool.

If there are no available connections, a new connection is created and returned immediately. When a database is disconnected to the pool, the connection is kept open, and only the component gets disconnected; the real connection is left available for the next request.

The reason I created this pool is to port ADO-based applications. In ADO, connections are usually pooled, so the fastest way is to connect, use and disconnect. This is used a lot for building scriptable components and using them in Windows DNA-like architectures (presentation tier, business tier, data tier).

I typically keep my presentation tier in HTML and ASP, my business tier in scriptable objects, and my data tier in data modules. Each operation in the business tier will create a data module, use it, and destroy it, so the business tier object is always stateless.

See readme.txt for more information.

   Latest Comments  View All Add New

Move mouse over comment to see the full text

Could not retrieve comments. Please try again later.

Server Response from: ETNACDC03