Redirect-to uri

[Rajasekhar Atchutuni]

Hi all,

I am trying the redirect-to in the sitemap and I have some trouble here.

Site map:

 

 <map:match pattern="my_req">
     <map:act type="form-validator">
     <map:parameter name="descriptor" value="context://project/Validate.xml"/>
     <map:parameter name="validate-set" value="my_req"/>
       <!-- if success -->
        <map:generate type="xsp" src=""/>
        <map:redirect-to session="true" uri="main.xml"/>
        </map:act>
          <!-- if fail -->
               <map:generate type="xsp" src=""/>
                   <map:serialize/>
      </map:match> 

 

And the code in the action is:

<page>
   <content>  
   <esql:connection>
     <esql:pool>project</esql:pool>
      
     <esql:execute-query>
                <esql:query>            
                insert into mydb (ID,Date) values (null,sysdate)
                    </esql:query>
   
              <esql:results/>
    
              <esql:no-results/>
    
              <esql:error-results>
                 <error>
                    <message><esql:get-message/></message>
                    <trace><esql:get-stacktrace/></trace>
                    <string><esql:to-string/></string>
                 </error>
              </esql:error-results>
    
              <esql:update-results>
              
               <!--inserted><esql:get-update-count/></inserted-->
              </esql:update-results>
    
        </esql:execute-query>

   </esql:connection>
    
   </content>
  </page>

 

If I have map:redirect in the </map:act>, the data is not inserted into the table and it redirects to main.xml.  If I have it outside </map:act>, it gives "FATAL -- LANGUAGE EXCEPTION".  Can some one guide me here

 

Thanks

Raj

 

---

MSN 8 with e-mail virus protection service: 2 months FREE* --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>