Monday Sep 14, 2009
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.
Wednesday Aug 26, 2009
The Apache Derby project is pleased to announce a new bug-fix release of Derby, 10.5.3.0.
Apache Derby is a subproject 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 customers to
use.
Derby 10.5.3.0 can be obtained from the Apache download site:
http://db.apache.org/derby/derby_downloads.html
Derby 10.5.3.0 contains many bug fixes plus localizations for messages
added in the previous feature release, 10.5.1.1.
10.5.3.0 replaces
10.5.2.0, which introduced a query-ordering regression.
Here is the list of bug fixes addressed in 10.5.3.
Friday May 29, 2009
The Java DB team will be at CommunityOne and JavaOne 2009 next week.
Feel free to come and visit us at the Java DB POD and share feedback with us. You might even get a nice T-Shirt 
We will show demo's of new features, including some nice JavaFX application using Java DB / Apache Derby.
Friday May 29, 2009
The Java DB project is pleased to announce a new feature release of Java DB 10.5.1.
Java DB is Sun's branded distribution of the Apache Derby open source database. Java DB is a pure Java relational database engine which conforms to the ISO/ANSI SQL and JDBC standards. Java DB aims to be easy for developers and end-users to work with.
Java DB 10.5.1 can be obtained from the Java DB download site:
http://developers.sun.com/javadb/downloads/index.jsp
Java DB 10.5.1 introduces the following new features and improvements:
- In-memory databases for test rigs and transient data
- Replication of Encrypted Data for failover of sensitive databases
- OFFSET/FETCH FIRST for paging through query results efficiently
- SQL Roles for administering fine-grained access controls
- Generated Columns for speeding up queries by pre-computing results
- LOB Improvements for speeding up access to large binary and text objects
- Optimizer Statistics Improvements for better management of query plans
Java DB offers the following:
- Installers for various platforms
- Support offering (more info)
- Notification of new releases and updates via registration
- Native Netbeans integration
- Bundled in GlassFish and Sun JDK6
If you are interested in learning more or/and sharing feedback about Java DB, please come and visit us at our POD during
CommunityOne and
JavaOne 2009.
Friday May 01, 2009
The Apache Derby project is pleased to announce a new GA feature release
of Derby, 10.5.1.1.
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 10.5.1.1 can be obtained from the Derby download site:
http://db.apache.org/derby/derby_downloads.html.
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 10.5.1.1 contains many bug and documentation fixes.
Java DB, which is Sun's distribution of Apache Derby should be available as a 10.5.1.1 release level very soon.
Friday Mar 27, 2009
Amongst the recent updates to Java DB's portal, I recommend reading these 2 great interviews of Masood Mortazavi, engineering manager for Java DB.
You can also find a various selection of technical articles, tips and white-papers.
If you are using Netbeans, this article will show you how to use Java DB more effectively inside this IDE.
Thursday Mar 05, 2009
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.
Tuesday Dec 16, 2008
Java DB (based on Apache Derby) is now on Twitter. If you want to follow the latest about Java DB, then become a follower
Tuesday Dec 16, 2008
I was at Devoxx (formely known as JavaPolis) 08' last week and like the previous years, the conference was packed with more than 3,000 attendees.
I had the opportunities to present 2 quickies and you can find the presentations below:
- How to JavaFX with Java DB in less than 10 minutes (pdf)
- Virtualization or How to query any dataset with Java DB (pdf)
Monday Dec 03, 2007
JavaPolis 2007 is starting on december 10th in Antwerp, Belgium and as expected it is already sold-out.
If you don't happen to know, JavaPolis is one of, if not, the biggest Java conference in Europe. There will be 3,200 attendees this year and some great technical content.
I'm going to be presenting the following sessions on Apache Derby / Java DB:
Throughout these sessions, the audience will get to see how Java DB can be integrated in the various web tiers and throughout various scenarios. I will cover how it can be used to empower web, standalone and server applications, as well as how it differentiates itself from traditional
RDBMS, due to its unique architecture and capabilities for various types of usage.
Kristian Waagan and Jørgen Løland from the Sun Java DB engineering team will be discussing about what's coming up in the next release of Apache Derby - Some very cool stuffs indeed.
Feel free to stop by our booth to ask questions and share your experiences; who knows, you might end-up getting some goodies, it is nearly Christmas after all
See you in Antwerp!
Friday Nov 30, 2007
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.
Tuesday Oct 16, 2007
In this blog, Byron Nevins shows how to enable Java DB to start as a Windows service using GlassFish's appservService facility. You can also find more information about Java DB bundling in GlassFish here.
Wednesday Sep 26, 2007
+ 
+ 
Arun Gupta has posted some information about using Java DB / Apache Derby as part of a JRuby on Rails application on GlassFish. Java DB is bundled with GlassFish and can be used as a multi-user RDBMS, running embedded in the same JVM as GlassFish or as a standalone database server in its own host and JVM.
Monday Aug 13, 2007
The Apache Derby project is pleased to announce a new feature release
of Derby, 10.3.1.4.
Notes describing the difference between Derby release 10.3.1.4 and the preceding release 10.2.2.0 are available here.
Monday Jul 09, 2007
The Apache Derby community has delivered a release candidate of Derby (10.3) which can now be downloaded.
A non exhaustive list of new features in this release:
- DBA Powers to control who can shutdown, encrypt and upgrade databases.
- Secure Server which makes the Derby Network Server secure by default.
- Language Based Ordering which adds built in language based ordering (collation) and like processing to Derby.
- SSL/TLS to allow secure SSL/TLS communication between a client and a Derby server.
- Various performance improvements in query processing along with reduced CPU usage in Derby embedded core engine.
- Alter Table DROP or RENAME of a column. This means that most dynamic schema modifications are now possible in Derby.
More details at http://wiki.apache.org/db-derby/DerbyTenThreeRelease
NOTE that this is a release candidate, not a GA (General Availability) one, which should be available soon after public testing has completed and reported issues have been addressed.
Monday Jun 25, 2007
Apache Derby's WIKI is full of wonders when it comes to resources. I reckon it is not obvious to navigate the WIKI and find relevant information but if you're interested and curious about some Apache Derby & Java DB hints and tips, then point your browser to this link and bookmark it
Tuesday May 22, 2007
The Java DB (based on Apache Derby) support offering page is now online. Note that you can also consult the Apache Derby derby-user mailing list using Nabble for getting answers or even post your questions to this last one. Apache Derby has a very active community and getting feedback via the mailing lists is a way to participate. In fact, by asking questions on the list, one is in a way adding persistent content that someone might find useful and get to via Nabble at some point
Tuesday May 08, 2007
I heard the news from JRuby core developer Olivier Nutter at CommunityOne as I was setting up for my presentation with Kevin Henrikson from Zimbra.
Yes, so ThoughtWorks Studios will have their collaborative development project management solution named Mingle be the first commercially-distributed Rails application to run on JRuby.
Mingle 1.0 which should be released in June 07', will be running with a Jetty web front-end and an Apache Derby database back-end.
InfoQ blog on the subject reports that performance has not been a major concern. The current runtime easily supports hundreds of concurrent users with a simple cluster, and JRuby performance has been getting faster all the time. According to the team, experimental deployments have included 10 JRuby interpreters running in a single JVM process.
Friday May 04, 2007
As David Van Couvering pointed out in his blog, I will be co-presenting with Kevin Henrikson from Zimbra at CommunityOne and JavaOne 2007 next week. Kevin will especially highlight how they have implemented offline support in their current Zimbra Desktop offering.
We will discuss how today's and tomorrow's Rich Internet Applications (RIA's) can be enabled to run offline and allow the users to keep using the same application, while not being connected to the net.
You can get a sneak peak of what we will talking about based on David Berlind's recent article on the subject of enabling offline Rich Internet Applications using some local storage such as Java DB / Apache Derby and some Local Ajax (LAJAX) or Asynchronous JavaScript technic based on LiveConnect.
Thursday Apr 26, 2007
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).
Thursday Apr 26, 2007
For those of us working on open source software, this article shows an interesting view of what open source hardware is all about.
You can also check OpenSPARC which is Sun's open source hardware initiative, aimed at spawning dramatic innovations around chip design.
All I have to say is that I'm glad to be in Software
/Salute
Wednesday Apr 25, 2007
Come learn what's cool and what's new in Apache Derby, the database for Java applications, from Derby committers and community members. This is a great opportunity to meet with the Apache Derby community and Java DB folks. Of course, there will be Beer, wine, soft drinks, and very nice snacks!
*Tuesday evening, 8 May from 7:00 to 10:00+ pm **
@ Jillian's in the Sony Metreon, right next to the Moscone Center
101 4th Street, Suite 170, San Francisco*
Monday Apr 23, 2007
Simon Phipps has posted a neat picture of Sun's booth at FISL 8.0 (Porto Alegre, Brazil) where I just came back from last week.
As usual and once again, the conference has been terrific - Lots of attendees (5,363) and it is all about free and open source software. It was incredible (even after my second time there) to experience the level of interest from the attendees - Very nice folks and this conference keeps you busy for sure until dusk .
Also, for a "meaterian" like me , it was absolutely awesome to experience the intense BBQ cuisine from Brazil (churrasco)and this area.
I gave a presentation on particular technics on how to enable offline web applications (RIA) using Java DB - I will give a more elaborated talk at JavaOne 2007 where I'm co-presenting with Zimbra on their next-generation suite of collaborative web applications that can operate homogeneously online and offline (Zimbra Desktop), using Apache Derby.
Many thanks to Rafael Vanoni for hosting my talk and speaking Portuguese better than I do
Obrigado a Todos!
Thursday Apr 19, 2007
It has been announced today, Ubuntu Feisty Fawn (7.04) has been released and it includes Sun's complete Java stack.
This is the first time that an entire, production quality Java stack with tooling is being included in an open source GNU/Linux distribution - greatly simplifying the process for Linux developers and users to access Java technology.
The complete and fully supported components of Sun's Java stack which are packaged for Ubuntu are Java SE 6 JDK, GlassFish v1, NetBeans IDE 5.5 and Java DB 10.2 (based on Apache Derby). (FAQ)
You can also check Tom Marble's blog entry for additional information. This is very exciting indeed.
You can 'apt-get' install Java DB as an optional Ubuntu package such as:
# apt-get install sun-java6-javadb
and it should get installed under '/usr/lib/jvm/java-6-sun/db/'
|
|
|
|
