How to call a Java program in SQLServer?

Greenhorn

Posts: 3

posted 23 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I get to call a Java program from MS-SQLServer (Either in trigger or in store-procedure) to through a message to a remote Data Queue in AS/400.
Did anybody have any idea whether SQLServer can call the Java program? If not, can it call C, C++ or VB program?
And what is the easiest way to use a third party API in Java?

Cindy Glass

"The Hood"

Posts: 8521

posted 23 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Well, I believe that the SQLServer can call a .bat file, and the bat file can contain the commands to invoke a java program so . . . . .

"JavaRanch, where the deer and the Certified play" - David O'Meara

What I don't understand is how they changed the earth's orbit to fit the metric calendar. Tiny ad:

Gift giving made easy with the permaculture playing cards

https://coderanch.com/t/777758/Gift-giving-easy-permaculture-playing