+

Search Tips   |   Advanced Search

About Apache Derby

The Apache Derby package bundled with the application server is backed by full IBM Quality Assurance (QA).

Supported configurations: WebSphere Application Server supports direct customer use of the Apache Derby database in test environments only. The product does not support direct customer use of Apache Derby database in production environments. The product supports the use of Apache Derby only by internal application server componentsf in production environments.

Unlike versions 5.1.60x and earlier, Apache Derby is a pure Java database server. The Apache Derby code base, which the open source community calls Derby, is a product of the Apache Software Foundation (ASF) open source relational database project. Apache Derby includes the Derby base code without any modification to the underlying source code. We can investigate more incompatibilities about Derby code at the Apache Derby website.

Earlier versions of Apache Derby cannot conduct two phase-commit transactions over the Network Server framework, but later versions of the Derby Client JDBC driver provides Apache Derby with support for XA transactions. Only the Network Server framework provides support for multiple JVMs, such as application servers, to access Apache Derby.

Apache Derby is equipped with the following .bat/sh tools:

If we use non-English characters in our Derby database name, we need to update the ij script to specify the file encoding property to the JVM: -Dfile.encoding=XXXXXX, where XXXXXX is the encoding used to create the non-English characters.


Related concepts

  • Transaction type and connection behavior

  • Data source minimum required settings, by vendor
    Apache Derby website