java.sql.SQLException: data exception: invalid interval format

Oracle Community | 2759327 | 2 years ago
  1. 0

    Characters cannot be loaded into flat file(txt) by using ODI

    Oracle Community | 2 years ago | 2759327
    java.sql.SQLException: data exception: invalid interval format
  2. 0

    ODI data load error

    Oracle Community | 5 years ago | 907888
    java.sql.SQLException: data exception: invalid interval format
  3. 0

    HSQLDB + insert data + error statement

    Stack Overflow | 2 years ago
    java.sql.SQLException: statement does not generate a result set
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Using embedded database with Flyway and jOOQ in Maven for continuous integration

    Stack Overflow | 2 years ago | user2957009
    org.hsqldb.HsqlException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@1096ec89[file =...db/db.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2015-02-09 03:56:15 heartbeat - read: -863 ms.
  6. 0

    User lacks privilege or object not found WITH JUnit

    codedmi.com | 12 months ago
    java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: GROUP

  1. kjhdofjosvs 1 times, last 5 days ago
  2. andyglick 2 times, last 3 weeks ago
  3. marcbouvierdav 1 times, last 1 month ago
  4. WoodenDoors 67 times, last 8 months ago
87 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.hsqldb.HsqlException

    data exception: invalid interval format

    at org.hsqldb.error.Error.error()
  2. HyperSQL Database
    Error.error
    1. org.hsqldb.error.Error.error(Unknown Source)
    2. org.hsqldb.error.Error.error(Unknown Source)
    2 frames
  3. HSQLDB
    JDBCPreparedStatement.executeQuery
    1. org.hsqldb.Scanner.scanIntervalValue(Unknown Source)
    2. org.hsqldb.Scanner.newInterval(Unknown Source)
    3. org.hsqldb.Scanner.convertToDatetimeInterval(Unknown Source)
    4. org.hsqldb.types.IntervalType.convertToType(Unknown Source)
    5. org.hsqldb.types.Type.castToType(Unknown Source)
    6. org.hsqldb.ExpressionOp.getValue(Unknown Source)
    7. org.hsqldb.QuerySpecification.buildResult(Unknown Source)
    8. org.hsqldb.QuerySpecification.getSingleResult(Unknown Source)
    9. org.hsqldb.QuerySpecification.getResult(Unknown Source)
    10. org.hsqldb.StatementQuery.getResult(Unknown Source)
    11. org.hsqldb.StatementDMQL.execute(Unknown Source)
    12. org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    13. org.hsqldb.Session.execute(Unknown Source)
    14. org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source)
    15. org.hsqldb.jdbc.JDBCPreparedStatement.executeQuery(Unknown Source)
    15 frames
  4. oracle.odi.query
    JDBCTemplate.executeQuery
    1. oracle.odi.query.JDBCTemplate.executeQuery(JDBCTemplate.java:189)
    1 frame
  5. oracle.odi.runtime
    DataMovementTaskExecutionHandler.handleTask
    1. oracle.odi.runtime.agent.execution.sql.SQLDataProvider.readData(SQLDataProvider.java:94)
    2. oracle.odi.runtime.agent.execution.sql.SQLDataProvider.readData(SQLDataProvider.java:1)
    3. oracle.odi.runtime.agent.execution.DataMovementTaskExecutionHandler.handleTask(DataMovementTaskExecutionHandler.java:70)
    3 frames
  6. com.sunopsis.dwg
    SnpSession.treatSession
    1. com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)
    2. com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)
    3. com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)
    4. com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)
    5. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)
    5 frames
  7. oracle.odi.runtime
    StartSessRequestProcessor$2.doAction
    1. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:366)
    1 frame
  8. oracle.odi.core
    DwgObjectTemplate.execute
    1. oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
    1 frame
  9. oracle.odi.runtime
    DefaultAgentTaskExecutor$2.run
    1. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:300)
    2. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:292)
    3. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:855)
    4. oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
    5. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
    5 frames
  10. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:662)
    1 frame