Continuous integration including DB schema(s)
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   George_McKinney
Posted On:   Wednesday, July 10, 2002 02:02 PM

We tend to develop webapps that work against relational databases (almost always Oracle). We have been using Ant to handle the webapp side of things for some time now. Middle-tier developers run their own instances of the servlet container and appropriately configured build files, but all talk to the same database. Db development has been outside of that process. When db stuff changes, those developers just tell the middletier folks that they need to do something (whatever that might be) I would like: 1. To have completely independent "sandboxes" for each developer - so, for instance, a Java developer can work against a stable db schema and not have tests throwing exceptions because the stored procedures need to be recompiled.    More>>

We tend to develop webapps that work against relational databases (almost always Oracle). We have been using Ant to handle the webapp side of things for some time now. Middle-tier developers run their own instances of the servlet container and appropriately configured build files, but all talk to the same database. Db development has been outside of that process. When db stuff changes, those developers just tell the middletier folks that they need to do something (whatever that might be)



I would like:

1. To have completely independent "sandboxes" for each developer - so, for instance, a Java developer can work against a stable db schema and not have tests throwing exceptions because the stored procedures need to be recompiled.

2. there to be a "single point of build" that could handle changes in table structure, grants, stored procedures, ... as well as the webapp itself, so a developer can get the latest version of EVERYTHING and build it from the ground up if necessary.


Are these wishes reasonable?

Is anyone set up that way?

What does it require from DB developers?

What does it require from midtier developers?

What requirements would these imply for updating a production site?


Thanks,

   <<Less

Re: Continuous integration including DB schema(s)

Posted By:   Erik_Hatcher  
Posted On:   Wednesday, July 10, 2002 05:46 PM

Ant can certainly do most or all of what you desire, but you're going to have to be more specific about what you need. Ant includes a task that can run scripts against a JDBC connection - so that is not a problem.


Having developer-specific settings incorporated into a build process is trivial with Ant by loading a user-defined properties file (see ).

About | Sitemap | Contact