I finally succeed in integrating Jetspeed and db2 by several days' struggle. I share
it with all, If anyone has other simpler solution,please let me know. Because I'm not
from English speaking country, If you can't understand my English, please let me
know.
The steps for integrating Jetspeed and db2 are as following:
1: Create database tables and populate them, because the sql files from jetspeed
source code have bugs,you can get them from the attachment;
2: Replace
TurbineRoleManagement.java、TurbineGroupManagement.java、TurbinePermissionManagement.java
in src\java\org\apache\jetspeed\services\security\turbine directory with those from
the attachment;
3: Edited build/torque/build.properties, build/torque/psml.properties(I'm not sure
whether psml.properties must be modified, but I modified it)
## torque.database=hypersonic
torque.database=db2
4: Edit build\torque\schema\*.xml
replace all the idMethod="native" with idMethod="idbroker"
5: Build jetspeed from the build dir
build war
6:Copy the db2 JDBC driver into WEB-INF\lib directory,rename it from db2java.zip to
db2java.jar. Pay attention to the driver version
7: Edit webapp/WEB-INF/conf/Torque.properties
torque.database.default=default
### torque.database.default.adapter=hypersonic
torque.database.default.adapter=db2app
...
### torque.dsfactory.default.connection.driver = org.hsqldb.jdbcDriver
### torque.dsfactory.default.connection.url =
jdbc:hsqldb:${webappRoot}/WEB-INF/db/jetspeed
### torque.dsfactory.default.connection.user = sa
### torque.dsfactory.default.connection.password =
torque.dsfactory.default.connection.driver = COM.ibm.db2.jdbc.app.DB2Driver
torque.dsfactory.default.connection.url = jdbc:db2:jetspeed
torque.dsfactory.default.connection.user = db2admin
torque.dsfactory.default.connection.password = db2
8:enjoy it :-)
<<jetspeeddb2.zip>>
Thank Stuart Belden [EMAIL PROTECTED] for grat help.
Wang Xusheng
jetspeeddb2.zip
Description: jetspeeddb2.zip
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
