In this chapter, an Excel spreadsheet was generated from an Oracle database table using the Apache POI HSSF API. The Apache POI HSSF API may also be used to parse an Excel spreadsheet and subsequently store the spreadsheet in a database. In the JDBC 4.0 version of the Apache POI application we added JDBC 4.0 features connection state tracking, setting of client info properties, statement caching, access of nonstandard JDBC methods using the Wrapper interface, and the Java SE chained exceptions facility.
JDBC 4.0 and Oracle JDeveloper for J2EE Development
JDBC 4.0 and Oracle JDeveloper for J2EE Development
Overview of this book
Table of Contents (20 chapters)
JDBC 4.0 and Oracle JDeveloper for J2EE Development
Credits
About the Author
About the Reviewer
Preface
Free Chapter
JDBC 4.0
Configuring JDBC in Oracle JDeveloper
Connecting to a Database with JSTL SQL Tag Library
Configuring JDBC in JBoss Application Server
Configuring JDBC in WebLogic Server
Configuring JDBC in WebSphere Application Server
XML SQL Utility
XSQL
Oracle Web RowSet
Creating a JSF Data Table
Creating a JSF Panel Grid
Creating a Report with JasperReports
Creating a Spreadsheet with Apache POI
Creating Oracle ADF Business Components
Hibernate
Customer Reviews