Re: Create Function fails after upgrade to 2.7.1
Fred Toussi via Hsqldb-user <[email protected]> Thu, 12 Jan 2023 18:13:55 +0000
| Newsgroups | gmane.comp.java.hsqldb.user |
|---|---|
| Message-ID | <[email protected]> |
--===============5432705578887668244== Content-Type: multipart/alternative; boundary=5db7adcd52e24e33ac653afce42fc68e --5db7adcd52e24e33ac653afce42fc68e Content-Type: text/plain 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 > --5db7adcd52e24e33ac653afce42fc68e 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;">The property setting is not included correctly in the java= command. It should look like this:<br></div><div style=3D"font-family:A= rial;"><br></div><div style=3D"font-family:Arial;">-Dhsqldb.method_class= _names=3Dcom.tavve.services.proxycachemgr.* -classpath /usr/tavve/ranger= /server/bundles/zr-ProxyCacheMgr.jar:/usr/tavve/ranger/server/bundles/hs= qldb.jar:/usr/tavve/ranger/server/felix/sqltool.jar org.hsqldb.util.Main= Invoker org.hsqldb.server.Server<br></div><div style=3D"font-family:Aria= l;"><br></div><div style=3D"font-family:Arial;"></div><div style=3D"font= -family:Arial;">Fred<br></div><div style=3D"font-family:Arial;"><br></di= v><div>On Thu, Jan 12, 2023, at 17:39, Elise Atkins wrote:<br></div><blo= ckquote type=3D"cite" id=3D"qt" style=3D""><div dir=3D"ltr"><div>I'm upg= rading from version 2.3 to 2.7.1 using the memory db mode. I am using th= e java 8 jar. I added the -Dhsqldb.method_class_names=3D.... to the= java options and am left with an error when using the CREATE FUNCT= ION statement. <br></div><div><br></div><div>The hsqldb process:<br= ></div><div><div>/usr/bin/java -Xmx512m -Dhsqldb.java_method_names=3Dcom= .tavve.services.proxycachemgr.* -classpath /usr/tavve/ranger/server/bund= les/zr-ProxyCacheMgr.jar:/usr/tavve/ranger/server/bundles/hsqldb.jar:/us= r/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>RETURNS BOOLEAN <br>= </div><div>LANGUAGE JAVA <br></div><div>DETERMINISTIC <br></di= v><div>NO SQL <br></div><div>EXTERNAL NAME 'CLASSPATH:com.tavve.ser= vices.proxycachemgr.HsDbFullTrigger.isMemoryAboveThreshold<br></div><div= ><br></div><div>The error is: java.sql.SQLSyntaxErrorException: use= r lacks privilege or object not found: com.tavve.services.proxycachemgr.= HsDbFullTrigger<br></div><div><br></div><div>I don't believe the issue i= s the user lacks privilege as the CREATE TABLE statements are successful= ly executed. It does work if I use version 2.7.0.<br></div><div><br></di= v><div>Any clues on what I 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"mailto:[email protected]"= >[email protected]</a><br></div><div><a href=3D"https://= lists.sourceforge.net/lists/listinfo/hsqldb-user">https://lists.sourcefo= rge.net/lists/listinfo/hsqldb-user</a><br></div><div><br></div></blockqu= ote><div style=3D"font-family:Arial;"><br></div></body></html> --5db7adcd52e24e33ac653afce42fc68e-- --===============5432705578887668244== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline --===============5432705578887668244== 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 --===============5432705578887668244==--