Setting up a Tomcat server

Installing : Installing Focal Point : Setting up the application server : Setting up a Tomcat server

Before starting Focal Point^® for the first time, you must specify the database details in the fp.properties file, and then allocate memory to Focal Point^®.

You only have to do this once; you do not have to do it every time that you restart Focal Point^®.

Specifying the database details

1 Open the fp.properties file that is this folder:

<Focal Point installation directory>/server/conf/fp/

2 Change the parameter values to use the database that you have configured for Focal Point^®.

▪ For PostgreSQL, set the JDBC connection properties.

▪ For DB2 and Oracle, set the JDBC connection properties, and the table space details.

▪ The format for specifying the database details are provided as examples in the fp.properties file and are commented.

▪ The password in the fp.properties file will be encrypted when you start Focal Point^® for the first time.

JDBC connection properties: Examples

PostgreSQL

Use the same values as when you installed the database.

jdbc.driverClassName=org.postgresql.Driver

jdbc.url=jdbc:postgresql://127.0.0.1:5432/focalpoint

jdbc.username=postgre_username

jdbc.password=postgre_password

DB2

Use the same values as when you installed the database.

jdbc.driverClassName=com.ibm.db2.jcc.DB2Driver

jdbc.url=jdbc:db2://127.0.0.1:50000/FOCALDB

jdbc.username=db2_username

jdbc.password=db2_password

Oracle

Specify the username and the password that you used when you created the Focal Point^® schemas.

jdbc.driverClassName=oracle.jdbc.OracleDriver

jdbc.url=jdbc:oracle:thin:@//127.0.0.1:1521/focalpoint

jdbc.username=oracle_username

jdbc.password=oracle_password

Table space details (DB2 and Oracle only): Examples

Set the data index and big object details:

DB2

dataStorage=IN FP_DATA

indexStorage=IN FP_INDEX

bigObjStorage=IN FP_BIGOBJ

Oracle

dataStorage=TABLESPACE FP_DATA STORAGE (initial 1m next 1m pctincrease 0)

indexStorage=TABLESPACE FP_INDEX STORAGE (initial 1m next 1m pctincrease 0)

bigObjStorage=TABLESPACE FP_BIGOBJ STORAGE (initial 1m next 1m pctincrease 0)

Allocating memory to Focal Point

1 Navigate to this folder:

<Focal Point installation directory>\server

2 Open this file:

Operating system	File
Windows	server.startup.bat
Linux or Solaris	server.startup.sh

3 To increase the memory size, add the following Java arguments:

set JAVA_OPTS=%JAVA_OPTS% -Xmx4G
set JAVA_OPTS=%JAVA_OPTS% -Xms4G
set JAVA_OPTS=%JAVA_OPTS% -Xmn512M

These are the default values used by the Tomcat server. To allocate more memory, increase each of the values proportionately.