Hi all,
Finally, I was able to deploy and run the latest J2 from CVS head (as of 10-26). Congratulations to you all. So far, it looks very promising. Keep up the good work. There are some issues that I would like to share with you how I was able to get J2 to run under J2SE5 (JDK5.0)+Tomcat 5.5.x+MSSQL 2000 with MS-JDBC driver. 1. The inconsistency of the SECURITY_PRINCIPAL table and populated data. The src/sql/mssql/populated-userinfo-for-default-psml.sql' needs to be update to match the correct number of SECURITY_PRINCIPAL columns. E.g: INSERT INTO SECURITY_PRINCIPAL VALUES(1,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,'/user/a dmin','2004-05-22 16:27:12.442','2004-05-22 16:27:12.442'); 2. JDBC-Datasource setup file. %Tomcat_home%/conf/Catalina/localhost/Jetspeed.xml file must be modified in order for J2 to run on Tomcat 5.5 or else it will yield a blank screen. The <ResourceParams> must be <Resource> inline with <name/> <value/> </Resource>. For more info, please go to http://jakarta.apache.org/tomcat/tomcat-5.5-doc/jndi-datasource-examples-how to.html E.g: <Context path="/jetspeed" docBase="jetspeed" crossContext="true"> <Realm className="org.apache.catalina.realm.JAASRealm" appName="Jetspeed" userClassNames="org.apache.jetspeed.security.impl.UserPrincipalImpl" roleClassNames="org.apache.jetspeed.security.impl.RolePrincipalImpl" useContextClassLoader="false" debug="3"/> <Resource name="jdbc/jetspeed" auth="Container" type="javax.sql.DataSource" factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxActive="100" maxIdle="30" maxWait="10000" username="*****" password="*****" driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver" url="jdbc:microsoft:sqlserver://TEST:1433;DatabaseName=j2prod;SelectMethod=c ursor"/> </Context> 3. There's problem with the latest db-obj-1.0.1.jar and MS SQL JDBC driver. There's a patch available online but for some reason, I couldn't get it to run due to the way J2 coupling the 'RowReaderDefaultImpl'. The patch is available at http://www.mail-archive.com/[EMAIL PROTECTED]/msg11506.html Alternatively, if you replace it with db-obj-1.0.0.jar, everything seems to work OK. That's it for now. Aloundeth, Here's my build.properties: # jetspeed 2 home required for build org.apache.jetspeed.project.home = C:/eclipse/workspace/jakarta-jetspeed-2 # jetspeed required properties org.apache.jetspeed.server.home = C:/Program Files/Apache Software Foundation/Tomcat 5.5 org.apache.jetspeed.catalina.version.major = 5 org.apache.jetspeed.server.shared = ${org.apache.jetspeed.server.home}/shared/lib org.apache.jetspeed.deploy.war.dir = ${org.apache.jetspeed.server.home}/webapps org.apache.jetspeed.services.autodeployment.user = j2deployer org.apache.jetspeed.services.autodeployment.password = j2deployer # jetspeed db build properties example for Hsqldb # Override the database connection and driverproperties in your ${USER_HOME}/build.properties appropriately # See: # http://portals.apache.org/jetspeed-2/database.html org.apache.jetspeed.test.database.url = jdbc:microsoft:sqlserver://TEST:1433;DatabaseName=j2test;SelectMethod=cursor org.apache.jetspeed.test.database.driver = com.microsoft.jdbc.sqlserver.SQLServerDriver org.apache.jetspeed.test.database.user = ***** org.apache.jetspeed.test.database.password = ***** org.apache.jetspeed.test.jdbc.drivers.path=C:/Apps/JavaSoft/mssql2000jdbc/li b/msbase.jar;C:/Apps/JavaSoft/mssql2000jdbc/lib/mssqlserver.jar;C:/Apps/Java Soft/mssql2000jdbc/lib/msutil.jar org.apache.jetspeed.test.database.default.name=mssql #org.apache.jetspeed.test.database.ojb.platform=Hsqldb org.apache.jetspeed.production.database.url = jdbc:microsoft:sqlserver://TEST:1433;DatabaseName=j2prod;SelectMethod=cursor org.apache.jetspeed.production.database.driver = com.microsoft.jdbc.sqlserver.SQLServerDriver org.apache.jetspeed.production.database.user = ***** org.apache.jetspeed.production.database.password = ***** org.apache.jetspeed.production.jdbc.drivers.path=C:/Apps/JavaSoft/mssql2000j dbc/lib/msbase.jar;C:/Apps/JavaSoft/mssql2000jdbc/lib/mssqlserver.jar;C:/App s/JavaSoft/mssql2000jdbc/lib/msutil.jar org.apache.jetspeed.production.database.default.name=mssql #org.apache.jetspeed.production.database.ojb.platform=Hsqldb
