What methods can I use to read and modify the Apache Derby database used by GoAnywhere MFT?
You can read the Derby database using command-line tools like Apache Derby's `ij` script (connect with `connect 'jdbc:derby:<path>';`) or a GUI tool like DBSchema. To modify the database when GoAnywhere is stopped, use either method to run SQL statements—for example, enabling a disabled user with `UPDATE APP.DPA_USER SET ENABLED='1' WHERE USER_NAME='root';`. When the service is running, you can also write a JSP file to perform modifications. These techniques are covered in the database operations section of the setup guide.
Apache DerbydatabaseDBSchemaSQLembedded database