Re: Custom functions disappearing from script file
Fred Toussi <[email protected]>
| Newsgroups | gmane.comp.java.hsqldb.user |
|---|---|
| Message-ID | <1364288581.4302.140661209253653.46561DAD@webmail.messagingengine.com> |
This hasn't been reported before. I guess if the classes for the java functions are not available on the classpath when the database is opened, this might happen. In any case, I suggest you follow this up in the SourceForge Help forum, as it can take several posts to clear it up. Fred On Tue, Mar 26, 2013, at 5:24, Dean Oemcke wrote: 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. [1]http://p.sf.net/sfu/intel_levelupd2d _______________________________________________ Hsqldb-user mailing list [2][email protected] [3]https://lists.sourceforge.net/lists/listinfo/hsqldb-user References 1. http://p.sf.net/sfu/intel_levelupd2d 2. mailto:[email protected] 3. https://lists.sourceforge.net/lists/listinfo/hsqldb-user ------------------------------------------------------------------------------ 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