By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,877 Members | 1,102 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,877 IT Pros & Developers. It's quick & easy.

Java method invocation support

P: n/a
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/...6/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

Feb 13 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
> 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/...6/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
Feb 14 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.