Error: “java.sql.SQLException: Invalid column index”
Thursday, June 11th, 2009Setup:
Viewing of table from Search
Resolution:
Modified Search Function on ADAO
Setup:
Viewing of table from Search
Resolution:
Modified Search Function on ADAO
1. Form Bean
<form-bean name=”pinspecialtyForm” type=”com.kp.ep2.admin.form.AdminPinSpecialtyForm” />
2. View
<action path=”/viewAdminPinSpecialty”
input=”tableadminmenu.jsp”
scope=”request”
type=”com.kp.ep2.admin.action.AdminPinSpecialtyAction” >
<forward name=”pinspecialtytablelist” path=”/viewPinSpecialty.jsp”/>
</action>
3. Save
<action path=”/saveAdminPinSpecialty”
attribute=”pinspecialtyForm” name=”pinspecialtyForm” scope=”request”
type=”com.kp.ep2.admin.action.AdminPinSpecialtyAction” >
<forward name=”pinspecialtytablelist” path=”/viewPinSpecialty.jsp”/>
</action>
4. AddNew
<action path=”/addNewAdminPinSpecialty”
attribute=”pinspecialtyForm” name=”pinspecialtyForm” scope=”request”
type=”com.kp.ep2.admin.action.AdminPinSpecialtyAction” >
<forward name=”newpinspecialty” path=”/addNewPinSpecialty.jsp”/>
</action>
5. SaveNew
<action path=”/saveNewAdminPinSpecialty”
attribute=”pinspecialtyForm” name=”pinspecialtyForm” scope=”request”
type=”com.kp.ep2.admin.action.AdminPinSpecialtyAction” >
<forward name=”newpinspecialty” path=”/addNewPinSpecialty.jsp”/>
</action>