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]

tip

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


rafael

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • Error in the sample application
    via GitHub by djonmayer
    ,
  • H2 Oracle decode function
    via Stack Overflow by SvRekaa
    ,
  • Failover @Type for h2?
    via Stack Overflow by xenoterracide
    ,
  • Connecting to H2 server from DbVisualizer
    via Stack Overflow by balteo
    ,
  • Scala Play Anorm: Placeholder not replaced
    via by Unknown author,
  • ODBC Error
    via by Jeff Gunther,
    • 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)[h2-1.3.168.jar:1.3.168] at org.h2.message.DbException.get(DbException.java:169)[h2-1.3.168.jar:1.3.168] at org.h2.message.DbException.get(DbException.java:146)[h2-1.3.168.jar:1.3.168] at org.h2.command.Parser.readTableOrView(Parser.java:4770)[h2-1.3.168.jar:1.3.168] at org.h2.command.Parser.readTableFilter(Parser.java:1084)[h2-1.3.168.jar:1.3.168] at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1690)[h2-1.3.168.jar:1.3.168]

    Users with the same issue

    batwalrus76
    batwalrus764 times, last one,
    Unknown visitor1 times, last one,
    aidoan
    aidoan1 times, last one,
    guizmaii
    guizmaii2 times, last one,
    tvrmsmith
    tvrmsmith1 times, last one,
    143 more bugmates