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 | 4 months ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    GitHub comment 2440#254040169

    GitHub | 4 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 | 4 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

    JDBC, Oracle: Statement to clear all tables: Query works in SQLDeveloper, not in Java

    Stack Overflow | 2 weeks ago | Daniel Huber
    java.sql.SQLSyntaxErrorException: ORA-00922: Fehlende oder ungültige Option
  6. 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');

  1. jpvee 2 times, last 2 months ago
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