Subject | Re: Java Stored Procedures |
---|---|
Author | Roman Rokytskyy |
Post date | 2005-10-20T11:07:03Z |
> Roman, one question about the Java procedures (as you're doingNo.
> a good job there ;) ...
> Is it java-source code stored and compiled in
> Fb,
> or are the classes registered and should I do a:Syntax is bit different, but yes.
> CREATE PROCEDURE MyJavaWrapper
> LANGUAGE JAVA
> CLASS myregisteredclass.mymethod etc etc...
>
I would prefer to have a possibility to use Java code between AS BEGIN
and END, but that is quite substantial change to the engine and does
not eliminate need of having engine CLASSPATH (procedure would very
likely need other classes except Java runtime and JDBC driver). So, I
do not think it is worth the effort.
Roman