Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\WFALSNRSVCApp\testDS.jsp

<%--
 ============================================================================+
 |      Copyright (c) 1999 Oracle Corporation, Redwood Shores, CA, USA       |
 |                         All rights reserved.                              |
 +===========================================================================+
 |  FILENAME                                                                 |
 |        testDS.jsp                                                         |
 |                                                                           |
 |  DESCRIPTION                                                              |
 |                                                                           |
 |  NOTES                                                                    |
 |                                                                           |
 |  DEPENDENCIES                                                             |
 |                                                                           |
 |                                                                           |
 |  HISTORY                                                                  |
 |     27-AUG-2003 sacsharm.us created                                       |
 |                                                                           |
 | $Header: testDS.jsp 26.0 2004/12/10 22:56:15 yohuang noship $   |
 |                                                                           |
 +===========================================================================+
--%>
<%@ page contentType="text/html;charset=windows-1252"%>
<html>
<head>
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%@ page import="javax.naming.*" %>
<%@ page import="javax.sql.DataSource" %>
<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
     {
       DataSource ds = null;
       Context ic = new InitialContext();
       ds = (DataSource) ic.lookup("jdbc/WorkflowDS");
       
       if (ds != null) 
       {
         java.sql.Connection conn = ds.getConnection();
         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));
           }
           rs.close();
           prepStmt.close();
         } catch (Exception e)
         {
           streamOut.write(e.toString());           
           throw e;
         } finally
         {
           if (conn != null) conn.close();
         }
       } else
       {
         streamOut.write("Null Data Source Retrieved"); 
       }
     } catch (Exception e)
     {
       try { streamOut.write(e.toString() + "<br>" ); } catch (IOException ex) {}
       synchronized(this) {notify();}
     } 
     synchronized(this) {notify();}
    }
   };
       
   new Thread(testDeployRunnable).start();
   out.write("Waiting for the other thread" + "<br>");
   synchronized (this ) { wait(15000); }
   out.write("Wait Finished" + "<br>");
  %>
</body>
</html>

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de