Re: Create Function fails after upgrade to 2.7.1

--===============3419429414511918973==
Content-Type: multipart/alternative; boundary="00000000000084b03f05f225a96a"

--00000000000084b03f05f225a96a
Content-Type: text/plain; charset="UTF-8"

Thanks and it is working.  The change log for version 2.7.1 shows the
property is: hsqldb.java_method_names.

Elise

On Thu, Jan 12, 2023 at 1:31 PM Fred Toussi via Hsqldb-user <
[email protected]> wrote:

> The property setting is not included correctly in the java command. It
> should look like this:
>
> -Dhsqldb.method_class_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
>
> Fred
>
> On Thu, Jan 12, 2023, at 17:39, Elise Atkins wrote:
>
> 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
>
>
> _______________________________________________
> Hsqldb-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>
>
> _______________________________________________
> Hsqldb-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>

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

<div dir=3D"ltr">Thanks and it is working.=C2=A0 The change log for version=
 2.7.1 shows the property is:=C2=A0<span style=3D"color:rgb(0,0,0);white-sp=
ace:pre-wrap">hsqldb.java_method_names.</span><div><span style=3D"color:rgb=
(0,0,0);white-space:pre-wrap"><br></span></div><div><span style=3D"color:rg=
b(0,0,0);white-space:pre-wrap">Elise</span></div></div><br><div class=3D"gm=
ail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Thu, Jan 12, 2023 at 1:=
31 PM Fred Toussi via Hsqldb-user &lt;<a href=3D"mailto:[email protected]=
ourceforge.net">[email protected]</a>&gt; wrote:<br></div><=
blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-l=
eft:1px solid rgb(204,204,204);padding-left:1ex"><div class=3D"msg-28983745=
93909728497"><u></u><div><div style=3D"font-family:Arial">The property sett=
ing is not included correctly in the java command. It should look like this=
:<br></div><div style=3D"font-family:Arial"><br></div><div style=3D"font-fa=
mily:Arial">-Dhsqldb.method_class_names=3Dcom.tavve.services.proxycachemgr.=
* -classpath /usr/tavve/ranger/server/bundles/zr-ProxyCacheMgr.jar:/usr/tav=
ve/ranger/server/bundles/hsqldb.jar:/usr/tavve/ranger/server/felix/sqltool.=
jar org.hsqldb.util.MainInvoker org.hsqldb.server.Server<br></div><div styl=
e=3D"font-family:Arial"><br></div><div style=3D"font-family:Arial"></div><d=
iv style=3D"font-family:Arial">Fred<br></div><div style=3D"font-family:Aria=
l"><br></div><div>On Thu, Jan 12, 2023, at 17:39, Elise Atkins wrote:<br></=
div><blockquote type=3D"cite" id=3D"m_-2898374593909728497qt"><div dir=3D"l=
tr"><div>I&#39;m upgrading from version 2.3 to 2.7.1 using the memory db mo=
de. I am using the java 8 jar. I added the=C2=A0-Dhsqldb.method_class_names=
=3D.... to the java options and am=C2=A0left with an error when using the C=
REATE FUNCTION statement.=C2=A0<br></div><div><br></div><div>The hsqldb pro=
cess:<br></div><div><div>/usr/bin/java -Xmx512m -Dhsqldb.java_method_names=
=3Dcom.tavve.services.proxycachemgr.* -classpath /usr/tavve/ranger/server/b=
undles/zr-ProxyCacheMgr.jar:/usr/tavve/ranger/server/bundles/hsqldb.jar:/us=
r/tavve/ranger/server/felix/sqltool.jar org.hsqldb.util.MainInvoker org.hsq=
ldb.server.Server<br></div><div><br></div><div>CREATE FUNCTION=C2=A0<br></d=
iv><div>MEMORYHIGH()=C2=A0<br></div><div>RETURNS BOOLEAN=C2=A0<br></div><di=
v>LANGUAGE JAVA=C2=A0<br></div><div>DETERMINISTIC=C2=A0<br></div><div>NO SQ=
L=C2=A0<br></div><div>EXTERNAL NAME &#39;CLASSPATH:com.tavve.services.proxy=
cachemgr.HsDbFullTrigger.isMemoryAboveThreshold<br></div><div><br></div><di=
v>The error is:=C2=A0java.sql.SQLSyntaxErrorException: user lacks privilege=
 or object not found: com.tavve.services.proxycachemgr.HsDbFullTrigger<br><=
/div><div><br></div><div>I don&#39;t believe the issue is the user lacks pr=
ivilege as the CREATE TABLE statements are successfully executed. It does w=
ork if I use version 2.7.0.<br></div><div><br></div><div>Any clues on what=
=C2=A0I am missing?<br></div><div><br></div><div>Elise<br></div><div><br></=
div></div></div><div><br></div><div>_______________________________________=
________<br></div><div>Hsqldb-user mailing list<br></div><div><a href=3D"ma=
ilto:[email protected]" target=3D"_blank">Hsqldb-user@lists=
.sourceforge.net</a><br></div><div><a href=3D"https://lists.sourceforge.net=
/lists/listinfo/hsqldb-user" target=3D"_blank">https://lists.sourceforge.ne=
t/lists/listinfo/hsqldb-user</a><br></div><div><br></div></blockquote><div =
style=3D"font-family:Arial"><br></div></div>_______________________________=
________________<br>
Hsqldb-user mailing list<br>
<a href=3D"mailto:[email protected]" target=3D"_blank">Hsql=
[email protected]</a><br>
<a href=3D"https://lists.sourceforge.net/lists/listinfo/hsqldb-user" rel=3D=
"noreferrer" target=3D"_blank">https://lists.sourceforge.net/lists/listinfo=
/hsqldb-user</a><br>
</div></blockquote></div>

--00000000000084b03f05f225a96a--


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


--===============3419429414511918973==
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

--===============3419429414511918973==--