errors trying to create an alias

[Vito De Tullio]

Hi.

I'm trying to "convert" a stored procedure in h2.

I'm trying to follow http://www.h2database.com/html/features.html#user_defined_functions, but I have errors.

For example, if I run

CREATE ALIAS NEXT_PRIME AS $$
String nextPrime(String value) {
    return new BigInteger(value).nextProbablePrime().toString();
}
$$;

in dbeaver (using jdbc:h2:~/test;MODE=Oracle as connection url), I have this error:

SQL Error [50000] [HY000]: General error: "java.lang.NoClassDefFoundError: javax/tools/JavaFileManager"; SQL statement:
CREATE ALIAS NEXT_PRIME AS $$
String nextPrime(String value) {
    return new BigInteger(value).nextProbablePrime().toString();
}
$$

 [50000-200]

Could you help me understanding what is the problem?

Thanks

[Evgenij Ryazanov]

Hello.

It looks like you run H2 in JRE instead of JDK and you don't have a javac from JDK in the path. JRE doesn't have a Java compiler.