ids is String array. getHibernateTemplate().find("select iov fromcom.zenred.ecommerce.model. ItemOptionValue iov where iov.id in (?)", ids); when the ids array' s lengh is larger than 1, the exception will be thrown out. Please help me fix this problem. com.zenred.ecommerce.business.BusinessLayerException: Error finding option values. at com.zenred.ecommerce.business.impl.ItemOptionBOImpl. findItemOptionValueByPrimaryKeys(ItemOptionBOImpl.java:40) at sun.reflect.Nativ