數(shù)據(jù)庫調(diào)用
String[] params = {"identifier","fileType","topNum"};
Object[] values = {1,1,10};
String selectQuery = FROM File hq WHERE hq.createParty.identifier=:identifier AND fileType = :fileType AND rownum < :topNum ORDER BY hq.createTime DESC;
//this.getFileDao().getObjects 這個(gè)方法就是調(diào)用Hibernate的方法，沒有對參數(shù)進(jìn)行任何的操作
return this.getFileDao().getObjects(selectQuery, params, values);

異常：
2006-11-23 9:15:54 org.hibernate.type.NullableType nullSafeSet
信息: could not bind value '6' to parameter: 3
2006-11-23 9:15:54 org.hibernate.util.JDBCExceptionReporter logExceptions
警告: SQL Error: 17041, SQLState: null
2006-11-23 9:15:54 org.hibernate.util.JDBCExceptionReporter logExceptions
嚴(yán)重: 索引中丟失 IN 或 OUT 參數(shù):: 3


  回復(fù)  更多評論
  

String[] params = {"identifier","fileType","topNum"};
Object[] values = {1,1,6};
String selectQuery = FROM File hq WHERE hq.createParty.identifier=:identifier AND fileType = :fileType AND rownum < :topNum ORDER BY hq.createTime DESC;
//this.getFileDao().getObjects 這個(gè)方法就是調(diào)用Hibernate的方法，沒有對參數(shù)進(jìn)行任何的操作
return this.getFileDao().getObjects(selectQuery, params, values);

異常：
2006-11-23 9:15:54 org.hibernate.type.NullableType nullSafeSet
信息: could not bind value '6' to parameter: 3
2006-11-23 9:15:54 org.hibernate.util.JDBCExceptionReporter logExceptions
警告: SQL Error: 17041, SQLState: null
2006-11-23 9:15:54 org.hibernate.util.JDBCExceptionReporter logExceptions
嚴(yán)重: 索引中丟失 IN 或 OUT 參數(shù):: 3
  回復(fù)  更多評論