Im trying to make webservice based on GenericDao. I have Person Entity and im trying to make dao for that Entity exteded by GenericDao. But im getting this error:
org.hibeate.HibeateException: No Session found for current thread
I cant find where did i miss @Transactional. If i makes simple Dao it works well. I have tried to add @transactional almost everywhere. It feels like the aotations does not inherit from GenericDao..
spring-config.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:p="http://www.springframework.org/schema/p"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.0.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd">
<tx:aotation-driven transaction-manager="transactionManager"/>
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName" value="org.postgresql.Driver" />
<property name="url" value="jdbc:postgresql://127.0.0.1:5432/test" />
<property name="useame" value="postgres" />
<property name="password" value="postgress" />
</bean>
<bean id="sessionFactory" class="org.springframework.orm.hibeate4.LocalSessionFactoryBean">
<property name="dataSource" ref="dataSource"></property>
<property name="aotatedClasses">
<list>
<value>org.entity.nci.person.Person</value>
</list>
</property>
<property name="hibeateProperties">
<props>
<prop
key="hibeate.dialect">org.hibeate.dialect.HSQLDialect</prop>
<prop key="hibeate.show_sql">true</prop>
</props>
</property>
<property name="packagesToScan" value="com.byteslounge.spring.tx.model" />
</bean>
<bean id="transactionManager"
class="org.springframework.orm.hibeate4.HibeateTransactionManager"
p:sessionFactory-ref="sessionFactory">
</bean>
<tx:advice id="transactionAdvice" transaction-manager="transactionManager">
<tx:attributes>
<tx:method name="*"/>
</tx:attributes>
</tx:advice>
</beans>
GenericDao.java
<pre><code>
package org.dao.nci.person;
import java.io.Serializable;
import java.util.List;
import javax.jws.WebMethod;
import javax.jws.WebService;
import org.springframework.transaction.aotation.Transactional;
public interface GenericDao<E,K> {
@WebMethod(exclude = true)
public String add(List<E> entities) ;
@WebMethod(exclude = true)
public String saveOrUpdate(E entity) ;
@WebMethod(exclude = true)
public String update(E entity, String whereClause) ;
@WebMethod(exclude = true)
public String remove(E entity);
@WebMethod(exclude = true)
public E find(K key);
@WebMethod(exclude = true)
public List<E> get(String whereClause) ;
}
</code></pre>
GenericDaoImpl.java
<pre><code>package org.dao.nci.person;
import java.io.Serializable;
import java.lang.reflect.ParameterizedType;
import java.lang.reflect.Type;
import java.util.List;
import javax.jws.WebService;
import org.hibeate.Session;
import org.hibeate.SessionFactory;
import org.hibeate.Transaction;
import org.springframework.beans.factory.aotation.Autowired;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.aotation.Transactional;
@SuppressWaings("unchecked")
@Repository
public abstract class GenericDaoImpl<E, K extends Serializable>
implements GenericDao<E, K> {
@Autowired
private SessionFactory sessionFactory;
protected Class<? extends E> daoType;
public GenericDaoImpl() {
Type t = getClass().getGenericSuperclass();
ParameterizedType pt = (ParameterizedType) t;
daoType = (Class) pt.getActualTypeArguments()[0];
}
protected Session currentSession() {
retu sessionFactory.getCurrentSession();
}
@Override
@Transactional
public String add(List<E> entities) {
for(Object entity : entities){
currentSession().save(entity);
}
retu "test";
}
@Override
@Transactional
public String saveOrUpdate(E entity) {
currentSession().saveOrUpdate(entity);
retu "test";
}
@Override
@Transactional
public String update(E entity, String whereClause) {
currentSession().saveOrUpdate(entity);
retu "test";
}
@Override
@Transactional
public String remove(E entity) {
currentSession().delete(entity);
retu "test";
}
@Override
@Transactional
public E find(K key) {
Session session = currentSession();
Transaction transaction = session.beginTransaction();
transaction.commit();
//session.close();
retu (E) session.get(daoType, key);
}
@Override
@Transactional
public List<E> get(String filter) {
List<E> records = currentSession().createCriteria(daoType).list();
retu records;
}
}
</code></pre>
PersonDao.java
<pre><code>package org.dao.nci.person;
import java.util.List;
import javax.jws.WebMethod;
import javax.jws.WebParam;
import javax.jws.WebResult;
import javax.jws.WebService;
import javax.xml.bind.aotation.XmlRootElement;
import org.entity.nci.person.Person;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.aotation.Transactional;
@WebService
@XmlRootElement(name = "ComplexService")
@Transactional
public interface PersonDao extends GenericDao<Person, String>{
@WebMethod(operationName = "selectPerson")
@WebResult(name="row")
@Override
@Transactional
public List<Person> get(@WebParam(name="filter") String whereClause);
@WebMethod(operationName = "insertPerson")
@Override
@Transactional
public String add(@WebParam(name="row") List<Person> persons);
}
</code></pre>
PersonDaoImpl.java
<pre><code>package org.dao.nci.person;
import java.util.List;
import javax.jws.WebParam;
import javax.jws.WebService;
import org.entity.nci.person.Person;
import org.springframework.beans.factory.aotation.Autowired;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.aotation.Transactional;
@WebService(endpointInterface = "example.catalog.ProductCatalogService",
serviceName = "ProductCatalogService")
@Repository
@Transactional
public class PersonDaoImpl extends GenericDaoImpl<Person, String>
implements PersonDao {
}
</code></pre>
