Resources

Learn

• Check out the first two Cocoon 2 tutorials in this series: "Introducing Cocoon 2" (developerWorks, March 2002) and "Working with XML Server Pages" (developerWorks, April 2002).
  
  
• Take the other tutorials in this developerWorks series on Cocoon.
  
  
• Looking for a JDBC driver? Search the Sun JDBC Driver database.
  
  
• Get background on building database-backed Web sites using JSP, Java Beans, and JDBC with Robert Brunner's developerWorks tutorial, "Building Web-based applications with JDBC" (developerWorks, December 2001).
  
  
• Try Brunner's tutorial Advanced database operations with JDBC for additional training that expands your JDBC knowledge (developerWorks, November 2001).
  
  
• Read Enterprise JavaBeans fundamentals for basics on Enterprise JavaBean (EJB) programming and the Java 2 Enterprise Edition environment (developerWorks, April 2003).
  
  
• ESQL isn't the only way to generate XML from relational data. Nick Chase's Using JDBC to extract data into XML provides a DOM-based alternative. (developerWorks, October 2001) Chase has also written a tutorial on how to insert data from XML into a database (developerWorks, October 2001).
  
  
• Investigate the real capabilities of a Web-based CD catalog over at MusicBrainz.
  
  
• To register a JDBC driver, as described in Loading the JDBC driver, see java.sql.DriverManager.
  
  
• Refer to the ESQL logicsheet documentation for information on the complete set of available elements.
  
  
• For a reference on the DriverManager.getDriver method, as described in Configuring a connection pool, see http://java.sun.com/j2se/1.3/docs/api/java/sql/DriverManager.html#getDriver(java.lang.String).
  
  
• Below is a list of JDBC objects and their ESQL logicsheet element equivalents:
  • The JDBC Connection object = the esql:equivalent element (see The core ESQL elements, part 1).
  • The JDBC PreparedStatement object = the esql:execute-query element (see The core ESQL elements, part 1).
  • The JDBC ResultSet object = the esql:results element (see The core ESQL elements, part 2).
  • The JDBC ResultSetMetaData object = the esql:update-results element (see The core ESQL elements, part 2)
  • The JDBC SQLException object = the esql:error-results element (see The core ESQL elements, part 2).
  • The JDBC java.sql.ResultSet object = the esql:get-int and the esql:get-string elements (see Processing individual rows, part 1).
  
  
• Find out how you can become an IBM Certified Developer in XML and related technologies.
  
  
• Explore many more XML resources on the developerWorks XML zone.
  
  

Get products and technologies

• Need an open source database for building Web applications? Look into MySQL, a favorite among developers.
  
  
• IBM WebSphere Studio Application Developer is an easy-to-use, integrated development environment for building, testing, and deploying J2EE™ applications, including generating XML documents from DTDs and schemas.
  
  

10 of 11 | Previous | Next

Comments

Back to top

Table of contents

• About this tutorial
• Configuring database connections
• The ESQL logicsheet
• Performing queries
• Nesting and grouping query results
• Modifying data
• Form validation
• Summary
• Download
• Resources
• About the author

---

10 of 11 | Previous | Next

Local resources

• IBM Innovation Center - Austin, TX
• IBM Innovation Center - Chicago, IL
• IBM Innovation Center - Dallas, TX
• IBM Innovation Center - San Mateo, CA
• IBM Innovation Center - Waltham, MA
• Technical Briefings in North America

Dig deeper into XML on developerWorks

Try IBM PureSystems. No charge.

Experience today!

---

Get started with the cloud-based trial and pattern development kit.