O'Reilly logo

J2EE™ Applications and BEA™ WebLogic Server™ by Sandra L. Emerson, Rob Woollen, Michael Girdley

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Best Practices for JDBC

There are a number of best practices that enable your JDBC-based applications to be as successful as possible:

Make Your Queries as Smart as Possible

Learning to select only the data you really want at the server side is crucial. For many applications where performance is a problem, it is often due to poorly written SQL. Typical problems include returning too many rows, queries that are too general, and so forth. There are many tricks for SQL that are worth learning to optimize performance. Some are simple while some are complicated. While SQL joins and subqueries are beyond the scope of this book, there are simple things that you can do to improve your performance, such as using prepared statements and accessing stored ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required