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

  1. ,
    Expert tip

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

Solutions on the web

via GitHub by yd1234
, 1 year ago
Unable to run insert stmt on object MetricsBatteryUsage(node=Node(id=16, eui=254, gatewayTable=GatewayTable(id=1, enabled=true, name=MyGw, networkType=MY_SENSORS, timestamp=null, state=UP, statusMessage=Connected Successfully, statusSince
via Stack Overflow by Rubicon
, 2 years ago
Unable to run insert stmt on object com.myapp.tester.Article@7a36824: INSERT INTO `articles` (`category` ,`storyid` ,`body` ,`added` ) VALUES (?,?,?,?)
via GitHub by cimba007
, 1 year ago
=GatewayTable(id=1, enabled=true, name=mosquitto, networkType=MY_SENSORS, timestamp=1470659030270, state=UP, statusMessage=Connected Successfully, statusSince=1471002435640, type=MQTT, properties={p=, u=, bh=tcp://localhost:1883, tp=mysensors-in, cid
via GitHub by cimba007
, 1 year ago
Unable to run insert stmt on object MetricsDoubleTypeDevice(sensorVariable=SensorVariable(id=2, sensor=Sensor(id=2, sensorId=0, type=S_MOTION, name=, lastSeen=1472079238564, node=Node(id=2, eui=20, gatewayTable=GatewayTable(id=1, enabled=true, name
via GitHub by gbrd
, 1 year ago
=true, name=g1, networkType=MY_SENSORS, timestamp=null, state=UP, statusMessage=Connected Successfully, statusSince=1471813237223, type=SERIAL, properties={br=115200, rdr=pi4j, rf=120, dr=Auto, pn=/dev/ttyUSB0}), name=Thermostat, version=1.1, type
org.h2.jdbc.JdbcSQLException: NULL not allowed for column "AVG"; SQL statement:
INSERT INTO `metrics_battery_usage` (`nodeId` ,`timestamp` ,`samples` ,`min` ,`max` ,`avg` ,`aggregationType` ) VALUES (?,?,?,?,?,?,?) [23502-176]	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.table.Column.validateConvertUpdateSequence(Column.java:308)	at org.h2.table.Table.validateConvertUpdateSequence(Table.java:726)	at org.h2.command.dml.Insert.insertRows(Insert.java:152)	at org.h2.command.dml.Insert.update(Insert.java:115)	at org.h2.command.CommandContainer.update(CommandContainer.java:79)	at org.h2.command.Command.executeUpdate(Command.java:254)	at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:158)	at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:144)	at com.j256.ormlite.jdbc.JdbcDatabaseConnection.insert(JdbcDatabaseConnection.java:170)	at com.j256.ormlite.stmt.mapped.MappedCreate.insert(MappedCreate.java:91)	at com.j256.ormlite.stmt.StatementExecutor.create(StatementExecutor.java:450)	at com.j256.ormlite.dao.BaseDaoImpl.create(BaseDaoImpl.java:310)	at org.mycontroller.standalone.db.dao.BaseAbstractDaoImpl.create(BaseAbstractDaoImpl.java:184)	at org.mycontroller.standalone.message.McMessageEngine.internalSubMessageTypeSelector(McMessageEngine.java:250)	at org.mycontroller.standalone.message.McMessageEngine.execute(McMessageEngine.java:129)	at org.mycontroller.standalone.message.McMessageEngine.run(McMessageEngine.java:962)	at java.lang.Thread.run(Thread.java:745)