@craigweb I think this protocol is important. And many hardware supports this protocol. Does Mango have a timetable to support this?

Or is there a way to indirectly support the hardware of this protocol?

Or is there a manual support method? Now I have passed c# to Read and Write my hardware.

I found an OPCDA protocol data-source. And I use Mango OPCDA to connect my OPCDAserver. Successed!
But I dont find OPCUA protocol data-source. Is there something I missed?
How to connect my OPCUAserver and read&write data?

I was not so clear with this thing, but it do solved!

here is my solution:
"connectionUrl":"jdbc:mysql://localhost:3306/test",
"driverClassname":"com.mysql.jdbc.Driver",

Note: replace "localhost" "3306" "test" if needed.

//your code here
{
   "dataSources":[
      {
         "xid":"DS_64b30a4f-d8c2-4b8a-9978-1b9c085893b6",
         "name":"test_SQL",
         "enabled":false,
         "type":"SQL",
         "alarmLevels":{
            "POLL_ABORTED":"URGENT",
            "STATEMENT_EXCEPTION":"URGENT",
            "DATA_SOURCE_EXCEPTION":"URGENT"
         },
         "purgeType":"YEARS",
         "updatePeriodType":"SECONDS",
         "connectionUrl":"192.168.61.191:3306",
         "driverClassname":"MySQL",
         "password":"1234",
         "rowBasedQuery":false,
         "selectStatement":"select * from biao;",
         "updatePeriods":5,
         "username":"root",
         "editPermission":"",
         "purgeOverride":false,
         "purgePeriod":1
      }
   ]
}

It's not clear what "driverClassname" means.
The database I use is MySQL, what should i type in ? "com.mysql.jdbc.Driver"(same error below)?

when I click "SQL Statement Testing", It shows an error: class java.lang.ClassNotFoundException: MySQL

@craigweb thank you !
this problem solved!

@craigweb thank you first!
I don't know if what I'm offering is what you want.
here is "dashboard code":

<ma-point-value id="e76d6d6c-45f1-440c-90f3-c446aa6c87b6" enable-popup="hide" style="position: absolute; left: 399px; top: 75px; width: 25px; height: 25px;" point-xid="DP_c6eebfd0-d128-4ea2-8bf1-77f7cf355edd"></ma-point-value>
<ma-switch id="078c0795-8eba-4cc1-9166-f62c62de3af6" style="position: absolute; left: 394px; top: 220px; width: 50px; height: 50px; background-color: rgb(0, 46, 92);" point-xid="DP_da02f5a8-afc1-4ecb-ba8c-403ffe6345dd"></ma-switch>

here is dataSource-dataPoint(SET_LIGHT):
(also, I use mango-publisher to publish this. In this way I control my light)
(<ma-switch> Connect with this)

{
   "dataPoints":[
      {
         "xid":"DP_da02f5a8-afc1-4ecb-ba8c-403ffe6345dd",
         "name":"Light01_print",
         "enabled":true,
         "loggingType":"ON_CHANGE",
         "intervalLoggingPeriodType":"MINUTES",
         "intervalLoggingType":"INSTANT",
         "purgeType":"YEARS",
         "pointLocator":{
            "dataType":"BINARY",
            "changeType":{
               "type":"NO_CHANGE",
               "startValue":"0"
            },
            "settable":true
         },
         "eventDetectors":[
         ],
         "plotType":"STEP",
         "rollup":"NONE",
         "unit":"",
         "templateXid":"Light",
         "simplifyType":"NONE",
         "chartColour":"",
         "chartRenderer":{
            "type":"TABLE",
            "limit":10
         },
         "dataSourceXid":"DS_afafb004-8328-49e6-8bbb-1e5520c377d8",
         "defaultCacheSize":1,
         "deviceName":"TEST2",
         "discardExtremeValues":false,
         "discardHighLimit":1.7976931348623157E308,
         "discardLowLimit":-1.7976931348623157E308,
         "intervalLoggingPeriod":15,
         "intervalLoggingSampleWindowSize":0,
         "overrideIntervalLoggingSamples":false,
         "preventSetExtremeValues":false,
         "purgeOverride":false,
         "purgePeriod":1,
         "readPermission":"",
         "setExtremeHighLimit":1.7976931348623157E308,
         "setExtremeLowLimit":-1.7976931348623157E308,
         "setPermission":"",
         "tags":{
         },
         "textRenderer":{
            "type":"BINARY",
            "oneColour":"#99ff99",
            "oneLabel":"",
            "zeroColour":"#c0c0ee",
            "zeroLabel":""
         },
         "tolerance":0.0
      }
   ]
}

here is dataSource-dataPoint(GET_LIGHT):
My light send HTTP message to Mango.

{
   "dataPoints":[
      {
         "xid":"DP_c6eebfd0-d128-4ea2-8bf1-77f7cf355edd",
         "name":"light01",
         "enabled":true,
         "loggingType":"ON_CHANGE",
         "intervalLoggingPeriodType":"MINUTES",
         "intervalLoggingType":"INSTANT",
         "purgeType":"YEARS",
         "pointLocator":{
            "dataType":"BINARY",
            "binary0Value":"false",
            "includeTimestamp":false,
            "parameterName":"light01",
            "setPointName":"",
            "settable":false
         },
         "eventDetectors":[
         ],
         "plotType":"STEP",
         "rollup":"NONE",
         "unit":"",
         "templateXid":"ReadLight",
         "simplifyType":"NONE",
         "chartColour":"",
         "chartRenderer":{
            "type":"TABLE",
            "limit":10
         },
         "dataSourceXid":"DS_0638891e-846e-4413-a3d3-c5b5596f688a",
         "defaultCacheSize":1,
         "deviceName":"light_source",
         "discardExtremeValues":false,
         "discardHighLimit":1.7976931348623157E308,
         "discardLowLimit":-1.7976931348623157E308,
         "intervalLoggingPeriod":15,
         "intervalLoggingSampleWindowSize":0,
         "overrideIntervalLoggingSamples":false,
         "preventSetExtremeValues":false,
         "purgeOverride":false,
         "purgePeriod":1,
         "readPermission":"",
         "setExtremeHighLimit":1.7976931348623157E308,
         "setExtremeLowLimit":-1.7976931348623157E308,
         "setPermission":"",
         "tags":{
         },
         "textRenderer":{
            "type":"BINARY",
            "oneColour":"#eeee00",
            "oneLabel":"亮",
            "zeroColour":"#c0c0ee",
            "zeroLabel":"灭"
         },
         "tolerance":0.0
      }
   ]
}

[virtual data source] and [<ma-switch> control and show data] work well
[virtual data publisher] work well
[hard device (light)] work well
[<ma-point-value> receive HTTP msg and show value] work well
The problem is that when someone controls the light from other systems, <ma-point-value> displays normally and the <ma-switch> does not.
(Of course I know because the data is not connected. but how)
(Please let me know what else you need.)

Sorry, my title is not very clear.

• I have a dataSource from HTTP receiver. Here we set the datapoint's name GET_LIGHT.
  I dessigned a dashboard. using "Point Value" to show GET_LIGHT's value. <- work well

• I have a dataSource from Virtual data source. Here we set the datapoint's name SET_LIGHT.
  at the same dashboard. using "Binary Switch Button" to control SET_LIGHT's value. <- work well

• when they work together, Control the "Binary Switch Button" and "Point Value" changed(Although they are not directly connected). <- work well

• BUT, when another controller change the light(such as using light_switch at scene). "Point Value" in dashboard can change. "Binary Switch Button" can NOT change(because the Virtual data source not change). <- problem here

I'm not very proficient in using Mango system.
is there a way when GET_LIGHT changed making the Virtual data source SET_LIGHT change as well?
Or I dont need a Virtual data source, another way to solve this problem?

review this topic title, How can I describe this problem in one sentence? ^_^

thank you！

I think I need to improve myself for some time.
It's simpler to use Mango.

I think I understand. Thank you very much!

Mango Public Code：https://github.com/infiniteautomation/ma-core-public

I don't know JAVA very well. Suppose I have studied JAVA for half a year.

I want to know what architecture these codes use (or how I should start reading).
The Learning Route I Formulated is: java -> spring -> Mango Public Code. Do you have any suggestions for this?

My editor (Idea) told me that some of the packages used in the code did not exist.

java: packages org.apache.commons.io did not exist
java: packages org.apache.commons.io.comparator did not exist
java: packages org.apache.commons.io.output did not exist

and there is a strange problem: (but i really find the class in project)

java: can not find symbol
  symbol:   class CompiledCoreVersion
  position: packages com.infiniteautomation.mango