[
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
