我们正在构建一个应用程序,我们需要在历史表中记录实体更新。我正试图通过hibernate拦截器来实现这一点,我们可以设法获得所有的更改,但在将它们插入审计表时遇到困难。
我的JPA配置
public class JPAConfiguration {
----
@Bean(name = "entityManagerFactory")
public LocalContainerEntityManagerFactoryBean entityManagerFactoryBean() throws SQLException {
LocalContainerEntityManagerFactoryBean factoryBean = new LocalContainerEntityManagerFactoryBean();
factoryBean.setDataSource(dataSource());
factoryBean.setPackagesToScan(new String[] {"com.yyy.persist"});
HibernateJpaVendorAdapter vendorAdapter = new HibernateJpaVendorAdapter();
vendorAdapter.setShowSql(true);
// thsi is required in order to enable Query DSL
vendorAdapter.setDatabasePlatform("org.hibernate.dialect.Oracle10gDialect");
factoryBean.setJpaVendorAdapter(vendorAdapter);
// factoryBean.setMappingResources(mappingResources);
// adding hibernate interceptor
Properties jpaProperties = new Properties();
jpaProperties.setProperty("hibernate.ejb.interceptor", "com.yyy.admin.service.AuditInterceptor");
factoryBean.setJpaProperties(jpaProperties);
return factoryBean;
}
我的拦截器
public class AuditInterceptor extends EmptyInterceptor {
public boolean onFlushDirty(Object entity, Serializable id, Object[] currentState, Object[] previousState,
String[] propertyNames, Type[] types) {
if ( entity instanceof Auditable ) {
// updates++;
for (int i = 0; i < propertyNames.length; i++) {
if ((currentState[i] == null && previousState[i] != null)
|| (currentState[i] != null && previousState[i] == null) || (currentState[i] != null
&& previousState[i] != null && !currentState[i].equals(previousState[i]))) {
AuditLog audit = new AuditLog();
audit.setAction("UPDATE");
audit.setFieldChanged(propertyNames[i]);
audit.setOldvalue(previousState[i] != null ? previousState[i].toString() : "");
audit.setNewvalue(currentState[i] != null ? currentState[i].toString() : "");
audit.setTimeStamp(new Date());
audit.setUsername(userName);
entities.add(audit);
}
}
// iterate elements on the report build a entity
}
return false;
}
public void afterTransactionCompletion(Transaction tx) {
if (tx.wasCommitted()) {
if (entities != null) {
for (AuditLog e : entities) {
System.out.println(e);
//.save(e);
}
entities = new ArrayList<AuditLog>();
}
}
}
}
方法afterTransactionCompletion我需要将所有审计实体写入DB,自动连接不工作,因为这不是spring管理bean,是否有任何方法可以在此方法中获得DB会话,以便我可以执行插入。
将Spring bean注入非Spring托管类的典型解决方案是通过静态资源占位器。例如,您有一个名为StaticServiceHolder的类,并使用@Component
注释它,然后为您想要通过setter注入的spring bean创建静态字段。如:
@Component
public class StaticServiceHolder
{
public static AuditService auditService;
@Autowired
public void setAuditService(AuditService auditService)
{
StaticServiceHolder.auditService = auditService;
}
}
或者更简单的是,如果你有很多这些东西需要注入,那么你可以自动连接ApplicationContext
。这样你就可以得到任何你需要的豆子。
@Component
public class ApplicationContextHolder implements ApplicationContextAware {
public static ApplicationContext applicationContext;
@Override
public void setApplicationContext(ApplicationContext ctx) {
ApplicationContextHolder.applicationContext = ctx;
}
}
....
//in your hibernate interceptor
YourAuditService auditService = ApplicationContextHolder.applicationContext.getBean(YourAuditService.class);
auditService.saveAuditLog();
无论哪种方式,只要你使用的服务是Transactional
,你应该能够在DB中持久化你的东西。希望这对你有用。
对于事务管理器设置:
@Bean
public PlatformTransactionManager transactionManager(EntityManagerFactory emf)
{
JpaTransactionManager transactionManager = new JpaTransactionManager();
transactionManager.setEntityManagerFactory(emf);
return transactionManager;
}
我知道这有点晚了,但也许对别人有帮助。通过使用spring bean而不是类名作为"hibernate.ejb.interceptor"
的值,hibernate使用spring bean而不是实例化一个新类。
在这里找到更多:自动休眠拦截器