cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andre Taube" <andreta...@attbi.com>
Subject RE: MySQL date conversion with modular database action
Date Wed, 19 Feb 2003 18:40:31 GMT
It still does not work.

descriptor:

	<table-set name="pcm_contract">
		<table name="pcm_contract" others-mode="attribute"/>
	</table-set>


	<table name="pcm_contract" alias="pcm_contract">
		<keys>
			<key name="id" type="int" autoincrement="true">
				<mode name="auto" type="autoincr"/>
			</key>
		</keys>

		<values>
			<value name="contract_name"	type="string"></value>
			<value name="contract_type"	type="int"></value>
			<value name="contract_code"	type="string"></value>
			<value name="job_number"	type="string"></value>
			<value name="misc_code"		type="string"></value>
			<value name="start_date"	type="date">
				<mode name="datemeta" type="attrib">
					<parameter>pcm_contract.start_date</parameter>
					<format>MM/dd/yyyy</format>
					<input-module name="request-param"/>
			   </mode>
			</value>
			<value name="end_date"		type="date">
				<mode name="datemeta" type="attrib">
					<parameter>pcm_contract.end_date</parameter>
					<format>MM/dd/yyyy</format>
					<input-module name="request-param"/>
			   </mode>
			</value>
			<value name="contract_status"	type="int"></value>
		</values>
	</table>


and the log is:

DEBUG   (2003-02-19) 11:22.42:540   [sitemap]
(/pcm/contract_admin.contract.html) Thread-9/DefaultComponentFactory:
ComponentFactory creating new instance of
org.apache.cocoon.acting.modular.DatabaseUpdateAction.
DEBUG   (2003-02-19) 11:22.42:541   [sitemap]
(/pcm/contract_admin.contract.html) Thread-9/DefaultComponentFactory: logger
attribute is sitemap.action.DatabaseUpdateAction
DEBUG   (2003-02-19) 11:22.42:543   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html)
Thread-9/AbstractComplementaryConfigurableAction: Using cached configuration
for contract_descriptor.xml
DEBUG   (2003-02-19) 11:22.42:547   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: modeTypes :
{2=request-attr, 1=others, 0=autoincr}
DEBUG   (2003-02-19) 11:22.42:548   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: i=0
DEBUG   (2003-02-19) 11:22.42:549   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: i=1
DEBUG   (2003-02-19) 11:22.42:550   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: i=2
DEBUG   (2003-02-19) 11:22.42:551   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: i=3
DEBUG   (2003-02-19) 11:22.42:552   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: i=4
DEBUG   (2003-02-19) 11:22.42:553   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: i=5
DEBUG   (2003-02-19) 11:22.42:554   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: i=6
DEBUG   (2003-02-19) 11:22.42:555   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: i=7
DEBUG   (2003-02-19) 11:22.42:556   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: i=8
DEBUG   (2003-02-19) 11:22.42:557   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: query: UPDATE
pcm_contract SET contract_name= ?, contract_type= ?, contract_code= ?,
job_number= ?, misc_code= ?, start_date= ?, end_date= ?, contract_status= ?
WHERE id= ?
DEBUG   (2003-02-19) 11:22.42:558   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Trying to set
column pcm_contract.id from request-param using getAttribute method
DEBUG   (2003-02-19) 11:22.42:559   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.id [0] 17
DEBUG   (2003-02-19) 11:22.42:560   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Trying to set
column pcm_contract.contract_name from request-param using getAttribute
method
DEBUG   (2003-02-19) 11:22.42:561   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.contract_name [0] Qwerty 123123
DEBUG   (2003-02-19) 11:22.42:562   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Trying to set
column pcm_contract.contract_type from request-param using getAttribute
method
DEBUG   (2003-02-19) 11:22.42:563   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.contract_type [0] 1
DEBUG   (2003-02-19) 11:22.42:564   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Trying to set
column pcm_contract.contract_code from request-param using getAttribute
method
DEBUG   (2003-02-19) 11:22.42:565   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.contract_code [0] QWERTY 123123
DEBUG   (2003-02-19) 11:22.42:566   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Trying to set
column pcm_contract.job_number from request-param using getAttribute method
DEBUG   (2003-02-19) 11:22.42:566   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.job_number [0] ABC DEF
DEBUG   (2003-02-19) 11:22.42:567   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Trying to set
column pcm_contract.misc_code from request-param using getAttribute method
DEBUG   (2003-02-19) 11:22.42:568   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.misc_code [0] 123123
DEBUG   (2003-02-19) 11:22.42:569   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Trying to set
column pcm_contract.start_date from request-param using getAttribute method
DEBUG   (2003-02-19) 11:22.42:570   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.start_date [0] 02/03/2003
DEBUG   (2003-02-19) 11:22.42:571   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Trying to set
column pcm_contract.end_date from request-param using getAttribute method
DEBUG   (2003-02-19) 11:22.42:572   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.end_date [0] 02/03/2003
DEBUG   (2003-02-19) 11:22.42:573   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Trying to set
column pcm_contract.contract_status from request-param using getAttribute
method
DEBUG   (2003-02-19) 11:22.42:574   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.contract_status [0] 0
DEBUG   (2003-02-19) 11:22.42:575   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: ====> row no. 0
DEBUG   (2003-02-19) 11:22.42:576   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.contract_name[0] to Qwerty 123123
DEBUG   (2003-02-19) 11:22.42:577   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.contract_type[0] to 1
DEBUG   (2003-02-19) 11:22.42:579   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.contract_code[0] to QWERTY 123123
DEBUG   (2003-02-19) 11:22.42:580   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.job_number[0] to ABC DEF
DEBUG   (2003-02-19) 11:22.42:582   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.misc_code[0] to 123123
DEBUG   (2003-02-19) 11:22.42:583   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Setting column
pcm_contract.start_date[0] to 02/03/2003
DEBUG   (2003-02-19) 11:22.42:585   [sitemap.action.DatabaseUpdateAction]
(/pcm/contract_admin.contract.html) Thread-9/DatabaseAction: Rolling back
transaction. Caused by null
DEBUG   (2003-02-19) 11:22.42:599   [sitemap]
(/pcm/contract_admin.contract.html) Thread-9/DefaultComponentFactory:
ComponentFactory decommissioning instance of
org.apache.cocoon.acting.modular.DatabaseUpdateAction.


Thanks for your help!
Andre

> -----Original Message-----
> From: Christian Haul [mailto:haul@informatik.tu-darmstadt.de]
> Sent: Tuesday, February 18, 2003 9:46 AM
> To: cocoon-users@xml.apache.org
> Subject: Re: MySQL date conversion with modular database action
>
>
> Andre Taube wrote:
>
> <snip/>
>
>  > Trying to set column pcm_contract.start_date from request-param using
> getAttribute method
>  > Setting column pcm_contract.start_date [0] 2/9/2003
>
> This shows cleanly that you haven't requested the "attribute" mode here.
> Please check your table set!
>
> 	Chris.
>
> --
> C h r i s t i a n       H a u l
> haul@informatik.tu-darmstadt.de
>      fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9 6856 335A 9E08
>
>
> ---------------------------------------------------------------------
> 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>
>
>



---------------------------------------------------------------------
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