- html - 出于某种原因,IE8 对我的 Sass 文件中继承的 html5 CSS 不友好?
- JMeter 在响应断言中使用 span 标签的问题
- html - 在 :hover and :active? 上具有不同效果的 CSS 动画
- html - 相对于居中的 html 内容固定的 CSS 重复背景?
我使用 Spring MVC 和 Spring JPA 开发了我的第一个应用程序。使用 @Transactional 注释时出现问题。我用 @Transactional 注释我的一个服务方法,并在该方法中抛出异常,因为我希望它被回滚,但它没有。
这是我的配置文件和我的类文件内容:
应用上下文.xml
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:jdbc="http://www.springframework.org/schema/jdbc"
xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:jpa="http://www.springframework.org/schema/data/jpa"
xsi:schemaLocation="http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-3.0.xsd http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-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/data/jpa http://www.springframework.org/schema/data/jpa/spring-jpa.xsd">
<tx:annotation-driven transaction-manager="transactionManager"/>
<context:component-scan base-package="id.co.cslgroup"/>
<jpa:repositories base-package="id.co.cslgroup"/>
<bean class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close" id="dataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver"/>
<property name="url" value="${database.url}"/>
<property name="username" value="${database.username}"/>
<property name="password" value="${database.password}"/>
<property name="testOnBorrow" value="true"/>
<property name="testOnReturn" value="true"/>
<property name="testWhileIdle" value="true"/>
<property name="timeBetweenEvictionRunsMillis" value="1800000"/>
<property name="numTestsPerEvictionRun" value="3"/>
<property name="minEvictableIdleTimeMillis" value="1800000"/>
<property name="validationQuery" value="SELECT 1"/>
<property name="defaultAutoCommit" value="false"/>
</bean>
<bean class="org.springframework.orm.jpa.JpaTransactionManager" id="transactionManager">
<property name="entityManagerFactory" ref="entityManagerFactory"/>
</bean>
<bean class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean" id="entityManagerFactory">
<property name="persistenceUnitName" value="kms-pu"/>
<property name="dataSource" ref="dataSource"/>
<property name="jpaVendorAdapter" ref="hibernateJpaAdapter"/>
</bean>
<bean id="customUserDetailsService" class="id.co.cslgroup.kms.svc.CustomUserDetailsService" />
<bean id="hibernateJpaAdapter" class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter"/>
<context:property-placeholder location="classpath:/META-INF/database.properties"/>
</beans>
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
<!-- The definition of the Root Spring Container shared by all Servlets and Filters -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>
classpath:/META-INF/spring/app-context.xml
/WEB-INF/spring/security-app-context.xml
/WEB-INF/spring/collection-context.xml
</param-value>
</context-param>
<filter>
<filter-name>springSecurityFilterChain</filter-name>
<filter-class>org.springframework.web.filter.DelegatingFilterProxy</filter-class>
</filter>
<filter-mapping>
<filter-name>springSecurityFilterChain</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!-- Creates the Spring Container shared by all Servlets and Filters -->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!-- place constraints on a single user's ability to log in to your application -->
<listener>
<listener-class>
org.springframework.security.web.session.HttpSessionEventPublisher
</listener-class>
</listener>
<!-- Processes application requests -->
<servlet>
<servlet-name>kmsServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>/WEB-INF/spring/servlet-context.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>kmsServlet</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
</web-app>
<?xml version="1.0" encoding="UTF-8"?>
<beans:beans xmlns="http://www.springframework.org/schema/mvc"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:beans="http://www.springframework.org/schema/beans"
xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd
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">
<!-- DispatcherServlet Context: defines this servlet's request-processing infrastructure -->
<!-- Enables the Spring MVC @Controller programming model -->
<annotation-driven conversion-service="conversionService"/>
<!-- Handles HTTP GET requests for /resources/** by efficiently serving up static resources in the ${webappRoot}/resources directory -->
<resources mapping="/resources/**" location="/resources/" />
<!-- Resolves views selected for rendering by @Controllers to .jsp resources in the /WEB-INF/views directory -->
<beans:bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<beans:property name ="prefix" value="/WEB-INF/views/" />
<beans:property name="suffix" value=".jsp" />
</beans:bean>
<beans:bean id="conversionService"
class="org.springframework.context.support.ConversionServiceFactoryBean">
<beans:property name="converters">
<beans:list>
<beans:bean class="id.co.cslgroup.kms.svc.AttributeConverter"/>
<beans:bean class="id.co.cslgroup.kms.svc.KeyClassConverter"/>
<beans:bean class="id.co.cslgroup.kms.svc.KeyTypeConverter"/>
<beans:bean class="id.co.cslgroup.kms.svc.KeyProfileConverter"/>
<beans:bean class="id.co.cslgroup.kms.svc.StringToDateConverter"/>
<beans:bean class="id.co.cslgroup.kms.svc.StringToIntegerConverter"/>
</beans:list>
</beans:property>
</beans:bean>
<context:component-scan base-package="id.co.cslgroup" />
</beans:beans
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<persistence xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="2.0" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd">
<persistence-unit name="kms-pu" transaction-type="RESOURCE_LOCAL">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<properties>
<property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5InnoDBDialect"/>
<!-- value="create" to build a new database on each run; value="update" to modify an existing database; value="create-drop" means the same as "create" but also drops tables when Hibernate closes; value="validate" makes no changes to the database -->
<property name="hibernate.hbm2ddl.auto" value="update"/>
<property name="hibernate.ejb.naming_strategy" value="org.hibernate.cfg.ImprovedNamingStrategy"/>
<property name="hibernate.connection.charSet" value="UTF-8"/>
<!-- Uncomment the following two properties for JBoss only -->
<!-- property name="hibernate.validator.apply_to_ddl" value="false" /-->
<!-- property name="hibernate.validator.autoregister_listeners" value="false" /-->
</properties>
</persistence-unit>
</persistence>
@Controller
@RequestMapping(value="/attribute")
public class AttributeController {
@Autowired
private AttributeService attService;
@RequestMapping(value = "/save", method = RequestMethod.POST)
public String save(@ModelAttribute("attribute") @Valid AttributeMasterForm attr,BindingResult result,Model model,@RequestParam("id") Long attID,HttpServletRequest httpRequest)
{
Map paramMap = httpRequest.getParameterMap();
String[] frmTitlePar = (String[]) paramMap.get("formTitle");
if(result.hasErrors()){
model.addAttribute("formTitle",frmTitlePar[0]);
model.addAttribute("id", attID);
return "attribute/add";
}
System.out.println("Status: " + attr.getStatus());
try{
if(attr.getStatus() == null)
attr.setStatus(false);
if(attID != null){
attr = attService.edit(attr,attID);
}
else{
attr = attService.save(attr);
}
}
catch(Exception e){
e.printStackTrace();
model.addAttribute("violateMsg", "Constraint Violation");
model.addAttribute("formTitle",frmTitlePar[0]);
model.addAttribute("id", attr.getId());
return "attribute/add";
}
return "redirect:/attribute/show?id="+attr.getId();
}
}
public interface AttributeRepository extends JpaRepository<Attribute, Long> {
}
@Service
@Transactional
public class AttributeService {
@Autowired
private AttributeRepository attributeRepository;
@Transactional(readOnly=false,propagation= Propagation.REQUIRES_NEW,rollbackFor=Exception.class)
public AttributeMasterForm save(AttributeMasterForm attForm) throws Exception{
Attribute t = new Attribute();
AttributeMasterForm masterForm = new AttributeMasterForm();
//transfer value from master form to entity
t = updateValue(t,attForm);
//persist to database
t = attributeRepository.save(t);
if(t.getId() > 1){
throw new Exception();
}
return this.convertToMasterForm(t);
}
private AttributeMasterForm convertToMasterForm(Attribute attr){
AttributeMasterForm masterForm = new AttributeMasterForm();
masterForm.setId(attr.getId());
masterForm.setCode(attr.getCode());
masterForm.setName(attr.getName());
masterForm.setStatus(attr.getStatus());
return masterForm;
}
private Attribute updateValue(Attribute attr,AttributeMasterForm attForm){
attr.setCode(attForm.getCode());
attr.setName(attForm.getName());
attr.setStatus(attForm.getStatus());
return attr;
}
}
package id.co.cslgroup.kms.entity;
import java.util.Collection;
import java.util.Date;
import java.util.Set;
import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.JoinColumn;
import javax.persistence.JoinTable;
import javax.persistence.ManyToMany;
import javax.persistence.OneToMany;
import javax.persistence.PrePersist;
import javax.persistence.PreUpdate;
import javax.persistence.Temporal;
import javax.persistence.Version;
import javax.validation.constraints.NotNull;
import org.hibernate.validator.constraints.NotEmpty;
import org.springframework.data.jpa.domain.AbstractPersistable;
@Entity
public class Attribute extends AbstractPersistable<Long> {
@Column(nullable = false, unique = true)
@NotEmpty
@NotNull
private String code;
@Column(nullable = false)
@NotEmpty
@NotNull
private String name;
@OneToMany(fetch= FetchType.LAZY, mappedBy = "pk.attribute")
private Collection<ProfileAttribute> profileAttribute;
@Column(nullable = false)
@Temporal(javax.persistence.TemporalType.DATE)
private Date createTime;
@Column(nullable = false)
private String createBy;
@Column(nullable = true)
@Temporal(javax.persistence.TemporalType.DATE)
private Date updateTime;
@Column(nullable = true)
private String updateBy;
@Column(nullable = false)
private Boolean status;
@Version
@Column
private Long version = 0L;
// @ManyToMany(cascade=CascadeType.ALL)
// @JoinTable(name = "key_attributes",
// joinColumns = {@JoinColumn(name="attribute_id")},
// inverseJoinColumns = {@JoinColumn(name="key_table_id")}
// )
// private Set<KeyTable> keytables;
//
// public Set<KeyTable> getKeyTables(){
// return keytables;
// }
//
// public void setKeyTables(Set<KeyTable> kt){
// this.keytables = kt;
// }
// @Transient
// private String[] testArr;
//
// public String[] getTestArr() {
// return testArr;
// }
//
// public void setTestArr(String[] ta) {
// this.testArr = ta;
// }
public String getCode() {
return code;
}
public void setCode(String code) {
this.code = code;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Boolean getStatus() {
return status;
}
public void setStatus(Boolean status) {
this.status = status;
}
public String getCreateBy() {
return createBy;
}
public void setCreateBy(String createBy) {
this.createBy = createBy;
}
public String getUpdateBy() {
return updateBy;
}
public void setUpdateBy(String updateBy) {
this.updateBy = updateBy;
}
public Date getCreateTime() {
return createTime;
}
public Date getUpdateTime() {
return updateTime;
}
public Long getVersion() {
return version;
}
@PrePersist
private void prePersist() {
this.createBy = "Admin";
this.createTime = new Date();
}
@PreUpdate
private void preUpdate() {
this.updateBy = "Admin";
this.updateTime = new Date();
}
/**
* @return the keyProfiles
*/
public Collection<ProfileAttribute> getProfileAttribute() {
return profileAttribute;
}
/**
* @param keyProfiles the keyProfiles to set
*/
public void setProfileAttribute(Collection<ProfileAttribute> profileAttribute) {
this.profileAttribute = profileAttribute;
}
}
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package id.co.cslgroup.kms.model;
import java.util.Date;
import javax.validation.constraints.NotNull;
import org.hibernate.validator.constraints.NotEmpty;
/**
*
* @author supriadi
*/
public class AttributeMasterForm {
private Long id;
@NotEmpty
@NotNull
private String code;
@NotEmpty
@NotNull
private String name;
private Date createTime;
private String createBy;
private Date updateTime;
private String updateBy;
private Boolean status;
/**
* @return the id
*/
public Long getId() {
return id;
}
/**
* @param id the id to set
*/
public void setId(Long id) {
this.id = id;
}
/**
* @return the code
*/
public String getCode() {
return code;
}
/**
* @param code the code to set
*/
public void setCode(String code) {
this.code = code;
}
/**
* @return the name
*/
public String getName() {
return name;
}
/**
* @param name the name to set
*/
public void setName(String name) {
this.name = name;
}
/**
* @return the status
*/
public Boolean getStatus() {
return status;
}
/**
* @param status the status to set
*/
public void setStatus(Boolean status) {
this.status = status;
}
/**
* @return the createTime
*/
public Date getCreateTime() {
return createTime;
}
/**
* @param createTime the createTime to set
*/
public void setCreateTime(Date createTime) {
this.createTime = createTime;
}
/**
* @return the createBy
*/
public String getCreateBy() {
return createBy;
}
/**
* @param createBy the createBy to set
*/
public void setCreateBy(String createBy) {
this.createBy = createBy;
}
/**
* @return the updateTime
*/
public Date getUpdateTime() {
return updateTime;
}
/**
* @param updateTime the updateTime to set
*/
public void setUpdateTime(Date updateTime) {
this.updateTime = updateTime;
}
/**
* @return the updateBy
*/
public String getUpdateBy() {
return updateBy;
}
/**
* @param updateBy the updateBy to set
*/
public void setUpdateBy(String updateBy) {
this.updateBy = updateBy;
}
}
t = attributeRepository.save(t);
if(t.getId() > 1){
throw new Exception();
}
最佳答案
我发现了问题。在 app-context.xml 和 servlet-context.xml 中,都有 <context:component-scan/>
.该标签将导致此链接中解释的问题:
Spring @Transactional annotations ignored .
关于Spring数据@Transactional不回滚,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/16415921/
如果我执行以下操作 session.getTransaction().rollback(); 然后可以/可以在同一个 session 对象上开始调用保存/更新/删除等吗?无法在 Hibernate S
在Sqlite3中,有没有办法在提交事务后回滚到某个点? 如果您想知道如果我不确定我为什么要提交一个语句,原因是我在 C++ 接口(interface)内使用 Sqlite,只有在我提交事务时才会保存
经过一段时间的阅读和测试不同形式的加载EntityManager实例和bean以进行一些嵌套事务,最后我没有找到一种方法,在运行时异常之后,数据进行完全回滚,必须接近阶段到什么我想要的是只有一个实体保
我们有一个应用程序,它读取 JMS 并执行一些数据库事务,所有这些都是 XA 事务的一部分。如果我们发现消息有问题,我们想要回滚数据库,但我们不希望 JMS 回滚让我们再次读取消息(如果先前已启动回滚
我有一个情况,我需要回滚数据库上的更改,而且我想保留插入的日志。 插图: Add processing log Insert some data Insert some data Insert
我定义了这样一个函数- ... DECLARE EXIT HANDLER FOR SQLEXCEPTION ROLLBACK; DECLARE EXIT HANDLER FOR SQLWARNING
我的应用程序中有一个模型和一个类似商店的东西。模型对象使用 promise 等待存储中的数据。 但在某些情况下我需要删除模型,但因为我使用了 promise 我的模型仍处于关闭状态并且 GC 无法清理
我错误地触发了更新查询,并且 dat 字段中表中的所有记录都已更新,并且由于 auto_commit 处于打开状态,因此也无法回滚。 还有其他方法可以检索记录吗? 最佳答案 我不认为一旦提交查询/事务
我了解我可以使用 MySql 的命令 BACKUP 和 RESTORE 来备份数据库并在需要时回滚。 我的问题是,我是否能够以这种方式执行它: sql="BACKUP my_db TO DISK my
如果 MySQL 中仍有未提交/未回滚的事务,如何让我的事务等待? 目前,我在代码端进行事务处理,而不是在数据库存储过程端,如下所示: cmd.Connection.BeginTransaction(
这是以下内容的后续内容: php/mysql transaction not rolling back on failure (Codeigniter framework) 我在上面的链接中实现了建议
我只是构建了一个存储过程来测试 mysql 中的事务。 但不知何故它不起作用。 这是我的代码: USE `test`; DROP procedure IF EXISTS `testTran`; DEL
我有一个 Service Fabric 应用程序。比方说,版本 1.0.0。我将更新部署为版本 2.0.0。一切都很好。 稍后,我想回滚(或根据您的观点升级)到版本 1.0.0。 我想运行一个简单的P
我不知道这是否正确,但由于某种原因,我的存储过程在发生异常后没有回滚。所以即使我遇到异常,我的插入语句也会被提交 我忘记了什么吗? PROCEDURE SP_USUARIO_INSERT
这个问题与我的问题有关:SQL Server and TransactionScope (with MSDTC): Sporadically can't get connection 我正在使用 .n
登录到我正在使用的Oracle数据库的用户没有提交或回滚就注销了,现在我的数据库无法更改,它似乎已被锁定。 我试过了 rollback 但这没用。 有什么想法吗? 谢谢。 最佳答案 不提交或不回滚就
这只是一个 RStudio 界面问题: 当回滚控制台查看我的工作和输出时,我只能回滚到目前为止。有没有办法打开控制台并回滚我所做的一切? 有时我想检查一个很长的列表的结果,或者我忘记在脚本框而不是控制
是否可以在 Heroku 上撤消回滚? 我必须在实时环境中尝试一些东西,进行测试,然后恢复到原始状态(在回滚之前)。 Heroku 是否能够顺利做到这一点,否则会导致问题? 最佳答案 是的,您可以滚动
我想要 仅回滚: 回滚:2015_05_15_195423_alter_table_web_directories 我运行 php artisan migrate:rollback,我的 3 个迁移正
我正在使用 MQQueueSession.rollback() 来回滚工作单元。消息被移至 BACKOUT 队列,这样就可以了。 问题是如何处理回退队列中的这些消息?我读到我可以使用 runmqdlq
我是一名优秀的程序员,十分优秀!