liquibase.exception.DatabaseException: ORA-00910: specified length too long for its datatype INFO | jvm 1 | 2016/10/16 11:54:19 | WrapperSimpleApp Error: [Failed SQL: CREATE TABLE TRACCAR.positions (id INTEGER NOT NULL, protocol VARCHAR2(128), deviceid INTEGER NOT NULL, servertime TIMESTAMP NOT NULL, devicetime TIMESTAMP NOT NULL, fixtime TIMESTAMP NOT NULL, valid NUMBER(1) NOT NULL, latitude FLOAT(24) NOT NULL, longitude FLOAT(24) NOT NULL, altitude FLOAT NOT NULL, speed FLOAT NOT NULL, course FLOAT NOT NULL, address VARCHAR2(512), attributes VARCHAR2(4096) NOT NULL, CONSTRAINT PK_POSITIONS PRIMARY KEY (id))]

GitHub | gpproton | 2 months ago
  1. 0

    GitHub comment 2440#254040169

    GitHub | 2 months ago | gpproton
    liquibase.exception.DatabaseException: ORA-00910: specified length too long for its datatype INFO | jvm 1 | 2016/10/16 11:54:19 | WrapperSimpleApp Error: [Failed SQL: CREATE TABLE TRACCAR.positions (id INTEGER NOT NULL, protocol VARCHAR2(128), deviceid INTEGER NOT NULL, servertime TIMESTAMP NOT NULL, devicetime TIMESTAMP NOT NULL, fixtime TIMESTAMP NOT NULL, valid NUMBER(1) NOT NULL, latitude FLOAT(24) NOT NULL, longitude FLOAT(24) NOT NULL, altitude FLOAT NOT NULL, speed FLOAT NOT NULL, course FLOAT NOT NULL, address VARCHAR2(512), attributes VARCHAR2(4096) NOT NULL, CONSTRAINT PK_POSITIONS PRIMARY KEY (id))]
  2. 0

    GitHub comment 900#254040538

    GitHub | 2 months ago | gpproton
    liquibase.exception.DatabaseException: ORA-00910: specified length too long for its datatype INFO | jvm 1 | 2016/10/16 11:54:19 | WrapperSimpleApp Error: [Failed SQL: CREATE TABLE TRACCAR.positions (id INTEGER NOT NULL, protocol VARCHAR2(128), deviceid INTEGER NOT NULL, servertime TIMESTAMP NOT NULL, devicetime TIMESTAMP NOT NULL, fixtime TIMESTAMP NOT NULL, valid NUMBER(1) NOT NULL, latitude FLOAT(24) NOT NULL, longitude FLOAT(24) NOT NULL, altitude FLOAT NOT NULL, speed FLOAT NOT NULL, course FLOAT NOT NULL, address VARCHAR2(512), attributes VARCHAR2(4096) NOT NULL, CONSTRAINT PK_POSITIONS PRIMARY KEY (id))]
  3. 0

    invalid character when running liquibase script

    Stack Overflow | 3 years ago | Marthin
    liquibase.exception.DatabaseException: Error executing SQL CREATE GLOBAL TEMPORARY TABLE TransactionsToMove( TransactionId NUMBER(38,0) NOT NULL, PRIMARY KEY (TransactionId)) ON COMMIT DELETE ROWS;: ORA-00911: invalid character
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    ORA-00933 When trying to insert space followed by "n" Character

    Stack Overflow | 2 years ago | Slettal
    com.googlecode.flyway.core.command.FlywaySqlScriptException: Error executing statement at line 12: INSERT INTO TEST (TEST) VALUES ( ' n');
  6. 0

    Executing SQL Script via Ant

    Stack Overflow | 2 years ago | user1259318
    java.sql.SQLSyntaxErrorException: ORA-00922: Fehlende oder ung├╝ltige Option

    3 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. java.sql.SQLSyntaxErrorException

      ORA-00910: specified length too long for its datatype INFO | jvm 1 | 2016/10/16 11:54:19 | WrapperSimpleApp Error:

      at oracle.jdbc.driver.T4CTTIoer.processError()
    2. Oracle jdbc
      OracleStatementWrapper.execute
      1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
      3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
      4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
      5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
      6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
      7. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202)
      8. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:45)
      9. oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:933)
      10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1075)
      11. oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1718)
      12. oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1678)
      13. oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:332)
      13 frames
    3. Liquibase Core
      Liquibase.update
      1. liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:299)
      2. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
      3. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:107)
      4. liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1273)
      5. liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1255)
      6. liquibase.changelog.ChangeSet.execute(ChangeSet.java:568)
      7. liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)
      8. liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:79)
      9. liquibase.Liquibase.update(Liquibase.java:214)
      10. liquibase.Liquibase.update(Liquibase.java:192)
      11. liquibase.Liquibase.update(Liquibase.java:188)
      11 frames
    4. org.traccar.database
      DataManager.<init>
      1. org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:141)
      2. org.traccar.database.DataManager.<init>(DataManager.java:67)
      2 frames
    5. org.traccar
      Main.main
      1. org.traccar.Context.init(Context.java:150)
      2. org.traccar.Main.main(Main.java:35)
      2 frames
    6. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:606)
      4 frames
    7. Java Service Wrapper
      WrapperSimpleApp.run
      1. org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:325)
      1 frame
    8. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:745)
      1 frame