org.h2.jdbc.JdbcSQLException

If you like a tip written by other Samebug users, mark is as helpful! Marks help our algorithm provide you better solutions and also help other users.
tip

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


rafaelrafael

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

  • GitHub comment 1223#228852354
    via GitHub by tundratim
    ,
  • GitHub comment 791#279014277
    via GitHub by schbetsy
    ,
  • 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
    ,
    • org.h2.jdbc.JdbcSQLException: Column "X3.ORIGIN_REPOSITORY_NAME" not found; SQL statement: CREATE FORCE VIEW PUBLIC._6 AS SELECT X3.UPDATED_DATE AS UPDATED_DATE, X3.DESCRIPTION AS DESCRIPTION, X3.ORIGIN_REPOSITORY_NAME AS ORIGIN_REPOSITORY_NAME, X3.ORIGIN_USER_NAME AS ORIGIN_USER_NAME, X3.TITLE AS TITLE, X3.PRIVATE AS PRIVATE, X3.REPOSITORY_NAME AS REPOSITORY_NAME, X3.USER_NAME AS USER_NAME, X3.REGISTERED_DATE AS REGISTERED_DATE FROM PUBLIC.GIST X3 WHERE (X3.USER_NAME = ?1) AND (X3.PRIVATE = ?2) ORDER BY =X3.REGISTERED_DATE DESC LIMIT 10 [42122-190] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) at org.h2.message.DbException.get(DbException.java:179) at org.h2.message.DbException.get(DbException.java:155) at org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:147) at org.h2.expression.Alias.optimize(Alias.java:51) at org.h2.command.dml.Select.prepare(Select.java:835) at org.h2.command.Parser.prepare(Parser.java:226) at org.h2.engine.Session.prepare(Session.java:426) at org.h2.engine.Session.prepare(Session.java:413) at org.h2.table.TableView.compileViewQuery(TableView.java:106) at org.h2.table.TableView.initColumnsAndTables(TableView.java:151) at org.h2.table.TableView.init(TableView.java:102) at org.h2.table.TableView.<init>(TableView.java:67) at org.h2.table.TableView.createTempView(TableView.java:512) at org.h2.command.Parser.readTableFilter(Parser.java:1169) at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1873) at org.h2.command.Parser.parseSelectSimple(Parser.java:1982) at org.h2.command.Parser.parseSelectSub(Parser.java:1867) at org.h2.command.Parser.parseSelectUnion(Parser.java:1688) at org.h2.command.Parser.parseSelect(Parser.java:1676)

    Users with the same issue

    guizmaiiguizmaii
    21 times, last one,
    tvrmsmithtvrmsmith
    2 times, last one,
    batwalrus76batwalrus76
    4 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    aidoanaidoan
    1 times, last one,
    143 more bugmates