This batch utility requires these libraries:
- Oracle JDBC 2.0 driver (classes111.zip or classes12.zip)
- Oracle SQLJ runtime (runtime.zip)
- Andy Quick's Java port of Dave's Tidy utility (Tidy.jar)
- Oracle XDK 9.0.2+ (xmlparserv2.jar/xsu12.jar/classgen.jar/xschema.jar)
Here an example of this setting on Unix enviroment (CMS_HOME/scritps/upload-demo-site.sh):
 |  |  |
 |
#!/bin/sh
# VERY IMPORTANT NOTE:
# edit username, password and connect string on setupcms.xml document according to your installation
#
JAVA_HOME=/usr/local/jdk1.3;export JAVA_HOME
PATH=$JAVA_HOME/bin:$PATH;export PATH
CMS_HOME=$HOME/cms;export CMS_HOME
CLASSPATH=$JAVA_HOME/lib/dt.jar
CLASSPATH=$ORACLE_HOME/jdbc/lib/classes12.zip:$CLASSPATH
CLASSPATH=$ORACLE_HOME/sqlj/lib/runtime.zip:$CLASSPATH
CLASSPATH=$ORACLE_HOME/lib/xmlparserv2.jar:$CLASSPATH
CLASSPATH=$ORACLE_HOME/lib/xsu12.jar:$CLASSPATH
CLASSPATH=$ORACLE_HOME/lib/classgen.jar:$CLASSPATH
CLASSPATH=$ORACLE_HOME/lib/xschema.jar:$CLASSPATH
echo Using classpath to $CLASSPATH
echo Installing DBPrism CMS Demo Web Site Documents...
java -Xbootclasspath/a:$CLASSPATH -jar $CMS_HOME/deploy/CMS-Java.jar file://$CMS_HOME/demo/xdocs/setupcms.xml
|  |
 |  |  |
Here an example of this setting on Win32 enviroment (CMS_HOME/scripts/upload-demo-site.bat):
 |  |  |
 |
@echo off
rem VERY IMPORTANT NOTE:
rem Requires ORACLE_HOME and JAVA_HOME properly configured.
rem edit username, password and connect string on setupcms.xml document according to your installation
set _CP=%CLASSPATH%
set _PT=%PATH%
rem set ORACLE_HOME=D:\oracle\orabase
rem set JAVA_HOME=%ORACLE_HOME%\jdk
set CLASSPATH=%ORACLE_HOME%\jdbc\lib\classes12.zip;%CLASSPATH%
set CLASSPATH=%ORACLE_HOME%\sqlj\lib\runtime.zip;%CLASSPATH%
set CLASSPATH=%ORACLE_HOME%\lib\xmlparserv2.jar;%CLASSPATH%
set CLASSPATH=%ORACLE_HOME%\lib\xsu12.jar;%CLASSPATH%
set CLASSPATH=%ORACLE_HOME%\lib\classgen.jar;%CLASSPATH%
set CLASSPATH=%ORACLE_HOME%\lib\xschema.jar;%CLASSPATH%
set PATH=%JAVA_HOME%\bin;%PATH%
set CMS_HOME=file:///P:
call java -Xbootclasspath/a:%CLASSPATH% -jar ..\deploy\CMS-Java.jar %CMS_HOME%/demo/xdocs/setupcms.xml
set CLASSPATH=%_CP%
set PATH=%_PT%
|  |
 |  |  |
 |
Check the values of JAVA_HOME, CMS_HOME, ORACLE_HOME and HOME variables.
|
 |
After running the CMS Upload this utility rebuild the Oracle Text index. If it
wasn't installed with the install.sql script, produce an error message.
To avoid this step set the parameter SyncIndex to
false at the top of your upload config file.
To manually rebuild the Oracle Text index run with your SQLPlus logged as cms_owner:
|
 |  |  |
 |
begin
ctx_ddl.sync_index('cms_xml_idx');
end;
|  |
 |  |  |
|