我的变更集中有一个如此定义的列:
<column name="LAST_MOD_TIME" type="date"/>
我有这样的插入(从另一个数据库生成):
<column name="LAST_MOD_TIME" valueDate="2009-05-30T00:39:40"/>
当我使用mvn liquibase:update运行时
它会产生如下错误:
[SQL失败:INSERT INTO ....,不支持:2009-05-30T00:39:40]
删除 T
没有任何区别 . 唯一有效的方法是完全远程调用 HH:MI:SS
值 .
我尝试在Oracle中更改会话 NLS_DATE_FORMAT
- 但这可能需要系统范围,我还没想到 . 或者以某种方式将其添加到Liquibase更改文件中 .
任何帮助赞赏 .
Stacktrace:
org.apache.maven.lifecycle.LifecycleExecutionException:无法执行目标org.liquibase:liquibase-maven-plugin:3.6.1:项目liquibase.ecom上的update(default-cli):设置或运行Liquibase时出错:迁移失败更改set src / main / resources / liquibase / db-prop-changelog-4.xml :: 1531127783280-4 :: user:原因:liquibase.exception.DatabaseException:ORA-00917:缺少逗号
at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:216)
at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153)
at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145)
at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:116)
at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:80)
at org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build(SingleThreadedBuilder.java:51)
at org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:120)
at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:355)
at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:155)
at org.apache.maven.cli.MavenCli.execute(MavenCli.java:584)
at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:216)
at org.apache.maven.cli.MavenCli.main(MavenCli.java:160)
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:483)
at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:289)
at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:229)
at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:415)
at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:356)
at org.liquibase.maven.plugins.AbstractLiquibaseMojo.execute(AbstractLiquibaseMojo.java:370)
at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:132)
at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:208)
... 19 more
引起:liquibase.exception.MigrationFailedException:更改集的迁移失败src / main / resources / liquibase / db-ec-prop-changelog-4.xml :: 1531127783280-4 :: user:原因:liquibase.exception.DatabaseException: ORA-00917:缺少逗号
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:637)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:53)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:78)
at liquibase.Liquibase.update(Liquibase.java:202)
at liquibase.Liquibase.update(Liquibase.java:179)
at liquibase.Liquibase.update(Liquibase.java:334)
at org.liquibase.maven.plugins.LiquibaseUpdate.doUpdate(LiquibaseUpdate.java:33)
at org.liquibase.maven.plugins.AbstractLiquibaseUpdateMojo.performLiquibaseTask(AbstractLiquibaseUpdateMojo.java:30)
at org.liquibase.maven.plugins.AbstractLiquibaseMojo.execute(AbstractLiquibaseMojo.java:366)
... 21 more
引起:liquibase.exception.DatabaseException:ORA-00917:缺少逗号[失败的SQL:INSERT INTO PROPERTY(OBJECT_ID,NAME,LOCALE,VALUE,DESCRIPTION,INSERT_DATE_TIME,LAST_MOD_TIME,LAST_MODIFIED_BY,LAST_ACCESS_AUDIT_TIME,VERSION,ENVIRONMENT_NAME)VALUES(60471,'信息','即','Y','信息',不支持:2018-05-30T00:39:40,不支持:2018-05-30T00:39:40,'abc',不支持:2018-05-30T00 :39:40,1,NULL)]在liquibase.executor上的liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:57)中的liquibase.executor.jvm.JdbcExecutor $ ExecuteStatementCallback.doInStatement(JdbcExecutor.java:356)位于liquibase.database.AbstractJdbcDatabase.exe的Liquibase.database.AbstractJdbcDatabase.exe执行(AbstractJdbcDatabase.java:1211)中的.jvm.JdbcExecutor.execute(JdbcExecutor.java:125),位于liquibase.changelog.ChangeSet . 执行(ChangeSet.java:600)... 29更多
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
2 回答
我不知道Liquibase是如何处理的,但Oracle支持ISO SQL Date & TIMESTAMP literals:
最后,我找到的唯一方法是:
和