Hi
I am using jRDC2 as my server for an sqlite db.
I composed a query:
Basically the query runs a moving average over the data. Because the query doesn't work I had to bring over all the rows and do the moving average on the Android. Not very efficient.
The error I get is:
(SQLException) java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (near "(": syntax error)
The query runs fine using using an API connection, but fails when submitted to jRDC. All my simpler queries are running fine with jRDC2.
Does anyone know why this is and if it can be worked around?
Who are the developers of jRDC and do they take questions?
Regards
Rob
I am using jRDC2 as my server for an sqlite db.
I composed a query:
SQL:
sql.getDailyData5min=
SELECT
max(UTC_DataTimeStamp) OVER (ORDER BY UTC_DataTimeStamp ROWS BETWEEN 5 PRECEDING AND CURRENT ROW) AS UTC_DataTimeStampfir,
max(InsideTempDegC) OVER (ORDER BY UTC_DataTimeStamp ROWS BETWEEN 5 PRECEDING AND CURRENT ROW) AS InsideTempDegCfir,
max(OutsideTemperatureDegC) OVER (ORDER BY UTC_DataTimeStamp ROWS BETWEEN 5 PRECEDING AND CURRENT ROW) AS OutsideTempDegCfir,
avg(BatteryVolts) OVER (ORDER BY UTC_DataTimeStamp ROWS BETWEEN 5 PRECEDING AND CURRENT ROW) AS BatteryVoltsfir
FROM tblProcessAnalog
ORDER BY UTC_DataTimeStamp DESC
LIMIT 288;
Basically the query runs a moving average over the data. Because the query doesn't work I had to bring over all the rows and do the moving average on the Android. Not very efficient.
The error I get is:
(SQLException) java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (near "(": syntax error)
The query runs fine using using an API connection, but fails when submitted to jRDC. All my simpler queries are running fine with jRDC2.
Does anyone know why this is and if it can be worked around?
Who are the developers of jRDC and do they take questions?
Regards
Rob