Slow schema update generation for Oracle with update in Hibernate with JBoss EAP 5
Issue
- User is using
AnnotationConfigurationto generate oracle sql schema statement.The reason for the high time (at least 11 minutes on some DB istance) to compute is that oracle execute for each table mapped from hibernate a query. Is there any way to overwrite the query done by hibernate package? - The snippet of code doing it is like the following:
Ejb3Configuration ejb3Configuration = new Ejb3Configuration();
AnnotationConfiguration config = ejb3Configuration.getHibernateConfiguration();
ejb3Configuration.configure(selectedDb.name(), configOverrides);
//Enable envers
AuditConfiguration.getFor(config);
String[] createSQL = config.generateSchemaUpdateScript(dialect, databaseMetadata);
- This issue is occurred with oracle database having many schema
Environment
- Red Hat JBoss Enterprise Application Platform (EAP)
- 5.2.0
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
