Oracle查询Timestamp报错

最新推荐文章于 2022-08-05 17:52:31 发布

原创最新推荐文章于 2022-08-05 17:52:31 发布 · 1.2k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java #数据库 #开发语言

Bee 同时被 2 个专栏收录

314 篇文章

订阅专栏

138 篇文章

订阅专栏

此篇博客讲述了在使用Java通过Oracle查询Timestamp数据时遇到的错误，涉及到类型不匹配问题，以及如何解决javabean与DB中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)");