Tuesday Sep 22, 2009

Videos to get acquainted with Apache Derby and Java DB

javadb.png

derbyLogo.png

Kristian Wagaan and Richard Hillegas, both Apache Derby committers who also work on Java DB, recently gave some great presentations about Apache Derby and Java DB.

Kristian Wagaan presented at the 2009 OpenSQLCamp, in conjunction with FrOSCon 2009 in Europe.

The presentation (slides) gives a brief overview of Apache Derby, its history and the community around it. Further, it goes into the details of features that have been added in the latest releases and show how they enable powerful ways to use a relational database.




Rick Hillegas gave an introduction of Java DB / Apache Derby at The San Francisco Java User Group's Sep 8th event in San Francisco.


Monday Sep 14, 2009

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.

Wednesday Aug 26, 2009

Apache Derby 10.5.3 Bug-Fix Release is now available!


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

Java DB at CommunityOne and JavaOne 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.

Java DB 10.5.1 now available

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

Apache Derby 10.5.1.1 Feature Release is now available!

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

Java DB Articles and Interviews with Masood Mortazavi, Engineering Manager

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. 

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.

Tuesday Dec 16, 2008

Java DB on Twitter - Become a follower

Java DB (based on Apache Derby) is now on Twitter. If you want to follow the latest about Java DB, then become a follower ;-)

Devoxx 08' - Java DB Quickie Presentations

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 '07 is Around the Corner




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

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.

Tuesday Oct 16, 2007

How to start JavaDB / Apache Derby as a Windows Service

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

Using Java DB / Apache Derby with JRuby on Rails on GlassFish

+ 

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

Apache Derby 10.3.1.4 has been released


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

Apache Derby 10.3 release candidate is now available


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

Hints, Tips and Useful Information for Apache Derby Users


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

Java DB Support


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 ;-)

Monday May 07, 2007

First Commercial Application to run on JRuby also uses Apache Derby

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.

Thursday May 03, 2007

Enabling Offline Web Applications with Java DB

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

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).

Open Source Hardware - What is it?

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

An Apache Derby unBOF at JavaOne 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

FISL 8.0 Conference in Brazil

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

Ubuntu Users Gets Java DB Surprise and A Lot More Than That...


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/'

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