About Apache Derby

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. You can investigate more incompatibilities about Derby code at the Apache Derby website.

Only the Network Server framework provides support for multiple Java virtual machines (JVMs), such as application servers, to access Apache Derby.

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 components in production environments.

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

sysinfo: displays database version information
ij: manipulates the database instances. When you run the ij tool, surround the dbname by double quotation marks ("") if it includes the full path name; for example:
```
connect '"c:\temp;create=true"'
```
This is '""'' without spaces.
dblook: dumps DDL information
networkServerControl: controls the networkServer process (can be used for functions such as ping and trace)
startNetworkServer: starts the networkServer process
stopNetworkServer: stops the networkServer process

Attention: If you use non-English characters in your Derby database name, you 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.