ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thorsten Elfert <thorsten.elf...@db.com>
Subject Re: Oracle date type mapping issue
Date Thu, 08 Nov 2007 14:17:31 GMT
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" <lmeadors@apache.org> 
Sent by: larry.meadors@gmail.com
08.11.2007 13:23
Please respond to
user-java@ibatis.apache.org


To
user-java@ibatis.apache.org
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 <thorsten.elfert@db.com> 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.
Mime
View raw message