Java DB 10.5.3 is now available

Following the release of Apache Derby 10.5.3, Java DB which is Sun's supported version of this last one is also now available.

Java DB 10.5.3 is primarily a bug-fix release and inherits all the bug fixes and localized messages from Apache Derby 10.5.3.

Java DB offers installers for the following platforms:

  • Solaris
  • Linux
  • Windows
  • Mac OS X (newly added)

Here is a recap of all changes that are coming as part of Java DB 10.5.3:
  • 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". Java DB 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 Java DB to fill a column with an expression built out of other columns in the row. Java DB 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 Java DB 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.

  • Service tag - Introduction of the Java DB registration service (service tag).

Further details on new features, changes, and issues in this release can be found in the Release Notes.

Comments:

Is there a chance that derby implements boolean data type in the near future?

Posted by Sergio Medina on September 16, 2009 at 09:55 AM PDT #

Greetings from Philippines!

Sir, this is with respect to the DerbyTax offline Application. Are there plans in the future to update the application which will include Data Synchronization between local and remote server database?

Thanks for any reply.

Rey

Posted by Rey on September 21, 2009 at 06:30 PM PDT #

Hi Sergio,

Yes, there is a JIRA for re-enabling / re-exposing Boolean datatype in Derby - There has been significant progress but there was also an issue about backward-compatibility. You can vote for this feature in that JIRA and feel free to post comments / feedback there too. Regards.

http://issues.apache.org/jira/browse/DERBY-499

Posted by Francois Orsini on September 22, 2009 at 03:09 AM PDT #

Thanks, Francois.

Posted by Sergio on September 22, 2009 at 03:47 AM PDT #

Hi Rey,

If you're just interested in one-way synchronization (tearoffs or snapshots) you might want to take a look at the vti demo code in Derby. The README file there will get you started. The vti demo code includes classes which make it easy to declare parameterized snapshots of Derby data--and then use and refresh them. You can find this code in the bin distribution of Derby in the demo/programs/vtis directory. Hope this helps.

-Rick

Posted by Rick Hillegas on September 22, 2009 at 10:22 PM PDT #

Thanks, Rick.

Posted by Francois Orsini on September 23, 2009 at 05:44 PM PDT #

Support of the Lou Zhu, Lou Zhu worked hard
Signature--------------------------------------------------------------------------------------------------------------------
Nothing is impossible for a willing heart
<a href="http://www.uggshelf.com/Products.html">ugg Boots</a>

Posted by hanyujoys on October 14, 2009 at 01:24 PM PDT #

Post a Comment:
Comments are closed for this entry.
About

forsini

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today
Bookmarks