John Goodson

Subscribe to John Goodson: eMailAlertsEmail Alerts
Get John Goodson: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn

Top Stories by John Goodson

Pooling is great - except it's not very tunable, it's hard to map end users back to connections in the pool, and if a connection ever becomes invalid inside the pool, expunging only that connection from the pool is nearly impossible; JDBC 4.0 addresses all these drawbacks As a member of every previous JDBC Expert Group, it sometimes seems as if the specification process moves too slowly for the few features being added or it seems as if the new feature list is good, but "not good enough." The JDBC 4.0 specification fits neither of these perceptions. The specification includes a lot of new features - too many, in fact, to describe in this article. As this article was written a few months before the publication of the public draft of the JDBC 4.0 specification, it's possible that some features, features even more significant than those described here, might make it int... (more)

Java Feature — JDBC 4.0

It's been over three years since the JDBC Expert Group held its first meeting to gather requirements, requests, and pipe dreams for the JDBC 4.0 specification. In that meeting, we discussed a wide variety of topics, including performance enhancements, clarifications on the existing JDBC 3.0 specification, and Ease of Development features. Unbelievably, everything but the kitchen sink ended up making it into the release. In this article, we'll look at several key features that made the enhancement list for JDBC 4.0, and we'll discuss why those features are important. At the time ... (more)

Best Practices for SOA: Building a Data Services Layer

These days nearly every sizable organization has either implemented some form of SOA or has it on their roadmap. They quickly find that SOA efforts tend to expand like spider webs, eventually touching every corner of IT as well as the business itself. Due to the vital role that data plays both in business and systems operations, database architects, information specialists, data integration experts, and anyone responsible for data persistence in an organization are increasingly being called on to contribute to their organization’s SOA initiatives – whether or not this was intende... (more)

JDBC 3.0 - Something for Everyone

There was no ticker tape parade to accompany the release of the JDBC 3.0 specification, but many will be pleasantly surprised at its list of enhancements that include everything from performance-tuning options to support for extended-level database features. This article describes, in detail, the new features that are available in JDBC 3.0 and explains why they are important. The JDBC 3.0 specification was shipped as part of the J2SE 1.4 release early in 2002. The key goals of the JDBC Expert Panel were to align with the most important features of SQL99, combine all the previous ... (more)

Deployment Of Java Server Pages

While Java databases have become essential for Web applications, developing performance-oriented Java Database Connectivity (JDBC) applications can be challenging. But by following tried-and-true approaches, it is possible to develop and fine-tune JDBC applications to make them run faster, jump higher, and make fewer trips to the database. Below, we present practical guidelines for many of the common JDBC applications. Guideline 1: Use Metadata With Care The first guideline is to be careful about using metadata. Although it's almost impossible to write JDBC applications without d... (more)