• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Database initialization and patches

 
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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?
 
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.

 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic