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® 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