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

Oracle Community | 2759327 | 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

    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

    EditView: no validation for fixed format fields

    GitHub | 4 years ago | ikostenko
    org.hsqldb.HsqlException: data exception: numeric value out of range
  6. 0

    SQL initialization with "data.sql" comes too late if using hibernate DDL auto as well

    GitHub | 3 years ago | mihkels
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration': Invocation of init method failed; nested exception is org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement at line 1 of resource URL [file:/C:/projects/personal/sport-store/target/classes/data.sql]: INSERT INTO category (id, name) VALUES (1, 'Watersports'); nested exception is java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: CATEGORY
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