Post reply

Java stored proc support in sql server 2000

  • October 8, 2003 at 1:58 am

    #358369

    Hi Experts,

    Is there any kind of direct or indirect support of java stored procedure in sql server 2000 sp3a.Any resource/link etc are appreciated.

    TIA,

  • October 8, 2003 at 2:00 am

    #477480

    quote:

    Is there any kind of direct or indirect support of java stored procedure in sql server 2000 sp3a.Any resource/link etc are appreciated.

    if you mean the thing that Oracle has, I think the answer is no.

    Frank

    http://www.insidesql.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • October 8, 2003 at 3:00 am

    #477494

    Nope, SQL 2000 only supports T-SQL as the language for stored procedures.

    Next release aparantly has full integration with the .NET framework so in theory and .NET language can be used for writing stored procedures. Not sure if there is a Java.NET available yet, im sure there must be somewhere!

    Dan

  • October 8, 2003 at 3:18 am

    #477498

    Dan and Frenk ,Thanks for the replies.Can anybody know more about java.NET will it work with sql server 2000 ? Is there any other way to write sp like COM/vb etc ?

    Thanks,

    Sheilesh

  • October 8, 2003 at 3:21 am

    #477500

    It will work with SQL 2000, but within SQL 2000. The only way you can use Java is as the access to SQL 2000. There is no way of using it within SQL Server (Until the next release).

    You can write your code in a COM object or as a .NET object/component/assembly which accesses the tables/views itself rather than going through a stored procedure.

    Dan

  • October 9, 2003 at 12:28 pm

    #477749

    There is no Java.NET - Microsoft has released a Java-like language for the .NET platform called J# (J Sharp). It was intended as an upgrade path from their older product Visual J++.

    It has Java syntax (as of version 1.1.4 I believe) but looking at their web site (http://msdn.microsoft.com/vjsharp/) it looks like MS is including additional classes to make it more compatible with Java 1.2

    Of course it uses the .NET Framework Classes, so you still have to know that to really do anything.

  • October 10, 2003 at 12:22 am

    #477794

    Thanks Mr. Moor for such a vital info about JSharp.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply