[CASSANDRA-2876] JDBC 1.1 Roadmap of Enhancements

• Type: Improvement
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 1.1.0
• Labels: cql jdbc
• Assignee: Rick Shaw
• Reporter: Rick Shaw

Authors

Rick Shaw

• Created: 09/Jul/11 22:11
• Updated: 16/Apr/19 09:32
• Resolved: 15/Dec/11 20:07

Description

Organizational ticket to tie together the proposed improvements to Cassandra's JDBC driver in order to coincide with the 1.0 release of the server-side product in the fall of 2011.

The target list of improvements (in no particular order for the moment) are as follows:

1. Complete the PreparedStatement functionality by implementing true server side variable binding against pre-compiled CQL references.
2. Provide simple DataSource Support.
3. Provide a full PooledDataSource implementation that integrates the C* JDBC driver with App Servers, JPA implementations and POJO Frameworks (like Spring).
4. Add the BigDecimal datatype to the list of AbstractType classes to complete the planned datatype support for PreparedStatement and ResultSet.
5. Enhance the Driver features to support automatic error recovery and reconnection.
6. Support RowId in ResultSet
7. Allow bi-directional row access scrolling to complete functionality in the ResultSet.
8. Deliver unit tests for each of the major components of the suite.

Sub-Tasks

• Add Support for BigDecimal Java data type as the "DecimalType" AbstractType: Resolved
• The JDBC PreparedStatement Class should be enhanced to support server-side Data Binding: Resolved
• The JDBC Suite should provide a simple DataSource implementation: Resolved
• The JDBC Suite should provide a simple DatabaseMetaData implementation: Resolved
• Support RowId in ResultSet: Resolved
• Add support for BigDecimal Java data type to JDBC ResultSet: Resolved