That did it. Thanks so much!!!!
-----Original Message-----
From: Andrus Adamchik [mailto:andru..bjectstyle.org]
Sent: Thursday, March 10, 2005 11:28 AM
To: cayenne-use..bjectstyle.org
Subject: Re: Date being stripped of time on commitChanges()
DbAttributes need to be remapped as TIMESTAMP. No change in Java is
needed. E.g.:
<db-attribute name="NOTE_DT" type="DATE" isMandatory="true" length="7"/>
becomes
<db-attribute name="NOTE_DT" type="TIMESTAMP" isMandatory="true" length="7"/>
Andrus
> I have a object entity (Notes) for which I am trying to insert a new
> Notes object (see code sample below). As you can see, the noteDate
> attribute is being set with a Date object of today's date which includes
> the time (2005-03-10 11:10:36.32). The problem is that when I do the
> commitChanges() the record is inserted into the table, however the time
> is stripped from the Date object (2005-03-10 00:00:00). Do I need to
> specify it a type other than Date in the Modeler? If so, what should
> that type be? If not, any thoughts on what might be happening? I have
> included code sample along with data mappings for the entity. Any help
> would be much appreciated. Thanks.
>
> Code sample:
> Notes newNote = (Notes)
> cayenneContext.createAndRegisterNewObject(Notes.class);
> newNote.setText(noteText);
> newNote.setNoteDate(new Date());
> newNote.setNotesType("FLD");
>
> ctxt.commitChanges();
>
> **********************
>
> DB Entity mapping:
> <db-entity name="NOTES" schema="MEMBERSHIP">
> <db-attribute name="DE_WE_DT" type="DATE" length="7"/>
> <db-attribute name="DT_ACCESSED" type="DATE" length="7"/>
> <db-attribute name="GRP" type="VARCHAR" length="10"/>
> <db-attribute name="LEAD_ID" type="INTEGER" length="9"/>
> <db-attribute name="MEM_ID" type="INTEGER" length="9"/>
> <db-attribute name="NMO_GEN_NBR" type="INTEGER" length="9"/>
> <db-attribute name="NOTES_SEQ_NBR" type="INTEGER" isPrimaryKey="true"
> isMandatory="true" length="9"/> <db-attribute name="NOTES_TYPE"
> type="VARCHAR" length="10"/>
> <db-attribute name="NOTE_DT" type="DATE" isMandatory="true"
> length="7"/> <db-attribute name="PERSON_ID" type="INTEGER"
> length="9"/>
> <db-attribute name="PROSP_ID" type="INTEGER" length="9"/>
> <db-attribute name="RPT_WE_DT" type="DATE" length="7"/>
> <db-attribute name="SALE_SEQ_NBR" type="INTEGER" length="9"/>
> <db-attribute name="TEXT" type="LONGVARCHAR" isMandatory="true"/>
> <db-attribute name="USER_ACCESSED" type="VARCHAR" length="30"/>
> <db-key-generator>
> <db-generator-type>ORACLE</db-generator-type>
> <db-generator-name>NOTES_SEQ_NBR</db-generator-name>
> <db-key-cache-size>20</db-key-cache-size>
> </db-key-generator>
> </db-entity>
>
> **********************
>
> Object Entity Mapping:
> <obj-entity name="Notes" className="org.nfib.core.model.Notes"
> dbEntityName="NOTES">
> <obj-attribute name="dataEntryWeekEndindDate" type="java.util.Date"
> db-attribute-path="DE_WE_DT"/> <obj-attribute name="dateAccessed"
> type="java.util.Date" db-attribute-path="DT_ACCESSED"/> <obj-attribute
> name="group" type="java.lang.String" db-attribute-path="GRP"/>
> <obj-attribute name="leadId" type="java.lang.Integer"
> db-attribute-path="LEAD_ID"/> <obj-attribute name="memberId"
> type="java.lang.Integer" db-attribute-path="MEM_ID"/> <obj-attribute
> name="nonMemberOrganizationNumber" type="java.lang.Integer"
> db-attribute-path="NMO_GEN_NBR"/> <obj-attribute name="noteDate"
> type="java.util.Date" db-attribute-path="NOTE_DT"/> <obj-attribute
> name="notesType" type="java.lang.String"
> db-attribute-path="NOTES_TYPE"/> <obj-attribute name="personId"
> type="java.lang.Integer" db-attribute-path="PERSON_ID"/>
> <obj-attribute name="prospectId" type="java.lang.Integer"
> db-attribute-path="PROSP_ID"/> <obj-attribute
> name="reportWeekEndingDate" type="java.util.Date"
> db-attribute-path="RPT_WE_DT"/> <obj-attribute
> name="saleSequenceNumber" type="java.lang.Integer"
> db-attribute-path="SALE_SEQ_NBR"/> <obj-attribute name="text"
> type="java.lang.String" db-attribute-path="TEXT"/> <obj-attribute
> name="userAccessed" type="java.lang.String"
> db-attribute-path="USER_ACCESSED"/>
> </obj-entity>
This archive was generated by hypermail 2.0.0 : Thu Mar 10 2005 - 12:32:32 EST