英文:
org.hibernate.exception.GenericJDBCException: could not execute query though able to get result from sql
问题
我正在尝试执行一个 Hibernate 查询
final StringBuilder sql = new StringBuilder(50);
sql.append("SELECT DISTINCT SN.GTIN || ',' || SN.BATCH_NBR||','||SN.EXPIRATION_DATE||','||SN.SRL_NBR from C_SRL_NBR SN");
sql.append(" WHERE TC_LPN_ID =:cartonNum");
final String[] nameList = { "cartonNum" };
final Object[] parmList = { cartonNum };
List<String> columnName = new ArrayList<>();
List<Type> columnType = new ArrayList<>();
columnName.add("GTIN");
columnName.add("BATCH_NBR");
columnName.add("EXPIRATION_DATE");
columnName.add("SRL_NBR");
columnType.add(Type.STRING);
columnType.add(Type.STRING);
columnType.add(Type.STRING);
columnType.add(Type.STRING);
try {
@SuppressWarnings("unchecked")
final List<String> list = directSQLQuery(sql.toString(), nameList, parmList, columnName, columnType);
if (list != null && !list.isEmpty()) {
return list;
}
} catch (Exception e)
throw new DataAccessException(e);
}
当我在数据库中运行查询时，可以得到输出，但通过代码运行时会出现异常，请问有谁可以帮忙解决这个问题。
英文:
I am trying to excute a hibernate query
final StringBuilder sql = new StringBuilder(50);
sql.append("SELECT DISTINCT SN.GTIN || ',' || SN.BATCH_NBR||','||SN.EXPIRATION_DATE||','||SN.SRL_NBR from C_SRL_NBR SN");
sql.append(" WHERE TC_LPN_ID =:cartonNum");
final String[] nameList = { "cartonNum" };
final Object[] parmList = { cartonNum };
List<String> columnName = new ArrayList<>();
List<Type> columnType = new ArrayList<>();
columnName.add("GTIN");
columnName.add("BATCH_NBR");
columnName.add("EXPIRATION_DATE");
columnName.add("SRL_NBR");
columnType.add(Type.STRING);
columnType.add(Type.STRING);
columnType.add(Type.STRING);
columnType.add(Type.STRING);
try {
@SuppressWarnings("unchecked")
final List<String> list = directSQLQuery(sql.toString(), nameList, parmList, columnName, columnType);
if (list != null && !list.isEmpty()) {
return list;
}
} catch (Exception e)
throw new DataAccessException(e);
}
when I am running the query in db it is giving me output but through code it is giving exception can any one please help with this
专注分享java语言的经验与见解，让所有开发者获益！
评论