That sounds like our code for checking for relative url is not working
great when it contains an environment variable. I am surprised that the
environment variable has not been replaced before it gets to the h2 code
On Thu, 23 Jan 2025 at 22:53, 'philfrei1' via H2 Database <
h2-database@googlegroups.com> wrote:
> I have a Spring Boot project meant to run on a remote server. The project
> interacts with the H2 database correctly when I run the following command
> from the ssh shell:
> *java -jar shiftstarts-0.0.1.jar*
>
> When I run this same command using systemd (*sudo systemctl start
> shiftstarts*) I get the following error:
> *unable to obtain isolated JDBC connection [A file path that is implicitly
> relative to the current working directory is not allowed in the database
> URL "jdbc:h2:file:${PATH_TO_SHIFTSTARTSDB}". Use an absolute path... *
>
> The application.properties file has the following line:
>
> *spring.datasource.url=jdbc:h2:file:${PATH_TO_SHIFTSTARTSDB}*
>
> *PATH_TO_SHIFTSTARTSDB* is defined as "*/var/lib/shiftstarts/ShiftStartDB*
> ".
>
> Any thoughts on why the error message turns up on the systemd start but is
> fine when executing the java -jar command from the ssh shell? Are there
> additional lines I need to add to the configuration? Is the syntax for the
> use of the environment variable correct?
>
> What exactly does "implicitly relative" mean in this context? The address
> given, assuming the environment variable is properly expanded, is absolute,
> is it not? Is the variable not expanding when running from the systemd
> wrapper?
>
> I wonder if this might be more a *systemd *issue than an H2 issue,
> though, since the expansion only fails (afaik) during the systemd start.
>
> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to h2-database+unsubscr...@googlegroups.com.
> To view this discussion visit
> https://groups.google.com/d/msgid/h2-database/3ae263c6-c5ff-4734-aec8-7062ec84e4fan%40googlegroups.com
> <https://groups.google.com/d/msgid/h2-database/3ae263c6-c5ff-4734-aec8-7062ec84e4fan%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to h2-database+unsubscr...@googlegroups.com.
To view this discussion visit
https://groups.google.com/d/msgid/h2-database/CAFYHVnUtCE-8Nuicm4d0XRQbcR_K1ZVu1CXVYz9BpthJwc1QQA%40mail.gmail.com.
