Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

By default Weave stores information about Redlines, Bookmarks etc. in an internal Weave data source (system.datasource) however this information can be stored in a database instead. The advantage of storing this information in a database is that it stores it independently of the Weave installation. Also it allows items to be deleted that have been created by a specific Weave user (for example, if someone leaves the organisation). 

Step-by-step guide

  1. Define a Weave data source for the database where you want to store the Redlines, Bookmarks etc. 

    1.  If Weave is running from the command line, add a reference to the data source in the startup.cmd file to set the database that should be used for storage.

      Extract from startup.cmd file
      REM Set data storage to SQL Server DB instead of Weave internal DB
SET JAVA_OPTS=%JAVA_OPTS% -Dstorage.datasource=gis_db

      where "gis_db" is an id in the datasource.xml file as:

      Extract from datasource.xml file
      <jdbc:datasource id="gis_db">

	<jdbc:driver>com.microsoft.sqlserver.jdbc.SQLServerDriver</jdbc:driver>
	<jdbc:url>
		<![CDATA[jdbc:sqlserver://localhost:1433;databaseName=weave]]>
	</jdbc:url>
    ...
    ...
</jdbc:datasource>

    2. If Weave is running as a Windows service, add a reference to the data source in the service/conf/wrapper.conf file.

      Extract from wrapper.conf file
      # Set data storage to SQL Server DB instead of Weave internal DB
wrapper.java.additional.22 = -Dstorage.datasource=gis_db



  2. Stop the Weave service and clean out the Eclipse folders in the ../weave/platform/configuration folder:
    1. org.eclipse.core.runtime
    2. org.eclipse.equinox.app
    3. org.eclipse.osgi
    4. org.eclipse.update
       

  3. Start the Weave service. Once Weave is started the wv_* tables will be created. These tables will be empty:

    1. wv_storage_attributes

    2. wv_user_attributes

    3. wv_user_nodes
       




  4. Open the Weave application and add a new Bookmark. This Bookmark will be saved into the database and you will be able to see it by looking into the wv_user_nodes table.
     
     



  5. The following steps will ensure that everything is working correctly. 

    1. Stop the Weave service.

    2. Repeat Step 2 to make sure that Weave will read the Bookmark from the database.

    3. Start the Weave service.

    4. Open the Weave application and the saved Bookmark will be available.


Also refer to the following sections of the Weave System Administrator Guides:

  • No labels