java.sql.SQLException: Could not perform raw query for SELECT sensorVariableId, MIN(min) AS min, MAX(max) AS max, SUM(avg*samples)/SUM(samples) AS avg, SUM(samples) AS samples, 1484940146167 AS timestamp FROM metrics_double_type_device WHERE sensorVariableId=2,827 AND timestamp > 1484940086167 AND timestamp <= 1484940146167 GROUP BY sensorVariableId

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
Expert tip

Check if you're not creating unused SQL entities, as it might cause this exception.

Solutions on the web

via GitHub by Redferne
, 9 months ago
Could not perform raw query for SELECT sensorVariableId, MIN(min) AS min, MAX(max) AS max, SUM(avg*samples)/SUM(samples) AS avg, SUM(samples) AS samples, 1484940146167 AS timestamp FROM metrics_double_type_device WHERE sensorVariableId=2,827 AND timestamp > 1484940086167 AND timestamp <= 1484940146167 GROUP BY sensorVariableId
via GitHub by tomorrowboy
, 1 year ago
Problems executing Android query: SELECT * FROM `t_wkItem`
via Stack Overflow by John Ernest Guadalupe
, 2 years ago
queryForLong from database failed: SELECT COUNT(*) FROM `table` WHERE `id` = ?
via ormlite by cuak
, 1 year ago
Problems executing Android query: SELECT * FROM `file` WHERE (`path` = '/Marketing/Datasheets/What's_New.pdf' AND `persisted` = 1 )
via GitHub by kunall17
, 10 months ago
updating database failed: UPDATE `people` SET `avatarUrl` = ?, `email` = ?, `isActive` = ?, `isBot` = ?, `name` = ? WHERE `id` = ?
via Stack Overflow by Ascorbin
, 1 year ago
Problems executing Android query: SELECT * FROM `account`
java.sql.SQLException: Could not perform raw query for SELECT sensorVariableId, MIN(min) AS min, MAX(max) AS max, SUM(avg*samples)/SUM(samples) AS avg, SUM(samples) AS samples, 1484940146167 AS timestamp FROM metrics_double_type_device WHERE sensorVariableId=2,827 AND timestamp > 1484940086167 AND timestamp <= 1484940146167 GROUP BY sensorVariableId
at org.h2.message.DbException.getJdbcSQLException(DbException.java:344)
at org.h2.message.DbException.get(DbException.java:178)
at org.h2.message.DbException.get(DbException.java:154)
at org.h2.message.DbException.getSyntaxError(DbException.java:190)
at org.h2.command.Parser.getSyntaxError(Parser.java:517)
at org.h2.command.Parser.prepareCommand(Parser.java:246)
at org.h2.engine.Session.prepareLocal(Session.java:442)
at org.h2.engine.Session.prepareCommand(Session.java:384)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1188)
at org.h2.jdbc.JdbcPreparedStatement.(JdbcPreparedStatement.java:73)
at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:665)
at com.j256.ormlite.stmt.StatementExecutor.queryRaw(StatementExecutor.java:302)
at org.mycontroller.standalone.api.MetricApi.getSensorVariableMetricsDouble(MetricApi.java:145)
at org.mycontroller.standalone.api.jaxrs.MetricsHandler.getMetricsDataJsonNVD3(MetricsHandler.java:824)
at org.mycontroller.standalone.api.jaxrs.MetricsHandler.getMetricsNvd3Data(MetricsHandler.java:134)
at sun.reflect.GeneratedMethodAccessor56.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:139)
at org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:295)
at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:249)
at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:236)
at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:395)
at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:202)
at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:221)
at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)
at org.jboss.resteasy.plugins.server.tjws.TJWSServletDispatcher.service(TJWSServletDispatcher.java:40)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at Acme.Serve.Serve$ServeConnection.runServlet(Serve.java:2328)
at Acme.Serve.Serve$ServeConnection.parseRequest(Serve.java:2282)
at Acme.Serve.Serve$ServeConnection.run(Serve.java:2054)
at java.lang.Thread.run(Thread.java:745)

Users with the same issue

10 times, 8 months ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
2 times, 9 months ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
152 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.