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

Creating connection objects in SQLJ applications


To establish a connection to the database, we use connection contexts in the SQLJ application. A connection context specifies the database details, transaction behavior, and session to be used in the application. In this recipe, we will focus on the different ways of establishing database connections in SQLJ applications.

Getting ready

DB2 supports IBM Data Server Driver for JDBC and SQLJ for SQLJ applications. This driver is packaged as db2jcc.jar and sqlj.zip for JDBC 3.0 and as db2jcc4.jar and sqlj4.zip for JDBC 4.0. This driver allows us to use type-2 and type-4 type connectivity.

This driver is shipped with DB2.

How to do it...

The basic idea with all these techniques is to create a connection context based on an interface that can identify the database. The database can be represented by a DataSource interface or a DriverManager interface. We use these interfaces as arguments for the context class constructor method.

  1. 1. Technique 1 : This...