Hi:
On Mar 3, 2014, at 5:17 PM, Ivan Kohler <[email protected]> wrote:
I managed to start CSS archive.engine on a MySQL db,
Good, so at least something is working.
In Eclipse I edited:
org.csstudio.archive.engine
plugin_customization.ini file
org.csstudio.archive.rdb/url=jdbc:postgresql://localhost:5432/archive
and
org.csstudio.archive.engine.rdb
preferences.ini file
# Postgresql example
url=jdbc:postgresql://localhost/archive?rewriteBatchedStatements=true
You should leave the "preferences.ini" files unchanged. They contain the defaults and explanation of available settings.
To specify what you actually want to use, you _could_ edit the plugin_customization.ini in the archive engine sources, but better would be to not edit any sources and instead provide the path to _your_ plugin_customization.ini file on the command-line:
ArchiveEngine -pluginCustomization /path/to/my/settings.ini -engine Demo ….
See also "Hierarchical Preferences" in the CSS Guide, http://cs-studio.sourceforge.net/docbook/ch06.html
Caused by: java.lang.NullPointerException
at
org.csstudio.archive.rdb.RDBArchivePreferences.getSchema(RDBArchivePreferences.java:37)
Strange.
For Postgres you should configure the "schema" to be empty, just as you did with MySQL.
So your settings.ini would contain:
# Set schema to empty
org.csstudio.archive.rdb/schema=
The error message suggests that the 'schema' is not defined at all, which could only happen if you deleted it from the org.csstudio.archive.rdb/preferences.ini as well as org.csstudio.archive.engine/plugin_customization.ini.
Thanks,
Kay