Spring and persistence unit with jboss

[Dilshan De Silva]

My project initially develop using with out persistence unit and project is spring,Struts2 hibernate intergration one. Now I need to use jboss connection pool and persistence unit.I need to handle transaction by conatainer also not like in the code i posted(dao). Please change my code to meet that requirement.
current spring.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:p="http://www.springframework.org/schema/p"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">


<bean
    class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
    <property name="location">
        <value>properties/database.properties</value>
    </property>
</bean>
<bean id="springdatasource"

    class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName" value="${jdbc.driverClassName}" />
    <property name="url" value="${jdbc.url}" />
    <property name="username" value="${jdbc.username}" />
    <property name="password" value="${jdbc.password}" />
</bean>

<bean id="sessionFactory"
    class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">

    <property name="dataSource">
        <ref bean="springdatasource" />
    </property>

    <property name="hibernateProperties">
        <props>
            <prop key="hibernate.dialect">org.hibernate.dialect.OracleDialect</prop>
            <prop key="hibernate.format_sql">true</prop>
            <prop key="hibernate.hbm2ddl.auto">update</prop>
            <prop key="hibernate.show_sql">true</prop>
        </props>
    </property>

    <property name="annotatedClasses">
        <list>

            <value>model.AtOrganisation</value>

            <value>model.AtDivision</value>



        </list>
    </property>

</bean>



<bean id="orgdao" class="dao.OrganisationDaoImp">
    <property name="sessionfactory" ref="sessionFactory" />
</bean>
<bean id="divdao" class="dao.DevisionDaoImpl">
    <property name="sessionfactory" ref="sessionFactory" />
</bean>
<bean id="empAction" class="action.OraganisationAction">
    <property name="orgdao" ref="orgdao" />
</bean>
<bean id="empAction2" class="action.DevisionAction">
    <property name="orgdao" ref="orgdao" />
</bean>
<bean id="divAction" class="action.DevisionAction">
    <property name="divdao" ref="divdao" />
</bean>

sample DAO class

public class DevisionDaoImpl implements DevisionDao {


private SessionFactory sessionfactory;

public void setSessionfactory(SessionFactory sessionfactory) {
    this.sessionfactory = sessionfactory;
}
@Override
public List showDiv() {
    // TODO Auto-generated method stub
    return null;
}

@Override
public void addDiv(AtDivision div) {
    Session session = sessionfactory.openSession();
    Transaction tx = null;
    try {
        tx = session.beginTransaction();
        session.saveOrUpdate(div);
        tx.commit();
        //System.out.println("after save : " + org.getAoId());
    } catch (Exception e) {
        if (tx != null) {
            tx.rollback();
        }
        e.printStackTrace();
    } finally {
        session.close();
    }
}
}

[Jayesh A Lalwani]

You need to look up the data source from JNDI instead of DriverManagedDataSource. Also you should use the JTATransactionManager. JTA transaction Manager will use the transaction manager provided by JBoss

[Dilshan De Silva]

Jayesh A Lalwani wrote:You need to look up the data source from JNDI instead of DriverManagedDataSource. Also you should use the JTATransactionManager. JTA transaction Manager will use the transaction manager provided by JBoss

can you give me sample code or replace my code with changes...
I have tried several and non of them succeed..
thanks.

[Jayesh A Lalwani]

For looking up your data source from JNDI, you have to do

<jee:jndi-lookup id="dataSource" jndi-name="jdbc/MyDataSource"/>

Replace JNDI-name with the name of your JNDI data source.

For using the JBoss transaction manager, do

 <bean id="transactionManager" class="org.springframework.transaction.jta.JtaTransactionManager">

These setting are pretty much what you find all over the net. If you have tried them already, and they are not working, you will have to figure out what the problem is by looking at the error messages.

[Dilshan De Silva]

Jayesh A Lalwani wrote:For looking up your data source from JNDI, you have to do

<jee:jndi-lookup id="dataSource" jndi-name="jdbc/MyDataSource"/>

Replace JNDI-name with the name of your JNDI data source.

For using the JBoss transaction manager, do

 <bean id="transactionManager" class="org.springframework.transaction.jta.JtaTransactionManager">

These setting are pretty much what you find all over the net. If you have tried them already, and they are not working, you will have to figure out what the problem is by looking at the error messages.

how do I change this code.

@Override  
public void addDiv(AtDivision div) {  
    Session session = sessionfactory.openSession();  
    Transaction tx = null;  
    try {  
        tx = session.beginTransaction();  
        session.saveOrUpdate(div);  
        tx.commit();  
        //System.out.println("after save : " + org.getAoId());  
    } catch (Exception e) {  
        if (tx != null) {  
            tx.rollback();  
        }  
        e.printStackTrace();  
    } finally {  
        session.close();  
    }  
}  
}  

[Jayesh A Lalwani]

What's wrong with it?

[Dilshan De Silva]

Jayesh A Lalwani wrote:What's wrong with it?

this is my spring xml after make changes you have mentioned.

<?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:jee="http://www.springframework.org/schema/jee"
	xmlns:tx="http://www.springframework.org/schema/tx"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
	http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-3.0.xsd
	http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
	">


    
    	<jee:jndi-lookup id="depo" jndi-name="java:/depo" />
        	<tx:annotation-driven transaction-manager="transactionManager" />


    <bean id="transactionManager" class="org.springframework.transaction.jta.JtaTransactionManager">  




    <bean id="orgdao" class="dao.OrganisationDaoImp">
       
    </bean>

    <bean id="empAction" class="action.OraganisationAction">
        <property name="orgdao" ref="orgdao" />
    </bean>
   
     
    </bean>
</beans>

There is no session factory bean and I cant set session factory to DAO class as i done earlier.
soo how to change my DAO class and annotate with Transactional.

[Jayesh A Lalwani]

Maybe you should put the session factory back in the spring XML then, eh?