Re: Setup-db and PostgreSQL 8.1 problem

On 8/12/06, Krzysztof Borkowski <[email protected]> wrote:

> I have just started my adveture with OJB. I've read the "Getting
> Started" and FAQ and have tried to launch the ojb_blank. It works great
> with the Hsqldb but don't want to work with PostgreSQL.
>
> The problem is the setup-db target. It seems that the target can't work
> because it tries to remove tables before it try to create them. The
> tables are not present in the database so the whole process is going to
> nowhere. Here is a feedback from ant (the output is a mess so please find the 'add-shutdown-sql-file' target and look at next 5 lines):

<snip>

> Please help with that for I don't have any more ideas what should I do (of course I don't want to create tables by hand if such a great tools like OJB and Torque exist).

You might want to use DdlUtils (http://db.apache.org/ddlutils) instead
of Torque. The schema format is the same, so all you need to do is to
replace the setup-db task in the build file.
Btw, for the 1.0.5 we'll likely replace Torque with DdlUtils in OJB.

Tom