Posted by Craig Kelly on 02/14/06 05:30

> Hello,
>
> Does anyone know if SQL Server supports invoking Java methods from a
> Stored Procedure or even a Trigger. For example, it looks like oracle
> provides this capability based on the article at
> http://www.cs.umbc.edu/help/oracle8/java.815/a64686/04_call2.htm. It
> looks like for a Trigger it uses a SP as an in-between. Any insight
> into this would be greatly appreciated.
>
> Thanks,
> --Willard

The short answer is no but you get .NET in SQL Server 2005.

The long answer is that in SQL Server 2000 and earlier, you had two options:
code in T-SQL or write an "extended stored procedure" (often called an xp).
An xp is essentially a vanilla Win32 DLL that exports a function with a
specific signature that you can call like a T-SQL procedure. That can be
*very* dangerous because you're essentially loading your own executable code
(often/usually written in C or C++) directly into SQL Server's process
space. (We don't even allow it as a dev option where I work, but then we're
paranoid :)

Starting with SQL Server 2005, you get the .NET runtime in SQL Server which
marketing-wise is the same as Oracle's Java capabilities. Since I don't
know much about Oracle's Java features I won't comment on how similar they
are.

Craig

[Back to original message]