Hi, > With one exception: SQL-based triggers and stored procedures.
I know. > I've tinkered a bit with H2's java-based procedures, but I just can't > figure out how to use them for what I want, and the limited > documentation isn't helping much. Then I need to improve the documentation :-) > Is there any way to hack in SQL > procedures using the existing features OR store SQL snippets within > the database and then execute them? Probably you would need to parameterize the statements... In any case, using Java methods and triggers would mean less work for you. > If not, could I get some additional pointers on how to use the Java- > based UDFs/Stored Procs to do more advanced stuff? Did you read the sample triggers and functions at http://code.google.com/p/h2database/source/browse/#svn/trunk/h2/src/test/org/h2/samples%3Fstate%3Dclosed - for example TriggerSample.java, Function.java, FunctionMultiReturn.java ? > I'd like to be > able to do the usual things, such as conditionally picking which > tables to select a value from, doing input validation and conditional > errors in response to invalid inputs, and modifying one table in > response to changes in another. All that shouldn't be a problem. > But, I'm not crazy about creating a separate java class for every tiny trigger > or stored procedure. You can use inner classes if you want. Regards, Thomas --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
