Conclusion

Connection caches are one of the primary facets of an application server that supports building highly scalable, database-intensive applications with optimal usage of available connectivity resources. Making the most efficient use of database connectivity in an n-tier application is predicated on an understanding of the cooperation between the cache manager and the component logic that interacts with the provided connections.

With EAServer and PowerBuilder specifically, the tight integration and retention of familiar client/server programming constructs, such as the CONNECT and DISCONNECT statements, make using connection caches in this environment very straightforward.

EAServer's support of the ODBC, CT-Library, and Oracle OCI APIs ...

Get PowerBuilder® 9: Internet and Distributed Application Development now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.