[JS2-167] DataSource problem wiht Tomcat 5.5.x

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 2.0-dev/cvs
• Fix Version/s: 2.0-dev/cvs, 2.0-M2
• Component/s: Other
• Environment: TC 5.5.4, JDK 5.0, hsqldb 1.7.1, W2K SP4
• Assignee: Unassigned
• Reporter: Marc Lehmann
• Created: 26/Nov/04 14:30
• Updated: 24/Mar/05 09:09
• Resolved: 24/Mar/05 09:09

Description

DataSource is broken. See also http://www.mail-archive.com/[e-mail]/msg14119.html

The following solution seems to work for me:

1) ${TOMCAT_HOME}/conf/Catalina/localhost/jetspeed.xml

Replace <ResourceParams...> ... </ResourceParams> with

<Resource name="jdbc/jetspeed" auth="Container"
factory="org.apache.commons.dbcp.BasicDataSourceFactory"
type="javax.sql.DataSource" username="sa" password=""
driverClassName="org.hsqldb.jdbcDriver" url="jdbc:hsqldb:hsql://127.0.0.1:9001"
maxActive="100" maxIdle="30" maxWait="10000"/>

2) Move hsqldb-1.7.1.jar from ${TOMCAT_HOME}/webapps/jetspeed/WEB-INF/lib to ${TOMCAT_HOME}/shared/lib

However, this may not be correct or there may be side-effects...