Hi: To answer my own question. Nobody reply my question. I was researching the Cocoon 2.0.3 source code....
The answer is: THERE IS NO A BOOLEAN DATA TYPE. I must change the DB Schema to rebuild a new database. Valid datatypes are ONLY (see the file "AbtractDatabaseAction.java" inside the cocoon directory: src/java/org/apache/cocoon/acting) Type - Description ascii - ASCII Input Stream, a CLOB input big-decimal - java.math.BigDecimal binary - Binary Input Stream, a BLOB input byte - a Byte string - a String date - a Date double - a Double float - a Float int - an Integer long - a Long short - a Short time - a Time time-stamp - a Timestamp now - a Timestamp with the current day/time -- the form value is ignored image - a binary image file, we cache the attribute information image-width -- The width attribute of the cached file attribute. NOTE: param attribute must equal the param for image with a "-width" suffix. image-height - The height attribute of the cached file attribute. NOTE: param attribute must equal the param for image with a "-height" suffix. image-size - the size attribute of the cached file attribute NOTE: param attribute must equal the param for image with a "-size" suffix. @version CVS $Id: AbstractDatabaseAction.java,v 1.6.2.2 2002/06/11 13:39:23 haul ----------------------------------------------------------------------------------- After that the answer to my question is: use char or another datatype inside your Database schema to emulate the boolean datatype. Thanks for your help, Regards, Antonio Gallardo. El Miércoles, 28 de Agosto de 2002 14:36, Antonio Gallardo Rivera escribió: > I am using cocoon to let the users fill a database. > > I am using Cocoon 2.03, Tomcat 4.1.9 and Java 1.4.1 on Linux. > > I wrote the following descriptor: > > <root> > <parameter name="id" nullable="no" type="long" default="1"/> > <parameter name="nombre" nullable="no" max-len="50" min-len="3" > type="string"/> > <parameter name="habilitado" nullable="no" min="0" max="1" type="long"/> > <constraint-set name="update"> > <validate name="id"/> > <validate name="nombre"/> > <validate name="habilitado"/> > </constraint-set> > <constraint-set name="add"> > <validate name="nombre"/> > <validate name="habilitado" default="1"/> > </constraint-set> > <connection>mp_pool</connection> > <table name="categoria"> > <keys> > <key dbcol="cat_id" mode="manual" param="id" type="int"/> > </keys> > <values> > <value dbcol="cat_nombre" param="nombre" type="string"/> > <value dbcol="cat_habilitado" param="habilitado" type="boolean"/> > </values> > </table> > </root> > > Cocoon give me and error in the line: > > <value dbcol="cat_habilitado" param="habilitado" type="boolean"/> > > Then how I can code a boolean value to store and retrieve it from > ProstgreSQL 7.2.1? > > The error I got is: > > "Can't set column because the type boolean is unrecognized" > > Detail: > > Original exception : java.sql.SQLException: Can't set column because the > type boolean is unrecognized at > org.apache.cocoon.acting.AbstractDatabaseAction.setColumn(AbstractDatabaseA >ction.java:415) at > org.apache.cocoon.acting.AbstractDatabaseAction.setColumn(AbstractDatabaseA >ction.java:393) at > org.apache.cocoon.acting.AbstractDatabaseAction.setColumn(AbstractDatabaseA >ction.java:379) at > org.apache.cocoon.acting.AbstractDatabaseAction.setColumn(AbstractDatabaseA >ction.java:355) at > org.apache.cocoon.acting.DatabaseAddAction.processTable(DatabaseAddAction.j >ava:221) at > org.apache.cocoon.acting.DatabaseAddAction.act(DatabaseAddAction.java:117) > at > .... > > --------------------------------------------------------------------- > 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]> --------------------------------------------------------------------- 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]>
