How do I execute a jar file from a ms sql stored procedure?

From: Schimelcat (tammy.mullins_at_ensco.com)
Date: 03/30/04 

Date: 30 Mar 2004 07:37:39 -0800

Hello all,
I have a java application that will be passing data to my SQL Server.
The data is getting passed as parameters to a stored procedure, based
on what is passed the recordset is collected but needs to be returned
to another java application for display.

I can go from java to stored procedure, how do I go from stored
procedure to java app if the java app isn't already running?

Thx in advance,
tam

Relevant Pages

  • Re: Why use Java Stored Procedures....
    ... Aside from Microsoft databases, most well-known databases support java ... but that is not a Stored Procedure) I ...
    (comp.databases.oracle.server)
  • TDS_RET_STATUS exception
    ... high enough the occasional deadlock can occur. ... This is ok as the java code that executed the deadlocked CallableStatement ... However, what I'm currently getting is that the first retry attempt fails, ... found for the stored procedure output parameters. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Where do business rules belong... OCP and SPs
    ... problem with using a stored procedure is. ... that proc only through that interface. ... Say, in Java: ...
    (comp.object)
  • RE: No TDS_RET_STATUS was found
    ... high enough the occasional deadlock can occur. ... This is ok as the java code that executed the deadlocked CallableStatement ... what I'm currently getting is that the first retry attempt falls ... found for the stored procedure output parameters. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Exception comes from where?
    ... Java servlet code is calling a MSSQL stored procedure, ...
    (microsoft.public.sqlserver.jdbcdriver)