Are you calling your jsp from a servlet or is it run as it's own entry point? Also could you post (under code tags) the first 20 or so lines of the JSP.
I am not externally calling jsp but my application is developed in JSF framewrk,
FacesServlet(Co ntroller) will be instantiated first.
I am inserting data into a temp table of oracle, on that insert event trigger is fired, this trigger creates a database link and cursor , then the data is synchronized from local database to remote database through database link.
jsp:
<?xml version="1.0" encoding="UTF-8"?>
<jsp:root version="1.2" xmlns:f="http://java.sun.com/jsf/core" xmlns:h="http://java.sun.com/jsf/html" xmlns:jsp="http ://java.sun.com/JSP/Page" xmlns:ui="http://www.sun.com/web/ui">
<jsp:directive. page contentType="te xt/html;charset=UT F-8" pageEncoding="U TF-8"/>
<f:view>
<ui:page binding="#{Sync Status.page1}" id="page1">
<ui:html binding="#{Sync Status.html1}" id="html1">
<ui:head binding="#{Sync Status.head1}" id="head1">
<ui:link binding="#{Sync Status.link1}" id="link1" url="/resources/stylesheet.css"/>
</ui:head>
<ui:body binding="#{Sync Status.body1}" id="body1" imageURL="/resources/mainback.jpg" style="backgrou nd-color: rgb(22, 155, 224); -rave-layout: grid">
<ui:form binding="#{Sync Status.form1}" id="form1">
<table border="0" cellpadding="0" cellspacing="0" height="12" width="100%">
<tr>
<td>&nbsp;& amp;nbsp;&n bsp;&nbsp;& amp;nbsp;&n bsp;
<font color="#BFDBE8"
face="verdana" style="strong">
<script language="JavaS cript">
//To Display Current Time and Date
var d= new Date();
document.write( d.toLocaleStrin g());
</script>
</font>
</td>
<td align="right" class="whitetop navtxt" style="height: 16px">
<a onclick="window .open('http://localhost:8090/fm/SMS%20Document/main.htm');">
<font color="#BFDBE8" face="verdana" style="strong"> Help</font>
</a>
<font color="#BFDBE8" face="verdana" style="strong"> | </font>
<a href="index.jsp ">
<font color="#BFDBE8" face="verdana" style="strong"> </font>
</a>
</td>
<td width="30">
<table border="0" cellpadding="0" cellspacing="0" width="30">
<tr>
<td width="32"></td>
</tr>
</table>
<ui:button action="#{SyncS tatus.logout_ac tion}" binding="#{Sync Status.logout}" id="logout" text="Logout"/>
</td>
</tr>
</table>
<!-- <table border="0" cellpadding="0" cellspacing="0" height="12" width="100%">
<tr>
<td align="right" class="whitetop navtxt" style="height: 28px" width="50%"></td>
<td style="width: 75px" width="8%"></td>
<td width="10%"></td>
<td width="30">
<table border="0" cellpadding="0" cellspacing="0" width="30">
<tr>
<td width="32">
<br/>&nbsp;</td>
</tr>
</table>
</td>
</tr>
</table>-->
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="20">
<img alt="" height="12" src="images/base/GRID_03.jpg" width="20"/>
</td>
<td background="ima ges/base/GRID_04.jpg">
<img alt="" height="12" src="images/base/GRID_04.jpg" width="748"/>
</td>
<td width="15">
<img alt="" height="12" src="images/base/GRID_05.jpg" width="15"/>
</td>
</tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td style="height: 29px" width="20">
<img alt="" height="32" src="images/base/GRID_07.jpg" width="20"/>
</td>
<td bgcolor="#FFFFF F" valign="top" width="91">
<img height="29" src="images/misc/toplogo.jpg" width="91"/>
</td>
<td bgcolor="#FFFFF F" width="79%">&am p;nbsp;</td>
<td bgcolor="#FFFFF F" width="190">
<img height="15" src="images/misc/topmotto.jpg" width="190"/>
</td>
<td width="15">
<img alt="" height="32" src="images/base/GRID_09.jpg" width="15"/>
</td>
</tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="19">
<img alt="" height="119" src="images/base/GRID_10.jpg" width="20"/>
</td>
<td background="ima ges/base/GRID_10a.jpg" valign="top">
<table border="0" cellpadding="0" cellspacing="0" width="659">
<tr>
<td height="14" width="659">
<img height="14" src="images/misc/topnavbarbck.jp g" width="659"/>
</td>
</tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr valign="top">
<td height="100" width="659">
<table border="0" cellpadding="0" cellspacing="0" width="659">
<tr valign="top">
<td height="100" width="27">
<img height="100" src="images/misc/topnavbarbcklt. jpg" width="27"/>
</td>
<td width="92">
<!-- <a href="faces/Menu.jsp" onmouseout="MM_ swapImgRestore( )" onmouseover="MM _swapImage('Ima ge1','','images/misc/navschedule2.jp g',1)">-->
<img border="0" height="100" id="Image1" name="Image1" src="images/misc/navschedule1.jp g" width="92"/>
<!-- </a>-->
</td>
<td width="5">
<img height="101" src="images/misc/topnavbarsep.jp g" width="5"/>
</td>
<td width="94">
<!-- <a href="faces/gridViewPGAU.js p" onmouseout="MM_ swapImgRestore( )" onmouseover="MM _swapImage('gri dnav','','image s/misc/navgrid2.jpg',1 )">-->
<img alt="Grid" border="0" height="101" name="gridnav" src="images/misc/navgrid1.jpg" width="94"/>
<!-- </a>-->
</td>
<td width="5">
<img height="101" src="images/misc/topnavbarsep.jp g" width="5"/>
</td>
<td width="94">
<!-- <a href="faces/FMCTargets.jsp" onmouseout="MM_ swapImgRestore( )" onmouseover="MM _swapImage('tar get','','images/misc/navtarget2.jpg' ,1)">-->
<img alt="Target" border="0" height="101" name="target" src="images/misc/navtarget1.jpg" width="94"/>
<!-- </a>-->
</td>
<td width="5">
<img height="101" src="images/misc/topnavbarsep.jp g" width="5"/>
</td>
<td width="93">
<!-- <a href="faces/offerSummary.js p" onmouseout="MM_ swapImgRestore( )" onmouseover="MM _swapImage('off er','','images/misc/navoffer2.jpg', 1)">-->
<img alt="Offer" border="0" height="101" name="offer" src="images/misc/navoffer1.jpg" width="93"/>
<!-- </a>-->
</td>
<td width="5">
<img height="101" src="images/misc/topnavbarsep.jp g" width="5"/>
</td>
<td width="94">
<!-- <a href="faces/orderSummary.js p" onmouseout="MM_ swapImgRestore( )" onmouseover="MM _swapImage('ord er','','images/misc/navorder2.jpg', 1)">-->
<img alt="Order" border="0" height="101" name="order" src="images/misc/navorder1.jpg" width="94"/>
<!-- </a>-->
</td>
<td width="5">
<img height="101" src="images/misc/topnavbarsep.jp g" width="5"/>
</td>
<td background="ima ges/misc/topnavbarsep.jp g" width="98">
<!-- <a href="Report%20 Weekly%20Analys is.htm" onmouseout="MM_ swapImgRestore( )" onmouseover="MM _swapImage('Ima ge2','','images/misc/navreport2.jpg' ,1)">-->
<img border="0" height="101" id="Image2" name="Image2" src="images/misc/navreport1.jpg" width="94"/>
<!-- </a>-->
</td>
<td width="42">
<img height="100" src="images/misc/topnavbarbckrt. jpg" width="42"/>
</td>
</tr>
</table>
</td>
<td align="right">
<!-- <a href="faces/SPGAU.jsp" onmouseout="MM_ swapImgRestore( )" onmouseover="MM _swapImage('syn chmanager','',' images/buttons/synchmanager2.j pg',1)">-->
<img alt="Synch Manager" border="0" height="96" name="synchmana ger" src="images/buttons/synchmanager1.j pg" width="75"/>
<!-- </a>-->
</td>
</tr>
</table>
</td>
<td width="15">
<img alt="" height="119" src="images/base/GRID_11.jpg" width="15"/>
</td>
</tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="20">
<img alt="" height="50" src="images/base/GRID_12.jpg" width="20"/>
</td>
<td background="ima ges/base/litebluebarmid. jpg">
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td align="left" valign="top" width="21%">
<img height="41" src="images/SyncManager/title_sync.jpg" width="225"/>
</td>
<td align="left" valign="middle" width="79%">
<table border="0" cellpadding="0" cellspacing="0" width="413">
<tr>
<td style="height: 16px" width="5%"></td>
<td align="right" style="height: 20px" valign="middle" width="208">
<span class="gray1txt ">
<img height="10" src="images/misc/spacer.gif" width="10"/>
</span>
<span class="dbluenav smalltxt">
<!-- <font color="RED">
<strong>Selec t Item to sync</strong>
</font>-->
</span>
<span class="gray1txt "></span>
</td>
<td align="left" valign="middle" width="205">
<span class="gray1txt ">
<img height="10" src="images/misc/spacer.gif" width="10"/>
</span>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<ui:panelGrou p binding="#{Sync Status.groupPan el1}" id="groupPanel1 " style="border: 2px solid white; background-color: white; height: 644px; left: 0px; top: 264px; position: absolute; width: 1004px"/>
<ui:panelGrou p binding="#{Sync Status.groupPan el2}" id="groupPanel2 " style="border: 3px groove rgb(134, 205, 205); background-color: rgb(255, 255, 255); height: 354px; left: 120px; top: 360px; position: absolute; width: 762px"/>
<img height="30" src="images/misc/bottomlogo.jpg" style="left: 0px; top: 936px; position: absolute" width="172"/>
<ui:button action="#{SyncS tatus.btnRefres hStat_action}" binding="#{Sync Status.btnRefre shStat}" id="btnRefreshS tat" rendered="false "
style="height: 24px; left: 119px; top: 744px; position: absolute; width: 107px; z-index: 520" text="Refresh Status"
toolTip="Refres hes the Status for Synchronization " visible="false"/>
<ui:alert binding="#{Sync Status.alert1}" id="alert1" style="left: 672px; top: 936px; position: absolute; width: 166px"/>
<ui:label binding="#{Sync Status.label1}" id="label1"
style="height: 22px; left: 120px; top: 312px; position: absolute; width: 131px; z-index: 521" text="SYNC STATUS:"/>
<ui:button action="#{SyncS tatus.btnBack_a ction}" binding="#{Sync Status.btnBack} " id="btnBack"
style="height: 20px; left: 791px; top: 744px; position: absolute; width: 97px; z-index: 522;color:red" text="Back"/>
<ui:panelLayo ut binding="#{Sync Status.lpSyncSt at}" id="lpSyncStat " panelLayout="fl ow" style="height: 310px; left: 144px; top: 384px; position: absolute;overfl ow:scroll; width: 718px; z-index: 523">
<ui:table augmentTitle="f alse" binding="#{Sync Status.tblSyncS tat}" id="tblSyncStat " title="Synchron ization Status" width="120">
<script><![CDATA[
/* ----- Functions for Table Preferences Panel ----- */
/*
* Toggle the table preferences panel open or closed
*/
function togglePreferenc esPanel() {
var table = document.getEle mentById("form1 :table1");
table.toggleTbl ePreferencesPan el();
}
/* ----- Functions for Filter Panel ----- */
/*
* Return true if the filter menu has actually changed,
* so the corresponding event should be allowed to continue.
*/
function filterMenuChang ed() {
var table = document.getEle mentById("form1 :table1");
return table.filterMen uChanged();
}
/*
* Toggle the custom filter panel (if any) open or closed.
*/
function toggleFilterPan el() {
var table = document.getEle mentById("form1 :table1");
return table.toggleTab leFilterPanel() ;
}
/* ----- Functions for Table Actions ----- */
/*
* Initialize all rows of the table when the state
* of selected rows changes.
*/
function initAllRows() {
var table = document.getEle mentById("form1 :table1");
table.initAllRo ws();
}
/*
* Set the selected state for the given row groups
* displayed in the table. This functionality requires
* the 'selectId' of the tableColumn to be set.
*
* @param rowGroupId HTML element id of the tableRowGroup component
* @param selected Flag indicating whether components should be selected
*/
function selectGroupRows (rowGroupId, selected) {
var table = document.getEle mentById("form1 :table1");
table.selectGro upRows(rowGroup Id, selected);
}
/*
* Disable all table actions if no rows have been selected.
*/
function disableActions( ) {
// Determine whether any rows are currently selected
var table = document.getEle mentById("form1 :table1");
var disabled = (table.getAllSe lectedRowsCount () > 0) ? false : true;
// Set disabled state for top actions
document.getEle mentById("form1 :table1:tableAc tionsTop:delete Top").setDisabl ed(disabled);
// Set disabled state for bottom actions
document.getEle mentById("form1 :table1:tableAc tionsBottom:del eteBottom").set Disabled(disabl ed);
}]]></script>
<ui:tableRowGro up binding="#{Sync Status.tableRow Group1}" id="tableRowGro up1" rows="10"
sourceData="#{S yncStatus.sync_ statusDataProvi der}" sourceVar="curr entRow">
<ui:tableColu mn binding="#{Sync Status.tableCol umn1}" headerText="STA TUS" id="tableColumn 1">
<ui:staticTex t binding="#{Sync Status.staticTe xt1}" id="staticText1 " text="#{current Row.value['OPERATIONDESC']}"/>
</ui:tableColumn>
</ui:tableRowGrou p>
</ui:table>
</ui:panelLayout>
<ui:messageGrou p binding="#{Sync Status.messageG roup1}" id="messageGrou p1" style="left: 744px; top: 792px; position: absolute; width: 190px"/>
</ui:form>
</ui:body>
</ui:html>
</ui:page>
</f:view>
</jsp:root>
3
