io.requery.sql.StatementExecutionException: Exception executing statement: insert into Event (code, colour, dayName, endTime, name, roomCode, roomDescription, staff, startTime, studentOwner, type, weeks) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

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

activity.OnCreate is executed every time the app launches or the screen is rotated, so, putting your DB initialization inside it will cause the DB to be called too many times causing the exception. Try to use the MyDatabase.onCreate method for this.

Solutions on the web

via GitHub by dabx
, 1 year ago
Exception executing statement: insert into Event (code, colour, dayName, endTime, name, roomCode, roomDescription, staff, startTime, studentOwner, type, weeks) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
via GitHub by danysz
, 1 year ago
Exception executing statement: insert into Connection (SSID, iPAddressLocal, iPAddressRemote, name, password, portLocal, portRemote, userName, vBoxLastUpdate) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
via GitHub by AlexeyKorshun
, 9 months ago
Exception executing statement: insert into Team (id, coach, name) values (?, ?, ?)
io.requery.sql.StatementExecutionException: Exception executing statement: insert into Event (code, colour, dayName, endTime, name, roomCode, roomDescription, staff, startTime, studentOwner, type, weeks) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method)
at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:782)
at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788)
at io.requery.android.sqlite.SqlitePreparedStatement.executeUpdate(SqlitePreparedStatement.java:160)
at io.requery.sql.EntityUpdateOperation$1.evaluate(EntityUpdateOperation.java:69)
at io.requery.sql.EntityUpdateOperation$1.evaluate(EntityUpdateOperation.java:55)
at io.requery.query.BaseScalar.value(BaseScalar.java:49)
at io.requery.sql.EntityWriter.insert(EntityWriter.java:452)
at io.requery.sql.EntityWriter.cascadeWrite(EntityWriter.java:926)
at io.requery.sql.EntityWriter.updateInverseAssociation(EntityWriter.java:782)
at io.requery.sql.EntityWriter.updateAssociations(EntityWriter.java:665)
at io.requery.sql.EntityWriter.insert(EntityWriter.java:454)
at io.requery.sql.EntityWriter.insert(EntityWriter.java:410)
at io.requery.sql.EntityDataStore.insert(EntityDataStore.java:209)
at io.requery.sql.EntityDataStore.insert(EntityDataStore.java:199)
at io.requery.rx.SingleEntityStoreFromBlocking$1.get(SingleEntityStoreFromBlocking.java:87)
at io.requery.rx.SingleOnSubscribeFromSupplier.call(SingleOnSubscribeFromSupplier.java:34)
at io.requery.rx.SingleOnSubscribeFromSupplier.call(SingleOnSubscribeFromSupplier.java:23)
at rx.Single$1.call(Single.java:94)
at rx.Single$1.call(Single.java:74)
at rx.Single.subscribe(Single.java:1822)
at rx.Single.subscribe(Single.java:1899)
at rx.Single$19$1.call(Single.java:1954)
at rx.internal.schedulers.ScheduledAction.run(ScheduledAction.java:55)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1113)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:588)
at java.lang.Thread.run(Thread.java:818)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
4 times, 11 months ago
Once, 5 months ago
617 times, 1 year ago
Once, 1 year ago
72 more bugmates

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