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?
posted 14 years ago
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