A problem about oracle9i date

[blizzard.yao]

I try to use octopus 3.6,transform data into oracle9i database.but it doesn't work.I got a error.Caused by: java.sql.SQLException: ORA-01861: literal does not match format string.It seems to be that timestamp format that is causing the problem. Has anyone else run across this issue, and what resolution could there be?
    please help me,thanks.


        Query 'select * from WF_Leave where id=9999 and ispass=1 and istransform=0' will be executed

Import block is started.

Working...  1. block

        Started from the 1. row.

        insertTargetTable method is started.

        insertRow method is started.

        readSubCounterValue method is started

        readSubCounterValue method is finished

Try to parse date with src config: 2007-08-01

Try to parse date with target config: 2007-08-01

call setString on date: 2007-08-01

        Query 'insert into hr_atn_t_interface(hols_corp_id, hols_emp_id, hols_emp_code, hols_reason, hols_type, hols_beg
in_time, hols_end_time, hols_is_testify, biz_type, create_time, id) VALUES (102,195,'2000731','test',8,'2008-01-01','200
8-01-02','0','HOLS','2007-08-01',100)' will be executed

        Error in SQL statement: org.webdocwf.util.loader.LoaderException: SQLException:
        at org.webdocwf.util.loader.Loader.insertRow(Unknown Source)
        at org.webdocwf.util.loader.Loader.insertTargetTable(Unknown Source)
        at org.webdocwf.util.loader.Loader.loadSource(Unknown Source)
        at org.webdocwf.util.loader.Loader.load(Unknown Source)
        at org.webdocwf.util.loader.Loader.main(Unknown Source)
Caused by: java.sql.SQLException: ORA-01861: literal does not match format string

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3368)
        ... 5 more
java.lang.Throwable
        at org.webdocwf.util.loader.LoaderException.printStackTrace(Unknown Source)
        at org.webdocwf.util.loader.LoaderException.getStackTraceAsString(Unknown Source)
        at org.webdocwf.util.loader.Loader.insertRow(Unknown Source)
        at org.webdocwf.util.loader.Loader.insertTargetTable(Unknown Source)
        at org.webdocwf.util.loader.Loader.loadSource(Unknown Source)
        at org.webdocwf.util.loader.Loader.load(Unknown Source)
        at org.webdocwf.util.loader.Loader.main(Unknown Source)


        Because DataCleaning features is turn on, some replacement were made:

         INSERT:FAILS: in table hr_atn_t_interface, in row 1 . ORA-01861: literal does not match format string


         LOGTABLENAME does not exists, or is invalid!

        insertRow method is finished.

        insertTargetTable method is finished.

Imported block is commited.



--
You receive this message as a subscriber of the octopus@... mailing list.
To unsubscribe: mailto:octopus-unsubscribe@...
For general help: mailto:sympa@...?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws