Note: This applies to DocuShare 6.5.x only.
Issue
Unable to change some of the database information using the dssetup command.
The only information dssetup command is unable to change in DocuShare 6.5.x is the following:
· host name
· database instance name
· database driver
· database provider
Note: Use the dssetup command to change the database type, database user, database password and database name.
Solution
This issue has been fixed in DocuShare 6.6.x.
Workaround
Note: You must be a Windows Administrator to perform this solution.
Note: Windows 2008 and 2008 R2 may require that you set the User Access Control (UAC) levels accordingly to allow you to edit the files.
Note: The examples in the workaround assume that the new database engine is SQLServer, if it’s a different Database engine such as Oracle or PostgreSQL other parameters such as driver and provider would need to be changed accordingly.
1. Stop DocuShare.
2. Edit the JDBCPropertyBean.properties file.
To change the hostname, database instance name, provider and pool size:
a. Open Windows Explorer and browse to the \config directory.
Where is replaced with the installation directory for DocuShare. The default installation path is C:\Xerox\Docushare. Depending on your installation environment the path may vary.
b. Make a copy of the JDBCPropertyBean.properties and rename the copy JDBCPropertyBean.properties.orig.
c. Open the JDBCPropertyBean.properties file in a text editor such as Notepad.
d. Look for the url= entry.
Example: url=jdbc\:docushare\:sqlserver\://localhost\\docushare\:1433
e. Edit the url= entry accordingly.(if applicable)
f. Look for the driver= entry.
Example: driver=com.xerox.docushare.jdbc.sqlserver.SQLServerDriver
g. Edit the driver= entry accordingly (if applicable).
h. Search for the providerName= entry.
i. Change to SQLServer. (if applicable)
Example: providerName=SQLServer
j. Search for poolSize=
k. Change the value to 35. (if using SQLServer Full version)
Example: PoolSize=35
l. Save the file.
3. Edit the dw.xml file.
a. Browse to the \drala\dwe\conf directory.
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 such as Notepad.
d. Look for the following entry in the file and enter the appropriate database connection information displayed in red text.
5
5
-1
sa
6542304E4F4B444E505241756F7A53784C474E6B
com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc:sqlserver://localhost\docushare;DatabaseName=Docushare;
e. Save the file.