Version

    Embedded Apache Derby

    The Apache Derby embedded DB is used with a default CloverDX Server installation. It uses the working directory as a storage for data persistence by default. This may be a problem on some systems. If a problem occurs with connecting to Derby DB, we recommend you configure a connection to external DB or at least specify the Derby home directory:

    Configure the derby.system.home system property to set path which is accessible for application server. You can specify this system property with this JVM execution parameter:

    -Dderby.system.home=[derby_DB_files_root]

    Example of a properties file configuration:

    jdbc.driverClassName=org.apache.derby.jdbc.EmbeddedDriver
    jdbc.url=jdbc:derby:databases/cloverDb;create=true
    jdbc.username=user
    jdbc.password=password
    jdbc.dialect=com.cloveretl.server.dbschema.DerbyTableIdDialect

    Take a closer look at the jdbc.url parameter. The databases/cloverDb part means a subdirectory for DB data. This subdirectory will be created in the directory which is set as derby.system.home (or in the working directory if derby.system.home is not set). You may change the default value databases/cloverDb.

    A Derby JDBC 4 compliant driver is bundled with CloverDX Server, thus there is no need to add it on the classpath.

    [Note]Note

    Continue with:  Encrypted JNDI or Activation