Hi I have created a modbus instance and configured the data points. Now if I go to the instance and look at the data points and try to filter on a column, I get a big SQL error:
I am using ubuntu 12.04 and openjdk-7. everthing else seems to work...
Server error: PreparedStatementCallback; bad SQL grammar [SELECT dp.id,dp.data,dp.xid,dp.dataSourceId,dp.name,dp.deviceName,dp.enabled,dp.pointFolderId,dp.loggingType,dp.intervalLoggingPeriodType,dp.intervalLoggingPeriod,dp.intervalLoggingType,dp.tolerance,dp.purgeOverride,dp.purgeType,dp.purgePeriod,dp.defaultCacheSize,dp.discardExtremeValues,dp.engineeringUnits,ds.name,ds.xid,ds.dataSourceType FROM dataPoints AS dp join dataSources ds on ds.id = dp.dataSourceId WHERE ORDER BY dp.deviceName, dp.name]; nested exception is org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SELECT DP.ID,DP.DATA,DP.XID,DP.DATASOURCEID,DP.NAME,DP.DEVICENAME,DP.ENABLED,DP.POINTFOLDERID,DP.LOGGINGTYPE,DP.INTERVALLOGGINGPERIODTYPE,DP.INTERVALLOGGINGPERIOD,DP.INTERVALLOGGINGTYPE,DP.TOLERANCE,DP.PURGEOVERRIDE,DP.PURGETYPE,DP.PURGEPERIOD,DP.DEFAULTCACHESIZE,DP.DISCARDEXTREMEVALUES,DP.ENGINEERINGUNITS,DS.NAME,DS.XID,DS.DATASOURCETYPE FROM DATAPOINTS AS DP JOIN DATASOURCES DS ON DS.ID = DP.DATASOURCEID WHERE ORDER[*] BY DP.DEVICENAME, DP.NAME "; expected "NOT, EXISTS, SELECT, FROM"; SQL statement: SELECT dp.id,dp.data,dp.xid,dp.dataSourceId,dp.name,dp.deviceName,dp.enabled,dp.pointFolderId,dp.loggingType,dp.intervalLoggingPeriodType,dp.intervalLoggingPeriod,dp.intervalLoggingType,dp.tolerance,dp.purgeOverride,dp.purgeType,dp.purgePeriod,dp.defaultCacheSize,dp.discardExtremeValues,dp.engineeringUnits,ds.name,ds.xid,ds.dataSourceType FROM dataPoints AS dp join dataSources ds on ds.id = dp.dataSourceId WHERE ORDER BY dp.deviceName, dp.name [42001-171]
I'd send you a screenshot of my instance but I don't seem to be able to attach anything ...