本机查询未获取任何结果

发布于 2025-01-17 23:14:28 字数 512 浏览 0 评论 0原文

下面的 JPA Native 查询始终返回“0”（无结果），但是我们在数据库中有此条件的记录。

有人可以告诉我们我们在这里做错了什么吗？

List<Integer> intArrayList = new ArrayList<>();
intArrayList.add(10);
intArrayList.add(20);

String col3Vals = "'test1','test2'";

Query qry = entityMgr.createNativeQuery("select count(*) from mytable where col1 = ?1 and col2 in ?2 and col3 in (?3)")
.setParameter(1, "testVal")
.setParameter(2, intArrayList);
.setParameter(3, col3Vals);
List<?> res = qry.getResultList();

提前致谢！

原文

The below JPA Native query always returns '0' (no results), however we have records for this condition in the DB.

Can someone please advise what we are doing wrong here?

List<Integer> intArrayList = new ArrayList<>();
intArrayList.add(10);
intArrayList.add(20);

String col3Vals = "'test1','test2'";

Query qry = entityMgr.createNativeQuery("select count(*) from mytable where col1 = ?1 and col2 in ?2 and col3 in (?3)")
.setParameter(1, "testVal")
.setParameter(2, intArrayList);
.setParameter(3, col3Vals);
List<?> res = qry.getResultList();

Thanks in Advance!

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

<逆流佳人身旁 2025-01-24 23:14:29

更改如下代码解决了该问题，问题在于我们如何填充“IN”子句之一中的“col3”列的字符串值。

List<Integer> intArrayList = new ArrayList<>();
intArrayList.add(10);
intArrayList.add(20);

List<String> stringVals = new ArrayList<>();
stringVals.add("test1");
stringVals.add("test2");

Query qry = entityMgr.createNativeQuery("select count(*) from mytable where col1 = ?1 and col2 in ?2 and col3 in ?3")
.setParameter(1, "testVal")
.setParameter(2, intArrayList);
.setParameter(3, stringVals);
List<?> res = qry.getResultList();

Changing the code like below resolved the issue, the issue was with the way how we populated the String values for column 'col3' that we had in one of the 'IN' clauses.

List<Integer> intArrayList = new ArrayList<>();
intArrayList.add(10);
intArrayList.add(20);

List<String> stringVals = new ArrayList<>();
stringVals.add("test1");
stringVals.add("test2");

Query qry = entityMgr.createNativeQuery("select count(*) from mytable where col1 = ?1 and col2 in ?2 and col3 in ?3")
.setParameter(1, "testVal")
.setParameter(2, intArrayList);
.setParameter(3, stringVals);
List<?> res = qry.getResultList();

回复收藏 0 原文

~没有更多了~