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','-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','-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$','-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-10} Connection$$
- @@{pstm-11} PreparedStatement: insert into test (col) values
(to_date('2005-07-14 16:06:48.921','-mm-dd hh:mi:ss')); $$
- @@{pstm-11} Parameters: []$$
- @@{pstm-11} 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','-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
