Re: Java method invocation support

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


.

Relevant Pages

  • Re: How to get list of EventClasses in MSSQLServer2000
    ... statement inside a stored procedure has completed.') ... SQL Server statement or stored procedure.') ... Plan','Displays the plan tree of the Transact-SQL statement executed.') ... Login','Occurs when a SQL Server login is added or removed; ...
    (microsoft.public.sqlserver.security)
  • Re: Stored Proc Recompile
    ... In order to promote re-use of query plans, our java application is using ... This method of invoking the stored procedure should not trigger a ... My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis ...
    (microsoft.public.sqlserver.server)
  • Re: Accessing FoxPro Free Table
    ... which the SQL Server service is running. ... account, ... > If you are creating a stored procedure and you want> to make sure that the procedure definition cannot be> viewed by other users, you can use the WITH ENCRYPTION> clause. ... The procedure definition is then stored in an> unreadable form. ...
    (microsoft.public.data.odbc)
  • Re: Adding date to parameter
    ... SqlClient provider which is specifically written for SQL Server. ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... I made the assumption that the stored procedure went by the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Problem with the Legacy ASP files and the Sql Server Express
    ... table, if another inserting occurs at the nearly exactly the same moment, ... SQL Server will pass it a default value. ... assume that you do have a connection that can reach SQL Server Express. ... unless your stored procedure has some thing that only works ...
    (microsoft.public.dotnet.framework.aspnet)
Loading