my problems were a bit different, but I think you may try these steps:
- first, Torque generated SQL script for PostgreSQL is wrong; I think it is because of those OID related things mentioned in PostgreSQL howto. Anyway, I solved this issue by using type 'bytea' instead of 'oid' for OBJECTDATA column in tables turbine_user, turbine_role, turbine_group and turbine_permission; this works for my PostgreSQL 7.1.3
- second, I had some problems using Torque pool for coonecting to db, so I prefer using JDBC2 pool (and latest driver with jdbc2 support from jdbc.postgresql.org, which I did NOT patch as in postgreSQL-howto); here is a part of my Torque.properties:
torque.database.jetspeed.adapter=postgresql
torque.dsfactory.jetspeed.connection.driver = org.postgresql.Driver
torque.dsfactory.jetspeed.connection.url = jdbc:postgresql://localhost/ jetspeed
torque.dsfactory.jetspeed.connection.user = user
torque.dsfactory.jetspeed.connection.password = ****
torque.dsfactory.jetspeed.factory=org.apache.torque.dsfactory. Jdbc2PoolDataSourceFactory
torque.dsfactory.jetspeed.pool.defaultMaxActive=10
torque.dsfactory.jetspeed.pool.testOnBorrow=true
torque.dsfactory.jetspeed.pool.validationQuery=SELECT 1
- third, when extending your TurbineUser, you may want to have a look at this howto: http://jakarta.apache.org/turbine/turbine-2.3/howto/extend-user-howto.html
Hope this helps.
Regards, Martin
Dne 14.11.2003 09:51:14 napsal nick the mytilian:
Dear Martin,
As i can see from the jetspeed-user list, you had some problems make jetspeed run with postgres. I have the same problems. Unfortunately, although i sent many emails in the list, nobody answered yet.
Have you solved these problems? I am working with jetspeed from CVS, postgres 7.3.4, java 1.4, redhat 7. The problem is that with postgres as the DBMS of jetpseed, a new user cannot be added.
Did you follow the instructions of this site? (http://db.apache.org/torque/postgres-howto.html)
I really thank you! Nik.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
