| public <E> List<E> retrieveBySqlQueryWithResultTransformer(String query, Class<?> t) throws DataAccessException { List<E> list = null; try { Session session = getSessionFactory().getCurrentSession(); if (query != null) { list = session.createSQLQuery(query).setResultTransformer(Transformers.aliasToBean(t)).list(); } } catch (HibernateException hibernateException) { throw new DataSourceOperationFailedException( DataAccessUtils.getInstance().getPropertyFileValue("msg.datasource.retrieval.fail"), hibernateException); } catch (Exception exception) { throw new DataSourceOperationFailedException( DataAccessUtils.getInstance().getPropertyFileValue("msg.datasource.retrieval.fail"), exception); } return list; } |