StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POSpring jpa transaction business to Dao
primarykey
Id
7127858
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
18
CommunityOwnedDate
CreationDate
2011-08-19T21:59:31.633
FavoriteCount
0
LastActivityDate
2014-04-28T21:30:00.633
LastEditDate
2014-04-28T21:30:00.633
LastEditorUserId
251173
OwnerUserId
903181
ParentId
0
PostTypeId
1
Score
1
ViewCount
700
LastEditorDisplayName
text
Body
business layer: <pre><code>public class ServiceImpl implements Service{ @Transactional(readOnly = false) public void createOrUpdateAppPing(String s) { servicePingDao.createOrUpdateAppPing(s); } } </code></pre> Dao layer <pre><code>public void createOrUpdateAppPing(String sc) { EntityManager entityManager = entityManagerFactory.createEntityManager(); pingScService(sc,entityManager); if(ifHasPingScConfig(sc,entityManager)) { updateScConfig(sc,entityManager); } else { createScConfig(sc,entityManager); } entityManager.close(); } </code></pre> here : ** pingScService has select query ** updateScConfig - update query ** createScConfig-insert <pre><code> config service-datasorce.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:osgi="http://www.springframework.org/schema/osgi" xmlns:osgix="http://www.springframework.org/schema/osgi-compendium" xmlns:ctx="http://www.springframework.org/schema/context" xsi:schemaLocation=" http://www.springframework.org/schema/osgi http://www.springframework.org/schema/osgi/spring-osgi.xsd http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/osgi-compendium http://www.springframework.org/schema/osgi-compendium/spring-osgi-compendium.xsd "> <bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean"> <property name="persistenceUnitName" value="smx4" /> <property name="jpaVendorAdapter" ref="jpaAdapter" /> <property name="dataSource" ref="dataSource" /> </bean> <bean id="jpaAdapter" class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter"> <property name="databasePlatform" value="com.luthresearch.savvyconnect.model.PostgreSQLDialectUuid" /> <property name="showSql" value="true" /> <property name="generateDdl" value="true" /> </bean> <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName" value="${database.driver.class}" /> <property name="url" value="${database.savvyconnect.url}" /> <property name="username" value="${database.savvyconnect.username}" /> <property name="password" value="${database.savvyconnect.password}" /> </bean> <bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager"> <property name="entityManagerFactory" ref="entityManagerFactory"/> </bean> IN service.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:osgi="http://www.springframework.org/schema/osgi" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/osgi http://www.springframework.org/schema/osgi/spring-osgi.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd"> <bean id="service" class="com.services.impl.SServicempl" autowire="byName"> </bean> <tx:annotation-driven transaction-manager="transactionManager"/> </beans> </code></pre> Now i want to add transaction support at service layer ...How i can do this. I tried adding <code>@Transaction</code> annotation but I am getting <blockquote> javax.persistence.TransactionRequiredException: Executing an update/delete query </blockquote>
Tags
<spring><jpa><transactions>
Title
Spring jpa transaction business to Dao
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USBuhake Sindi
UserOwnerUserId
1. USChandra
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POSpring jpa transaction business to Dao
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTDownMod
2. VO
 singulars
 PostPostId
 POSpring jpa transaction business to Dao
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTModeratorReview
3. VO
 singulars
 PostPostId
 POSpring jpa transaction business to Dao
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTModeratorReview
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.