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 > >