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
--
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/0f65c59b-0726-4fc0-a402-53c300c1ea22n%40googlegroups.com.
