Re: Create Function fails after upgrade to 2.7.1
Fred Toussi via Hsqldb-user <[email protected]> Fri, 13 Jan 2023 17:34:21 +0000
| Newsgroups | gmane.comp.java.hsqldb.user |
|---|---|
| Message-ID | <[email protected]> |
--===============1348097631954450625== Content-Type: multipart/alternative; boundary=6d8f9e410c094f3ea0fff59cb5095ef7 --6d8f9e410c094f3ea0fff59cb5095ef7 Content-Type: text/plain Thanks for reporting. Fixed. On Fri, Jan 13, 2023, at 14:00, Elise Atkins wrote: > 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 > > _______________________________________________ > Hsqldb-user mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/hsqldb-user > --6d8f9e410c094f3ea0fff59cb5095ef7 Content-Type: text/html Content-Transfer-Encoding: quoted-printable <!DOCTYPE html><html><head><title></title><style type=3D"text/css">p.Mso= Normal,p.MsoNoSpacing{margin:0}</style></head><body><div style=3D"font-f= amily:Arial;">Thanks for reporting. Fixed.<br></div><div style=3D"font-f= amily:Arial;"><br></div><div>On Fri, Jan 13, 2023, at 14:00, Elise Atkin= s wrote:<br></div><blockquote type=3D"cite" id=3D"qt" style=3D""><div di= r=3D"ltr"><div>Thanks and it is working. The change log for versio= n 2.7.1 shows the property is: <span style=3D"color:rgb(0, 0, 0);wh= ite-space:pre-wrap;">hsqldb.java_method_names.</span><br></div><div><spa= n style=3D"color:rgb(0, 0, 0);white-space:pre-wrap;"></span><br></div><d= iv><span style=3D"color:rgb(0, 0, 0);white-space:pre-wrap;">Elise</span>= <br></div></div><div><br></div><div class=3D"qt-gmail_quote"><div dir=3D= "ltr" class=3D"qt-gmail_attr">On Thu, Jan 12, 2023 at 1:31 PM Fred Touss= i via Hsqldb-user <<a href=3D"mailto:[email protected]= t">[email protected]</a>> wrote:<br></div><blockquote= class=3D"qt-gmail_quote" style=3D"margin-top:0px;margin-right:0px;margi= n-bottom:0px;margin-left:0.8ex;border-left-color:rgb(204, 204, 204);bord= er-left-style:solid;border-left-width:1px;padding-left:1ex;"><div class=3D= "qt-msg-2898374593909728497"><div><u></u><br></div><div><div style=3D"fo= nt-family:Arial;">The property setting is not included correctly in the = java command. It should look like this:<br></div><div style=3D"font-fami= ly:Arial;"><br></div><div style=3D"font-family:Arial;">-Dhsqldb.method_c= lass_names=3Dcom.tavve.services.proxycachemgr.* -classpath /usr/tavve/ra= nger/server/bundles/zr-ProxyCacheMgr.jar:/usr/tavve/ranger/server/bundle= s/hsqldb.jar:/usr/tavve/ranger/server/felix/sqltool.jar org.hsqldb.util.= MainInvoker org.hsqldb.server.Server<br></div><div style=3D"font-family:= Arial;"><br></div><div style=3D"font-family:Arial;"><br></div><div style= =3D"font-family:Arial;">Fred<br></div><div style=3D"font-family:Arial;">= <br></div><div>On Thu, Jan 12, 2023, at 17:39, Elise Atkins wrote:<br></= div><blockquote type=3D"cite" id=3D"qt-m_-2898374593909728497qt"><div di= r=3D"ltr"><div>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_cla= ss_names=3D.... to the java options and am left with an error when = using the CREATE FUNCTION statement. <br></div><div><br></div><div>= The hsqldb process:<br></div><div><div>/usr/bin/java -Xmx512m -Dhsqldb.j= ava_method_names=3Dcom.tavve.services.proxycachemgr.* -classpath /usr/ta= vve/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<br></div><div><br></div><div>= CREATE FUNCTION <br></div><div>MEMORYHIGH() <br></div><div>RET= URNS BOOLEAN <br></div><div>LANGUAGE JAVA <br></div><div>DETER= MINISTIC <br></div><div>NO SQL <br></div><div>EXTERNAL NAME 'C= LASSPATH:com.tavve.services.proxycachemgr.HsDbFullTrigger.isMemoryAboveT= hreshold<br></div><div><br></div><div>The error is: java.sql.SQLSyn= taxErrorException: user lacks privilege or object not found: com.tavve.s= ervices.proxycachemgr.HsDbFullTrigger<br></div><div><br></div><div>I don= 't believe the issue is the user lacks privilege as the CREATE TABLE sta= tements are successfully executed. It does work if I use version 2.7.0.<= br></div><div><br></div><div>Any clues on what I am missing?<br></d= iv><div><br></div><div>Elise<br></div><div><br></div></div></div><div><b= r></div><div>_______________________________________________<br></div><d= iv>Hsqldb-user mailing list<br></div><div><a href=3D"mailto:Hsqldb-user@= lists.sourceforge.net" target=3D"_blank">[email protected]= et</a><br></div><div><a href=3D"https://lists.sourceforge.net/lists/list= info/hsqldb-user" target=3D"_blank">https://lists.sourceforge.net/lists/= listinfo/hsqldb-user</a><br></div><div><br></div></blockquote><div style= =3D"font-family:Arial;"><br></div></div><div>___________________________= ____________________<br></div><div> Hsqldb-user mailing list<br></div><d= iv> <a href=3D"mailto:[email protected]" target=3D"_blan= k">[email protected]</a><br></div><div> <a href=3D"https= ://lists.sourceforge.net/lists/listinfo/hsqldb-user" rel=3D"noreferrer" = target=3D"_blank">https://lists.sourceforge.net/lists/listinfo/hsqldb-us= er</a><br></div></div></blockquote></div><div><br></div><div>___________= ____________________________________<br></div><div>Hsqldb-user mailing l= ist<br></div><div><a href=3D"mailto:[email protected]">H= [email protected]</a><br></div><div><a href=3D"https://li= sts.sourceforge.net/lists/listinfo/hsqldb-user">https://lists.sourceforg= e.net/lists/listinfo/hsqldb-user</a><br></div><div><br></div></blockquot= e></body></html> --6d8f9e410c094f3ea0fff59cb5095ef7-- --===============1348097631954450625== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline --===============1348097631954450625== 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 --===============1348097631954450625==--