I am not an oracle guy, so maybe i am missing something really
obvious...but why would you do this as a string? It just seems like a
really fragile way to deal with this situation.
Larry
On 7/14/05, Darek Dober <[EMAIL PROTECTED]> wrote:
>
> 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" <[EMAIL PROTECTED]>
> To: <[email protected]>; <[email protected]>;
> <[email protected]>
> 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) <[email protected]> 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: []$$
> > > - @@@@[EMAIL PROTECTED] [EMAIL PROTECTED]
> [EMAIL PROTECTED] 2005.07.14 at
> 16:06:[EMAIL PROTECTED]
> > > --- 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
> > > [EMAIL PROTECTED]
> > > [EMAIL PROTECTED]
> >
> > --
> > 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
> >
> >
>
>
