DBPrism - Upload Utility ::-

Requeriments to run this utility

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%
set ORACLE_HOME=D:\JDeveloper
set JAVA_HOME=D:\JDeveloper\jdk
set CLASSPATH=%ORACLE_HOME%\jdbc\lib\classes12.jar;%CLASSPATH%
set CLASSPATH=%ORACLE_HOME%\sqlj\lib\runtime.jar;%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 CLASSPATH=..\deploy\CMS-Java.jar;%CLASSPATH%

set PATH=%JAVA_HOME%\bin;%PATH%
set CMS_HOME=file:///p:\cms

call java -cp "%CLASSPATH%" com.prism.cms.client.Upload %CMS_HOME%/dbprism/xdocs/setupcms.xml
set CLASSPATH=%_CP%
set PATH=%_PT%

Check the values of JAVA_HOME, CMS_HOME and ORACLE_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;

As an alternative for uploading CMS documents, look at the JDeveloper 9i Addin.

This work is licensed under a Creative Commons License .