install_postgresql.html

基于mondrian 开源框架进行OLAP多维分析

			above are available on the respective websites from which you will
			download these resources. </p>
<h4>Environment variables</h4>
<p>Once you have installed/ascertained that you have all the above
			components, you must set up some environment variables (these are
			used by the build script):

				</p>

				<UL>
					<LI>ANT_HOME</LI>
					<LI>CATALINA_HOME</LI>
					<LI>JAVA_HOME</LI>
					<LI>JUNIT_HOME</LI>
					<LI>XALAN_HOME</LI>
				</UL>
<p>You may skip this step (setting up environment variables) if you
			wish, but you must then take care of it in the build script. It is
			strongly recommended that you address this at this point by setting
			up environment variables, unless you have a strong reason not to do
			so.</p>

			<h2>4. Load the test database<a name="04-LoadTestDB">&nbsp;</a></h2>

            <p>The Mondrian distribution is accompanied by a test database (the
			classic &quot;Foodmart&quot; database). This database must be loaded for you
			run the examples available with the distribution. You will have to
			make use of the following resources from the distribution to load
			the database.</p>
<UL>
					<LI><span class="code"><STRONG>
					mondrian.test.loader.MondrianFoodMartLoader</STRONG></span>:
					A data loading utility that takes an input JDBC URL or file
					reference (from which the schema and test data are to be
					taken), an output JDBC URL and connection parameters (for
					the target database in which the schema must be created and
					data loaded), and one or more flags to indicate the schema
					objects that must be created (tables, data, etc.). This
					utility is packaged in &quot;<span class="code">%BIN_LOCATION%/lib/mondrian.jar</span>&quot;.</LI>
					<LI><STRONG>%BIN_LOCATION%/demo/access/MondrianFoodmart.mdb</STRONG>:
					MS Access database containing the complete foodmart
					database. This will be accessed through the DSN created by
					you in Sec. 3.</LI>
					<LI><STRONG>%BIN_LOCATION%/demo/access/FoodMartCreateData.sql</STRONG>:
					Text file containing &quot;<span class="code">INSERT INTO</span>&quot;
					SQL statements to load test data.</LI>
				</UL>
<p>Execute the following steps to load the test database:</p>
<OL>
					<LI><STRONG>Create a database and database user:</STRONG>
					Create a database user called &quot;<span class="code">foodmart</span>&quot;
					(password: &quot;<span class="code">foodmart</span>&quot;). Then
					create a database called &quot;<span class="code">foodmartdb</span>&quot;
					owned by the user &quot;<span class="code">foodmart</span>&quot;.<BR>&nbsp;</LI>
					<LI><STRONG>Copy the JDBC driver:</STRONG> Copy the Postgres
					JDBC driver into &quot;<span class="code">%BIN_LOCATION%/lib</span>&quot;.<BR>&nbsp;</LI>
					<LI><STRONG>Load the database</STRONG>: Open a command
					prompt window and change your current directory to &quot;<span class="code">%BIN_LOCATION%</span>&quot;.
					At the command prompt, run the command <BR>
					<span class="code">
					java -cp &quot;<span style="color:red">%BIN_LOCATION%</span>\lib\mondrian.jar;<span style="color:red">%BIN_LOCATION%</span>\lib\log4j-1.2.9.jar;<span style="color:red">%BIN_LOCATION%</span>\lib\eigenbase-xom.jar;<span style="color:red">%BIN_LOCATION%</span>\lib\eigenbase-resgen.jar;<span style="color:red">%BIN_LOCATION%</span>\lib\<span style="color:red">postgresql-8.0-312.jdbc3.jar</span>&quot;
					mondrian.test.loader.MondrianFoodMartLoader -verbose -tables
					-data -indexes
					-jdbcDrivers=&quot;org.postgresql.Driver,sun.jdbc.odbc.JdbcOdbcDriver&quot;
					-inputFile=<span style="color:red">%BIN_LOCATION%</span>\demo\FoodMartCreateData.sql&quot;
					-outputJdbcURL=&quot;jdbc:postgresql://localhost/<span style="color:red">foodmartdb</span>&quot;
					-outputJdbcUser=<span style="color:red">foodmart</span>
					-outputJdbcPassword=<span style="color:red">foodmart</span>
					</span>
					<BR><BR>
					<span class="caution">[!]</span>&nbsp;Please note the following:
					<UL>
						<LI>This command must be executed as a single command.
						When you copy+paste the above command into an editor,
						whitespaces/carriage returns will be introduced that
						will cause syntax errors. Be sure to replace these
						spaces if you copy+paste this command.</LI>
						<LI>All items in the above command marked in <span style="color:red">
						RED</span> will have to be replaced by the actual value
						(path, filename, database name, user name, etc.)
						applicable for your system.</LI>
					</UL>
					</LI>
				</OL>

			<h2>5. Install Mondrian (build the &quot;mondrian.war&quot; file)<a name="05-InstallationNotes">&nbsp;</a></h2>

<p>There are
			three sets of activities in creating the web archive: modifying some
			files, copying some files and running the ant script. Each of these
			is detailed out in this section.</p>
<h4>Modify files</h4>
<p>The source code that we extracted from <strong>
			mondrian-1.1.5-src.zip</strong> contains among others, three files
			that require to be changed before <span class="code">mondrian.war</span>
			can be built. These are &quot;<span class="code">mondrian.properties</span>&quot;,
			&quot;<span class="code">build.bat</span>&quot; and &quot;<span class="code">build.xml</span>&quot;.
			Changes to each of these files is detailed below.
				<BR>

				</p>

				<OL>
					<LI><STRONG>Changes to <span class="code">
					mondrian.properties</span></STRONG>: The changes in this
					file are predominantly changes to connection strings; the
					path to the Tomcat home directory is also to be specified
					here.<BR><BR>
						In particular, the following changes are to be made:<BR>
						<UL>
							<LI>Replace <span class="code" style="color:red">
							Jdbc=jdbc:odbc:MondrianFoodMart;\</span><BR> with
								<span class="code" style="color:blue">Jdbc=jdbc:postgresql://localhost/foodmartdb?user=foodmart&amp;#38;password=foodmart;\</span>
								<BR>
								<span class="caution">[!]</span>&nbsp;Please note the
							use of &quot;&amp;#38;&quot;. It is important NOT to directly use
							an ampersand here.
								<BR>&nbsp;</LI>
							<LI>Replace <span class="code" style="color:red">
							JdbcDrivers=sun.jdbc.odbc.JdbcOdbcDriver;\</span><BR>
							with
								<span class="code" style="color:blue">
							JdbcDrivers=org.postgresql.Driver;\</span>
								<BR>&nbsp;</LI>
							<LI>Replace <span class="code" style="color:red">
							mondrian.foodmart.jdbcURL=jdbc:odbc:MondrianFoodMart</span><BR>
							with
								<span class="code" style="color:blue">
							mondrian.foodmart.jdbcURL=jdbc:postgresql://localhost/foodmartdb?user=foodmart&amp;#38;password=foodmart</span>
								<BR>
								<span class="caution">[!]</span>&nbsp;Please note the
							use of &quot;&amp;#38;&quot;. It is important NOT to directly use
							an ampersand here.
								<BR>&nbsp;</LI>

							<LI>Uncomment the line &quot;<span class="code">tomcat.home</span>&quot;
							and set the correct path.<BR>&nbsp;</LI>
							<LI>Modify the line &quot;<span class="code">@set
							CLASSPATH</span>&quot; - replace all &quot;/&quot; (forward-slash)
							with a &quot;\&quot; (backslash).<BR>&nbsp;</LI>
						</UL>
						</LI>

					<LI><STRONG>Changes to <span class="code">build.bat</span></STRONG>:
					In this file, replace <span class="code" style="color:red">
					%ANT_HOME%\bin\ant %1 %2 %3 %4 %5 %6 %7 %8 %9</span>
						<BR>with <span class="code" style="color:blue">
					&quot;%ANT_HOME%\bin\ant&quot; %1 %2 %3 %4 %5 %6 %7 %8 %9</span> (add
					quotation marks around the path).
						<BR>This is to address problems that can potentially be
					caused by spaces in the names of folders (supported in the
					recent versions of Windows).
						<BR>&nbsp;</LI>

					<LI><STRONG>Changes to <span class="code">build.xml</span></STRONG>:
					In this file, references to the JDBC driver and to the XALAN
					path need to be changed. Specifically, the changes to be
					made are:
						<UL>
							<LI>Replace <span class="code">&lt;property name=&quot;mondrian.jdbcDrivers&quot;
							value=&quot;<span style="color:red">sun.jdbc.odbc.JdbcOdbcDriver</span>&quot;/&gt;</span><BR>
							with
								<span class="code">&lt;property name=&quot;mondrian.jdbcDrivers&quot;
							value=&quot;<span style="color:blue">org.postgresql.Driver</span>&quot;/&gt;</span>
								<BR>&nbsp;</LI>
							<LI>Replace <span class="code">&lt;property name=&quot;mondrian.foodmart.jdbcURL&quot;
							value=&quot;<span style="color:red">${mondrian.foodmart.jdbcURL.access}</span>&quot;/&gt;</span><BR>
							with
								<span class="code">&lt;property name=&quot;mondrian.jdbcDrivers&quot;
							value=&quot;<span style="color:blue">jdbc:postgresql://localhost/foodmartdb?user=foodmart&amp;#38;password=foodmart</span>&quot;/&gt;</span>
								<BR>
								<span class="caution">[!]</span>&nbsp;Please note the
							use of &quot;&amp;#38;&quot;. It is important NOT to directly use
							an ampersand here.
								<BR>&nbsp;</LI>
							<LI>Modify the target &quot;jar&quot;. This task has a
							<span class="code">zipfileset</span> tag defined as follows:<span class="code"><blockquote>
								<div style="border-style: solid; border-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px">
									<code>&lt;zipfileset<BR>&nbsp;&nbsp;&nbsp;dir=&quot;.&quot;<BR>&nbsp;&nbsp;&nbsp;includes=&quot;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;LICENSE.html,<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;README.txt,<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;VERSION.txt&quot;/&gt;</code></div>
							</blockquote></span>This must be modified to include
							<span class="code">mondrian.properties</span> as follows:<span class="code"><blockquote>
								<div style="border-style: solid; border-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px">
									<code>&lt;zipfileset<BR>&nbsp;&nbsp;&nbsp;dir=&quot;.&quot;<BR>&nbsp;&nbsp;&nbsp;includes=&quot;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="color:blue">mondrian.properties</span>,<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;LICENSE.html,<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;README.txt,<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;VERSION.txt&quot;/&gt;</code></div>
							</blockquote>
								</span></LI>
							<LI>Modify the target &quot;copy-jars&quot;. The path to the
							Xalan JAR files (xalan.jar,xml-apis.jar,xercesImpl.jar)
							is specified as &quot;<span class="code">{xalan.home}<span style="color:red">/bin</span></span>&quot;.
							This must be modified to &quot;<span class="code">{xalan.home}</span>&quot;
							(remove the &quot;/bin&quot;).</LI>
						</UL>
						</LI>
				</OL>



				<h4>Copy files</h4>
				<OL>
					<LI>Copy the file <span class="code">%DEV_LOCATION%\mondrian.properties</span>
					to <span class="code">%CATALINA_HOME%\bin</span><BR>&nbsp;</LI>
					<LI>Copy the files &quot;<span class="code">xalan.jar</span>&quot;, &quot;<span class="code">xercesImpl.jar</span>&quot;,
					&quot;<span class="code">xml-apis.jar</span>&quot; and &quot;<span class="code">serializer.jar</span>&quot;
					from &quot;<span class="code">%XALAN_HOME%</span>&quot; to <span class="code">
					%CATALINA_HOME%\common\endorsed</span>.<BR><BR>
						<span class="notice">[#]</span>&nbsp;These files are not
					really required for the build per s