DB2 Java Stored Procedures Learning by Example

Abstract

Stored procedures can provide major benefits in the areas of application performance, code re-use, security, and integrity. The DB2 Family of products has offered support for stored procedures for some time, with each release offering significant enhancements over the last.

In the meantime, Java's inherent portability and openness, combined with the availability of skilled programming resource, has made it an increasingly attractive choice as the central plank in the e-business strategy of many organizations.

Until recently, DB2 did not support stored procedures written in Java, so the advantages of the two technologies could not be combined. The latest releases of DB2 have changed all that, opening up new possibilities for secure, highly portable application development.

This IBM Redbook aims to give the reader an in-depth understanding of the techniques and issues associated with the development of DB2 stored procedures written in SQLJ and JDBC. The extensive collection of sample code presented in this book and included on the accompanying CD-ROM was designed to run against DB2 UDB Server across the OS/390, Windows, and UNIX platforms.

Table of Contents

Part 1. Background

Chapter 1. Java platform support

Chapter 2. Java and DB2

Part 2. Developing Java stored procedures

Chapter 3. Java Sample application: The ACME software company

Chapter 4. System setup

Chapter 5. Designing Java stored procedures

Chapter 6. Coding Java stored procedures

Chapter 7. Preparing Java stored procedures

Chapter 8. Deployment and execution

Chapter 9. Client applications invoking Java stored procedures

Chapter 10. Migration of DB2 for OS/390 Version 5 to Version 6

Part 3. DB2 UDB for OS/390 V6 -- various enhancements

Chapter 11. DB2 UDB for OS/390 network computing enhancements

Chapter 12. DB2 UDB for OS/390 schema support

Chapter 13. DB2 UDB for OS/390 stored procedures enhancements

Part 4. Appendices

Appendix A. New messages and error codes

Appendix B. Sample code, DDL, and preparation scripts

Appendix C. OS/390 Recoverable Resource Services (RRS)

Appendix D. Define WLM stored procedure address space

Appendix E. Using the additional material

SOURCE : http://publib-b.boulder.ibm.com/Redbooks.nsf/9445fa5b416f6e32852569ae006bb65f/742209f135fb0fcc88256877006ab27d?OpenDocument&Highlight=0,udb