For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at firstname.lastname@example.org.
For media-related inquiries, contact Maureen Jennings at email@example.com.
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the OSCON newsletter (login required).
View a complete list of OSCON 2008 Contacts
With the increasing popularity of Hibernate and JPA we have seen plain JDBC code being used less. For small projects and projects where you need advanced access to stored procedures, JDBC is still a great option to get the work done. JDBC has a reputation of being difficult and requiring a lot of boilerplate code.
This presentation will show how you can make JDBC coding a lot easier using the latest JDBC abstractions provided in Spring 2.5. We will show how Spring’s resource and transaction management will take care of the cumbersome and error-prone parts of using the JDBC API, leaving your data access code cleaner and simpler.
We will also discuss new features that are part of Spring’s “SimpleJDBC” approach introduced in Spring 2.0 and enhanced in Spring 2.5. The SimpleJDBC approach uses new language features from Java 5, like generics and varargs, to make your JDBC code more expressive and easier to maintain. The Simple JDBC approach also utilizes database metadata to simplify stored procedure calls and other more advanced JDBC usages.
The database used for all examples is MySQL, and we will show how to write some stored procedures that are a new feature for MySQL 5.0.
Thomas Risberg currently works as a consultant specializing in Java EE and database projects. He has been developing database applications for over 20 years using a wide variety of languages and databases. Most of his current work is developed using Java, Java EE and Spring. He has been a committer on the Spring Framework project since early 2003, contributing to enhancements of the JDBC framework portion.
Thomas is co-author of “Professional Java Development with the Spring Framework” together with Rod Johnson, Juergen Hoeller, Alef Arendsen, and Colin Sampaleanu, published by Wrox in 2005.
Thomas has presented on Spring and JDBC at OSCON 2005, The Spring Experience 2005 and 2007, SpringOne 2006, and at local user group events.