Custom functions disappearing from script file

Dean Oemcke <[email protected]>
Newsgroups gmane.comp.java.hsqldb.user
Message-ID <CACTjWF3hPrMJP7Oeugyw6RUp4D=oz8Sfov-vHXy+TB90DW97aA@mail.gmail.com>
Hi,

I am have seen a few instances recently of my database (v2.2.9) dropping
custom functions from the script file.
I take nightly backups and am seeing that on one night all the functions
will be there and then the next night (and from then on) they are missing.
All other data seems to remain intact.

Specifically, a typical function in the script file looks something like
this:

CREATE FUNCTION PUBLIC.FORMATCUSTOMERNAME(IN FIRSTNAME VARCHAR(40),IN
LASTNAME VARCHAR(40)) RETURNS VARCHAR(80) SPECIFIC FORMATCUSTOMERNAME_10066
LANGUAGE JAVA DETERMINISTIC NO SQL CALLED ON NULL INPUT EXTERNAL NAME
'CLASSPATH:xxx.formatCustomerName'

Do you have any idea what could cause these functions to be dropped from
the database?
I believe something similar may also be happening to the global temporary
tables from time to time.

Thanks for your help,
Dean

------------------------------------------------------------------------------
Own the Future-Intel&reg; Level Up Game Demo Contest 2013
Rise to greatness in Intel's independent game demo contest.
Compete for recognition, cash, and the chance to get your game 
on Steam. $5K grand prize plus 10 genre and skill prizes. 
Submit your demo by 6/6/13. http://p.sf.net/sfu/intel_levelupd2d

_______________________________________________
Hsqldb-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.