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: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
