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?
| Class | Description |
| java.sql.BatchUpdatException | Provides information about errors that occurred during batch operations |
| java.sql.Blob | Provides access to and manipulation of Binary Large Object data |
| java.sql.CallableStatement | Provides access to and manipulation of Stored Procedures |
| java.sql.Clob | Provides access to and manipulation of Character Large Object data |
| java.sql.Connection | Constructs and manages the connection to the database Provides metadata information about the database |
| java.sql.DatabaseMetaData | Provides meta data about the database. |
| java.sql.Driver | Provides information about and manages the JDBC driver |
| java.sql.ParameterMetaData | Provides the number, type and properties of parameters to prepared statements. |
| java.sql.PreparedStatement | Manages dynamic SQL statements |
| java.sql. ResultSet | Provides metadata information about the result set |
| java.sql.ResultSetMetaData | Manages result set metadata information |
| java.sql.Statement | Manages static SQL statements |
| javax.sql.ConnectionPoolDataSource | Supports caching and reusing of physical connections, which improves application performance and scalability |
| javax.sql.DataSource | Provides access to JDBC drivers and manages data sources. |
| javax.sql.PooledConnection | Represents a physical connection to a data source. |
| javax.sql.RowSet | Encapsulates a set of rows that have been retrieved from a tabular data source. |
| javax.sql.RowSetMetaData | Manages row set meta data information. |
| javax.sql.XAConnection | A XAConnection object is a Pooled Connection object that can participate in a distributed transaction. |
| javax.sql.XADataSource | Provides connections that can participate in a distributed transaction. |