Java, SQL, XML and Web Services

by Ken North


This class explains how to use the powerful combination of Java, SQL, JDBC and XML to write multi-tier applications and extend databases.
It also explains how to use those technologies to develop Web services, the new paradigm for distributed Internet applications. To create portable, multi-platform software, many developers use Java to access databases and XML to exchange data.
Java database developers write applets, applications, servlets, and classes installed in databases. XML developers can use database extensions for storing and querying XML documents.
Developers creating and using Web services use the Simple Object Access Protocol (SOAP) and the Web Services Description Language (WSDL) when exposing services and methods on remote computers.
This class explains architectures and programming techniques for using XML, Java, SQL and Web services toolkits. The instructor explains JDBC, embedded SQL for Java (SQLJ), XML and Web services concepts.
The instructor explains the Document Object Model (DOM) and Simple API for XML (SAX), and interoperable SQL for ODBC and JDBC. The instructor explains example programs for doing SQL queries, for storing and retrieving XML from databases, for processing XML data, and for database-enabled Web services.

Main Topics

  • DBMS server architectures that include Java and XML in the database
  • Java, SQL, and XML as tools for writing database programs and Web services
  • The programming model for processing SQL statements and metadata
  • Java database programming techniques
  • Web services programming techniques
  • How to use JDBC when extending databases and developing Web services
  • The programming model and APIs for processing XML documents
  • How to use SQLJ and interoperable SQL
  • The role of XML Web services and XML-extended databases
  • How to add Java stored procedures and UDFs to a database
  • Benefits and cautions related to server extensions
  • How to perform content-based queries and section searches over XML documents