Caused by: org.h2.jdbc.JdbcSQLException: Unknown data type: "JSON"; SQL statement:

最新推荐文章于 2024-09-28 01:29:58 发布
最新推荐文章于 2024-09-28 01:29:58 发布
阅读量5.6k 收藏
点赞数
分类专栏： java playframework
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/w5688414/article/details/88680500
版权

今天在写ebean写json语句的时候出现了上述的错误：

com.google.inject.CreationException: Unable to create injector, see the following errors:

1) Error injecting constructor, javax.persistence.PersistenceException: Failed to run script
  at play.db.ebean.EbeanDynamicEvolutions.<init>(EbeanDynamicEvolutions.java:35)
  at play.db.ebean.EbeanDynamicEvolutions.class(EbeanDynamicEvolutions.java:32)
  while locating play.db.ebean.EbeanDynamicEvolutions
  at Module.configure(Module.java:46) (via modules: com.google.inject.util.Modules$OverrideModule -> Module)
  while locating play.api.db.evolutions.DynamicEvolutions
  while locating play.api.db.evolutions.ApplicationEvolutionsProvider
  at play.api.db.evolutions.EvolutionsModule.<init>(EvolutionsModule.scala:20):
Binding(class play.api.db.evolutions.ApplicationEvolutions to ProviderConstructionTarget(class play.api.db.evolutions.ApplicationEvolutionsProvider) eagerly) (via modules: com.google.inject.util.Modules$OverrideModule -> play.api.inject.guice.GuiceableModuleConversions$$anon$4)
  while locating play.api.db.evolutions.ApplicationEvolutions
Caused by: javax.persistence.PersistenceException: Failed to run script
	at io.ebeaninternal.dbmigration.DdlGenerator.runScript(DdlGenerator.java:126)
	at io.ebeaninternal.dbmigration.DdlGenerator.runCreateSql(DdlGenerator.java:154)
	at io.ebeaninternal.dbmigration.DdlGenerator.runDdl(DdlGenerator.java:93)
	at io.ebeaninternal.dbmigration.DdlGenerator.execute(DdlGenerator.java:68)
	at io.ebeaninternal.server.core.DefaultServer.executePlugins(DefaultServer.java:311)
	at io.ebeaninternal.server.core.DefaultContainer.createServer(DefaultContainer.java:146)
	at io.ebeaninternal.server.core.DefaultContainer.createServer(DefaultContainer.java:45)
	at io.ebean.EbeanServerFactory.createInternal(EbeanServerFactory.java:109)
	at io.ebean.EbeanServerFactory.create(EbeanServerFactory.java:70)
	at play.db.ebean.EbeanDynamicEvolutions.lambda$start$3(EbeanDynamicEvolutions.java:49)
	at java.util.HashMap.forEach(HashMap.java:1288)
	at play.db.ebean.EbeanDynamicEvolutions.start(EbeanDynamicEvolutions.java:49)
	at play.db.ebean.EbeanDynamicEvolutions.<init>(EbeanDynamicEvolutions.java:38)
	at play.db.ebean.EbeanDynamicEvolutions$$FastClassByGuice$$52c94231.newInstance(<generated>)
	at com.google.inject.internal.DefaultConstructionProxyFactory$FastClassProxy.newInstance(DefaultConstructionProxyFactory.java:89)
	at com.google.inject.internal.ConstructorInjector.provision(ConstructorInjector.java:111)
	at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:90)
	at com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:268)
	at com.google.inject.internal.ProviderToInternalFactoryAdapter$1.call(ProviderToInternalFactoryAdapter.java:46)
	at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1092)
	at com.google.inject.internal.ProviderToInternalFactoryAdapter.get(ProviderToInternalFactoryAdapter.java:40)
	at com.google.inject.internal.SingletonScope$1.get(SingletonScope.java:194)
	at com.google.inject.internal.InternalFactoryToProviderAdapter.get(InternalFactoryToProviderAdapter.java:41)
	at com.google.inject.internal.FactoryProxy.get(FactoryProxy.java:56)
	at com.google.inject.internal.ProviderToInternalFactoryAdapter$1.call(ProviderToInternalFactoryAdapter.java:46)
	at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1092)
	at com.google.inject.internal.ProviderToInternalFactoryAdapter.get(ProviderToInternalFactoryAdapter.java:40)
	at com.google.inject.internal.SingletonScope$1.get(SingletonScope.java:194)
	at com.google.inject.internal.InternalFactoryToProviderAdapter.get(InternalFactoryToProviderAdapter.java:41)
	at com.google.inject.internal.InjectorImpl$2$1.call(InjectorImpl.java:1019)
	at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1092)
	at com.google.inject.internal.InjectorImpl$2.get(InjectorImpl.java:1015)
	at com.google.inject.internal.InjectorImpl.getInstance(InjectorImpl.java:1054)
	at play.api.inject.guice.GuiceInjector.instanceOf(GuiceInjectorBuilder.scala:409)
	at play.api.inject.guice.GuiceInjector.instanceOf(GuiceInjectorBuilder.scala:404)
	at play.api.inject.ContextClassLoaderInjector.$anonfun$instanceOf$2(Injector.scala:117)
	at play.api.inject.ContextClassLoaderInjector.withContext(Injector.scala:126)
	at play.api.inject.ContextClassLoaderInjector.instanceOf(Injector.scala:117)
	at play.api.db.evolutions.ApplicationEvolutionsProvider.get$lzycompute(EvolutionsModule.scala:49)
	at play.api.db.evolutions.ApplicationEvolutionsProvider.get(EvolutionsModule.scala:49)
	at play.api.db.evolutions.ApplicationEvolutionsProvider.get(EvolutionsModule.scala:40)
	at com.google.inject.internal.ProviderInternalFactory.provision(ProviderInternalFactory.java:81)
	at com.google.inject.internal.BoundProviderFactory.provision(BoundProviderFactory.java:72)
	at com.google.inject.internal.ProviderInternalFactory.circularGet(ProviderInternalFactory.java:61)
	at com.google.inject.internal.BoundProviderFactory.get(BoundProviderFactory.java:62)
	at com.google.inject.internal.ProviderToInternalFactoryAdapter$1.call(ProviderToInternalFactoryAdapter.java:46)
	at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1092)
	at com.google.inject.internal.ProviderToInternalFactoryAdapter.get(ProviderToInternalFactoryAdapter.java:40)
	at com.google.inject.internal.SingletonScope$1.get(SingletonScope.java:194)
	at com.google.inject.internal.InternalFactoryToProviderAdapter.get(InternalFactoryToProviderAdapter.java:41)
	at com.google.inject.internal.InternalInjectorCreator$1.call(InternalInjectorCreator.java:205)
	at com.google.inject.internal.InternalInjectorCreator$1.call(InternalInjectorCreator.java:199)
	at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1085)
	at com.google.inject.internal.InternalInjectorCreator.loadEagerSingletons(InternalInjectorCreator.java:199)
	at com.google.inject.internal.InternalInjectorCreator.injectDynamically(InternalInjectorCreator.java:180)
	at com.google.inject.internal.InternalInjectorCreator.build(InternalInjectorCreator.java:110)
	at com.google.inject.Guice.createInjector(Guice.java:99)
	at com.google.inject.Guice.createInjector(Guice.java:84)
	at play.api.inject.guice.GuiceBuilder.injector(GuiceInjectorBuilder.scala:185)
	at play.inject.guice.GuiceBuilder.injector(GuiceBuilder.java:221)
	at play.inject.guice.GuiceApplicationBuilder.build(GuiceApplicationBuilder.java:156)
	at AbstractTest.setup(AbstractTest.java:36)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:24)
	at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
	at org.junit.runners.Suite.runChild(Suite.java:128)
	at org.junit.runners.Suite.runChild(Suite.java:27)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
	at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
	at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)
	at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)
	at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)
	at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)
Caused by: java.sql.SQLException: Error executing stmt[create table et_survey_answer ( id                            bigint auto_increment not null, survey_id                     int(11) NOT NULL COMMENT '问卷id', user_id                       int(11) NOT NULL DEFAULT '0' COMMENT '问卷回答者id', survey_question_id            int(11) NOT NULL COMMENT '问卷项id', answer                        json DEFAULT NULL COMMENT '问卷答案', deleted                       bit(1) NOT NULL COMMENT '是否删除', constraint pk_et_survey_answer primary key (id) )] error[Unknown data type: "JSON"; SQL statement:
create table et_survey_answer ( id                            bigint auto_increment not null, survey_id                     int(11) NOT NULL COMMENT '问卷id', user_id                       int(11) NOT NULL DEFAULT '0' COMMENT '问卷回答者id', survey_question_id            int(11) NOT NULL COMMENT '问卷项id', answer                        json DEFAULT NULL COMMENT '问卷答案', deleted                       bit(1) NOT NULL COMMENT '是否删除', constraint pk_et_survey_answer primary key (id) ) [50004-197]]
	at io.ebean.migration.ddl.DdlRunner.runStatement(DdlRunner.java:113)
	at io.ebean.migration.ddl.DdlRunner.runStatements(DdlRunner.java:70)
	at io.ebean.migration.ddl.DdlRunner.runAll(DdlRunner.java:49)
	at io.ebeaninternal.dbmigration.DdlGenerator.runScript(DdlGenerator.java:118)
	... 92 more
Caused by: org.h2.jdbc.JdbcSQLException: Unknown data type: "JSON"; SQL statement:
create table et_survey_answer ( id                            bigint auto_increment not null, survey_id                     int(11) NOT NULL COMMENT '问卷id', user_id                       int(11) NOT NULL DEFAULT '0' COMMENT '问卷回答者id', survey_question_id            int(11) NOT NULL COMMENT '问卷项id', answer                        json DEFAULT NULL COMMENT '问卷答案', deleted                       bit(1) NOT NULL COMMENT '是否删除', constraint pk_et_survey_answer primary key (id) ) [50004-197]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
	at org.h2.message.DbException.get(DbException.java:179)
	at org.h2.message.DbException.get(DbException.java:155)
	at org.h2.command.Parser.parseColumnWithType(Parser.java:4400)
	at org.h2.command.Parser.parseColumnForTable(Parser.java:4215)
	at org.h2.command.Parser.parseTableColumnDefinition(Parser.java:6662)
	at org.h2.command.Parser.parseCreateTable(Parser.java:6570)
	at org.h2.command.Parser.parseCreate(Parser.java:4615)
	at org.h2.command.Parser.parsePrepared(Parser.java:380)
	at org.h2.command.Parser.parse(Parser.java:335)
	at org.h2.command.Parser.parse(Parser.java:307)
	at org.h2.command.Parser.prepareCommand(Parser.java:278)
	at org.h2.engine.Session.prepareLocal(Session.java:611)
	at org.h2.engine.Session.prepareCommand(Session.java:549)
	at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1247)
	at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:76)
	at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:304)
	at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:318)
	at com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java)
	at io.ebean.migration.ddl.DdlRunner.runStatement(DdlRunner.java:105)
	... 95 more

2) Error injecting constructor, javax.persistence.PersistenceException: Failed to run script
  at play.db.ebean.EbeanDynamicEvolutions.<init>(EbeanDynamicEvolutions.java:35)
  at play.db.ebean.EbeanDynamicEvolutions.class(EbeanDynamicEvolutions.java:32)
  while locating play.db.ebean.EbeanDynamicEvolutions
  at Module.configure(Module.java:46) (via modules: com.google.inject.util.Modules$OverrideModule -> Module)
  while locating play.api.db.evolutions.DynamicEvolutions
Caused by: javax.persistence.PersistenceException: Failed to run script
	at io.ebeaninternal.dbmigration.DdlGenerator.runScript(DdlGenerator.java:126)
	at io.ebeaninternal.dbmigration.DdlGenerator.runCreateSql(DdlGenerator.java:154)
	at io.ebeaninternal.dbmigration.DdlGenerator.runDdl(DdlGenerator.java:93)
	at io.ebeaninternal.dbmigration.DdlGenerator.execute(DdlGenerator.java:68)
	at io.ebeaninternal.server.core.DefaultServer.executePlugins(DefaultServer.java:311)
	at io.ebeaninternal.server.core.DefaultContainer.createServer(DefaultContainer.java:146)
	at io.ebeaninternal.server.core.DefaultContainer.createServer(DefaultContainer.java:45)
	at io.ebean.EbeanServerFactory.createInternal(EbeanServerFactory.java:109)
	at io.ebean.EbeanServerFactory.create(EbeanServerFactory.java:70)
	at play.db.ebean.EbeanDynamicEvolutions.lambda$start$3(EbeanDynamicEvolutions.java:49)
	at java.util.HashMap.forEach(HashMap.java:1288)
	at play.db.ebean.EbeanDynamicEvolutions.start(EbeanDynamicEvolutions.java:49)
	at play.db.ebean.EbeanDynamicEvolutions.<init>(EbeanDynamicEvolutions.java:38)
	at play.db.ebean.EbeanDynamicEvolutions$$FastClassByGuice$$52c94231.newInstance(<generated>)
	at com.google.inject.internal.DefaultConstructionProxyFactory$FastClassProxy.newInstance(DefaultConstructionProxyFactory.java:89)
	at com.google.inject.internal.ConstructorInjector.provision(ConstructorInjector.java:111)
	at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:90)
	at com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:268)
	at com.google.inject.internal.ProviderToInternalFactoryAdapter$1.call(ProviderToInternalFactoryAdapter.java:46)
	at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1092)
	at com.google.inject.internal.ProviderToInternalFactoryAdapter.get(ProviderToInternalFactoryAdapter.java:40)
	at com.google.inject.internal.SingletonScope$1.get(SingletonScope.java:194)
	at com.google.inject.internal.InternalFactoryToProviderAdapter.get(InternalFactoryToProviderAdapter.java:41)
	at com.google.inject.internal.FactoryProxy.get(FactoryProxy.java:56)
	at com.google.inject.internal.ProviderToInternalFactoryAdapter$1.call(ProviderToInternalFactoryAdapter.java:46)
	at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1092)
	at com.google.inject.internal.ProviderToInternalFactoryAdapter.get(ProviderToInternalFactoryAdapter.java:40)
	at com.google.inject.internal.SingletonScope$1.get(SingletonScope.java:194)
	at com.google.inject.internal.InternalFactoryToProviderAdapter.get(InternalFactoryToProviderAdapter.java:41)
	at com.google.inject.internal.InternalInjectorCreator$1.call(InternalInjectorCreator.java:205)
	at com.google.inject.internal.InternalInjectorCreator$1.call(InternalInjectorCreator.java:199)
	at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1085)
	at com.google.inject.internal.InternalInjectorCreator.loadEagerSingletons(InternalInjectorCreator.java:199)
	at com.google.inject.internal.InternalInjectorCreator.injectDynamically(InternalInjectorCreator.java:180)
	at com.google.inject.internal.InternalInjectorCreator.build(InternalInjectorCreator.java:110)
	at com.google.inject.Guice.createInjector(Guice.java:99)
	at com.google.inject.Guice.createInjector(Guice.java:84)
	at play.api.inject.guice.GuiceBuilder.injector(GuiceInjectorBuilder.scala:185)
	at play.inject.guice.GuiceBuilder.injector(GuiceBuilder.java:221)
	at play.inject.guice.GuiceApplicationBuilder.build(GuiceApplicationBuilder.java:156)
	at AbstractTest.setup(AbstractTest.java:36)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:24)
	at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
	at org.junit.runners.Suite.runChild(Suite.java:128)
	at org.junit.runners.Suite.runChild(Suite.java:27)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
	at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
	at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)
	at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)
	at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)
	at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)
Caused by: java.sql.SQLException: Error executing stmt[create table et_activity ( id                            bigint auto_increment not null, title                         varchar(255), creator_id                    bigint, introduction                  varchar(255), content                       varchar(255), enroll_start_time             datetime, enroll_end_time               datetime, max_enroll_number             bigint, current_enroll_number         bigint, notice_news                   varchar(255), start_time                    datetime, end_time                      datetime, sign_in_start_time            datetime, sign_in_end_time              datetime, file_id                       bigint, location                      varchar(255), location_id                   bigint, type                          tinyint, qrcode_content                varchar(255), qrcode_id                     bigint, status                        tinyint, delete_time                   datetime, create_time                   datetime not null, update_time                   datetime not null, constraint pk_et_activity primary key (id) )] error[Table "ET_ACTIVITY" already exists; SQL statement:
create table et_activity ( id                            bigint auto_increment not null, title                         varchar(255), creator_id                    bigint, introduction                  varchar(255), content                       varchar(255), enroll_start_time             datetime, enroll_end_time               datetime, max_enroll_number             bigint, current_enroll_number         bigint, notice_news                   varchar(255), start_time                    datetime, end_time                      datetime, sign_in_start_time            datetime, sign_in_end_time              datetime, file_id                       bigint, location                      varchar(255), location_id                   bigint, type                          tinyint, qrcode_content                varchar(255), qrcode_id                     bigint, status                        tinyint, delete_time                   datetime, create_time                   datetime not null, update_time                   datetime not null, constraint pk_et_activity primary key (id) ) [42101-197]]
	at io.ebean.migration.ddl.DdlRunner.runStatement(DdlRunner.java:113)
	at io.ebean.migration.ddl.DdlRunner.runStatements(DdlRunner.java:70)
	at io.ebean.migration.ddl.DdlRunner.runAll(DdlRunner.java:49)
	at io.ebeaninternal.dbmigration.DdlGenerator.runScript(DdlGenerator.java:118)
	... 71 more
Caused by: org.h2.jdbc.JdbcSQLException: Table "ET_ACTIVITY" already exists; SQL statement:
create table et_activity ( id                            bigint auto_increment not null, title                         varchar(255), creator_id                    bigint, introduction                  varchar(255), content                       varchar(255), enroll_start_time             datetime, enroll_end_time               datetime, max_enroll_number             bigint, current_enroll_number         bigint, notice_news                   varchar(255), start_time                    datetime, end_time                      datetime, sign_in_start_time            datetime, sign_in_end_time              datetime, file_id                       bigint, location                      varchar(255), location_id                   bigint, type                          tinyint, qrcode_content                varchar(255), qrcode_id                     bigint, status                        tinyint, delete_time                   datetime, create_time                   datetime not null, update_time                   datetime not null, constraint pk_et_activity primary key (id) ) [42101-197]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
	at org.h2.message.DbException.get(DbException.java:179)
	at org.h2.message.DbException.get(DbException.java:155)
	at org.h2.command.ddl.CreateTable.update(CreateTable.java:86)
	at org.h2.command.CommandContainer.update(CommandContainer.java:102)
	at org.h2.command.Command.executeUpdate(Command.java:261)
	at org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:249)
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
	at io.ebean.migration.ddl.DdlRunner.runStatement(DdlRunner.java:106)
	... 74 more

2 errors

	at com.google.inject.internal.Errors.throwCreationExceptionIfErrorsExist(Errors.java:470)
	at com.google.inject.internal.InternalInjectorCreator.injectDynamically(InternalInjectorCreator.java:184)
	at com.google.inject.internal.InternalInjectorCreator.build(InternalInjectorCreator.java:110)
	at com.google.inject.Guice.createInjector(Guice.java:99)
	at com.google.inject.Guice.createInjector(Guice.java:84)
	at play.api.inject.guice.GuiceBuilder.injector(GuiceInjectorBuilder.scala:185)
	at play.inject.guice.GuiceBuilder.injector(GuiceBuilder.java:221)
	at play.inject.guice.GuiceApplicationBuilder.build(GuiceApplicationBuilder.java:156)
	at AbstractTest.setup(AbstractTest.java:36)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:24)
	at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
	at org.junit.runners.Suite.runChild(Suite.java:128)
	at org.junit.runners.Suite.runChild(Suite.java:27)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
	at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
	at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)
	at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)
	at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)
	at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)


java.lang.NullPointerException
	at play.test.Helpers.stop(Helpers.java:606)
	at AbstractTest.teardown(AbstractTest.java:42)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
	at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:33)
	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
	at org.junit.runners.Suite.runChild(Suite.java:128)
	at org.junit.runners.Suite.runChild(Suite.java:27)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
	at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
	at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)
	at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)
	at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)
	at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)

解决方法

@Constraints.Required
@Column(columnDefinition = "longtext NOT NULL COMMENT '问卷项'")
private String question;

把columndefinition里面的json改成longtext就行了。

因为h2不支持json类型，mysql里面的json本质上是longtext。

参考文献

[1]. How can solve JSON column in H2. https://stackoverflow.com/questions/39620317/how-can-solve-json-column-in-h2

 

农民小飞侠
关注
专栏目录
[解决]org.h2.jdbc.JdbcSQLException: Table XXX not found
DazedMen的博客
11-06 1万+
springboot+h2整合的项目中，启动项目访问h2的数据，报错org.h2.jdbc.JdbcSQLException: Table XXX not found; 开始遇到这个问题，从网上找资源进行查找，但最终没有找到解决办法。因为我是对项目进行了二次开发，报错的项目的springboot和h2版本较低，springboot版本2.0.6.RELEASE,h2版本1.4.197。 我重新调...
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
知识改变命运，ヾ(◍°∇°◍)ﾉﾞ【求关注】
08-14 5392
跑项目时报错：Table xxxxx’ doesn’t exist
Caused by: org.h2.jdbc.JdbcSQLException: Table "T_STUDENT_INFO" not found; SQL statement
游海东的技术专栏
05-01 1万+
1、错误描述 org.hibernate.exception.SQLGrammarException: error executing work at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123) at org.hibernate
无涯教程-H2数据库 - JDBC连接
无涯教程
11-06 500
H2是一个JAVA数据库，无涯教程可以使用JDBC与该数据库进行交互，在本章中，无涯教程将看到与H2数据库创建JDBC连接以及如何与H2数据库创建CRUD操作。通常，创建JDBC连接有五个步骤。第1步 - 注册JDBC数据库驱动程序。ClassforName第2步 - 打开连接。Connectionconn"sa"""第3步 - 创建一条语句。第4步 - 执行一条语句并接收输出集。Stmt第5步 - 关闭连接。conn。
JdbcSQLSyntaxErrorException: Syntax error in SQL statement “SELECT id,name,age,email FROM [*]user“
最新发布
qq_41623592的博客
09-28 1192
近来了解到MybatisPlus对于表的简单查询，竟然不用写sql，连xml文件都不用建，故此学习MP入门。
如何在测试中让H2支持JSONB
每天学习一点点，每天记录一点点
05-07 998
在使用H2执行测试时，如果H2不支持某种数据库数据类型，如JSONB，则会导致测试执行失败。本文介绍了如何通过SQL语句创建用户自定义类型，从而扩展H2数据类型，以支持原本不支持的数据类型。
dbexception.java,java - H2 org.h2.jdbc.JdbcSQLException与正确的DDL sql：错误代码= [42000-196] - 堆栈内存溢出...
weixin_31202821的博客
03-18 847
在执行下面的ddl时，抛出org.h2.jdbc.JdbcSQLException 。 当然我在隔离环境中测试它，没有任何其他sql。 更令人尴尬的是，除了[42000-196]之外，错误消息没有提供任何提示。 我已经在官方网站上检查过这个sql与某些特定于h2的语法，但是我错过了哪些特殊的语法？SQLCREATE TABLE Product(`id` BIGINT ...
JSON(JSON 是一种轻量级的数据交换格式。)
小森努力努力再努力i
03-04 678
JSON 1. JSON 值可以是： 数字（整数或浮点数） 字符串（在双引号中） 逻辑值（true 或 false） 数组（在中括号中） 对象（在大括号中） null 2. JSON 对象（大括号保存对象） 注意： key 必须是字符串，value 可以是合法的 JSON 数据类型（字符串, 数字, 对象, 数组, 布尔值或 null）。 {"name":"Runoob", "url":"www.runoob.com"} 1. 访问对象值 你可以使用点号（.）来访问对象的值： var myOb
IDEA使用sprintboot使用h2本地数据库找不到table。Caused by: org.h2.jdbc.JdbcSQLException: Table "USER" not found; S
weixin_41942804的博客
04-29 1万+
org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'org.springframework.boot.autoconfigure.orm.jpa.HibernateJpaConfiguration': Unsatisfied dependency expre...
安卓开发：解决Caused by: org.gradle.api.internal.artifacts.ivyservice.DefaultLenientConfiguration等问题
热门推荐
CaiNiao_hu的博客
09-13 7万+
安卓开发：解决Caused by: org.gradle.api.internal.artifacts.ivyservice.DefaultLenientConfiguration$ArtifactResolveException: Could not resolve all artifacts for configuration ‘:classpath’.等问题 创建一个新的安卓工程时，总会遇到如下图所示的众多问题，即使重装Android Studio也仍然会再次出现这个错误，本文给出此问题的可能原因及
H2数据库详解
吴代庄的博客
03-23 2174
H2数据库是一款轻量级、跨平台的开源Java数据库，支持嵌入式与服务器两种模式运行。可用于单一应用内部存储、开发测试阶段或作为小型项目的数据存储方案。具备丰富的数据类型（如字符、数值、日期、JSON等）和兼容多种数据库的模式（如MySQL、PostgreSQL等）。它拥有内嵌、内存、文件及服务器等多种运行模式，并内置Web控制台便于管理和操作。支持标准SQL语法，提供事务处理、并发控制、安全性保障及性能优化等功能，广泛应用于单元测试、临时数据存储及简易部署场景。
org.h2.jdbc.JdbcSQLDataException: Value too long for column """xxx"" ENUM('x1', 'x2')": "
程序猿的樊笼
04-08 1997
现象 更新money字段的值sql，却报too long for column "type"，其实更新语句不涉及type字段，但问题在这里。 有遇到类似问题的，接下来对号入座。 出现这这个问题，有以下几种情形： 1. java定义type字段是int类型 2. db中这个字段是enum类型 3. 插入和查询时这个字段是没有问题的 4. 更新这个字段没有问题 5. 更新别的字段的...
idea连接h2数据库错误:org.h2.jdbc.JdbcSQLSyntaxErrorException:Table “CATALOGS“ not found；SQL statement
10-15 4784
idea连接h2数据库错误:org.h2.jdbc.JdbcSQLSyntaxErrorException:Table “CATALOGS” not found;参考资料：https://blog.csdn.net/nruuu/article/details/123909184。在URL后面添加OLD_INFORMATION_SCHEMA=TRUE来解决问题。这个错误的主要出现原因是，当你连接h2数据库的时候，idea使用。但是，h2新版本不支持该语句。添加后就可以正常访问了。
H2数据库报错代码汇总
lionsarmstrong的博客
06-06 3522
首先说一下数据来源：H2数据库官网（文章底部有链接地址）之所以写上，是为了百度搜索方便。org.h2.api public class ErrorCode
idea配置h2数据库后，无法执行sql语句（schema.sql）
a_15715324986的博客
02-16 1329
remote是重复使用)，设置用户名和密码（这里的用户名和密码要与properties里面的配置的一致），点击apply。但是后来我发现，选了embedded后，再次打开，他还会变成remote。后来研究了下，这个always模式，是每次都重新执行schema.sql。如果设置成never或embedded，则每次运行，上次的数据也会保留。下图中，我的电脑，c盘，用户，昵称里面，最下面的两个文件就是，直接删除。如下图，always情况下，每次都是同样的结果。原因：h2数据库本地有缓存，会默认使用本地缓存。
明明是updateTime却报：org.h2.jdbc.JdbcSQLSyntaxErrorException: Column "update_time" not found
程序猿的樊笼
03-23 7453
背景 使用“Spring Boot With H2 Database”+“Spring Data JPA”写的一个小东西，第一次用下h2和jpa，有几个小问题，挑一个记录下。 问题说明 1. 定义一个实体类，其中有一个更新时间属性，定义如下： 2. 在数据库表中定义这个字段： 3. 查询sql： 4. 执行报错： 其实，我整个代码与sql脚本都没有update_tim...
【码匠社区项目】问题：H2数据库报错org.h2.jdbc.JdbcSQLException: File corrupted while reading record: null. Possible
Florenceee的博客
03-12 494
此系列用于记录自己遇到的一些坑和解决方案。
java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempt
qq_33240556的博客
02-04 3563
通常第一步是检查数据库服务器的状态以及应用程序与数据库之间的网络连接情况。同时，审查数据库连接池配置、登录凭据和数据库本身的运行状况也是非常重要的步骤。数据库服务器未运行或不可达：请检查数据库服务器是否正在运行，并且客户端应用可以访问该服务器。表示尝试创建到数据库服务器的连接时发生了非暂时性的错误，而且在尝试了3次重连之后仍然失败，因此放弃连接。数据库驱动不兼容或版本问题：确认使用的Java数据库驱动程序与所使用的数据库版本兼容。登录信息错误：检查应用程序中配置的数据库用户名、密码以及数据库名称是否正确。
jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
我亦无他，唯手熟尔
12-30 364
jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. 第二次遇到这个问题又是驱动版本问题,我的mysql是8.0版本所以得用新版本的connector
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Column "participator" not found; SQL statement:
07-27
这个错误通常是由于在 H2数据库中的SQL语句中引用了不存在的列导致的。在你的情况中，错误信息显示 "participator" 列未找到。 要解决这个问题，你可以按照以下步骤进行操作： 1. 确定你的数据库表中是否真的没有...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

农民小飞侠

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值