org.h2.jdbc.JdbcSQLException

tip

Check if you're not creating unused SQL entities, as it might cause this exception.


rafael

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • GitHub comment 230#237003937
    via GitHub by mozzbozz
    ,
  • H2 Oracle decode function
    via Stack Overflow by SvRekaa
    ,
  • Failover @Type for h2?
    via Stack Overflow by xenoterracide
    ,
  • Connecting to H2 server from DbVisualizer
    via Stack Overflow by balteo
    ,
  • Scala Play Anorm: Placeholder not replaced
    via by Unknown author,
  • ODBC Error
    via by Jeff Gunther,
  • gerrit as a windows service
    via by Unknown author,
    • org.h2.jdbc.JdbcSQLException: Feld "lastSeen" nicht gefunden Column "lastSeen" not found [42122-176] at org.h2.message.DbException.getJdbcSQLException(DbException.java:344)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at org.h2.message.DbException.get(DbException.java:178)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at org.h2.message.DbException.get(DbException.java:154)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at org.h2.jdbc.JdbcResultSet.getColumnIndex(JdbcResultSet.java:3122)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at org.h2.jdbc.JdbcResultSet.findColumn(JdbcResultSet.java:182)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at com.j256.ormlite.jdbc.JdbcDatabaseResults.findColumn(JdbcDatabaseResults.java:90)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at com.j256.ormlite.field.FieldType.resultToJava(FieldType.java:815)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at com.j256.ormlite.stmt.mapped.BaseMappedQuery.mapRow(BaseMappedQuery.java:60)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at com.j256.ormlite.jdbc.JdbcDatabaseConnection.queryForOne(JdbcDatabaseConnection.java:283)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at com.j256.ormlite.jdbc.JdbcDatabaseConnection.queryForOne(JdbcDatabaseConnection.java:201)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at com.j256.ormlite.stmt.mapped.MappedQueryForId.execute(MappedQueryForId.java:38)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at com.j256.ormlite.field.FieldType.assignField(FieldType.java:558)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at com.j256.ormlite.stmt.mapped.BaseMappedQuery.mapRow(BaseMappedQuery.java:71)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at com.j256.ormlite.jdbc.JdbcDatabaseConnection.queryForOne(JdbcDatabaseConnection.java:283)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at com.j256.ormlite.jdbc.JdbcDatabaseConnection.queryForOne(JdbcDatabaseConnection.java:201)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at com.j256.ormlite.stmt.mapped.MappedQueryForId.execute(MappedQueryForId.java:38)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at com.j256.ormlite.field.FieldType.assignField(FieldType.java:558)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at com.j256.ormlite.stmt.mapped.BaseMappedQuery.mapRow(BaseMappedQuery.java:71)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at com.j256.ormlite.stmt.SelectIterator.getCurrent(SelectIterator.java:270)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at com.j256.ormlite.stmt.SelectIterator.nextThrow(SelectIterator.java:161)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at com.j256.ormlite.stmt.StatementExecutor.query(StatementExecutor.java:202)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at com.j256.ormlite.stmt.StatementExecutor.queryForAll(StatementExecutor.java:118)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at com.j256.ormlite.dao.BaseDaoImpl.queryForAll(BaseDaoImpl.java:241)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at org.mycontroller.standalone.db.dao.BaseAbstractDaoImpl.getAll(BaseAbstractDaoImpl.java:252)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at org.mycontroller.standalone.db.migration.V1_02_08__2016_Jul_01.migrate(V1_02_08__2016_Jul_01.java:74)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at org.flywaydb.core.internal.resolver.jdbc.JdbcMigrationExecutor.execute(JdbcMigrationExecutor.java:45)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:284)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:282)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate.java:282)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at org.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:46)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:207)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:156)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:156)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at org.flywaydb.core.Flyway$1.execute(Flyway.java:1059)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at org.flywaydb.core.Flyway$1.execute(Flyway.java:1006)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at org.flywaydb.core.Flyway.execute(Flyway.java:1418)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at org.flywaydb.core.Flyway.migrate(Flyway.java:1006)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at org.mycontroller.standalone.db.DataBaseUtils.loadDatabase(DataBaseUtils.java:118)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at org.mycontroller.standalone.StartApp.startServices(StartApp.java:243)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at org.mycontroller.standalone.StartApp.startMycontroller(StartApp.java:106)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2] at org.mycontroller.standalone.StartApp.main(StartApp.java:93)[mycontroller-dist-standalone-0.0.3.Alpha2-single.jar:0.0.3.Alpha2]

    Users with the same issue

    tvrmsmith
    23 times, last one,
    batwalrus76
    4 times, last one,
    Unknown visitor1 times, last one,
    aidoan
    1 times, last one,
    guizmaii
    2 times, last one,
    143 more bugmates