portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tay...@apache.org
Subject cvs commit: jakarta-jetspeed/xdocs psml_db.xml
Date Wed, 27 Feb 2002 21:25:34 GMT
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:   <mailto:jetspeed-dev-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:jetspeed-dev-help@jakarta.apache.org>


Mime
View raw message