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

Oracle Community | 2759327 | 3 years ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

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

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

    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
  6. 0

    EditView: no validation for fixed format fields

    GitHub | 4 years ago | ikostenko
    org.hsqldb.HsqlException: data exception: numeric value out of range
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