Home Forums SQL Server 2005 SQL Server 2005 General Discussion call Java web service from SQL server 2005 store procedure and get response from web service in store procedure RE: call Java web service from SQL server 2005 store procedure and get response from web service in store procedure

  • one applicationA is directly calling my procedure for giving data to applicationB.

    inside of the proc,

    I need to call the Java webservice and get data from applicationC.

    It returns some data in XML format, then I inserted the data to temp table and compare that data to my own application data.

    then finally I need to send the data to applicationB through applicationA.

    Already we got success for the above scenario for .net webservices.

    so we are trying this method.

    we got the following msg for using Java webservice.

    "<h2>AXIS error</h2> <p>No service is available at this URL</p> "

    Thanks,

    Nithiyanandam.S