英文:
Migrating Spring cloud data flow server with Oracle Database
问题
我正在尝试将当前使用H2数据库的Spring Cloud Data Flow服务器迁移到Oracle数据库。我通过使用jar命令将ojdbc jar添加到boot-inf/lib目录中修改了spring-cloud-dataflow.jar。我能够成功启动服务器。
我面临的问题是，当我启动任务时，我收到一个错误，说task_execution_manifest表不存在。
我已将数据源属性更改为指向Oracle数据库，并且我可以看到表被创建并且表格中的条目被添加，例如app_registration。我查看了相同的GitHub仓库的迁移脚本，但我没有找到task_execution_manifest表的创建表脚本。
我无法理解为什么会出现这个错误。这个表从哪里来？我可以在哪里找到相同表的脚本。
任何帮助都将不胜感激。
英文:
I am trying to migrate spring-cloud-dataflow server that is currently using h2 database with oracle database. I modified the spring-cloud-dataflow.jar by adding ojdbc jar into boot-inf/lib directory with the help of jar commands. I am able to start the server also.
The problem that I am facing is when I am launching a task I am getting error saying task_execution_manifest table does not exist.
I have changed the datasource properties to point to oracle db and I can see tables getting created and entries being made to table such as app_registration. I saw the migration scripts from github repo of same but I don't see the create table script of task_execution_manifest.
I am not able to understand why I am getting this error. From where this table is coming. Where I can find script for same table.
Any help is appreciated.
答案1
得分: 2
默认情况下，SCDF 使用 Flyway 运行一组脚本来构建数据库。基本表通常在最早的脚本中，并且通常不特定于供应商（如 V1_INITIAL_SETUP.sql）。因此，要么使用 Flyway 并让它为您处理模式，要么如果您不想使用 Flyway，则可以禁用它，然后执行一些提供的模式脚本来构建数据库。这里有关SCDF处理模式的更多信息。
英文:
By default SCDF uses Flyway to run a set of scripts that build up the DB. The base tables are usually in the earliest script and typically not vendor specific (like V1_INITIAL_SETUP.sql). So either use Flyway and let it handle the schema for you OR if you don't want to use Flyway then use can disable it and then execute some provided schema scripts to build up the DB. Here is some more info on how SCDF handles schema.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论