I found the issue:
The time gets already truncated during the insert.
After adding the jdbcType as TIMESTAMP in the corresponding insert
statement it worked.
Now, it looks like:
<insert id="insertPrice" parameterClass="com.db.rocs.bo.price.Price" >
<![CDATA[
insert into TEST_TABLE (..., CREATED_AT, ...)
values(..., #createdAt:TIMESTAMP#, ...)
]]>
</insert>
Thanks all for your support!
________________________________________
"Larry Meadors" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08.11.2007 13:23
Please respond to
[email protected]
To
[email protected]
cc
Subject
Re: Oracle date type mapping issue
Was the time truncated on the insert/update?
select to_char(validfrom,'DD/MM/YYYY HH24:MI:SS') from {your table here}
Larry
On Nov 8, 2007 1:04 AM, Thorsten Elfert <[EMAIL PROTECTED]> wrote:
>
> well, this does not work as well. I tried:
>
> <result property="validFrom" column="VALID_FROM" jdbcType="TIMESTAMP"/>
>
> and I tried:
>
> <result property="validFrom" column="VALID_FROM" jdbcType="TIMESTAMP"
> javaType="java.sql.Timestamp"/>
>
> the time gets truncated all the time.
>
--
Informationen (einschließlich Pflichtangaben) zu einzelnen, innerhalb der EU
tätigen Gesellschaften und Zweigniederlassungen des Konzerns Deutsche Bank
finden Sie unter http://www.db.com/de/content/pflichtangaben.htm. Diese E-Mail
enthält vertrauliche und/ oder rechtlich geschützte Informationen. Wenn Sie
nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese E-Mail. Das
unerlaubte Kopieren sowie die unbefugte Weitergabe dieser E-Mail ist nicht
gestattet.
Please refer to http://www.db.com/en/content/eu_disclosures.htm for information
(including mandatory corporate particulars) on selected Deutsche Bank branches
and group companies registered or incorporated in the European Union. This
e-mail may contain confidential and/or privileged information. If you are not
the intended recipient (or have received this e-mail in error) please notify
the sender immediately and delete this e-mail. Any unauthorized copying,
disclosure or distribution of the material in this e-mail is strictly forbidden.
