<dependency>
<groupId>hsqldb</groupId>
<artifactId>hsqldb</artifactId>
<version>1.7.3.3</version>
</dependency>
Use jdbc driver: org.hsqldb.jdbcDriver
Connection url: jdbc:hsqldb:target/testdbs/testdb
This creates in inmemory db in target/testdbs/testdb.
It works quite nicely because it leaves a sql file behind that shows everything
done during test. Handy for debugging. Note, that there is a version 1.8 out,
but the docs where not up to date and I had other issues with that version.
-----Original Message-----
From: Raphaël Piéroni [mailto:[EMAIL PROTECTED]
Sent: Monday, January 23, 2006 4:43 PM
To: dev@mojo.codehaus.org
Subject: Re: [mojo-dev] sandbox - torque plugin
I now have a starting point using mysql.
Brett, may you send me some code sample to embed hsqldb. Therefore i will
replace mysql by hsqldb.
I have sent an email at the mojo dev list to ask for a maven2 plugin.
But don't know if i succeed as i didn't receive it back.
Ragards,
Raphaël
Brett Porter a écrit :
>use hsqldb (or derby, but its bigger and slower to setup - would only
>be for if hsqldb is not sufficient).
>
>I have no problem with it starting here, but I think its worth getting
>torque folks involved.
>
>- Brett
>
>Raphaël Piéroni wrote:
>
>
>>Brett Porter a écrit :
>>
>>
>>
>>>Wouldn't torque be interested in this contribution?
>>>
>>>
>>>
>>>
>>maybe. But if i remember correctly, putting it to mojo is quickier for
>>the patches to be applied (as on mojo sandbox, i have write access ;)).
>>
>>any idea about embedding a database for the tests of a plugin ?
>>
>>Regards,
>>
>>Raphaël
>>
>>
>>
>>>Brian E. Fox wrote:
>>>
>>>
>>>
>>>
>>>>I've had luck using the hypersonic sql driver as an embedded db.
>>>>It's on ibiblio too.
>>>>
>>>>--------------------------------------------------------------------
>>>>----
>>>>*From:* Piéroni Raphaël [mailto:[EMAIL PROTECTED]
>>>>*Sent:* Monday, January 23, 2006 11:54 AM
>>>>*To:* dev@mojo.codehaus.org
>>>>*Subject:* [mojo-dev] sandbox - torque plugin
>>>>
>>>>hello,
>>>>
>>>>i am currently working on a torque plugin for maven 2 (using torque
>>>>3.1.1)
>>>>may i upload it in the sandbox ? is there such a plugin already wrote ?
>>>>
>>>>for testing the plugin, i will need a mysql database (which may not
>>>>exists in the build environment) do i have to disable those tests or
>>>>should i use an embedded (derby) database during the tests. in such
>>>>a case, do someone know a way to embed derby for testing ? maybe by
>>>>using cargo ?
>>>>
>>>>In advance thank for any comment/answer.
>>>>
>>>>Regards,
>>>>
>>>>Raphaël
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>
>
>
>
