<!-- begin -->
<bean id="pbtDataSource"
class="org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy">
<constructor-arg ref="pbtDataSourceTarget" />
</bean>
<bean id="pbtDataSourceTarget"
class="org.springframework.jdbc.datasource.DriverManagerDataSource"
p:driverClassName="${jdbc.pbt.driverClassName}"
p:url="${jdbc.pbt.url}">
<property name="connectionProperties">
<ref bean="pbtDataSourceProps" />
</property>
</bean>
<bean id="pbtDataSourceProps" class="java.util.Properties">
<constructor-arg>
<props>
<prop key="user">${jdbc.pbt.username}</prop>
<prop key="password">${jdbc.pbt.password}</prop>
<prop key="DYNAMIC_CLASS">
com.purebros.callcenter.db.DynamicClass
</prop>
</props>
</constructor-arg>
</bean>
<!-- end -->
<!-- Transaction configuration -->
<bean id="jbossTransactionManager"
class="com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionManagerImple" />
<bean id="jbossUserTransaction"
class="com.arjuna.ats.internal.jta.transaction.arjunacore.UserTransactionImple" />
<bean id="transactionManager"
class="org.springframework.transaction.jta.JtaTransactionManager">
<property name="transactionManager">
<ref bean="jbossTransactionManager" />
</property>
<property name="userTransaction">
<ref bean="jbossUserTransaction" />
</property>
</bean>
@Autowired
@Resource(name = "pbtDataSource")
public void setPbtDataSouce(DataSource dataSource) {
this.pbtSimpleJdbcTemplate = new SimpleJdbcTemplate(dataSource);
this.pbtSimpleJdbcInsert = new SimpleJdbcInsert(dataSource);
this.pbtSimpleJdbcCall = new SimpleJdbcCall(dataSource);
}
public class UserActionDAOjdbc extends GenericDAOJdbc...
...
try {
return BigInteger.valueOf(pbtSimpleJdbcInsert.withTableName("tab_user_action").usingGeneratedKeyColumns("id").executeAndReturnKey(parameters).intValue());
}
Estou a mais de um dia apanhando para isto, qualquer ajuda é bem-vinda. :D
Valeu!