[OJB-developers] help with torque

[Georg S. <ge...@me...>]

Hi,

I am trying to adapt the torque based stuff to work with postgres. Since I
don't have any experience with it, I started out copying the mysql.profile
file to postgres.profile and setting corresponding values to my settings.

When I then do
	./build.sh junit

I get the following error:

      [sql] Executing file:
/people/georg/work/ojb/cvs/ojb-1-0/target/src/sql/create-db.sql
      [sql] Failed to execute: drop database if exists @DATABASE_DEFAULT@
      [sql] java.sql.SQLException: ERROR:  parser: parse error at or near
"exists"

      [sql] Failed to execute: create database @DATABASE_DEFAULT@
      [sql] java.sql.SQLException: ERROR:  parser: parse error at or near
"@"

      [sql] 0 of 2 SQL statements executed successfully


obviously @DATABASE_DEFAULT@ should have been substituted with the name of
the database, but wasn't. What else do I have to change to make it work
for a different database?

Any help is appreciated

Cheers

Georg