net.esper.client.EPStatementException: Error starting view: Error in statement 'select myint from "testtable" where ? = myint', failed to obtain result metadata, please check the statement, reason: statement handle not executed: getMetaData [select myint from  sql:MyDB ['select myint from "TOM_testtable" where ${intPrimitive} = myint'] as s0,net.esper.support.bean.SupportBean.win:time_batch(10 sec) as s1]

nabble.com | 7 months 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

    Esper Dev list - [jira] Created: (ESPER-142) ESPER Relational Database Access does not work with Oracle JDBC

    nabble.com | 7 months ago
    net.esper.client.EPStatementException: Error starting view: Error in statement 'select myint from "testtable" where ? = myint', failed to obtain result metadata, please check the statement, reason: statement handle not executed: getMetaData [select myint from  sql:MyDB ['select myint from "TOM_testtable" where ${intPrimitive} = myint'] as s0,net.esper.support.bean.SupportBean.win:time_batch(10 sec) as s1]
  2. 0

    jira.codehaus.org

    espertech.com | 7 months ago
    net.esper.client.EPStatementException: Error starting view: Invalid schema - the root element must have at least either attribute declarations or childs elements [select ID as sensorId, coalesce(sum(countTags), 0) as numTagsPerSensor from AutoIdRFIDExample.win:time(60 sec) where Observation .Command = 'READ_PALLET_TAGS_ONLY' group by ID]

    Root Cause Analysis

    1. net.esper.client.EPStatementException

      Error starting view: Error in statement 'select myint from "testtable" where ? = myint', failed to obtain result metadata, please check the statement, reason: statement handle not executed: getMetaData [select myint from  sql:MyDB ['select myint from "TOM_testtable" where ${intPrimitive} = myint'] as s0,net.esper.support.bean.SupportBean.win:time_batch(10 sec) as s1]

      at net.esper.core.StatementLifecycleSvcImpl.startInternal()
    2. net.esper.core
      EPAdministratorImpl.createEQL
      1. net.esper.core.StatementLifecycleSvcImpl.startInternal(StatementLifecycleSvcImpl.java:348)
      2. net.esper.core.StatementLifecycleSvcImpl.start(StatementLifecycleSvcImpl.java:307)
      3. net.esper.core.StatementLifecycleSvcImpl.createAndStart(StatementLifecycleSvcImpl.java:80)
      4. net.esper.core.EPAdministratorImpl.createEQLStmt(EPAdministratorImpl.java:174)
      5. net.esper.core.EPAdministratorImpl.createEQL(EPAdministratorImpl.java:87)
      5 frames
    3. net.esper.regression
      TestDatabaseJoin.testTimeBatch
      1. net.esper.regression.db.TestDatabaseJoin.testTimeBatch(TestDatabaseJoin.java:60)
      1 frame
    4. Java RT
      DelegatingMethodAccessorImpl.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3 frames
    5. IDEA
      JUnitStarter.main
      1. com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:40)
      1 frame
    6. Java RT
      DelegatingMethodAccessorImpl.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3 frames
    7. IDEA
      AppMain.main
      1. com.intellij.rt.execution.application.AppMain.main(AppMain.java:90)
      1 frame