<%-- ============================================================================+ | 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:53:55 yohuang noship $ | | | +===========================================================================+ --%> <%@ page contentType="text/html;charset=windows-1252"%> <%@ page import="oracle.apps.fnd.wf.common.WorkflowContext" %> <%@ page import="java.sql.*" %> <%@ page import="java.io.*" %> <% 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) + "
"); } } catch (Exception e) { streamOut.write(e.toString()); throw e; } finally { wc.releaseJDBCConnection(); } } else { streamOut.write("Null Workflow Context Created" + "
"); } } catch (Exception e) { try { streamOut.write(e.toString()); } catch (IOException ex) {} } } }; new Thread(testDeployRunnable).start(); synchronized (this ) { wait(15000); } %>