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. In case of any problems with connecting to Derby DB, we recommend you configure a connection to external DB or at least specify the Derby home directory:
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:
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
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
A Derby JDBC 4 compliant driver is bundled with CloverDX Server, thus there is no need to add it on the classpath.