Lifecycle Technology | Support Portal

How to update DigEplan DMS DataBase (DB) address

Follow

To move or change the location of the DMS 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 DMS 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 'DMS_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="DMS_db_URL">
        <param-name>DMS_db_URL</param-name>
        <param-value>jdbc:oracle:thin:@YourServer:1521:DBInstance</param-value>
    </init-param>

In the file, search for section 'DMS_db_username' - Update the value shown in red below

     <init-param id="DMS_db_username">
          <param-name>DMS_db_username</param-name>
          <param-value>UserName</param-value>
     </init-param>

In the file, search for section 'DMS_db_password' - Update the value shown in red below

     <init-param id="DMS_db_password">
          <param-name>DMS_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 'DMS_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="DMS_db_URL">
        <param-name>DMS_db_URL</param-name>
        <param-value>jdbc:oracle:thin:@YourServer:1521:DBInstance</param-value>
    </init-param>

In the file, search for section 'DMS_db_username' - Update the value shown in red below

     <init-param id="DMS_db_username">
          <param-name>DMS_db_username</param-name>
          <param-value>UserName</param-value>
     </init-param>

In the file, search for section 'DMS_db_password' - Update the value shown in red below

     <init-param id="DMS_db_password">
          <param-name>DMS_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

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments