Using JDBC with iSeries 400 WebSphere applications
One of the primary techniques to access the iSeries 400 database from WebSphere applications is JDBC. Using JDBC, you can work with any valid SQL statement to access and modify data in your database. Some of the topics included in this lab are: The two JDBC drivers provided with iSeries 400: where and when to use each, Basic concepts of JDBC: driver manager, connection, statement and result set, Using prepared statements, JDBC 2.0 features: scrollable result sets, connection pooling, row sets, and Configuring JDBC in WebSphere.

Craig Pelkie   is a frequent speaker at seminars and user group meetings around the country. Craig has written many articles for the major industry publications (Midrange Computing, News/400) and is an on-going contributor to iSeries 400 Experts Journal. Craig is a coauthor of four IBM Redbooks and the creator of the IBM Learning Services Net.Data course. Craig currently works with The 400 School to deliver customized training courses for Java and WebSphere projects. He maintains a web site at www.web400.com with many articles and code samples freely available to the iSeries 400 community.