NutzCN Logo
问答 ColType中有PSQL_ARRAY类型,但是建表异常
发布于 180天前 作者 Longitude 380 次浏览 复制 上一个帖子 下一个帖子
标签:
2021-12-28 16:46:06,520 INFO  org.nutz.dao.util.Daos$4:807 -add column[TAGS] to table[T_RESUME_ENTERPRISE]
2021-12-28 16:46:06,521 DEBUG org.nutz.dao.impl.sql.run.NutDaoExecutor:391 -ALTER TABLE T_RESUME_ENTERPRISE ADD COLUMN TAGS ARRAY
2021-12-28 16:46:06,529 DEBUG org.nutz.dao.impl.sql.run.NutDaoExecutor:103 -SQLException
org.postgresql.util.PSQLException: ERROR: syntax error at or near "ARRAY"
  位置:49
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553) ~[postgresql-42.2.18.jar:42.2.18]
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285) ~[postgresql-42.2.18.jar:42.2.18]
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323) ~[postgresql-42.2.18.jar:42.2.18]
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:473) ~[postgresql-42.2.18.jar:42.2.18]
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:393) ~[postgresql-42.2.18.jar:42.2.18]
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:322) ~[postgresql-42.2.18.jar:42.2.18]
	at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:308) ~[postgresql-42.2.18.jar:42.2.18]
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:284) ~[postgresql-42.2.18.jar:42.2.18]
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:279) ~[postgresql-42.2.18.jar:42.2.18]
	at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95) ~[HikariCP-3.4.5.jar:?]
	at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) ~[HikariCP-3.4.5.jar:?]
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runStatement(NutDaoExecutor.java:360) ~[nutz-1.r.68.v20201205.jar:1.r.68.v20201205]
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:66) ~[nutz-1.r.68.v20201205.jar:1.r.68.v20201205]
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:65) ~[nutz-1.r.68.v20201205.jar:1.r.68.v20201205]
	at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22) ~[nutz-1.r.68.v20201205.jar:1.r.68.v20201205]
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:63) ~[nutz-1.r.68.v20201205.jar:1.r.68.v20201205]
	at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:138) ~[nutz-1.r.68.v20201205.jar:1.r.68.v20201205]
	at org.nutz.integration.spring.SpringDaoRunner._run(SpringDaoRunner.java:18) ~[nutz-integration-spring-1.r.69-20210713.090244-9.jar:?]
	at org.nutz.dao.impl.sql.run.NutDaoRunner$1.run(NutDaoRunner.java:79) ~[nutz-1.r.68.v20201205.jar:1.r.68.v20201205]
	at org.nutz.trans.Trans.exec(Trans.java:174) ~[nutz-1.r.68.v20201205.jar:1.r.68.v20201205]
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:77) ~[nutz-1.r.68.v20201205.jar:1.r.68.v20201205]
	at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:242) ~[nutz-1.r.68.v20201205.jar:1.r.68.v20201205]
	at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:254) ~[nutz-1.r.68.v20201205.jar:1.r.68.v20201205]
	at org.nutz.dao.impl.DaoSupport.execute(DaoSupport.java:238) ~[nutz-1.r.68.v20201205.jar:1.r.68.v20201205]
	at org.nutz.dao.impl.NutDao.execute(NutDao.java:1291) ~[nutz-1.r.68.v20201205.jar:1.r.68.v20201205]
	at org.nutz.dao.util.Daos.migration(Daos.java:848) ~[nutz-1.r.68.v20201205.jar:1.r.68.v20201205]
	at org.nutz.dao.util.Daos.migration(Daos.java:765) ~[nutz-1.r.68.v20201205.jar:1.r.68.v20201205]
	at org.nutz.dao.util.Daos.migration(Daos.java:1002) ~[nutz-1.r.68.v20201205.jar:1.r.68.v20201205]
	at org.nutz.plugin.spring.boot.listener.NutzDataBaseIniter$2.invoke(NutzDataBaseIniter.java:48) ~[nutz-plugins-spring-boot-starter-1.r.68.v20201205.jar:?]
	at org.nutz.plugin.spring.boot.listener.NutzDataBaseIniter$2.invoke(NutzDataBaseIniter.java:44) ~[nutz-plugins-spring-boot-starter-1.r.68.v20201205.jar:?]
	at org.nutz.lang.Lang.each(Lang.java:1618) ~[nutz-1.r.68.v20201205.jar:1.r.68.v20201205]
	at org.nutz.lang.Lang.each(Lang.java:1583) ~[nutz-1.r.68.v20201205.jar:1.r.68.v20201205]
	at org.nutz.plugin.spring.boot.listener.NutzDataBaseIniter.create(NutzDataBaseIniter.java:44) ~[nutz-plugins-spring-boot-starter-1.r.68.v20201205.jar:?]
	at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
	at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
	at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
	at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
	at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:389) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
	at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:333) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
	at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:157) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:415) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1786) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:594) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:516) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:324) ~[spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) [spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322) [spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) [spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:897) [spring-beans-5.2.12.RELEASE.jar:5.2.12.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:879) [spring-context-5.2.12.RELEASE.jar:5.2.12.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:551) [spring-context-5.2.12.RELEASE.jar:5.2.12.RELEASE]
	at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:141) [spring-boot-2.2.13.RELEASE.jar:2.2.13.RELEASE]
	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:747) [spring-boot-2.2.13.RELEASE.jar:2.2.13.RELEASE]
	at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:405) [spring-boot-2.2.13.RELEASE.jar:2.2.13.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) [spring-boot-2.2.13.RELEASE.jar:2.2.13.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226) [spring-boot-2.2.13.RELEASE.jar:2.2.13.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1215) [spring-boot-2.2.13.RELEASE.jar:2.2.13.RELEASE]
	at com.tiger.hire.seek.HireSeekApplication.main(HireSeekApplication.java:19) [classes/:?]

1 回复

这个改表...

添加回复
请先登陆
回到顶部