Calling a java stored procedure from SQL server

[Pete Helgren <Pete@xxxxxxxxxx>]

OK.  This isn't directly an i question but the i stands for 
"integration" so I'll give it a whirl.

I have a java application that is fairly complex and produces an output 
file on the i.  I have called it from RPG and from DB2 but I need to 
call the same java app from MS SQL Server (2000) that is residing on the 
same network.  So far the only thing I have been able to come up with is 
to write an extended stored procedure in C that would invoke the Java 
app [maybe] (PLEASE don't make me do it!).

So, I know there are some folks on the list that have to integrate MS 
SQL Server with their i shops.  Is there any way to do this?  Seems I 
need to wrap something around the Java app so that SQL Server 2000 can 
call it but what?

Pete