I have tested the Hello World Demo on my local server and that is working as expected.

However, I am encountering problems when attempting to connect to MySQL using the modified HelloWorldDataAdapter posted in this thread :


The following errors were logged:

Starting Lightstreamer Server...
Please check logs for detailed information.
21.Oct.16 22:51:36,167 < INFO> Lightstreamer Server 5.1.2 build 1623.14
21.Oct.16 22:51:36,197 < WARN> Lightstreamer is running with a Demo license, which has a limit of 20 concurrent users and can be used for evaluation, development, and testing, but not for production. If you need to evaluate Lightstreamer without this user limit, or need any information on the other license types, please contact info@lightstreamer.com
21.Oct.16 22:51:36,205 < INFO> Lightstreamer Server starting in Vivace edition.
21.Oct.16 22:51:36,417 < INFO> Started RMI server for JMX on port 8888.
21.Oct.16 22:51:36,467 < INFO> Bound RMI Connector for JMX on port 8888 (communication on port 8888).
21.Oct.16 22:51:36,491 < INFO> Bound RMI Connector for Platform mbeans on port 8888 (communication on port 8888).
21.Oct.16 22:51:36,494 < INFO> SERVER pool size set by default at 10.
21.Oct.16 22:51:36,522 < INFO> data_provider element without name attribute; using DEFAULT as the default name.
21.Oct.16 22:51:36,524 < INFO> Loading Metadata Adapter HELLOWORLD
21.Oct.16 22:51:36,524 < INFO> Loading Data Adapter HELLOWORLD.DEFAULT
21.Oct.16 22:51:36,527 < INFO> Finished loading Metadata Adapter HELLOWORLD
21.Oct.16 22:51:36,528
<ERROR> Data Adapter HELLOWORLD.DEFAULT init error: java.lang.ClassNotFoundException: HelloWorldDataAdapter
21.Oct.16 22:51:36,528
<ERROR>Error while loading the Adapters: java.lang.ClassNotFoundException: HelloWorldDataAdapter
21.Oct.16 22:51:36,528
<ERROR> Error while loading the Adapters: HelloWorldDataAdapter.
21.Oct.16 22:51:36,528
<FATAL> Adapters initialization failed.

The following are the browser console errors:

http://localhost:8080/lightstreamer/create_session.js?LS_phase=8503&LS_caus…client_ver sion=6.1&LS_adapter_set=HELLOWORLD&LS_force_head=t rue&LS_eng=s0& Failed to load resource: net::ERR_CONNECTION_REFUSED

I have also tried without success the following:

  • Copied file and set CLASSPATH in the system environment variables to "C:\Program Files (x86)\Java\jdk1.7.0_79\jre\lib\ext\mysql-connector-java-5.1.40-bin.jar"
  • Copied files and set CLASSPATH to \adapters\HelloWorld\lib\mysql-connector-java-5.1.40-bin.jar; and \shared\lib folders\mysql-connector-java-5.1.40-bin.jar;

The source file "HelloWorldDataAdapter.java" would not compile until I placed the "mysql-connector-java-5.1.40-bin.jar" file into the "C:\Program Files (x86)\Java\jdk1.7.0_79\jre\lib\ext" directory.

The test database name, table name and associated fields have been configured to match the example Adapter code, so coding errors can be excluded.

Any assistance would be much appreciated.

Thank you