Hi Michael,
I am sending you this email as you have successfully resolved issue with
Postgresql.
I have downloaded the latest version of jetspeed 1.4 and successfully
installed it on XP Professional. I want to change the database to
Postgresql 7.3.2 for Windows. I have tested the connection to database
with a java test program as well.
I have looked at the resolution you provided on mailing list.
I have tried all the steps but unable to run Jetspeed with Postgresql.
I performed the following steps:
1) Get the latest Jetspeed source from CVS :)
2) Modify jakarta-jetspeed/build/torque/build.properties
You need to tell Torque to generate SQL for Postgresql, so change the
line
that says
torque.database=hypersonic
to
torque.database=postgresql
3) Build Jetspeed
ant war
(or whatever)
4) Create your jetspeed DB
createdb jetspeed
5) Create tables
Instead of using the prepackaged SQL script, you use the
Torque-generated
one. Go to jakarta-jetspeed/src/sql and run:
cat security-schema.sql | psql jetspeed
6) Populate tables
Using the modified populate-postgres.sql I posted yesterday, do:
cat populate-postgres.sql | psql jetspeed
7) Set sequence values beyond existing users
Start "psql jetspeed" and from the psql prompt issue the following
commands:
select setval('turbine_user_seq', 1000);
select setval('turbine_group_seq', 1000);
select setval('turbine_permission_seq', 1000);
select setval('turbine_role_seq', 1000);
8) Deploy the war (ok, I actually ran 'ant hotdeploy')
9) Start tomcat
I get following error:
org.apache.turbine.util.TurbineException: Error rendering Velocity
template: /controls/html/jetspeed.vm: Invocation of method 'getContent'
in class
org.apache.jetspeed.portal.security.portlets.CacheableStatefulPortletWra
pper threw exception class java.lang.Error : Error in
BasePeer.initTableSchema(TURBINE_USER): There was no DataSourceFactory
configured for the connection default
Here are my Torque.properties settings.
torque.database.default.adapter=postgresql
torque.dsfactory.default.connection.driver = org.postgresql.Driver
torque.dsfactory.default.connection.url =
jdbc:postgresql://localhost:5432/jetspeed
torque.dsfactory.default.connection.user = postgres
torque.dsfactory.default.connection.password =
Any help in this regard will be appreciable. I have been trying to make
it work for last 10 days :-(
Thank you,
Surender
