You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by "Marc Lehmann (JIRA)" <je...@jakarta.apache.org> on 2004/11/26 15:40:23 UTC

[jira] Created: (JS2-167) DataSource problem wiht Tomcat 5.5.x

DataSource problem wiht Tomcat 5.5.x
------------------------------------

         Key: JS2-167
         URL: http://nagoya.apache.org/jira/browse/JS2-167
     Project: Jetspeed 2
        Type: Bug
  Components: Other  
    Versions: 2.0-dev/cvs    
 Environment: TC 5.5.4, JDK 5.0, hsqldb 1.7.1, W2K SP4
    Reporter: Marc Lehmann
    Priority: Minor


DataSource is broken. See also http://www.mail-archive.com/jetspeed-user@jakarta.apache.org/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...

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://nagoya.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org

[jira] Closed: (JS2-167) DataSource problem wiht Tomcat 5.5.x

Posted by "Ate Douma (JIRA)" <je...@jakarta.apache.org>.
     [ http://issues.apache.org/jira/browse/JS2-167?page=history ]
     
Ate Douma closed JS2-167:
-------------------------

     Resolution: Fixed
    Fix Version: 2.0-dev/cvs
                 2.0-M2

 With the resolution of http://issues.apache.org/jira/browse/JS2-210, J2 now runs 100% on Tomcat 5.5, including using hsqldb. 

> DataSource problem wiht Tomcat 5.5.x
> ------------------------------------
>
>          Key: JS2-167
>          URL: http://issues.apache.org/jira/browse/JS2-167
>      Project: Jetspeed 2
>         Type: Bug
>   Components: Other
>     Versions: 2.0-dev/cvs
>  Environment: TC 5.5.4, JDK 5.0, hsqldb 1.7.1, W2K SP4
>     Reporter: Marc Lehmann
>     Priority: Minor
>      Fix For: 2.0-dev/cvs, 2.0-M2

>
> DataSource is broken. See also http://www.mail-archive.com/jetspeed-user@jakarta.apache.org/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...

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org