Extensible Markup Language (XML) is the standard medium of data exchange on the Web. Examples of data exchange with XML are web feeds (RSS feeds and Atom feeds), and web services. Data exchanged using XML documents may be required to be stored in a relational database, or an XML document may require to be generated from a database table. An XML document is a hierarchical data structure where various elements may be mapped to columns in a database table. Therefore, by mapping various elements to a table, you can store XML in relational databases, and this mapping process is called XML-to-SQL mapping technology. Oracle created the XML SQL Utility (XSU) Java API to map XML to SQL and SQL to XML. The table to which an XML document is being mapped to must to be created prior to the mapping of the XML document to the database. With XSU, XML elements are mapped to database table columns. Mapping an XML document to a database table with XSU does not store the attributes...
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