Prerequisites:
Gather the following information:
· SCAN name
· SCAN service name (this is the equivalence of SID on the SCAN server)
· SCAN database name
· SCAN port #
Note: You must be an Administrator to perform this solution.
1. Stop DocuShare.
2. Modify JDBCpropertybean.properties file.
To modify the JDBCPropertybean.properties file:
a. Open a Windows Explorer and browse to the \config directory.
Where is replaced with the installation path for DocuShare. Depending on your installation environment this path may vary. The default installation path is C:\Xerox\Docushare.
b. Make a copy of the jdbcpropertybean.properties file and rename it jdbcpropertybean.properties.orig
c. Open the \config\jdbcpropertybean.properties file in a text editor.
d. Search for the url= setting.
e. Change to the following url=jdbc\:docushare\:oracle\://SCAN_name\: SCAN_port #;ServiceName\=SCAN_service_name
Where SCAN_name is replaced with the your Scan name, SCAN_port is replaced with your scan port number, and SCAN_service_name is replaced with your SCAN service name.
Example:
url=jdbc\:docushare\:oracle\://scanserver.solutions.ca\:1521;ServiceName\=SIS_CRS
f. Search for the database= setting.
g. Change to the SCAN database name.
h. Save the file.
3. Modify the dw.xml file.
To modify the dw.xml file:
a. Open a Windows Explorer and browse to the \drala\dwe\conf directory.
Where is replaced with the installation path for DocuShare. Depending on your installation environment this path may vary. The default installation path is C:\Xerox\Docushare.
b. Make a copy of the dw.xml file and rename it dw.xml.orig
c. Open the dw.xml file in a text editor.
d. Search for the following entry:
oracle.jdbc.driver.OracleDriver
e. Change the section to the following:
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(HOST=SCAN name)(PROTOCOL=tcp)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=SCAN SERVICE NAME)))
Note: The file may read (CONNECT_DATA=(SID=SERVICE_NAME=SCAN SERVICE NAME))) If this is the case please remove SID= from the CONNECT_DATA= section.
f. Save the file.
4. Start DocuShare.
Solution Published: February 4th, 2011