Problem resolved:
Special Thanks to Robert J. Sanford and Ryan Marsh for their detailed
notes on making OJB and Postgres work. I am running 0.9.7 on W2000 with
Postgres on SunOS..
Version 0.9.7 does repair most of the problems except one. That linefeed
in torque.jar.. As soon as I unzipped the jar, edited the index.vm file
and re-zipped it all up. Everything started to work. So OJB and Postgres
work together as far as I can tell.
Just for completeness I am inclosing the profile file that I am using...
Hopefully this will help someone else out..
Ray lukas
# -------------------------------------------------------------------
# JDBC connection settings. This is used by the JDBCToXML task that
# will create an XML database schema from JDBC metadata. These
# settings are also used by the SQL Ant task to initialize your
# Turbine system with the generated SQL.
# -------------------------------------------------------------------
# from my hibernate example jdbc:postgresql://dargo:5432/test
dbmsName = postgresql
jdbcLevel = 1.0
urlProtocol = jdbc
urlSubprotocol = postgresql
urlDbalias = test
databaseDriver = org.postgresql.Driver
databaseUser = user1
databasePassword = ***** <-- my password is here
databaseHost = dargo:5432 <-- make sure that postgres is configured for
sockets and
specify the socket here, default is 5432
databaseUrl =
${urlProtocol}:${urlSubprotocol}://${databaseHost}/${urlDbalias}
createDatabaseUrl = ${databaseUrl}
buildDatabaseUrl = ${databaseUrl}
# Tells JDBC task that javaName attribute for the tables and columns
# should be made same as SQL name.
sameJavaName=false
