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))]

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via GitHub by gpproton
, 1 year ago
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
via GitHub by gpproton
, 1 year ago
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
via GitHub by moroq
, 2 years ago
Specified key was too long; max key length is 767 bytes [Failed SQL: CREATE TABLE c0_skiltrade.user (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(1024) NOT NULL, email VARCHAR(256) NOT NULL, hashedPassword VARCHAR(1024) NOT NULL, salt VARCHAR(1024
via GitHub by Turbovix
, 1 year ago
0 NOT NULL, admin BIT(1) DEFAULT 0 NOT NULL, map VARCHAR(128) DEFAULT 'osm' NOT NULL, language VARCHAR(128) DEFAULT 'en' NOT NULL, distanceunit VARCHAR(128) DEFAULT 'km' NOT NULL, speedunit VARCHAR(128) DEFAULT 'kmh' NOT NULL, latitude DOUBLE DEFAULT 0 NOT NULL, longitude DOUBLE DEFAULT 0 NOT NULL, zoom INT DEFAULT 0 NOT NULL, CONSTRAINT PK_USERS PRIMARY KEY (id))]
via GitHub by gpproton
, 1 year ago
ORA-01400: cannot insert NULL into ("TRACCAR"."SERVER"."ID") INFO | jvm 1 | 2016/10/16 12:18:15 | WrapperSimpleApp Error: [Failed SQL: INSERT INTO TRACCAR.server (registration, latitude, longitude, zoom) VALUES (1, 0, 0, 0)]
via GitHub by ruan0011
, 1 year ago
The object 'UQ__user__AB6E6164EA813277' is dependent on column 'email'. [Failed SQL: ALTER TABLE [dbo].[user] ALTER COLUMN [email] [varchar](128)]
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(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:45)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:933)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1075)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1718)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1678)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:332)
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:299)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:107)
at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1273)
at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1255)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:568)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:79)
at liquibase.Liquibase.update(Liquibase.java:214)
at liquibase.Liquibase.update(Liquibase.java:192)
at liquibase.Liquibase.update(Liquibase.java:188)
at org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:141)
at org.traccar.database.DataManager.(DataManager.java:67)
at org.traccar.Context.init(Context.java:150)
at org.traccar.Main.main(Main.java:35)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at java.lang.Thread.run(Thread.java:745)

Users with the same issue

6 times, 1 week ago
7 times, 1 month ago
Once, 4 months ago
Once, 9 months ago
3 times, 11 months ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.