org.h2.jdbc.JdbcSQLException: Table "SALE_TRANSACTION" not found; SQL statement: insert into sale_transaction (tran_id, store_id, workstation, day, seq) values (1000, '001', '3', '2014-03-21', 100) [42102-176]

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 symmetricds by mike182764
, 1 year ago
Table "SALE_TRANSACTION" not found; SQL statement: insert into sale_transaction (tran_id, store_id, workstation, day, seq) values (1000, '001', '3', '2014-03-21', 100) [42102-176]
via Stack Overflow by Heinzi
, 2 years ago
Tabelle "MYTABLE" nicht gefunden Table "MYTABLE" not found; SQL statement: INSERT INTO `mytable` (`field1`,`field2`,`field3`) VALUES (?,?,?) [42102-172]
via Stack Overflow by Edward Ng
, 2 years ago
Table "TODO" not found; SQL statement: insert into todo (id, completed, title) values (null, ?, ?) [42102-172]
via Stack Overflow by Paul Taylor
, 2 years ago
Table "SONG" not found; SQL statement: insert into Song (recNo, acoustidFingerprint, acoustidId, album, albumArtist, albumArtistSort, albumSort, amazonId, arranger, artist, artistSort, artists, barcode, bpm, catalogNo, comment, composer
via Stack Overflow by Alex
, 2 years ago
Table "MAP_USER" not found; SQL statement: insert into MAP_USER (ADS_USER, BAD_PASSWORD_COUNT, COST_CENTRE, DB_PASSWORD, DB_USER, department, email, ENABLED_YN, EXPIRING_DATE, EXTERNAL_ID, EXTERNAL_LAST_SYNC, EXTERNAL_REPOSITORY , fax, FULL_NAME
via Stack Overflow by Rahul Kulhari
, 2 years ago
Table "USERD" not found; SQL statement: insert into Userd (email, name, password, empid) values (?, ?, ?, ?) [42102-168]
org.h2.jdbc.JdbcSQLException: Table "SALE_TRANSACTION" not found; SQL statement: insert into sale_transaction (tran_id, store_id, workstation, day, seq) values (1000, '001', '3', '2014-03-21', 100) [42102-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.command.Parser.readTableOrView(Parser.java:5213)
at org.h2.command.Parser.readTableOrView(Parser.java:5190)
at org.h2.command.Parser.parseInsert(Parser.java:1024)
at org.h2.command.Parser.parsePrepared(Parser.java:402)
at org.h2.command.Parser.parse(Parser.java:306)
at org.h2.command.Parser.parse(Parser.java:278)
at org.h2.command.Parser.prepareCommand(Parser.java:243)
at org.h2.engine.Session.prepareLocal(Session.java:442)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:265)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:160)
at java.lang.Thread.run(Thread.java:745)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
2 times, 11 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
151 more bugmates

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