36 Star 99 Fork 103

openGauss / openGauss-connector-jdbc

 / 详情

DB2迁移OpenGpenGuass数据库后,实体变更后,Hibernate同步更新OpenGuass表结构报错

已取消
咨询
创建于  
2021-08-30 16:47

【标题描述】:DB2迁移到OpenGuass数据库,应用部署到Tomcat,配置好驱动测试连接成功,启动应用连接OpenGuass迁移后的库,在应用实体发生变更时候,无法完成表结构更新
【测试类型:SQL功能/存储功能/接口功能/工具功能/性能/并发/压力长稳/故障注入/安全/资料/编码规范】【测试版本:2.0.0】 问题描述

【操作系统和硬件信息】(查询命令: cat /etc/system-release, uname -a):

【测试环境】(单机/1主x备x级联备):单机

【数据库版本】(查询命令: gaussdb –V):2.0.0

【操作步骤】(请填写详细的操作步骤):

【日志信息】(请附上日志文件、截图、coredump信息):
2021-08-11 18:30:04,985 [INFO] ==== RMI TCP Connection(5)-127.0.0.1: com.alibaba.druid.pool.DruidDataSource.init(983)
{dataSource-1} inited
2021-08-11 18:31:12,454 [ERROR] ==== RMI TCP Connection(5)-127.0.0.1: org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(165)
could not complete schema update
java.lang.NullPointerException
at org.hibernate.tool.hbm2ddl.TableMetadata.getColumnMetadata(TableMetadata.java:64)
at org.hibernate.tool.hbm2ddl.TableMetadata.addIndex(TableMetadata.java:100)
at org.hibernate.tool.hbm2ddl.TableMetadata.initIndexes(TableMetadata.java:134)
at org.hibernate.tool.hbm2ddl.TableMetadata.(TableMetadata.java:35)
at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:90)
at org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configuration.java:949)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:140)
at org.hibernate.impl.SessionFactoryImpl.(SessionFactoryImpl.java:322)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1284)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:863)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:782)
at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:188)
at com.landray.kmss.sys.config.loader.KmssHibernateLocalSessionFactoryBean.afterPropertiesSet(KmssHibernateLocalSessionFactoryBean.java:196)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1573)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1511)
at com.landray.kmss.framework.spring.core.LookupListableBeanFactory.initializeBean(LookupListableBeanFactory.java:75)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
at com.landray.kmss.sys.config.loader.KmssLookupListableBeanFactory.doCreateBean(KmssLookupListableBeanFactory.java:28)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)
at com.landray.kmss.sys.config.loader.KmssLookupListableBeanFactory.doGetBean(KmssLookupListableBeanFactory.java:47)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1419)
at com.landray.kmss.sys.config.loader.KmssLookupListableBeanFactory.applyPropertyValues(KmssLookupListableBeanFactory.java:57)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1160)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
at com.landray.kmss.sys.config.loader.KmssLookupListableBeanFactory.doCreateBean(KmssLookupListableBeanFactory.java:28)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)
at com.landray.kmss.sys.config.loader.KmssLookupListableBeanFactory.doGetBean(KmssLookupListableBeanFactory.java:47)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1419)
at com.landray.kmss.sys.config.loader.KmssLookupListableBeanFactory.applyPropertyValues(KmssLookupListableBeanFactory.java:57)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1160)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
at com.landray.kmss.sys.config.loader.KmssLookupListableBeanFactory.doCreateBean(KmssLookupListableBeanFactory.java:28)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)
at com.landray.kmss.sys.config.loader.KmssLookupListableBeanFactory.doGetBean(KmssLookupListableBeanFactory.java:47)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:441)
at org.springframework.context.support.AbstractApplicationContext.getBeansOfType(AbstractApplicationContext.java:1198)
at com.landray.kmss.sys.config.loader.KmssLookupXmlWebApplicationContext.registerListeners(KmssLookupXmlWebApplicationContext.java:46)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479)
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)
at com.landray.kmss.sys.config.loader.ContextLoaderSupport4Spring3x.initWebApplicationContext(ContextLoaderSupport4Spring3x.java:79)
at com.landray.kmss.sys.config.loader.ContextLoaderSupport4Spring3x.access$1(ContextLoaderSupport4Spring3x.java:75)
at com.landray.kmss.sys.config.loader.ContextLoaderSupport4Spring3x$LoadContext.initLoadContextHelper(ContextLoaderSupport4Spring3x.java:201)
at com.landray.kmss.sys.config.loader.ContextLoaderSupport4Spring3x$LoadContext.initLoad(ContextLoaderSupport4Spring3x.java:190)
at com.landray.kmss.sys.config.loader.ContextLoaderSupport4Spring3x.initSmartApplicationContext(ContextLoaderSupport4Spring3x.java:67)
at com.landray.kmss.sys.config.loader.SpringLoader.doLoad(SpringLoader.java:36)
at com.landray.kmss.framework.loader.FrameworkContextLoader.doFrameworkLoader(FrameworkContextLoader.java:122)
at com.landray.kmss.framework.loader.FrameworkContextLoader.doLoadForPoint(FrameworkContextLoader.java:105)
at com.landray.kmss.framework.loader.FrameworkContextLoader.doLoad(FrameworkContextLoader.java:75)
at com.landray.kmss.framework.plugin.core.event.AbstractEventDefinition$VirtualLoadChain.doLoad(AbstractEventDefinition.java:294)
at com.landray.kmss.framework.service.plugin.config.FromAttributeInterceptor.doLoad(FromAttributeInterceptor.java:46)
at com.landray.kmss.framework.plugin.core.event.AbstractEventDefinition$VirtualLoadChain.doLoad(AbstractEventDefinition.java:294)
at com.landray.kmss.framework.plugin.core.event.AbstractEventDefinition.loadDefinition(AbstractEventDefinition.java:245)
at com.landray.kmss.framework.plugin.core.support.AbstractPluginFactory.getExtensionPoint(AbstractPluginFactory.java:44)
at com.landray.kmss.framework.plugin.core.support.DefaultListableFactory.instantiateAllPlugin(DefaultListableFactory.java:54)
at com.landray.kmss.framework.plugin.core.context.AbstractApplicationContext.refresh(AbstractApplicationContext.java:74)
at com.landray.kmss.framework.plugin.core.context.AbstractConfigurableApplicationContext.refresh(AbstractConfigurableApplicationContext.java:48)
at com.landray.kmss.framework.plugin.core.context.PluginContextLoader.createPluginContext(PluginContextLoader.java:74)
at com.landray.kmss.framework.plugin.core.context.PluginContextLoader.initPluginContext(PluginContextLoader.java:42)
at com.landray.kmss.framework.plugin.core.context.PluginContextLoader.initPluginContext(PluginContextLoader.java:32)
at com.landray.kmss.framework.plugin.loader.PluginContextLoaderListener.contextInitialized(PluginContextLoaderListener.java:195)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4887)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5381)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
at org.apache.catalina.startup.HostConfig.manageApp(HostConfig.java:1552)
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.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:301)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:819)
at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:801)
at org.apache.catalina.mbeans.MBeanFactory.createStandardContext(MBeanFactory.java:622)
at org.apache.catalina.mbeans.MBeanFactory.createStandardContext(MBeanFactory.java:569)
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.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:301)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:819)
at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:801)
at com.sun.jmx.remote.security.MBeanServerAccessController.invoke(MBeanServerAccessController.java:468)
at javax.management.remote.rmi.RMIConnectionImpl.doOperation(RMIConnectionImpl.java:1468)
at javax.management.remote.rmi.RMIConnectionImpl.access$300(RMIConnectionImpl.java:76)
at javax.management.remote.rmi.RMIConnectionImpl$PrivilegedOperation.run(RMIConnectionImpl.java:1309)
at java.security.AccessController.doPrivileged(Native Method)
at javax.management.remote.rmi.RMIConnectionImpl.doPrivilegedOperation(RMIConnectionImpl.java:1408)
at javax.management.remote.rmi.RMIConnectionImpl.invoke(RMIConnectionImpl.java:829)
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 sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:357)
at sun.rmi.transport.Transport$1.run(Transport.java:200)
at sun.rmi.transport.Transport$1.run(Transport.java:197)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:196)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:573)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:834)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:688)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:687)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

评论 (4)

Hey @乔大宝, Welcome to openGauss Community.
All of the projects in openGauss Community are maintained by @opengauss-bot.
That means the developers can comment below every pull request or issue to trigger Bot Commands.
Please follow instructions at https://gitee.com/opengauss/community/blob/master/contributors/command.en.md to find the details.

乔大宝 创建了咨询
展开全部操作日志

这个问题看下addIndex中传入的参数ResultSet rs是根据哪个sql语句得到的,查的是什么系统表,有没有“COLUMN_NAME”这个列,单纯的rs.getString("column_name")这个接口是没有问题的,因此排查方法应该看下这个名字为COLUMN_NAME的列是否在查询结果集中存在

zhangxubo 添加了
 
sig/connectors
标签

@zhangxubo you can't close an issue unless you are the author of it or a collaborator.

周斌 任务状态待办的 修改为已取消

登录 后才可以发表评论

状态
负责人
项目
里程碑
Pull Requests
关联的 Pull Requests 被合并后可能会关闭此 issue
分支
开始日期   -   截止日期
-
置顶选项
优先级
预计工期 (小时)
参与者(4)
5622128 opengauss bot 1581905080
Java
1
https://gitee.com/opengauss/openGauss-connector-jdbc.git
git@gitee.com:opengauss/openGauss-connector-jdbc.git
opengauss
openGauss-connector-jdbc
openGauss-connector-jdbc

搜索帮助