taylor 2004/05/03 10:31:35
Modified: xdocs faq.xml
xdocs/stylesheets project.xml
Added: xdocs database.xml
Log:
Added section to documentation on Databases
Revision Changes Path
1.21 +4 -14 jakarta-jetspeed/xdocs/faq.xml
Index: faq.xml
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/xdocs/faq.xml,v
retrieving revision 1.20
retrieving revision 1.21
diff -u -r1.20 -r1.21
--- faq.xml 17 Mar 2004 21:27:50 -0000 1.20
+++ faq.xml 3 May 2004 17:31:35 -0000 1.21
@@ -69,20 +69,10 @@
<tr>
<td>What databases does Jetspeed support?</td>
<td>
-Jetspeed should work with any JDBC 2.0 complaint driver. The following databases
have been tested:
-<ul>
- <li>DB2</li>
- <li>Hypersonic SQL</li>
- <li>MySQL</li>
- <li>Oracle</li>
- <li>Postgres</li>
- <li>Sybase</li>
- </ul>
-Scripts for setting up the database are included with the source code distribution,
under the src/sql/external folder.
-To change the database connection, you will also need to update the database
connection settings in Torque.properties. The war file installation automatically
configures Hypersonic SQL as the default database.
-</td>
- </tr>
- </table>
+ See the <a href='database.html'>Database Configuration</a>
documentation.
+ </td>
+ </tr>
+ </table>
</section>
<section name="Firewall Problems">
<table>
1.1 jakarta-jetspeed/xdocs/database.xml
Index: database.xml
===================================================================
<?xml version="1.0"?>
<!--
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.
-->
<document>
<properties>
<title>Database Configuration</title>
<subtitle>Database</subtitle>
<authors>
<person name="David S. Taylor" email="[EMAIL PROTECTED]"/>
</authors>
</properties>
<body>
<section name="Database Configuration">
<p>
Jetspeed should work with any JDBC 2.0 complaint driver. The following databases
have been tested:
</p>
<ul>
<li>DB2</li>
<li>Hypersonic SQL</li>
<li>MySQL</li>
<li>Oracle</li>
<li>Postgres</li>
<li>Sybase</li>
</ul>
<p>
Scripts for setting up the database are included with the source code distribution,
under the src/sql/external folder.
To change the database connection, you will also need to have the source code since
Jetspeed uses Torque.
Torque generates Java bindings specific to the backend database, requiring that the
source be rebuilt.
The war file installation automatically configures Hypersonic SQL as the default
database.
</p>
<p>
Steps to configure Jetspeed with another database:
<ul>
<li>1. Edit project.properties (or your $HOME/build.properties), and set the
'database' property to one
of these values [db2,hypersonic,mysql,oracle,postgresql,mssql,sybase]
</li>
<li>2. Edit webapp/WEB-INF/conf/Torque.properties. Uncomment and change the
following properties for your database:
<source><![CDATA[
### MySQL
### torque.dsfactory.default.connection.driver = org.gjt.mm.mysql.Driver
### torque.dsfactory.default.connection.url = jdbc:mysql://localhost:3306/jetspeed
### torque.dsfactory.default.connection.user = root
### torque.dsfactory.default.connection.password =
### Oracle
### torque.dsfactory.default.connection.driver = oracle.jdbc.driver.OracleDriver
### torque.dsfactory.default.connection.url = jdbc:oracle:thin:@nirvana:1521:bluesun3
### torque.dsfactory.default.connection.user = jetspeed
### torque.dsfactory.default.connection.password = jetspeed
### Microsoft SQL
### torque.dsfactory.default.connection.driver = net.avenir.jdbc3.Driver
### torque.dsfactory.default.connection.url = jdbc:
AvenirDriver://localhost:1433/jetspeed
### torque.dsfactory.default.connection.user = jetspeed
### torque.dsfactory.default.connection.password = jetspeed
]]></source>
</li>
<li>3. Rebuild the source: <b>maven dist</b>
</li>
<li>4. Run the database 2 turbine- and populate- scripts for your particular
database found in src/sql/external
</li>
</ul>
</p>
</section>
</body>
</document>
1.27 +1 -0 jakarta-jetspeed/xdocs/stylesheets/project.xml
Index: project.xml
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/xdocs/stylesheets/project.xml,v
retrieving revision 1.26
retrieving revision 1.27
diff -u -r1.26 -r1.27
--- project.xml 22 Apr 2004 20:21:28 -0000 1.26
+++ project.xml 3 May 2004 17:31:35 -0000 1.27
@@ -52,6 +52,7 @@
<item name="Cache" href="/diskcache.html"/>
<item name="PSML" href="/psml.html"/>
<item name="Forwards" href="/forwards.html"/>
+ <item name="Database" href="/database.html"/>
</menu>
<menu name="Translated">
<item name="Japanese (Web)"
href="http://jakarta.terra-intl.com/jetspeed/"/>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
