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 | 2 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Problems with wc:query-runtimes

    GitHub | 2 years 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

    Unable to start dotcms-3.2 on H2

    GitHub | 2 years ago | bryanboza
    org.h2.jdbc.JdbcSQLException: Tabla "QRTZ_TRIGGERS" no encontrada Table "QRTZ_TRIGGERS" not found; SQL statement: select * from qrtz_triggers, qrtz_cron_triggers where (qrtz_triggers.job_group='User Job' or qrtz_triggers.job_group='Recurrent Campaign') and qrtz_triggers.job_group<>'PAUSED' and qrtz_triggers.start_time < ? and qrtz_triggers.trigger_name=qrtz_cron_triggers.trigger_name and qrtz_triggers.trigger_group=qrtz_cron_triggers.trigger_group [42102-176]
  3. 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]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Get error after add spring-boot-starter-web in mybatis-spring-boot-starter-sample-annotation

    GitHub | 5 months ago | QiuMing
    org.h2.jdbc.JdbcSQLException: Table "CITY" not found; SQL statement: select * from city where state = ? [42102-193] ; bad SQL grammar []; nested exception is org.h2.jdbc.JdbcSQLException: Table "CITY" not found; SQL statement: select * from city where state = ? [42102-193]
  6. 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]

  1. batwalrus76 1 times, last 2 weeks ago
  2. Andreas Häber 1 times, last 3 weeks ago
  3. arnaudt 3 times, last 3 weeks ago
  4. arturgajowy 1 times, last 1 month ago
  5. tvrmsmith 2 times, last 1 month ago
4 more registered users
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