Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\WFMLRSVCApp\testDeploy.jsp

<%--
 ============================================================================+
 |      Copyright (c) 1999 Oracle Corporation, Redwood Shores, CA, USA       |
 |                         All rights reserved.                              |
 +===========================================================================+
 |  FILENAME                                                                 |
 |        testDeploy.jsp                                                     |
 |                                                                           |
 |  DESCRIPTION                                                              |
 |                                                                           |
 |  NOTES                                                                    |
 |                                                                           |
 |  DEPENDENCIES                                                             |
 |                                                                           |
 |                                                                           |
 |  HISTORY                                                                  |
 |     27-AUG-2003 sacsharm.us created                                       |
 |                                                                           |
 | $Header: testDeploy.jsp 26.1 2004/12/10 22:57:26 yohuang noship $   |
 |                                                                           |
 +===========================================================================+
--%>
<%@ page contentType="text/html;charset=windows-1252"%>
<html>
<head>
<%@ page import="oracle.apps.fnd.wf.common.WorkflowContext" %> 
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
</head>
<body>
 <%
  final JspWriter streamOut = out;
  Runnable testDeployRunnable = new Runnable() 
  {
    public void run() 
    {     
     try
     {
       oracle.apps.fnd.wf.common.WorkflowContext wc = new WorkflowContext();
       if (wc != null) 
       {
         java.sql.Connection conn = wc.getJDBCConnection();
         String selectStatement =
          "select 'Installed Workflow version is '||text from wf_resources where name like 'WF_VERSION' and language = 'US'";
         try
         {
           PreparedStatement prepStmt = conn.prepareStatement(selectStatement);
           ResultSet rs = prepStmt.executeQuery();

while (rs.next())
           {
             streamOut.write(rs.getString(1) + "<br>");
           }
         } catch (Exception e)
         {
           streamOut.write(e.toString());           
           throw e;
         } finally
         {
           wc.releaseJDBCConnection();
         }
       } else
       {
         streamOut.write("Null Workflow Context Created" + "<br>");
       }
     } catch (Exception e)
     {
       try { streamOut.write(e.toString()); } catch (IOException ex) {}
     } 
    }
   };
   new Thread(testDeployRunnable).start();
   synchronized (this ) { wait(15000); } 
  %>
</body>
</html>

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de