File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Database initialization and patches

 
Sven Moschel
Greenhorn
Posts: 10
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
We develop a EJB enterprise application and plan to release that application next year. At the moment we debate how to deliver fix application data and how we could handle patches. With fix application data I mean all data that is necessary to work with the application (Access rights, general configuration data, ...).

Some of our developers thinks the best way to deliver such data are native sql scripts. The other part said the easiest way to deliver the data is to create classes that insert the data over some dao functionality.

Because creating indices though JPA is not possible we need sql scripts to insert them. Because of that I tend to provide the data though native sql scripts.

What functionality do you use to provide the data? Is there a "best" way to do this?
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
We use PowerDesigner to generate database specific scripts from a logical model which works quite well, though PowerDesigner is not cheap. But it does mean you can offset some of the work testing scripts on individual platforms.

 
Consider Paul's rocket mass heater.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic