SQL Format

[MrRohwei]

Description

I found a Java library that can format SQL, so I wrote a method to call that library:

public static void main(String[] args) {
        String formattedSql = SqlFormatter.format(args[0]);
        System.out.println(formattedSql);
    }

The formatted result has been successfully printed using the command 'java cp a.jar Test. java' SELECT * FROM table 'in the cmd command line. When I try to use this command in DBeavear, an error occurs:

Error: A JNI error has occurred, please check your installation and try again
Exception in thread "main" java.lang.InternalError: Module jdk.compiler not in boot Layer
	at java.base/sun.launcher.LauncherHelper.loadModuleMainClass(Unknown Source)
	at java.base/sun.launcher.LauncherHelper.checkAndLoadMain(Unknown Source)

I installed JDK11 locally because that formatting library also requires JDK11. So I caused the above problem by directly executing a single file. What should I do if I want to implement calling this library to format SQL?

DBeaver Version

25.0.1.202503231807

Operating System

win10

Database and driver

PostgreSQL

Steps to reproduce

No response

Additional context

No response

[ShadelessFox]

DBeaver ships its own trimmed distribution of the JRE. It doesn't include the module jdk.compiler required by the library in the question. Try removing the jre directory from DBeaver's folder to force it to use the JRE available on your system. Please note that DBeaver requires Java 17.

[ShadelessFox]

I see you using java to compile and execute a source file. Instead, compile the source file with javac and pass it.

[MrRohwei]

I see you using java to compile and execute a source file. Instead, compile the source file with javac and pass it.

I executed it directly using a single file of JDK11, not compiled through JavaC first.

DBeaver ships its own trimmed distribution of the JRE. It doesn't include the module jdk.compiler required by the library in the question. Try removing the jre directory from DBeaver's folder to force it to use the JRE available on your system. Please note that DBeaver requires Java 17.

Do I have to use Java17 locally? Is Java11 not working？

[ShadelessFox]

I executed it directly using a single file of JDK11, not compiled through JavaC first.

What's the point of compiling the same source file whenever you format a script? It's redundant work that makes no sense. Compile it first, and it will work just fine.

Do I have to use Java17 locally? Is Java11 not working？

Java 17 is the minimal version required to run DBeaver. If you remove the embedded jre, you have to have Java 17 installed locally. But it's not the solution for your issue.