23. Accessing JDBC databases using Data Source in standard portlets

In this chapter, we introduce the process of gaining access to back-end JDBC databases using a Data Source for the database connection. The sample scenario is implemented using the JSR 168 portlet specification for classes and JSPs. A simple portlet project is included to show how portlets access relational databases using the JDBC interface.

This chapter discusses the following topics:

  • How to create a portlet project on Rational Application Developer.

  • How to create a Data Source connection to a database using Rational Application Developer.

  • How to create Java classes that will provide a database connection through a datasource.

  • A portlet example to access a database.

Get IBM Rational Application Developer V6 Portlet Application Development and Portal Tools now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.