Hi Stuart, Arial, et al. The section of the HSQLdb users manual that shows how to create your own stored procedures is http://hsqldb.org/doc/guide/ch09.html#stored-section
Also, there was a question regarding the creation a REGEX_LIKE function, similar to Oracle's implementation, at the HSQLdb help forum in June of this year. The person asking wanted to use the function in a WHERE clause of course. He reported back that using the regex.* libraries in JDK 1.4 and creating the wrapping function as described in the manual it worked as he needed. One other side note, the difference in how Derby handles stored procedures and HSLQdb seems to me more a case of semantics then anything else. Although Derby is more expressive in declaring the function. In both cases however the implementation will be in a language such as Java, I believe. In the case of built in support for regular expressions not all 'big time' databases support it, or have just. MS SQL SERVER still does not, an example of adding support via a User Defined Function can be found at the MSDB blog site, the example is implemented in C#. Stuart, just to let you know - there is both a code snippet repository at codesnippet.services.openoffice.org and the wiki at wiki.services.openoffice.org - should you implement a simple regex function, I for one would say thank you if you would consider donating it back to the community using either of these sites. Oh and one last thing - I have tested the steps for adding procedures to the stand along HSQLdb server against a Base embedded database, it works just the same. Sincerely, Drew On 9/20/07, Ariel Constenla-Haile <[EMAIL PROTECTED]> wrote: > > Hi people > > Frank Schönheit - Sun Microsystems Germany escribió: > > Hello Stuart, > > > > can't remmeber having got the email you cited, sorry for not answering > > if I indeed overlooked it. > > > > Also, please note I'm sending this mail to [email protected], for > > reasons of scaling (more people can read and learn if we discuss things > > in public instead of privatemails). See > > http://wiki.services.openoffice.org/wiki/Base_Mailing_List for how to > > use this list, please. > > > >> Do you know if base supports "regular expression" queries? > > > > What do you mean with "regular expression queries"? Comparing field > > content against a regular expression? > > > > In general, the answer depends on the database you're using with Base. > > Assuming HSQLDB, I can say there is no built-in support for such a > > functionality in HSQLDB, but it should be possible to create a function > > for this, and make HSQLDB using it. > > you forgot to add: you MUST KNOW programming in Java to do so: stored > procedures and triggers must be Java methods... > > Poor the common user with no (Java) programming knowledge at all! > We can not ask the user to learn Java just to create a stored procedure, > even a user knowing SQL is something strange!! > I think this a point against HSQLDB, other Java-RDBMS like Apache Derby > supports SQL for this (like most serious RDBMS) !!! Lucky us there is a > plan to embedded also Derby (is it planned?) > > Bye, Ariel. > > > -- > Ariel Constenla-Haile > La Plata, Argentina > > [EMAIL PROTECTED] > [EMAIL PROTECTED] > > http://www.arielconstenlahaile.com.ar/ooo/ > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
