Experimental Physics and
Industrial Control System

Ivan Kohler <[email protected]> · Tue, 04 Mar 2014 00:17:19 +0200

Hi All,

I managed to start CSS archive.engine on a MySQL db, now I am trying to

get it started on a Postgresql db.

I am on a PC running Ubuntu 1204 using:
Java: JDK SE Dev Kit 7.51
Eclipse fro RCP and RAP Developers ver 1.4.2
SNS Sources 3.2.14
I installed postgresql 9.1 and loaded the schema with:

 sudo -u postgres psql <

~/css/sources/org.csstudio.archive.rdb/dbd/postgres_schema.txt

So smpl_eng has the Demo engine in it:
1, Demo, Demo Engine, http://localhost:4812
I edited postgresql's pg_hba.conf file
      host    all             all 127.0.0.1/32            md5

 host all all 10.0.0.1/24 md5 #

Added this line

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

Before Launching the ArchiveEngine.product I added
Program Arguments using the 'Launching' tab
        -engine Demo
        -port 4812

On Launching I got the following in the Eclipse Console:

2014-03-03 23:11:01.753 INFO [Thread 1]

org.csstudio.archive.engine.Application (start) - Archive Engine

3.2.14.qualifier

2014-03-03 23:11:01.896 INFO [Thread 1]

org.csstudio.archive.engine.server.EngineServer (<init>) - Engine HTTP

Server on http://localhost:4812/main

2014-03-03 23:11:01.897 INFO [Thread 1]

org.csstudio.archive.engine.Application (start) - Reading configuration

'Demo'

2014-03-03 23:11:01.939 SEVERE [Thread 1]

org.csstudio.archive.engine.Application (start) - Cannot read configuration

org.eclipse.core.runtime.CoreException: Plug-in

"org.csstudio.archive.config.rdb" was unable to instantiate class

"org.csstudio.archive.config.rdb.RDBArchiveConfig".

 at

org.eclipse.core.internal.registry.osgi.RegistryStrategyOSGI.throwException(RegistryStrategyOSGI.java:194)

 at

org.eclipse.core.internal.registry.osgi.RegistryStrategyOSGI.createExecutableExtension(RegistryStrategyOSGI.java:186)

 at

org.eclipse.core.internal.registry.ExtensionRegistry.createExecutableExtension(ExtensionRegistry.java:905)

 at

org.eclipse.core.internal.registry.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:243)

 at

org.eclipse.core.internal.registry.ConfigurationElementHandle.createExecutableExtension(ConfigurationElementHandle.java:55)

 at

org.csstudio.archive.config.ArchiveConfigFactory.getArchiveConfig(ArchiveConfigFactory.java:37)

    at org.csstudio.archive.engine.Application.start(Application.java:164)

 at

org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)

 at

org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)

 at

org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)

 at

org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:344)

 at

org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)

    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

 at

sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

 at

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:622)
    at org.eclipse.equinox.launcher.Main.basicRun(Main.java:577)
    at org.eclipse.equinox.launcher.Main.run(Main.java:1410)
    at org.eclipse.equinox.launcher.Main.main(Main.java:1386)
Caused by: java.lang.NullPointerException

 at

org.csstudio.archive.rdb.RDBArchivePreferences.getSchema(RDBArchivePreferences.java:37)

 at

org.csstudio.archive.config.rdb.RDBArchiveConfig.<init>(RDBArchiveConfig.java:66)

 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native

Method)

 at

sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)

 at

sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

    at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
    at java.lang.Class.newInstance(Class.java:374)

 at

org.eclipse.core.internal.registry.osgi.RegistryStrategyOSGI.createExecutableExtension(RegistryStrategyOSGI.java:184)

    ... 18 more

Any comments would be greatly appreciated.
Best Regards,
Ivan Kohler
iThemba LABS,
South Africa

Experimental Physics and Industrial Control System

Experimental Physics and
Industrial Control System