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
