Cannot connect to URL via Java stored procedure

From: Terri I. <teresni_at_ucia.gov>
Date: 14 Nov 2001 14:28:22 -0800
Message-ID: <b1f8b3bc.0111141428.423b8027@posting.google.com>

Does anybody have any idea why my Java class stored procedure will not connect to a specified URL when running from within the Oracle database, even though it works fine from command prompt using java command?

Here is my source code:

import oracle.sql.CLOB;
import oracle.sql.*;

import java.net.*;
import java.net.*.URL;
import java.io.*;
import java.sql.*;

public class ManageSSLConnection {
  // POST an XML document to a Service's URL, returning response   public static String sendXMLoverSSL(oracle.sql.CLOB xmlToPost, String target)
  throws IOException, SQLException {
    String response = "Nothing Posted Yet";

    try {
// Open an HTTP connection to the target URL

      HttpURLConnection conn = null;
      URL vistarget = new URL(target);
      conn = (HttpURLConnection)vistarget.openConnection();
      if (conn == null) return "ERROR";



      // Use HTTP POST

      conn.setRequestMethod("POST");



      // Indicate that the content type is XML with appropriate MIME

type
      conn.setRequestProperty("Content-type","text/xml");



      // Set up for writing and reading from the connection

      conn.setDoOutput(true);
      conn.setDoInput(true);
      conn.connect();



      // Read from the CLOB stream and write to a string

      String xml_string = xmlToPost.getSubString(1L,

(int)xmlToPost.length());

// Write the XML document into the connection's output stream
      DataOutputStream out = new
DataOutputStream(conn.getOutputStream());

      out.writeBytes(xml_string);
      out.flush();
      out.close();



      // Get header response from the server.




      // Need to call getHeaderFieldKey method so that

      //  getResponseCode and getResponseMessage methods will

      //  not return FileNotFoundException when return code > 400.

      //  This is a known Java bug that is expected to be fixed in v.

1.4

      int i=1;
      String key;
      while(true) {
        key = conn.getHeaderFieldKey(i);
        if (key==null)
          break;
        i++;
      }

      int resp_code = conn.getResponseCode();
      String resp_msg = conn.getResponseMessage();
      response = resp_code + " " + resp_msg;

      conn.disconnect();
      return response;

    }

    catch (FileNotFoundException e1) {
      return("ERROR");
    }

    catch (Exception e2) {

      e2.printStackTrace();
      return("ERROR");

    }
  }
} Received on Wed Nov 14 2001 - 16:28:22 CST