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 ta...@apache.org on 2002/02/27 22:25:34 UTC
cvs commit: jakarta-jetspeed/xdocs psml_db.xml
taylor 02/02/27 13:25:34
Modified: xdocs psml_db.xml
Log:
- fixed some inaccurate documentation
Revision Changes Path
1.3 +22 -5 jakarta-jetspeed/xdocs/psml_db.xml
Index: psml_db.xml
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/xdocs/psml_db.xml,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- psml_db.xml 10 Dec 2001 05:17:06 -0000 1.2
+++ psml_db.xml 27 Feb 2002 21:25:34 -0000 1.3
@@ -98,7 +98,10 @@
database=hypersonic
</source>
<p>
- Save the <b>build.properties</b> file. From the command line in the <b>build/torque</b> directory, run the Torque build script by typing <b>"ant"</b>. Torque will then generate your database-specific SQL commands. The PSML database definitions are stored in a vendor-neutral XML-format in the file
+ Save the <b>build.properties</b> file. From the command line in the <b>build/torque</b> directory, run the Torque build script by typing <b>"ant"</b>.
+ (Ensure that Jakarta Ant version 1.4 or greater is in your system path.)
+ Torque will then generate your database-specific SQL commands. The PSML database definitions are stored in a vendor-neutral XML-format in the file
+
<b>build/torque/schema/dbpsml-schema.xml</b>. Torque takes these definitions, and generates a file containing the vendor-specific SQL commands that
will create the PSML tables in your database.
</p>
@@ -120,8 +123,18 @@
</section>
<section name="Configuring Jetspeed to use a PSML Database">
<p>
+ To use DB-PSML, you will first need to setup your User database and Turbine.
+ (If you are using the default Hypersonic DB, these steps are not necessary since the database is pre-populated).
+ Scripts are provided in the /src/sql/external directory.
+ The User database is based on the Turbine Security model.
+ See <a href="http://jakarta.apache.org/turbine/turbine-2/turbine-schema.html">Turbine Schema</a>
+ You will need to run the "turbine" and "populate" scripts for your database.
+ For example, with Oracle, first run "turbine-oracle.sql" to create the database tables,
+ and then "populate-oracle.sql" to populate the tables.
+ </p>
+ <p>
Jetspeed needs to be configured to access a PSML database. You do this by editing the file <b>webapp/WEB-INF/conf/TurbineResources.properties</b>.
- Edit the "databaseURL", "databaseDriver", "databaseUser", "databasePassword", "databaseHost" and "database.adaptor" settings. The default settings are:
+ The default settings are:
</p>
<source>
database.default.driver=org.hsql.jdbcDriver
@@ -136,15 +149,19 @@
Modify these for your specific database driver. For example, Oracle my look something like this:
</p>
<source>
-databaseDriver = oracle.jdbc.driver.OracleDriver
-databaseUrl = jdbc:oracle:thin@databaseUrl = jdbc:oracle:thin@host:1521:sid
+database.default.driver = oracle.jdbc.driver.OracleDriver
+database.default.url = jdbc:oracle:thin:@host:1521:sid
database.default.username=jetspeed
database.default.password=jetspeed
database.adaptor=DBOracle
database.adaptor.DBOracle = oracle.jdbc.driver.OracleDriver
</source>
- <p>Don't forget to put the JDBC driver's JAR file in your classpath or in the <b>webapp/WEB-INF/lib</b> directory.</p>
+ <p>Don't forget to put the JDBC driver's JAR file in your classpath or in the <b>webapp/WEB-INF/lib</b> directory.
+ With Oracle, the driver may be named something like 'classes12.zip'. This file is really a JAR, and can safely be renamed to classes12.jar.
+ If you are placing the driver in Tomcat's /webapps/jetspeed/WEB-INF/lib directory, then it must be renamed to .JAR or it will not be found.
+ </p>
+
</section>
<section name="Converting from PSML files to a PSML Database">
<p>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>