Subject Re: [Firebird-Architect] Re: Java Stored Procedures
Author Martijn Tonies
> > I hope Fb 3 ... but I doubt it
> The main show-stopper is an agreement on the API for external
> procedures (current version uses ISC API, while Jim Starkey argues
> about IscDsc API). I think this will be resolved during the FB/Vulcan
> merge, so FB 3.0 is quite likely to have it.

That would be excellent news ...

Cause, IMO, Fb 3 (the vulcan/fb merge) doesn't have a "whole lot" of
new stuff, as far as I know, besides internal plumbing.

I know this work had to be done, but for the majority out there, it's
non visible work, neither it's useful.

Having new SQL features (Stored Functions, c'mon now!), Java
Stored Procedures and - perhaps - .NET procedure would be

Add to that: a "variant" datatype, so you could do your own
wrapper around "coalesce", for example, would be even more cool.

Roman, one question about the Java procedures (as you're doing
a good job there ;) ... Is it java-source code stored and compiled in
Fb, or are the classes registered and should I do a:
CLASS myregisteredclass.mymethod etc etc...

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Upscene Productions
Database development questions? Check the forum!