为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【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
我也是这个问题,什么情况这是。。。
大佬解决了吗,解决望告知~
遇到了一样问题,有解决方法了吗?
您先看下数据库对应用户下是否存在对应的表?