registered a statement as closed which wasn't known to be open. This could happen if you close a statement twice.
解决方案 »
- 求助 生产库中ORA-04025: maximum allowed library object lock allocated for select
- 求,已知一张表,如何查找与它表结构相同的其它表
- select语句如何替换值为0的字段?
- oracle表空间的FSFI值过低
- Oracle初级知识知道的麻烦给说下
- 问一个触发器问题
- oci里面能不能调用pl\sql啊? 能的话 给个例子吧
- 在树形结构中,怎么样用一个SQL语句选出当前项的所有子项???
- 求教!Delphi三层开发中用存储过程用游标返回数据集的问题。
- 请问怎么获得连续次数呢?
- 有关时间处理的问题,急等解答
- ORA-01861: 文字与格式字符串不匹配 谢谢
resultClass="java.lang.Integer" remapResults="true">
<![CDATA[
SELECT count(*)
FROM SUP_TEMP_AUTHORIZATION_TEST
WHERE
BUSINESS_ID = #BUSINESS_ID#
AND USERID = #USERID#
]]>
</select>
throws Exception
{
IPoApplyWs poApplyWs = new IPoApplyWsProxy();
JSONObject inputJson = new JSONObject();
if (!aSwList.isEmpty())
{
inputJson.put("NLS_LANG", aNls);
//传入版本id、文档id
inputJson.put("VERSION_ID", "\'" + aSwList.get(0).getVersion()
+ "\'");
inputJson.put("PRODUCT_ID", "\'" + aSwList.get(0).getPp_product()
+ "\'");
UserInfoBean user = null;
user = getUserInfo(aRequest);
//用户所在的组
String userGroupId[] = user.getGroups();
StringBuilder userGroupIdStr = new StringBuilder();
for (int i = 0; i < userGroupId.length; i++)
{
userGroupIdStr.append(userGroupId[i] + ",");
}
String userGruop = userGroupIdStr.toString();
userGruop = userGruop.substring(0, userGruop.length() - 1);
inputJson.put("USERGROUPIDSTR", userGruop);
//用户
inputJson.put("USEID", user.getUid());
}
String aListVersionDocStr = poApplyWs.
getRelatedVersionDocBySWId(inputJson.toString());
String aListProductManualSoftStr = poApplyWs.
getRelatedProductManualSoftBySWId(inputJson.toString());
List listOne = JsonUtil.jsonArrayToList(new JSONArray(aListVersionDocStr));
List listTwo = JsonUtil.jsonArrayToList(new JSONArray(aListProductManualSoftStr));
for(Object obj : listOne){
listTwo.add(obj);
}
if (null != aListVersionDocStr && !"".equals(aListVersionDocStr))
{
// return JsonUtil.jsonArrayToList(new JSONArray(aListStr));
return listTwo;
}
return new ArrayList<SwInfoFormBean>();
}