Hi Thomas,
Are you happy, enough, with the following -- as described in an earlier
email:
1. Use this syntax to define a code module:
CREATE MODULE WIBBLE AS
$$
import java.sql.*;
public class MyNotWibbleCode ....
...
$$
.... but the classname is completely irrelevent -- we just use whatever
methods we happen to find defined within the 'module'.
2. When referring to a module in, for example, "CREATE TRIGGER", it's the
MODULE name, not the classname.
CREATE TRIGGER TRIG_INS BEFORE INSERT ON TEST FOR EACH ROW CALL "WIBBLE"
3. No support for packages. Internally all classes live in the existing
"org.h2.dynamic" package used for user-defined classes.
4. No support for uploading jars (at least not yet). I'm not sure I like the
idea, or the potential associated JVM byte-code version issues.
... if so then I'll finish up the code and we can all get on with the rest
of our lives. This horse has been flogged!
Thanks
Kerry
On Thu, Aug 26, 2010 at 6:10 AM, Thomas Mueller <
thomas.tom.muel...@gmail.com> wrote:
> Hi,
>
> > It just eases the deployment of some whose deployment software has
> difficulties in deploying java classes into h2's classpath.
>
> Yes, that's the main problem in my view.
>
> > Writing triggers or stored procedures in other databases doesn't require
> the
> > user to manually copy binary files onto the filesystem of the database
> > server -- that's *weird* and, IMHO, ugly.
>
> I agree, there should be a way to add classes using the source code or
> by uploading the jar file.
>
> 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 h2-datab...@googlegroups.com.
> To unsubscribe from this group, send email to
> h2-database+unsubscr...@googlegroups.com<h2-database%2bunsubscr...@googlegroups.com>
> .
> For more options, visit this group at
> http://groups.google.com/group/h2-database?hl=en.
>
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to h2-datab...@googlegroups.com.
To unsubscribe from this group, send email to
h2-database+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
