休眠-使用sqlQuery时，出现“数据异常:无效的日期时间格式"；问题 [英] Hibernate - When use sqlQuery, face "data exception: invalid datetime format" issue

问题描述

我的代码如下:

Session session = sessionFactory.getCurrentSession();
        Query countQuery = session.
                createSQLQuery(queryString);
        Long totalFilteredRecords = ((Number)countQuery.uniqueResult())
                .longValue();

queryString是:

SELECT COUNT(id)
FROM SOME_TABLE
WHERE
  to_char(LAST_UPDATED_DATE, 'yyyy-mm-dd hh:mi:ss')
BETWEEN
  '2015-11-13 11:40:03'
AND
  '2015-11-13 11:34:03'

LAST_UPDATED_DATE是Date类型.

我在SQLDeveloper上运行了此SQL，它运行良好，但通过Hibernate运行时失败了:

I run this SQL on SQLDeveloper and it works well, but failed when run via Hibernate:

org.hibernate.util.JDBCExceptionReporter: SQL Error: -3407, SQLState: 22007
org.hibernate.util.JDBCExceptionReporter: data exception: invalid datetime format: yyyy-mm-dd hh:mi:ss

我的数据库是Oracle.

My database is Oracle.

任何人都可以帮忙弄清楚有什么问题吗?

Could anybody help clarify is there anything wrong?

推荐答案

找到了答案，这有点出乎意料的简单...将小写日期格式的字符串替换为大写.

Found the answer, it is a little unexpected simple... Replace lower case date format string to upper case.

将queryString更改为:

SELECT COUNT(id)
FROM SOME_TABLE
WHERE
  to_char(LAST_UPDATED_DATE, 'YYYY-MM-DD HH24:MI:SS')
BETWEEN
  '2015-11-13 11:40:03'
AND
  '2015-11-13 11:34:03'

它有效.

这篇关于休眠-使用sqlQuery时，出现“数据异常:无效的日期时间格式"；问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！