cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nicholas Hemley" <Nicholas.Hem...@lhb.scot.nhs.uk>
Subject Re: mod-db example not working.
Date Mon, 21 Oct 2002 12:09:43 GMT
Hi,

I also have null values being entered into my DB (MySQL) from a DatabaseAddAction. Here is
the sitemap.log extract:

Current Sitemap Parameters:
LEVEL 4
PARAM: 'row-count' VALUE: '1'
PARAM: 'hint_type_request_link.hint_type_id[0]' VALUE: 'null'
PARAM: 'hint_type_request_link.request_id[0]' VALUE: 'null'
LEVEL 3
PARAM: '../request_id' VALUE: '914'
PARAM: '../hint_type_id' VALUE: '1'
LEVEL 2
PARAM: '../../context' VALUE: '/cocoon2.1dev1610'
PARAM: '../../requestURI' VALUE: '/cocoon2.1dev1610/hint/info_requests/update_request'
PARAM: '../../requestQuery' VALUE: ''
LEVEL 1
PARAM: '../../../0' VALUE: 'update_request'

Somehow I am loosing the values between level 3 and 4.

My descriptor is as follows:
<?xml version="1.0"?>

<root>
  <connection>mysql_pool</connection>
  <table name="hint_type_request_link" alias="hint_type_request_link">
    <keys>
    </keys>
    <values>
      <value name="hint_type_id" type="int"> 
        <mode name="request" parameter="hint_type_request_link.hint_type_id" type="request"/>
      </value>
      <value name="request_id" type="int">
        <mode name="request" parameter="hint_type_request_link.request_id" type="request"/>
      </value>
    </values>
  </table>

<table-set name="hint_type_request_link">
      <table name="hint_type_request_link" others-mode="request"/>
</table-set>

</root>

and the sitemap entry is:
<!-- declare actions for database operations -->
       <map:action name="mod-db-add" src="org.apache.cocoon.acting.modular.DatabaseAddAction">
          <descriptor>xml/descriptor.xml</descriptor>
          <input>request-param</input>
          <output>request-attr</output>
          <throw-exception>false</throw-exception>
       </map:action>

and

<!-- insert hint_types into db -->
      <map:act type="req-params">
        <map:parameter name="parameters" value="hint_type_id request_id"/>
        <map:act type="mod-db-add">
          <map:parameter name="table-set" value="hint_type_request_link"/>
        </map:act>
      </map:act>

any ideas? I have no keys in the table since it is a link table. 

I am using a dev version of cocoon2.1 from 16/10/2002 with tomcat 4.1.12 and win2k.

Cheers,
Nic Hemley



**********************************************************************
The information contained in this message may be confidential or legally privileged and is
intended for the addressee only,

If you have received this message in error or there are any problems please notify the originator
immediately.

The unauthorised use, disclosure, copying or alteration of this message is strictly forbidden.
**********************************************************************


---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


Mime
View raw message