Create Function fails after upgrade to 2.7.1

--===============0710183378534296272==
Content-Type: multipart/alternative; boundary="0000000000003df5c605f21499f2"

--0000000000003df5c605f21499f2
Content-Type: text/plain; charset="UTF-8"

I'm upgrading from version 2.3 to 2.7.1 using the memory db mode. I am
using the java 8 jar. I added the -Dhsqldb.method_class_names=.... to the
java options and am left with an error when using the CREATE FUNCTION
statement.

The hsqldb process:
/usr/bin/java -Xmx512m
-Dhsqldb.java_method_names=com.tavve.services.proxycachemgr.* -classpath
/usr/tavve/ranger/server/bundles/zr-ProxyCacheMgr.jar:/usr/tavve/ranger/server/bundles/hsqldb.jar:/usr/tavve/ranger/server/felix/sqltool.jar
org.hsqldb.util.MainInvoker org.hsqldb.server.Server

CREATE FUNCTION
MEMORYHIGH()
RETURNS BOOLEAN
LANGUAGE JAVA
DETERMINISTIC
NO SQL
EXTERNAL NAME
'CLASSPATH:com.tavve.services.proxycachemgr.HsDbFullTrigger.isMemoryAboveThreshold

The error is: java.sql.SQLSyntaxErrorException: user lacks privilege or
object not found: com.tavve.services.proxycachemgr.HsDbFullTrigger

I don't believe the issue is the user lacks privilege as the CREATE TABLE
statements are successfully executed. It does work if I use version 2.7.0.

Any clues on what I am missing?

Elise

--0000000000003df5c605f21499f2
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">I&#39;m upgrading from version 2.3 to 2.7.1 using the memo=
ry db mode. I am using the java 8 jar. I added the=C2=A0-Dhsqldb.method_cla=
ss_names=3D.... to the java options and am=C2=A0left with an error when usi=
ng the CREATE FUNCTION statement.=C2=A0<div><br></div><div>The hsqldb proce=
ss:</div><div>/usr/bin/java -Xmx512m -Dhsqldb.java_method_names=3Dcom.tavve=
.services.proxycachemgr.* -classpath /usr/tavve/ranger/server/bundles/zr-Pr=
oxyCacheMgr.jar:/usr/tavve/ranger/server/bundles/hsqldb.jar:/usr/tavve/rang=
er/server/felix/sqltool.jar org.hsqldb.util.MainInvoker org.hsqldb.server.S=
erver<br><div><br></div><div>CREATE FUNCTION=C2=A0</div><div>MEMORYHIGH()=
=C2=A0</div><div>RETURNS BOOLEAN=C2=A0</div><div>LANGUAGE JAVA=C2=A0</div><=
div>DETERMINISTIC=C2=A0</div><div>NO SQL=C2=A0</div><div>EXTERNAL NAME &#39=
;CLASSPATH:com.tavve.services.proxycachemgr.HsDbFullTrigger.isMemoryAboveTh=
reshold<br></div><div><br></div><div>The error is:=C2=A0java.sql.SQLSyntaxE=
rrorException: user lacks privilege or object not found: com.tavve.services=
.proxycachemgr.HsDbFullTrigger</div><div><br></div><div>I don&#39;t believe=
 the issue is the user lacks privilege as the CREATE TABLE statements are s=
uccessfully executed. It does work if I use version 2.7.0.</div><div><br></=
div><div>Any clues on what=C2=A0I am missing?</div><div><br></div><div>Elis=
e</div><div><br></div></div></div>

--0000000000003df5c605f21499f2--


--===============0710183378534296272==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline


--===============0710183378534296272==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Hsqldb-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

--===============0710183378534296272==--