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(Controller) 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="text/html;charset=UTF-8" pageEncoding="UTF-8"/>
<f:view>
<ui:page binding="#{SyncStatus.page1}" id="page1">
<ui:html binding="#{SyncStatus.html1}" id="html1">
<ui:head binding="#{SyncStatus.head1}" id="head1">
<ui:link binding="#{SyncStatus.link1}" id="link1" url="/resources/stylesheet.css"/>
</ui:head>
<ui:body binding="#{SyncStatus.body1}" id="body1" imageURL="/resources/mainback.jpg" style="background-color: rgb(22, 155, 224); -rave-layout: grid">
<ui:form binding="#{SyncStatus.form1}" id="form1">
<table border="0" cellpadding="0" cellspacing="0" height="12" width="100%">
<tr>
<td>&nbsp;&nbsp;&nbsp;&nbsp;&n bsp;&nbsp;
<font color="#BFDBE8"
face="verdana" style="strong">
<script language="JavaScript">
//To Display Current Time and Date
var d= new Date();
document.write(d.toLocaleString());
</script>
</font>
</td>
<td align="right" class="whitetopnavtxt" 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="#{SyncStatus.logout_action}" binding="#{SyncStatus.logout}" id="logout" text="Logout"/>
</td>
</tr>
</table>
<!-- <table border="0" cellpadding="0" cellspacing="0" height="12" width="100%">
<tr>
<td align="right" class="whitetopnavtxt" 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="images/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="#FFFFFF" valign="top" width="91">
<img height="29" src="images/misc/toplogo.jpg" width="91"/>
</td>
<td bgcolor="#FFFFFF" width="79%">&nbsp;</td>
<td bgcolor="#FFFFFF" 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="images/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.jpg" 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('Image1','','images/misc/navschedule2.jpg',1)">-->
<img border="0" height="100" id="Image1" name="Image1" src="images/misc/navschedule1.jpg" width="92"/>
<!-- </a>-->
</td>
<td width="5">
<img height="101" src="images/misc/topnavbarsep.jpg" width="5"/>
</td>
<td width="94">
<!-- <a href="faces/gridViewPGAU.jsp" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('gridnav','','images/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.jpg" width="5"/>
</td>
<td width="94">
<!-- <a href="faces/FMCTargets.jsp" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('target','','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.jpg" width="5"/>
</td>
<td width="93">
<!-- <a href="faces/offerSummary.jsp" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('offer','','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.jpg" width="5"/>
</td>
<td width="94">
<!-- <a href="faces/orderSummary.jsp" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('order','','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.jpg" width="5"/>
</td>
<td background="images/misc/topnavbarsep.jpg" width="98">
<!-- <a href="Report%20Weekly%20Analysis.htm" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image2','','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('synchmanager','','image s/buttons/synchmanager2.jpg',1)">-->
<img alt="Synch Manager" border="0" height="96" name="synchmanager" src="images/buttons/synchmanager1.jpg" 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="images/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="dbluenavsmalltxt">
<!-- <font color="RED">
<strong>Select 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:panelGroup binding="#{SyncStatus.groupPanel1}" id="groupPanel1" style="border: 2px solid white; background-color: white; height: 644px; left: 0px; top: 264px; position: absolute; width: 1004px"/>
<ui:panelGroup binding="#{SyncStatus.groupPanel2}" 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="#{SyncStatus.btnRefreshStat_action}" binding="#{SyncStatus.btnRefreshStat}" id="btnRefreshStat" rendered="false"
style="height: 24px; left: 119px; top: 744px; position: absolute; width: 107px; z-index: 520" text="Refresh Status"
toolTip="Refreshes the Status for Synchronization" visible="false"/>
<ui:alert binding="#{SyncStatus.alert1}" id="alert1" style="left: 672px; top: 936px; position: absolute; width: 166px"/>
<ui:label binding="#{SyncStatus.label1}" id="label1"
style="height: 22px; left: 120px; top: 312px; position: absolute; width: 131px; z-index: 521" text="SYNC STATUS:"/>
<ui:button action="#{SyncStatus.btnBack_action}" binding="#{SyncStatus.btnBack}" id="btnBack"
style="height: 20px; left: 791px; top: 744px; position: absolute; width: 97px; z-index: 522;color:red" text="Back"/>
<ui:panelLayout binding="#{SyncStatus.lpSyncStat}" id="lpSyncStat" panelLayout="flow" style="height: 310px; left: 144px; top: 384px; position: absolute;overflow:scroll; width: 718px; z-index: 523">
<ui:table augmentTitle="false" binding="#{SyncStatus.tblSyncStat}" id="tblSyncStat" title="Synchronization Status" width="120">
<script><![CDATA[
/* ----- Functions for Table Preferences Panel ----- */
/*
* Toggle the table preferences panel open or closed
*/
function togglePreferencesPanel() {
var table = document.getElementById("form1:table1");
table.toggleTblePreferencesPanel();
}
/* ----- Functions for Filter Panel ----- */
/*
* Return true if the filter menu has actually changed,
* so the corresponding event should be allowed to continue.
*/
function filterMenuChanged() {
var table = document.getElementById("form1:table1");
return table.filterMenuChanged();
}
/*
* Toggle the custom filter panel (if any) open or closed.
*/
function toggleFilterPanel() {
var table = document.getElementById("form1:table1");
return table.toggleTableFilterPanel();
}
/* ----- Functions for Table Actions ----- */
/*
* Initialize all rows of the table when the state
* of selected rows changes.
*/
function initAllRows() {
var table = document.getElementById("form1:table1");
table.initAllRows();
}
/*
* 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.getElementById("form1:table1");
table.selectGroupRows(rowGroupId, selected);
}
/*
* Disable all table actions if no rows have been selected.
*/
function disableActions() {
// Determine whether any rows are currently selected
var table = document.getElementById("form1:table1");
var disabled = (table.getAllSelectedRowsCount() > 0) ? false : true;
// Set disabled state for top actions
document.getElementById("form1:table1:tableActions Top:deleteTop").setDisabled(disabled);
// Set disabled state for bottom actions
document.getElementById("form1:table1:tableActions Bottom:deleteBottom").setDisabled(disabled);
}]]></script>
<ui:tableRowGroup binding="#{SyncStatus.tableRowGroup1}" id="tableRowGroup1" rows="10"
sourceData="#{SyncStatus.sync_statusDataProvider}" sourceVar="currentRow">
<ui:tableColumn binding="#{SyncStatus.tableColumn1}" headerText="STATUS" id="tableColumn1">
<ui:staticText binding="#{SyncStatus.staticText1}" id="staticText1" text="#{currentRow.value['OPERATIONDESC']}"/>
</ui:tableColumn>
</ui:tableRowGroup>
</ui:table>
</ui:panelLayout>
<ui:messageGroup binding="#{SyncStatus.messageGroup1}" id="messageGroup1" style="left: 744px; top: 792px; position: absolute; width: 190px"/>
</ui:form>
</ui:body>
</ui:html>
</ui:page>
</f:view>
</jsp:root>