Book Image

IBM DB2 9.7 Advanced Application Developer Cookbook

Book Image

IBM DB2 9.7 Advanced Application Developer Cookbook

Overview of this book

With lots of new features, DB2 9.7 delivers one the best relational database systems in the market. DB2 pureXML optimizes Web 2.0 and SOA applications. DB2 LUW database software offers industry leading performance, scale, and reliability on your choice of platform on various Linux distributions, leading Unix Systems like AIX, HP-UX and Solaris and MS Windows platforms. This DB2 9.7 Advanced Application Developer Cookbook will provide an in-depth quick reference during any application's design and development. This practical cookbook focuses on advanced application development areas that include performance tips and the most useful DB2 features that help in designing high quality applications. This book dives deep into tips and tricks for optimized application performance. With this book you will learn how to use various DB2 features in database applications in an interactive way.
Table of Contents (15 chapters)
IBM DB2 9.7 Advanced Application Developer Cookbook
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface

Handling errors and warnings in JDBC applications


A Java application uses its own way of catching exceptions. An error is commonly referred to as an exception in Java applications. An exception can be recognized by an exception class. A try block can have multiple catch blocks. The idea is to handle every possibility of the error condition. JDBC also provides some standard exception classes that can be used to capture the basic information. Apart from them, DB2 also provides its own exception classes that can be used for better diagnosis. In this recipe, we will focus on exception handling in Java applications.

Getting ready

JDBC applications use try and catch blocks to handle different exceptions. There is no exception thrown in the case of warnings. To handle warnings in JDBC applications, we need to explicitly check for warnings. We can use the getWarning() method to retrieve warnings as a SQLWarning object that has the following information:

  • Description of the warning

  • SQLSTATE

  • Error...