create a persistent db on knime server

KNIME Server
1

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/database.mv.db 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?

2

Hello,

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.

Regards,
Nickolaus

3

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