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 3560#253645088
    via GitHub by pratapsingh
    ,
  • GitHub comment 378#253649319
    via GitHub by camsaul
    ,
  • GitHub comment 378#253647906
    via GitHub by camsaul
    ,
  • 0.8 업그레이드 오류
    via GitHub by jeonnoej
    ,
  • H2 Oracle decode function
    via Stack Overflow by SvRekaa
    ,
  • Failover @Type for h2?
    via Stack Overflow by xenoterracide
    ,
    • org.h2.jdbc.JdbcSQLException: Function alias "READ_BLOB" already exists; SQL statement: CREATE FORCE ALIAS PUBLIC.READ_BLOB FOR "org.h2.tools.Recover.readBlob" [90076-192] 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.command.ddl.CreateFunctionAlias.update(CreateFunctionAlias.java:42) at org.h2.command.CommandContainer.update(CommandContainer.java:98) at org.h2.command.Command.executeUpdate(Command.java:258) at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:184) at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:158) at org.h2.tools.RunScript.process(RunScript.java:260) at org.h2.tools.RunScript.process(RunScript.java:190) at org.h2.tools.RunScript.process(RunScript.java:328) at org.h2.tools.RunScript.runTool(RunScript.java:141) at org.h2.tools.RunScript.main(RunScript.java:68)

    Users with the same issue

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