To move or change the location of the CaseTool address in DigEplan, you will need to change web.xml parameters on each server (View and Conversion) as per this article.
Before you start to edit any settings, please ensure you take a backup copy of the web.xml files.
Information you will need before making any changes
- DMS DB connection string
- DMS DB Connection UserName & Password
Note : Ensure you can connect to the CaseTool DB using the above credentials with a tool like SQLPlus (for Oracle DB) from the DigEplan servers. Ensure the relevant data can be accessed with the connection UserName and Password.
On both DigEplan servers (View and Conversion)
Note : On Test systems all components are normally installed on the same server
Locate the av_con web.xml - eg C:\Oracle\glassfish3\glassfish\domains\AutoVue\applications\av_con\WEB-INF\web.xml
In the file, search for section 'CASETOOL_db_URL' - Update the value shown in red below
<!-- Oracle example : value="jdbc:oracle:thin:@Nofa02.Nofa.local:1521:tgvg1891" -->
<!-- MySQL example : value="jdbc:mysql://localhost:3306/lct" -->
<!-- MySQL example : value="jdbc:mysql://localhost:3306/centricgisvb" -->
<init-param id="CASETOOL_db_URL">
<param-name>CASETOOL_db_URL</param-name>
<param-value>jdbc:oracle:thin:@YourServer:1521:DBInstance</param-value>
</init-param>
In the file, search for section 'CASETOOL_db_username' - Update the value shown in red below
<init-param id="CASETOOL_db_username">
<param-name>CASETOOL_db_username</param-name>
<param-value>UserName</param-value>
</init-param>
In the file, search for section 'CASETOOL_db_password' - Update the value shown in red below
<init-param id="CASETOOL_db_password">
<param-name>CASETOOL_db_password</param-name>
<param-value>Password</param-value>
</init-param>
On the DigEplan conversion server
Note : On Test systems all components are normally installed on the same server
Locate the av_con_ws web.xml - eg C:\Oracle\glassfish3\glassfish\domains\AutoVue\applications\av_con_ws\WEB-INF\web.xml
In the file, search for section 'CASETOOL_db_URL' - Update the value shown in red below
<!-- Oracle example : value="jdbc:oracle:thin:@Nofa02.Nofa.local:1521:tgvg1891" -->
<!-- MySQL example : value="jdbc:mysql://localhost:3306/lct" -->
<!-- MySQL example : value="jdbc:mysql://localhost:3306/centricgisvb" -->
<init-param id="CASETOOL_db_URL">
<param-name>CASETOOL_db_URL</param-name>
<param-value>jdbc:oracle:thin:@YourServer:1521:DBInstance</param-value>
</init-param>
In the file, search for section 'CASETOOL_db_username' - Update the value shown in red below
<init-param id="CASETOOL_db_username">
<param-name>CASETOOL_db_username</param-name>
<param-value>UserName</param-value>
</init-param>
In the file, search for section 'CASETOOL_db_password' - Update the value shown in red below
<init-param id="CASETOOL_db_password">
<param-name>CASETOOL_db_password</param-name>
<param-value>Password</param-value>
</init-param>
Restart AutoVue Glassfish windows service on each server where the change has been applied
Comments