Using Include List

Using Include List

Together Teamlösungen EDV-Dienstleistungen GmbH

Elmargasse 2-4
A-1190 Vienna
Austria
Phone: +43 (0) 5 04 04 - 122
Fax: +43 (0) 5 04 04 - 11 122
E-Mail: 
Web: http://www.together.at/together/index.html

All rights reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, electronic, mechanical, photocopying, recording or otherwise, without the prior written permission of the Together Teamlösungen EDV-Dienstleistungen GmbH.

Together Teamlösungen EDV-Dienstleistungen GmbH DISCLAIMS ALL WARRANTIES, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO ANY WARRANTY THAT THE USE OF THE INFORMATION HEREIN WILL NOT INFRINGE ANY RIGHTS OR ANY IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE.


Table of Contents

Create Include database
Insert data
Setting up 'Together Search Server Admin' application
Setting up a Site and Include list
Configuring Include list on a different database server

List of Tables

1. Insert data example

In order to use the Include List feature of 'Together Search Server' the following steps are to be performed.

Create Include database

The first step is to create an include list database. In the database a table should be created with following columns in the same order as written here. The column names are arbitrary and are given here only as an example:

OID – int, object ID

FILENAME – Varchar(254), file path

MODIFIED, Timestamp, file modification date

Insert data

After the successful database/table creation, the include list should be filled out the file paths to the files to be indexed along with their modification dates.

An example:

Table 1. Insert data example

AttributeFILENAMEMODIFIED
1'C:\myfile.xls''2005-01-01 00:00:00.0'

Setting up 'Together Search Server Admin' application

The next step is to configure the 'Together Search Server Admin' application to have access to our Include List.

The datasource for the database should be declared in the tssAdmin.xml. Here is an example of a datasource declaration:

<Resource name="includeDB" type="javax.sql.DataSource" 
maxWait="5000" maxActive="40" password="" maxIdle="10" username="sa"
    driverClassName="org.hsqldb.jdbcDriver"
    url="jdbc:hsqldb:${catalina.base}/hsql/ includeDB / includeDB" />

Parameters:

Resource name is the datasource name for the database that will be used throughout the application.

driverClassName is the name of the driver class used

url is the url to the database

In addition to this configuration file, the web.xml configuration file should as well be edited to reflect the changes made in the tssAdmin.xml.

In the DatabaseManager/Databases[] entry, the include database name should be declared as in this example:

<env-entry>
    <env-entry-name>DatabaseManager/Databases[]</env-entry-name>
    <env-entry-value>includeDB</env-entry-value>
    <env-entry-type>java.lang.String</env-entry-type>
</env-entry>

In the following listing are the additional declarations needed for the Include database to be operational. The examples are given :

  <env-entry>
    <env-entry-name>DatabaseManager/DB/ includeDB /ClassType</env-entry-name>
    <env-entry-value>HypersonicSQL</env-entry-value>
    <env-entry-type>java.lang.String</env-entry-type>
  </env-entry>

  <env-entry>
    <env-entry-name>DatabaseManager/DB/ includeDB /ObjectId/NextWithPrefix</env-entry-name>
    <env-entry-value>true</env-entry-value>
    <env-entry-type>java.lang.String</env-entry-type>
  </env-entry>

  <env-entry>
    <env-entry-name>DatabaseManager/DB/ includeDB /Connection/ShutDownString</env-entry-name>
    <env-entry-value>CHECKPOINT</env-entry-value>
    <env-entry-type>java.lang.String</env-entry-type>
  </env-entry>

  <env-entry>
    <env-entry-name>DatabaseManager/DB/ includeDB /Connection/DataSourceName</env-entry-name>
    <env-entry-value>jndi: includeDB </env-entry-value>
    <env-entry-type>java.lang.String</env-entry-type>
  </env-entry>

  <env-entry>
    <env-entry-name>DatabaseManager/DB/ includeDB /ConnectionAllocator</env-entry-name>
    <env-entry-value>com.lutris.appserver.server.sql.
                     datasource.DataSourceConnectionAllocator</env-entry-value>
    <env-entry-type>java.lang.String</env-entry-type>
  </env-entry>

  <env-entry>
    <env-entry-name>DatabaseManager/DB/ includeDB /
                    Connection/ConnectionFactory</env-entry-name>
    <env-entry-value>com.lutris.appserver.server.sql.
                     DataSourceDBConnectionFactory</env-entry-value>
    <env-entry-type>java.lang.String</env-entry-type>
  </env-entry>

  <env-entry>
    <env-entry-name>DatabaseManager/DB/ includeDB /ObjectId/MinValue</env-entry-name>
    <env-entry-value>1000000</env-entry-value>
    <env-entry-type>java.lang.String</env-entry-type>
  </env-entry>

  <env-entry>
    <env-entry-name>DatabaseManager/DB/ includeDB /Connection/MaxPoolSize</env-entry-name>
    <env-entry-value>10</env-entry-value>
    <env-entry-type>java.lang.String</env-entry-type>
  </env-entry>

Setting up a Site and Include list

An Include List for a Site is defined in configuretion file ('siteConf.xml'). The information about the Include list should be entered:

Include list DB: is the resource name defined in tssAdmin.xml

Include Table: table where the include list data are contained

Include Column: column in the table where the file paths are contained

Include Column modified: column in the table where the file modification dates are contained.

Configuring Include list on a different database server

In order to run the include list on a database server other than HSQL, the following modification should be performed:

In the tssAdmin.xml the proper driver and url should be entered Supported values: HypersonicSQL, PostgreSQL, DB2, QED, MySQL, Sybase, Oracle, MSQL.

Example for MSQL:

<Resource name="includeDB" type="javax.sql.DataSource"   
     maxWait="5000" maxActive="40" password="" maxIdle="10" username="sa"  
          driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver" 
     url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=includeDB;Select
Method=cursor" />

In the web.xml the <env-entry-name>DatabaseManager/DB/ includeDB /ClassType</env-entry-name> value should be changed to the proper database. i.e. MSQL.