ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Darek Dober" <doover...@op.pl>
Subject Re: [jira] Commented: (IBATIS-170) i am not sure it is a bug!
Date Thu, 14 Jul 2005 12:20:33 GMT

I think, it is not a bug :)

It doesn't work for me.

But this does
insert into testddo (col) values (to_date('2005-07-14 16:06:48','yyyy-mm-dd
hh24:mi:ss'));

hours: 16 should be declared as HH24 not hh

Anyway:)

Darek Dober







----- Original Message ----- 
From: "Larry Meadors" <larry.meadors@gmail.com>
To: <dev@ibatis.apache.org>; <user-java@ibatis.apache.org>;
<user-cs@ibatis.apache.org>
Sent: Thursday, July 14, 2005 1:51 PM
Subject: Re: [jira] Commented: (IBATIS-170) i am not sure it is a bug!


PLEASE! PLEASE! PLEASE!

If you are not 99.999% sure it is a bug, do not put it in JIRA.

Larry

On 7/14/05, leo zhang (JIRA) <ibatis-dev@incubator.apache.org> wrote:
>     [
http://issues.apache.org/jira/browse/IBATIS-170?page=comments#action_12315824 ]
>
> leo zhang commented on IBATIS-170:
> ----------------------------------
>
> sorry, the sql statement is this:
> insert into test (col) values (to_date('2005-07-14 16:06:48','yyyy-mm-dd
hh:mi:ss'));
>
> > i am not sure it is a bug!
> > --------------------------
> >
> >          Key: IBATIS-170
> >          URL: http://issues.apache.org/jira/browse/IBATIS-170
> >      Project: iBatis for Java
> >         Type: Bug
> >   Components: SQL Maps
> >     Versions: 2.1.0
> >  Environment: windows xp, professional oracle9i, eclipse
> >     Reporter: leo zhang
>
> >
> > i use oralce9i database.
> > the table names test;
> > CREATE TABLE TEST
> > (
> >   col  DATE
> > );
> > sqlmap like this
> >   <insert id = "product.testinsert" parameterClass="java.lang.String">
> >     insert into test (col) values (to_date('$timestamp$','yyyy-mm-dd
hh:mi:ss'));
> >   </insert>
> > java code like this:
> > ......
> >      long nCurrentTime = System.currentTimeMillis();
> >       Timestamp ts = new Timestamp(nCurrentTime);
> >         broker.insert("product.testinsert",ts.toLocaleString());
> > ......
> > the ibatis error is :
> > - @@{conn-100000} Connection$$
> > - @@{pstm-100001} PreparedStatement:      insert into test (col) values
(to_date('2005-07-14 16:06:48.921','yyyy-mm-dd hh:mi:ss'));   $$
> > - @@{pstm-100001} Parameters: []$$
> > - @@{pstm-100001} Types: []$$
> > - @@@@[@level INFO][@sender
com.ctbr.das.database.ibatis.DBBrokerIbatisImpl][@timestamp 2005.07.14 at
16:06:50][@Msg][
> > --- The error occurred in com/ctbr/config/ibatis/sqlmap/Product.xml.
> > --- The error occurred while applying a parameter map.
> > --- Check the product.testinsert-InlineParameterMap.
> > --- Check the statement (update failed).
> > --- Cause: java.sql.SQLException: ORA-00911: invalid characters.
> > ]$$$$
> > but  i use toad, the follow statement can execute successful.
> >  insert into test (col) values (to_date('2005-07-14
16:06:48.921','yyyy-mm-dd hh:mi:ss'));
> > i am mad! please help me!
> > leo
> > cszhzleo@msn.com
> > cszhz@126.com
>
> --
> This message is automatically generated by JIRA.
> -
> If you think it was sent incorrectly contact one of the administrators:
>    http://issues.apache.org/jira/secure/Administrators.jspa
> -
> For more information on JIRA, see:
>    http://www.atlassian.com/software/jira
>
>


Mime
View raw message