Experimental Physics and
Industrial Control System

"Kasemir, Kay" <[email protected]> · Tue, 4 Mar 2014 09:14:25 -0500

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

Experimental Physics and Industrial Control System

Experimental Physics and
Industrial Control System