org.h2.jdbc.JdbcSQLException: Function "MEDIAN" not found; SQL statement: SELECT e.suite as suite, e.name as name, MEDIAN(er.time) as median_time, MIN(er.time) as min_time, MAX(er.time) as max_time FROM experiment e, experiment_run er WHERE e.id = er.experiment_id AND e.suite = ? GROUP BY e.suite, e.name ORDER BY e.suite, e.name [90022-187]

GitHub | Rubenito | 1 year ago
  1. 0

    Problems with wc:query-runtimes

    GitHub | 1 year ago | Rubenito
    org.h2.jdbc.JdbcSQLException: Function "MEDIAN" not found; SQL statement: SELECT e.suite as suite, e.name as name, MEDIAN(er.time) as median_time, MIN(er.time) as min_time, MAX(er.time) as max_time FROM experiment e, experiment_run er WHERE e.id = er.experiment_id AND e.suite = ? GROUP BY e.suite, e.name ORDER BY e.suite, e.name [90022-187]
  2. 0

    CachedRowSet Support

    Google Groups | 3 years ago | da...@dandymadeproductions.com
    org.h2.jdbc.JdbcSQLException: Column "NAME" not found; SQL statement: INSERT INTO KEY_TABLES.PUBLIC."key_table5" (name, color, price) VALUES (?, ?, ?) [42122-175]
  3. 0

    H2Data cannot cope with periods in column names

    GitHub | 2 years ago | dpisarenko
    java.io.IOException: java.sql.SQLException: org.h2.jdbc.JdbcSQLException: Unbekannter Datentyp: "." Unknown data type: "."; SQL statement: CREATE TABLE table (user.urn VARCHAR PRIMARY KEY,domain.name CLOB,domain.key CLOB,domain.secret CLOB,domain.region CLOB,domain.bucket CLOB,domain.syslog CLOB) [50004-176]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    JdbcSQLException: Table "FILECHECKS" not found

    GitHub | 2 years ago | eallik
    org.h2.jdbc.JdbcSQLException: Table "FILECHECKS" not found; SQL statement: select x2."id", x2."filename", x2."timestamp" from "FILECHECKS" x2 [42102-182]
  6. 0

    Login not working after a few hours of being running

    GitHub | 2 years ago | imduffy15
    org.h2.jdbc.JdbcSQLException: Table "T_USER" not found; SQL statement: select user0_.login as login1_5_0_, user0_.created_by as created_2_5_0_, user0_.created_date as created_3_5_0_, user0_.last_modified_by as last_mod4_5_0_, user0_.last_modified_date as last_mod5_5_0_, user0_.email as email6_5_0_, user0_.first_name as first_na7_5_0_, user0_.lang_key as lang_key8_5_0_, user0_.last_name as last_nam9_5_0_, user0_.password as passwor10_5_0_ from T_USER user0_ where user0_.login=? [42102-175]

  1. kjhdofjosvs 2 times, last 3 weeks ago
  2. Luka 4 times, last 2 months ago
  3. andyglick 1 times, last 10 months ago
17 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. org.h2.jdbc.JdbcSQLException

    Function "MEDIAN" not found; SQL statement: SELECT e.suite as suite, e.name as name, MEDIAN(er.time) as median_time, MIN(er.time) as min_time, MAX(er.time) as max_time FROM experiment e, experiment_run er WHERE e.id = er.experiment_id AND e.suite = ? GROUP BY e.suite, e.name ORDER BY e.suite, e.name [90022-187]

    at org.h2.message.DbException.getJdbcSQLException()
  2. H2 Database Engine
    JdbcConnection.prepareStatement
    1. org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
    2. org.h2.message.DbException.get(DbException.java:179)
    3. org.h2.message.DbException.get(DbException.java:155)
    4. org.h2.command.Parser.readJavaFunction(Parser.java:2351)
    5. org.h2.command.Parser.readFunction(Parser.java:2403)
    6. org.h2.command.Parser.readTerm(Parser.java:2737)
    7. org.h2.command.Parser.readFactor(Parser.java:2259)
    8. org.h2.command.Parser.readSum(Parser.java:2246)
    9. org.h2.command.Parser.readConcat(Parser.java:2216)
    10. org.h2.command.Parser.readCondition(Parser.java:2066)
    11. org.h2.command.Parser.readAnd(Parser.java:2038)
    12. org.h2.command.Parser.readExpression(Parser.java:2030)
    13. org.h2.command.Parser.parseSelectSimpleSelectPart(Parser.java:1942)
    14. org.h2.command.Parser.parseSelectSimple(Parser.java:1974)
    15. org.h2.command.Parser.parseSelectSub(Parser.java:1868)
    16. org.h2.command.Parser.parseSelectUnion(Parser.java:1689)
    17. org.h2.command.Parser.parseSelect(Parser.java:1677)
    18. org.h2.command.Parser.parsePrepared(Parser.java:433)
    19. org.h2.command.Parser.parse(Parser.java:305)
    20. org.h2.command.Parser.parse(Parser.java:277)
    21. org.h2.command.Parser.prepareCommand(Parser.java:242)
    22. org.h2.engine.Session.prepareLocal(Session.java:461)
    23. org.h2.engine.Session.prepareCommand(Session.java:403)
    24. org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1189)
    25. org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:72)
    26. org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:277)
    26 frames
  3. anorm
    SimpleSql$$anonfun$preparedStatement$1.apply
    1. anorm.SimpleSql.getFilledStatement(SimpleSql.scala:59)
    2. anorm.SimpleSql$$anonfun$preparedStatement$1.apply(SimpleSql.scala:70)
    3. anorm.SimpleSql$$anonfun$preparedStatement$1.apply(SimpleSql.scala:70)
    3 frames
  4. resource
    DeferredExtractableManagedResource.acquireAndGet
    1. resource.DefaultManagedResource.open(AbstractManagedResource.scala:106)
    2. resource.AbstractManagedResource.acquireFor(AbstractManagedResource.scala:85)
    3. resource.ManagedResourceOperations$$anon$2.acquireFor(ManagedResourceOperations.scala:40)
    4. resource.DeferredExtractableManagedResource.acquireFor(AbstractManagedResource.scala:27)
    5. resource.ManagedResourceOperations$class.acquireAndGet(ManagedResourceOperations.scala:25)
    6. resource.DeferredExtractableManagedResource.acquireAndGet(AbstractManagedResource.scala:24)
    6 frames
  5. anorm
    Sql$$anonfun$asTry$1.apply
    1. anorm.Sql$$anonfun$asTry$1.apply(Anorm.scala:302)
    2. anorm.Sql$$anonfun$asTry$1.apply(Anorm.scala:302)
    2 frames
  6. Scala
    Try$.apply
    1. scala.util.Try$.apply(Try.scala:161)
    1 frame
  7. anorm
    SimpleSql.as
    1. anorm.Sql$.asTry(Anorm.scala:302)
    2. anorm.WithResult$class.as(SqlResult.scala:120)
    3. anorm.SimpleSql.as(SimpleSql.scala:6)
    3 frames
  8. de.tuberlin.cit
    QueryRuntimes.run
    1. de.tuberlin.cit.experiments.iterations.cli.command.QueryRuntimes.run(QueryRuntimes.scala:87)
    1 frame
  9. org.peelframework.core
    Peel.main
    1. org.peelframework.core.cli.Peel$.main(Peel.scala:104)
    2. org.peelframework.core.cli.Peel.main(Peel.scala)
    2 frames