Date Posted: June 8, 2004
What is Framework for Java Database Connectivity?
What is Framework for Java Database Connectivity?
The Framework for JavaTM Database Connectivity (JDBC) was implemented to demonstrate the ease with which a Java application may be designed to access a source code repository using a relational query language, such as SQL. The design was made general enough to accommodate easy access to virtually any data source. The framework supports parsing of the SQL query along with calculations supported within the SQL 92 standard specifications. Access to the data source is performed through the creation of a specific plug-in. This technology runs on any Java platform, including Linux®.How does it work?
The Framework for JDBC is compatible with the JDBC 1.0 specification. (Future plans include improving and completing the current JDBC 1.0 implementation. A small set of methods similar to those of JDBC 2.0 is available through the IOptimizedResultSet interface.) A SQL query from the application and/or user is parsed into an internal query representation. Through optimization processes, this query is transformed to a data access plan. For each node within the data access plan, a specific plug-in is then called to read or write the data source or, alternatively, the framework performs a calculation in order to build a query result.
