It's also worth noting how ORM solutions can affect points (1) & (2). For example, Hibernate normally creates and executes the db script for (1) - this is currently provided by the hibernate2/3 m2 plugin goals.
Regarding (2) with Hibernate, it normally makes sense to load data using the objects themselves, since they are the native database language in ORMs as opposed to SQL. I did look for support for this in DBUnit but couldn't find any. So any generic solution would need to keep these points in mind. I certainly think there's a need for something like this as it would eliminate proprietary db/orm plugins - almost Cargo for db's.. ;) Mark On 24/10/05, Eric Pugh <[EMAIL PROTECTED]> wrote: > While DBUnit IS about testing, I think that maybe the most common use > case for DBUnit isn't about testing datasets, but using it to load > test data up, which revolves around #2 on your list! > > I've thought about pulling out some sort of core part of DBUnit to be > called DBLoader or something.... > > Eric > On Oct 22, 2005, at 1:05 PM, Vincent Massol wrote: > > > > > > > > >> -----Original Message----- > >> From: Vincent Siveton [mailto:[EMAIL PROTECTED] > >> Sent: samedi 22 octobre 2005 17:04 > >> To: 'Maven Developers List' > >> Subject: RE: [M2] Database plugin? > >> > >> Hi Vincent, > >> > >> > >>> I'm looking for a m2 db plugin. Anyone working on one? > >>> > >> > >> Good idea! > >> > >> > >>> I'm currently working with Derby but ideally this plugin should > >>> probably > >>> be > >>> generic (with extensions) and allow to do things like: > >>> > >>> 1- create schema > >>> 2- load data in database > >>> > >> > >> Dbunit (as you know) could do that too. > >> > > > > Yeah... I had briefly thought about it and I had discarded it > > because DBUnit > > is about testing... but why not... > > > > > >>> 3- start/stop database (database dependent) > >>> 4- create db instance (database dependent and not always > >>> scriptable I > >>> guess) > >>> > >> > >> IMHO the 3 and 4 are maybe the more difficult points. > >> > > > > Yep > > > > > >> Maybe, it is possible to create a wrapper, something like Cargo. > >> > > > > Exactly my thought except I don't have the time to work on this as a > > standalone project! So either it exists or we can simply have > > extension > > points in the db plugin to plugin database-specific behaviors. > > > > > >>> Would someone know a Java framework for manipulating databases > >>> and that > >>> could be wrapped in a m2 plugin easily? > >>> > >>> I was thinking about DDLUtils (http://db.apache.org/ddlutils/) but I > >>> > >> have > >> > >>> no > >>> experience with it and I don't know how solid it is. Also it > >>> won't do > >>> points > >>> 3 and 4 above. > >>> > >> > >> Have a look to Ibatis project too. > >> > > > > I thought that IBatis was an O/R mapping framework in the same > > league as > > Hibernate and others... Does it offer features for features 3 and > > 4? I don't > > think so. Do you know what it would offer over DDLUtils for > > features 1 and > > 2? > > > > Thanks > > -Vincent > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
