Subject | Re: [Firebird-Architect] Re: Java Stored Procedures |
---|---|
Author | Martijn Tonies |
Post date | 2005-10-20T11:20:02Z |
> > Roman, one question about the Java procedures (as you're doingDo you have to registered available classes as objects?
> > a good job there ;) ...
> > Is it java-source code stored and compiled in
> > Fb,
>
> No.
>
> > or are the classes registered and should I do a:
> > CREATE PROCEDURE MyJavaWrapper
> > LANGUAGE JAVA
> > CLASS myregisteredclass.mymethod etc etc...
> >
>
> Syntax is bit different, but yes.
>
> 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.
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com