Database Connection Pooling with Tomcat (12 tags)
You know how to open and use database connections for each user, but what about optimizing for many concurrent users? Rather than creating and destroying connections over and over again, established practice calls for use of a pool of connections that can be reused. Kunal Jaggi shows how to implement this strategy in Tomcat.
Encrypting Connection Strings in Web.config (10 tags)
One of the best practices in ASP.NET is to save your database connection strings in the Web.config file instead of hard-coding it in your code. It's not such a good idea to save your connection strings as plain text in Web.config you should ideally encrypt the connection strings so it leaves no chance for a potential hacker to easily get more information about your database server. In ASP.NET 2.0, Microsoft has taken this further by allowing you to encrypt the connection strings in Web.config, all without much plumbing on your part. In this new article by Wei-Meng Lee, he shows you how it works!
ADO.NET Connection Pooling Explained (2 tags)
Because the .NET managed providers manage the connection pool for us, using shared database connections is as easy as a summertime splash in the kiddie pool. But if those connections unexpectedly become invalid you could find yourself floundering in the deep end. In this new article, James Still will have you doing laps in no time.