RE: Jetspeed2 with Oracle Help?

Tue, 08 Mar 2005 07:21:26 -0800 

Hi,

I'm also using Oracle. I changed the parameters in the HSQL entry in the jetspeed.xml file.

Following is my jetspeed file:

============================================================
<!--
Copyright 2004 The Apache Software Foundation

Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at

   http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
-->
<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"/>

        <ResourceParams name="jdbc/jetspeed">
   <parameter>
     <name>factory</name>
     <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
   </parameter>

   <!-- Maximum number of dB connections in pool. Make sure you
        configure your mysqld max_connections large enough to handle
        all of your db connections. Set to 0 for no limit.
        -->
   <parameter>
     <name>maxActive</name>
     <value>100</value>
   </parameter>

   <!-- Maximum number of idle dB connections to retain in pool.
        Set to 0 for no limit.
        -->
   <parameter>
     <name>maxIdle</name>
     <value>30</value>
   </parameter>

   <!-- Maximum time to wait for a dB connection to become available
        in ms, in this example 10 seconds. An Exception is thrown if
        this timeout is exceeded.  Set to -1 to wait indefinitely.
        -->
   <parameter>
     <name>maxWait</name>
     <value>10000</value>
   </parameter>

    <parameter>
    <name>username</name>
    <value>j2p</value>
   </parameter>
   <parameter>
    <name>password</name>
    <value>j2p</value>
   </parameter>

   <!-- Class name for Oracle JDBC driver -->
   <parameter>
      <name>driverClassName</name>
      <value>oracle.jdbc.driver.OracleDriver</value>
   </parameter>

   <!-- The JDBC connection url for connecting to your Oracle dB.  -->
   <parameter>
     <name>url</name>
     <value>jdbc:oracle:thin:@localhost:1521:<your DB name></value>
   </parameter>

 </ResourceParams>

</Context>

============================================================

Hope this was helpful


Regards,

ZB


From: "Peter T" <[EMAIL PROTECTED]>
Reply-To: "Jetspeed Users List" <jetspeed-user@jakarta.apache.org>
To: jetspeed-user@jakarta.apache.org
Subject: Jetspeed2 with Oracle Help?
Date: Mon, 07 Mar 2005 16:22:25 +1100

I followed the instruction on http://apache.xtelli.net/portals/jetspeed-2/JETSPEED-2.0-M1-README.txt
to configure "another database" (in my case, I connect to Oracle).

I can created the tables in my Oracle database, but I failed to start jetspeed2 after changing the $TOMCAT_HOME/conf/Catalina/localhost/jetspeed.xml

Is there any example on jetspeed.xml to configure Oracle please?

Many thanks.

Stan



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


_________________________________________________________________
It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to