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
- Replies:
- Re: Battling to start archive.engine on Postgresql db Ivan Kohler
- References:
- Battling to start archive.engine on Postgresql db Ivan Kohler
- Navigate by Date:
- Prev:
new improved version of caQtDM Mezger Anton Christian
- Next:
#personal#Fw: Error in feching PV from CSS Swati Soni2
- Index:
1994
1995
1996
1997
1998
1999
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
<2014>
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
- Navigate by Thread:
- Prev:
Battling to start archive.engine on Postgresql db Ivan Kohler
- Next:
Re: Battling to start archive.engine on Postgresql db Ivan Kohler
- Index:
1994
1995
1996
1997
1998
1999
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
<2014>
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
|