Friday May 01, 2009

Apache Derby Feature Release is now available!

The Apache Derby project is pleased to announce a new GA feature release
of Derby,

Apache Derby is a sub-project of the Apache DB project. Derby is a pure
Java relational database engine which conforms to the ISO/ANSI SQL and
JDBC standards. Derby aims to be easy for developers and end-users to
work with.

Derby can be obtained from the Derby download site:

It contains the following new features:
  • SQL Roles - SQL roles (as described in SQL 2003 and errata) are useful for administering privileges for groups of users. Administering roles is generally less error-prone than administering privileges for individual users. SQL Roles are defined in Feature T331 "Basic roles" and Feature T332 "Extended roles". Derby 10.5 implements a subset of T331, plus support for CURRENT_ROLE, which is a part of T332.
  • Generated Columns - Generated Columns is a feature which instructs Derby to fill a column with an expression built out of other columns in the row. Derby constructs these column values at INSERT and UPDATE time. The user declares indexes on these columns. This in turn improves SELECT performance since it lets users declare indexes on pre-computed pieces of the WHERE clause. This feature satisfies support for SQL Feature T175.
  • LOB Improvements - There were many performance and usability improvements for BLOBs and CLOBs.
  • Replication of encrypted databases - With 10.5 it is possible to replicate encrypted databases.
  • OFFSET/FETCH FIRST - SQL 2008 has added new syntax to support a direct way to limit the returned set of rows in a result set, through the fetch first and offset clauses.
  • In-Memory back end - Initial implementation of a storage engine for Derby where all data is kept in memory. There is no documentation for this feature. This functionality itself is not yet fully implemented, but users are welcome to experiment with it. For details, see the Primer for In-memory Back Ends.
  • Standard ALTER COLUMN syntax - Allow standard SQL "SET" keyword in ALTER COLUMN syntax, like so: "ALTER TABLE ALTER COLUMN columnname SET DEFAULT default-value"
  • SYSCS_UTIL.SYSCS_UPDATE_STATISTICS - New system procedure that updates cardinality statistics (or creates them if they do not exist) for a table's index or for all the indexes on a table, allowing a user to ensure that a query plan based on the most recent state of the table can be created.

In addition, Derby contains many bug and documentation fixes.

Java DB, which is Sun's distribution of Apache Derby should be available as a release level very soon.

Wednesday Mar 04, 2009

JavaFX and Java DB / Apache Derby Demo Applications

Sergey Surikov has updated and enhanced his CrudFX application to work with JavaFX 1.0.

These new applications below are using Java DB / Apache Derby's bundled demo database 'ToursDB' which contains travel agency sample data...

The first one has more advanced UI and graphic elements. Click on the screenshots below for more info.

Friday Nov 30, 2007

Using Apache Derby on Java ME platforms

As you may already know, Apache Derby supports the JDBC API defined for the Connected Device Configuration Foundation Profile, also known as JSR169. The features supported are a subset of the JDBC 3.0 specification. Support for JSR169 is limited to the embedded Derby driver.

John Embretsen has put a great page together with hints and resources about Apache Derby's support for Java ME (also known as J2ME) environments. This also applies to Java DB, which is Sun's supported version of Apache Derby.

If you need to know into which JDBC environment you're running as part of your application, you can use this tip to dertermine for instance if you're running within some JSR169 context.

Thursday Apr 26, 2007

Apache Derby 10.3 Features List

Here you can find the list of new features and issues to be resolved for the coming Apache Derby 10.3 which is targeted to be released around end of June 07'.

Some exciting additions around security and performance improvements:

- DBA Powers
- SSL/TLS support in Client/Server mode
- Language Based Ordering
- Reduction of CPU usage and improved concurrency in Derby (embedded) core.
- Long awaited ALTER TABLE DROP or RENAME column (great for dynamic schema modifications)

You can find more details here as well as the list of targeted issues to be addressed.

As usual, you can check the latest Alpha documentation corresponding to the Derby Alpha codeline (Trunk).

Wednesday Nov 22, 2006

Easysoft ODBC-JDBC Gateway certified for Java DB / Apache Derby

The Easysoft ODBC-JDBC Gateway which lets ODBC-enabled applications such as Business Objects, Microsoft Access, Microsoft Excel and Microsoft SQL Server access Java databases, is now certified with Java DB.

Note that the gateway is also available for the Solaris platform.




« September 2016