org.h2.jdbc.JdbcSQLException: Table "ALL_SEQUENCES" not found; SQL statement: select sequence_name from all_sequences union select synonym_name from all_synonyms us, all_sequences asq where asq.sequence_name = us.table_name and asq.sequence_owner = us.table_owner [42102-168]

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 Stack Overflow by user2369634
, 1 year ago
Table "ALL_SEQUENCES" not found; SQL statement: select sequence_name from all_sequences union select synonym_name from all_synonyms us, all_sequences asq where asq.sequence_name = us.table_name and asq.sequence_owner = us.table_owner [42102-168]
via GitHub by mattiasw2
, 1 year ago
Table "GUESTBOOK" not found; SQL statement: SELECT * from guestbook [42102-187]
via GitHub by wezell
, 2 years ago
Table "DOT_CLUSTER" not found; SQL statement: select cluster_id from dot_cluster [42102-169]
via Stack Overflow by raffian
, 2 years ago
Table "NOTE" not found; SQL statement: select this_.id as id0_0_, this_.version as version0_0_, this_.details as details0_0_, this_.title as title0_0_ from note this_ [42102-147]
via GitHub by jousby
, 7 months ago
Table "journal" not found; SQL statement: select "sequence_number" from "journal" where "persistence_id" = ? order by "sequence_number" desc limit 1 [42102-191]
via Stack Overflow by Felipe Oliveira Gutierrez
, 1 year ago
Table "PLAY_EVOLUTIONS" not found; SQL statement: select id, hash, apply_script, revert_script, state, last_problem from play_evolutions where state like 'applying_%' [42102-191]
org.h2.jdbc.JdbcSQLException: Table "ALL_SEQUENCES" not found; SQL statement: select sequence_name from all_sequences union select synonym_name from all_synonyms us, all_sequences asq where asq.sequence_name = us.table_name and asq.sequence_owner = us.table_owner [42102-168]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:169)
at org.h2.message.DbException.get(DbException.java:146)
at org.h2.command.Parser.readTableOrView(Parser.java:4770)
at org.h2.command.Parser.readTableFilter(Parser.java:1084)

Users with the same issue

Once, 1 week ago
Once, 1 week ago
4 times, 1 week ago
Once, 3 weeks ago
4 times, 1 month ago
150 more bugmates

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