JDBC Optional Package

Part of J2EE not Part of Standard Java 2.

Features

  • javax.sql package
  • Make the JDBC API a server-side technology as well as a client API.
  • JNDI support = Ease of deployment (gives JDBC driver independence, makes JDBC applications easier to manage)

  • This package adds an even better way to identify and connect to a data source, using a DataSource object, that makes code even more portable and easier to maintain. In addition to this important advantage, DataSource objects can provide connection pooling and distributed transactions, essential for enterprise database computing. This functionality is provided transparently to the programmer.

 

 

  • Connection pooling = Performance improvement (a connection pool is a cache of database connections that is maintained in memory, so that the connections may be reused)
  • Distributed transactions = Important for implementing a distributed transaction processing system
  • JavaBeans (RowSet objects) =
    • Send data across a network to thin clients, such as web browsers, laptops, PDAs, and so on
    • Access any tabular data source, even spreadsheets or flat files
    • Make results sets scrollable or updatable when the JDBC driver does not support scrollability and updatability
    • Encapsulate a driver as a JavaBeans component for use in a GUI
© Lynne Grewe 2000