create a persistent db on knime server

Have seen the articles/sample workflows on creating an h2 or sqlite db to use within a workflow however i want to spin up a db directly on my knime server that i can read/write to and have it persist across jobs. currently, my h2 clears out and gets initiated for each job that is run.

is this possible? currently if i provide a path that isn’t knime://knime.workflow/ i get errors like path cannot be resolved or a implicitly relative path cannot be used.

No idea how to provide a path that is basically the workflow group where my workflow is contained on knime server

Any suggestions?


SQLite requires direct access to the file which is not possible when running workflow on the Server/Hub.
We recommend using an alternate DB solution, such as Postgres, which you would be able to connect to from a workflow via DB Connector node.


This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.