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: <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: []$$ > > > - @@@@[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 > > > > > >