Oracle查询Timestamp报错

Oracle查询Timestamp报错

javabean与DB的类型要对应

select * from ( select id,biz_tag,step,description,update_time,version from leaf_alloc ) where rownum <= 10
[ERROR] Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
	at java.sql.Timestamp.valueOf(Timestamp.java:235)
	at oracle.jdbc.driver.CharCommonAccessor.getTimestamp(CharCommonAccessor.java:544)
	at oracle.jdbc.driver.T4CVarcharAccessor.getTimestamp(T4CVarcharAccessor.java:933)
	at oracle.jdbc.driver.OracleResultSetImpl.getTimestamp(OracleResultSetImpl.java:1376)
	at org.teasoft.honey.osql.core.HoneyUtil.getResultObjectByIndex(HoneyUtil.java:1275)
	at org.teasoft.honey.osql.core.SqlLib._getObjectByindex(SqlLib.java:1422)
	at org.teasoft.honey.osql.core.SqlLib.selectSomeField(SqlLib.java:164)
	at org.teasoft.honey.osql.core.SqlLib.select(SqlLib.java:69)
	at org.teasoft.honey.osql.core.ObjSQLRich.select(ObjSQLRich.java:80)
	at org.teasoft.exam.bee.osql.TransactionExam.testRollback(TransactionExam.java:155)
	at org.teasoft.exam.bee.osql.TransactionExam.test(TransactionExam.java:110)
	at org.teasoft.exam.bee.osql.TransactionExam.main(TransactionExam.java:36)
[ERROR]  Transaction rollback !

        java2DbType.put("java.sql.Timestamp", "timestamp"); //V1.11 javabean与DB的要对应
        //javabean是Timestamp,DB是varchar2,只能设置,查询会有问题.
//        java2DbType.put("java.sql.Timestamp", "varchar2(100)");