注册

使用Hibernate自动生成sql,报错:对象[xxx]已存在

Young 2023/08/14 1314 7

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:8.1.2.84
【操作系统】:centos7
【CPU】:
【问题描述】*:使用hibernate自动更新表结构,项目启动报错:
Caused by: dm.jdbc.driver.DMException: 第1 行附近出现错误:
对象[audit_account_auth]已存在
驱动版本为:8.1.2.192,方言版本:DmDialect-for-hibernate5.3 8.1.2.192
具体报错信息为:

2023-08-14 11:12:12.347, [], WARN 10260 --- [ main] o.h.t.s.i.ExceptionHandlerLoggedImpl : GenerationTarget encountered exception accepting command : Error executing DDL "create table audit_account_auth (log_id varchar(36) not null, app_version varchar(50) not null, c_ip varchar(50), geo_city varchar(255), geo_country_long varchar(255), geo_latitude float, geo_longitude float, geo_region varchar(255), http_req clob, module varchar(255) not null, rel_obj_name varchar(100), s_ip varchar(50) not null, tag varchar(100) not null, time bigint not null, accountName varchar(255), account_no varchar(255), action varchar(255), app_code varchar(255), app_name varchar(255), auth_code varchar(255), auth_name varchar(255), auth_time bigint, auth_type varchar(255), operator varchar(255), passive_operator varchar(255), remark_en clob, remark_zh clob, primary key (log_id))" via JDBC Statement org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "create table audit_account_auth (log_id varchar(36) not null, app_version varchar(50) not null, c_ip varchar(50), geo_city varchar(255), geo_country_long varchar(255), geo_latitude float, geo_longitude float, geo_region varchar(255), http_req clob, module varchar(255) not null, rel_obj_name varchar(100), s_ip varchar(50) not null, tag varchar(100) not null, time bigint not null, accountName varchar(255), account_no varchar(255), action varchar(255), app_code varchar(255), app_name varchar(255), auth_code varchar(255), auth_name varchar(255), auth_time bigint, auth_type varchar(255), operator varchar(255), passive_operator varchar(255), remark_en clob, remark_zh clob, primary key (log_id))" via JDBC Statement at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67) at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559) at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504) at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.createTable(AbstractSchemaMigrator.java:277) at org.hibernate.tool.schema.internal.GroupedSchemaMigratorImpl.performTablesMigration(GroupedSchemaMigratorImpl.java:71) at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:207) at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114) at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:184) at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:73) at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:316) at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:469) at com.para.audit.sdk.utils.AuditSDKUtil.getSessionFactory(AuditSDKUtil.java:159) at com.para.audit.sdk.utils.AuditSDKUtil.initSDKEnv(AuditSDKUtil.java:205) at com.para.audit.sdk.utils.ConfigUtil.setPropertiesMap(ConfigUtil.java:119) at com.para.audit.sdk.loader.ParaAuditSDKInit.build(ParaAuditSDKInit.java:66) at com.para.audit.sdk.AuditSdkConfigLoader.initConfig(AuditSdkConfigLoader.java:114) 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.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:389) at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:333) at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:157) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:415) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1786) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:594) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:516) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:324) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) at org.springframework.beans.factory.support.ReloadMainDefaultListableBeanFactory.getBean(ReloadMainDefaultListableBeanFactory.java:57) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:897) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:879) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:551) at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:141) at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:747) at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:405) at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1215) at com.paraview.esc.idm.web.Application.main(Application.java:76) Caused by: dm.jdbc.driver.DMException: 第1 行附近出现错误: 对象[audit_account_auth]已存在 at dm.jdbc.driver.DBError.throwException(DBError.java:711) at dm.jdbc.a.b.o.x(MSG.java:591) at dm.jdbc.a.b.o.C(MSG.java:526) at dm.jdbc.a.b.o.B(MSG.java:507) at dm.jdbc.a.a.a(DBAccess.java:245) at dm.jdbc.a.a.a(DBAccess.java:729) at dm.jdbc.driver.DmdbStatement.executeInner(DmdbStatement.java:730) at dm.jdbc.driver.DmdbStatement.do_execute(DmdbStatement.java:190) at dm.jdbc.driver.DmdbStatement.do_execute(DmdbStatement.java:182) at dm.jdbc.driver.DmdbStatement.execute(DmdbStatement.java:1294) at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:75) at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54) ... 41 common frames omitted
回答 0
暂无回答
扫一扫
联系客服