如何在Hibernate中通过注释以编程方式验证数据库模式? [英] How to validate database schema programmatically in hibernate with annotations?
问题描述
但是,此方法需要dialect和databaseMetadata对象。
我使用的是Spring,我可以从Spring上下文获得AnnotationSessionFactoryBean对象。到目前为止,我有以下代码:
AnnotationSessionFactoryBean factory = null;
factory =(AnnotationSessionFactoryBean)context.getBean(AnnotationSessionFactory);
配置配置= factory.getConfiguration();
//以下行不起作用,ConnectionHelper层次结构在包外不可见
ConnectionHelper connectionHelper =
新的ManagedConnectionProviderConnectionHelper(factory.getHibernateProperties());
方言dialect = Dialect.getDialect(factory.getHibernateProperties());
连接连接=空;
DatabaseMetadata databaseMetadata = null;
尝试{
databaseMetadata = new DatabaseMetadata(connection,dialect);
} catch(SQLException e){
// TODO自动生成的catch块
e.printStackTrace();
}
configuration.validateSchema(dialect,databaseMetadata);
我在正确的轨道上吗? ConnectionHelper层次结构在包外不可见,所以我无法以这种方式获取连接对象,以便构建数据库元数据。我怎么能实现这一点?
编辑:
我想我已经取得了一些进展。有一个SchemaValidator类。代码现在看起来像这样:
AnnotationSessionFactoryBean factory = context.getBean(& AnnotationSessionFactory);
配置配置= factory.getConfiguration();
SchemaValidator validator = new SchemaValidator(configuration);
validator.validate();
Howerver,现在我收到以下错误消息:
org.hibernate.HibernateException:找不到配置的本地DataSource - 必须在LocalSessionFactoryBean上设置'dataSource'属性
最后,在使用Spring时,这并不那么简单。我设法扩展AnnotationSessionFactoryBean,如下所示:
$ b $ pre $ public class SchemaValidatingAnnotationSessionFactoryBean extends
AnnotationSessionFactoryBean {
public void validateDatabaseSchema()抛出DataAccessException {
logger.info(为Hibernate SessionFactory验证数据库模式);
HibernateTemplate hibernateTemplate = new HibernateTemplate(
getSessionFactory());
hibernateTemplate.setFlushMode(HibernateTemplate.FLUSH_NEVER);
hibernateTemplate.execute(new HibernateCallback(){
public Object doInHibernate(会话会话)
抛出HibernateException,SQLException {
Connection con = session.connection();
Dialect方言= Dialect.getDialect(getConfiguration()
.getProperties());
DatabaseMetadata元数据= new DatabaseMetadata(con,dialect);
配置配置= getConfiguration();
configuration.validateSchema(dialect,metadata);
return null;
}
});
}
}
It seems that org.hibernate.cfg.Configuration object can be used to perform validation programmatically, by calling the validateSchema method. However, this method needs dialect and databaseMetadata objects. I am using Spring and I can get a hold of AnnotationSessionFactoryBean object from spring context. So far I have the following code:
AnnotationSessionFactoryBean factory = null;
factory = (AnnotationSessionFactoryBean) context.getBean("AnnotationSessionFactory");
Configuration configuration = factory.getConfiguration();
//the following line does not work, ConnectionHelper hierarchy is not visible outside the package
ConnectionHelper connectionHelper =
new ManagedConnectionProviderConnectionHelper(factory.getHibernateProperties());
Dialect dialect = Dialect.getDialect(factory.getHibernateProperties());
Connection connection = null;
DatabaseMetadata databaseMetadata = null;
try {
databaseMetadata = new DatabaseMetadata(connection, dialect);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
configuration.validateSchema(dialect, databaseMetadata);
Am I on the right track? ConnectionHelper hierarchy is not visible out of the package so I can’t obtain the connection object that way, in order to construct databaseMetadata. How can I implement this?
EDIT: I think I have made some progress. There is a SchemaValidator class. The code now looks like this:
AnnotationSessionFactoryBean factory = context.getBean("&AnnotationSessionFactory");
Configuration configuration = factory.getConfiguration();
SchemaValidator validator = new SchemaValidator(configuration);
validator.validate();
Howerver, now I am getting the following error:
org.hibernate.HibernateException: No local DataSource found for configuration - 'dataSource' property must be set on LocalSessionFactoryBean
In the end, when using Spring this is not that simple. I managed to do it extending the AnnotationSessionFactoryBean like this:
public class SchemaValidatingAnnotationSessionFactoryBean extends
AnnotationSessionFactoryBean {
public void validateDatabaseSchema() throws DataAccessException {
logger.info("Validating database schema for Hibernate SessionFactory");
HibernateTemplate hibernateTemplate = new HibernateTemplate(
getSessionFactory());
hibernateTemplate.setFlushMode(HibernateTemplate.FLUSH_NEVER);
hibernateTemplate.execute(new HibernateCallback() {
public Object doInHibernate(Session session)
throws HibernateException, SQLException {
Connection con = session.connection();
Dialect dialect = Dialect.getDialect(getConfiguration()
.getProperties());
DatabaseMetadata metadata = new DatabaseMetadata(con, dialect);
Configuration configuration = getConfiguration();
configuration.validateSchema(dialect, metadata);
return null;
}
});
}
}
这篇关于如何在Hibernate中通过注释以编程方式验证数据库模式?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!