Here's my original attachment to the dev list for those interested. It's a walkthrough of what I changed to get DB2 working. It shows how to get it working with Torque and Identity fields in DB2 as well.
Because the list sometimes eats attachments, the same doc is also available here: http://stumod.com/jetspeed/ Thanks to Wang Xusheng for providing a pre-packaged solution! >>> [EMAIL PROTECTED] 07/03/03 11:12PM >>> 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
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
