Pete,
I haven't MS SQL Server 2000, 2005 only, but this web link might be
helpful:
http://www.netsplore.com/PublicPortal/Articles/ASPNETArticles/CallingAS4
00AS400RPGProgramsFromASPNET/tabid/246/Default.aspx
or
http://tinyurl.com/3ylrk8
Regards,
Pat Landrum
Senior Programmer/Analyst
Hanover County Public Schools
200 Berkley Street
Ashland, VA 23005
Email: plandrum@xxxxxxx
Phone: 804-365-4658 Fax: 804-365-4628
Never trust a computer you can't throw out a window - Steve Wozniak
Notice: This message or any accompanying documents may contain
confidential or privileged information of Hanover County Public Schools.
If you are not the intended recipient, disclosure, copying or
distribution is strictly prohibited by state and federal law. If you
received this message in error, please notify the sender as soon as
possible.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Pete Helgren
Sent: Thursday, April 02, 2009 3:27 PM
To: Midrange Systems Technical Discussion
Subject: Calling a java stored procedure from SQL server
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
midrange.com
