Java FAQ

  1. Is Daffodil DB written entirely in Java?
  2. What version of Java does Daffodil DB require?
  3. Which versions of JDBC does Daffodil DB support?
  4. 4. Which platforms are supported by Daffodil DB?
  5. How can I store Java Objects in Daffodil DB database?
  6. What is the JDBC API? Where can I learn JDBC?
  7. How much of the JDBC API is supported?

1. Is Daffodil DB written entirely in Java?

Yes, Daffodil DB is written entirely in Java. Its JDBC driver has been certified for J2EE applications by Sun Microsystems.

2. What version of Java does Daffodil DB require?

Daffodil DB requires Sun JDK 1.3 or above.

3. Which versions of JDBC does Daffodil DB support?

Daffodil DB JDBC driver supports JDBC 3.0 specification. Daffodil DB JDBC driver has been certified for J2EE applications by Sun Microsystems.

4. Which platforms are supported by Daffodil DB?

Daffodil DB is written in pure Java (no non-Java components). It only uses the basic API from JDK 1.3.x. Daffodil DB supports Java 2 (JDK 1.3 onwards). Daffodil DB supports all platforms for which a Java Virtual Machine (JVM) is available.

5. How can I store Java Objects in Daffodil DB database?

Daffodil DB supports BLOB [Binary large object) data type for storing Java objects.

6. What is the JDBC API? Where can I learn JDBC?

JDBC is a set of classes and interfaces written in Java to allow other Java programs to send SQL statements to a relational database management system.
JDBC documentation can be found at -
http://Java.sun.com/products/jdk/1.2/docs/api/Java/sql/package-summary.html
http://Java.sun.com/products/jdbc/

7. How much of the JDBC API is supported?

ClassDescription
java.sql.BatchUpdatExceptionProvides information about errors that occurred during batch operations
java.sql.BlobProvides access to and manipulation of Binary Large Object data
java.sql.CallableStatementProvides access to and manipulation of Stored Procedures
java.sql.ClobProvides access to and manipulation of Character Large Object data
java.sql.ConnectionConstructs and manages the connection to the database Provides metadata information about the database
java.sql.DatabaseMetaDataProvides meta data about the database.
java.sql.DriverProvides information about and manages the JDBC driver
java.sql.ParameterMetaDataProvides the number, type and properties of parameters to prepared statements.
java.sql.PreparedStatementManages dynamic SQL statements
java.sql. ResultSetProvides metadata information about the result set
java.sql.ResultSetMetaDataManages result set metadata information
java.sql.StatementManages static SQL statements
javax.sql.ConnectionPoolDataSourceSupports caching and reusing of physical connections, which improves application performance and scalability
javax.sql.DataSourceProvides access to JDBC drivers and manages data sources.
javax.sql.PooledConnectionRepresents a physical connection to a data source.
javax.sql.RowSetEncapsulates a set of rows that have been retrieved from a tabular data source.
javax.sql.RowSetMetaDataManages row set meta data information.
javax.sql.XAConnectionA XAConnection object is a Pooled Connection object that can participate in a distributed transaction.
javax.sql.XADataSourceProvides connections that can participate in a distributed transaction.