Subject | Re: Java Stored Procedures |
---|---|
Author | Roman Rokytskyy |
Post date | 2005-10-20T13:05:59Z |
> Except that external classes could be not yours, whileThis is the same distinction as between UDFs and stored functions. I
> classes used by your database application and stored
> procedures could be inside your database, which means
> all stored application code can be inside your database.
do not know, maybe it is worth implementing saying that "beware - any
external dependency is your problem"...
> > Yup, and get 3MB text file for a 1 MB jar... which depends onWhat's the point of such scripts if it is similar to the backups?
> > other
>
> So?
> Given that there's still NO way to insert/update binaries in aThere is no way to execute script on the server on the first place.
> script, I'd say it's about time this gets implemented.
So, any script is executed by some tool - Database Workbench (?),
IBExpert, isql, IBObjects, etc. - and you just have to add a command
CREATE JAVA LIBRARY ... FROM FILE ... to that tool and load data from
file directly. Or INSERT INTO ... VALUES (..., file://..., ...) for
BLOB support. Those tools already have internal parsers, such feature
means only more advanced parser on their side.
Roman