Installing : Installing Focal Point : Setting up the application server : Setting up the Tomcat server
  
Setting up the 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:
FocalPoint-InstallDir/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:
FocalPoint-installdir\server
2 Open this file:
 
Operating system
File
Windows
server.startup.bat
Linux or Solaris
server.startup.sh
3 To increase the memory size, increase the following Java arguments:
set JAVA_OPTS=%JAVA_OPTS% -Xmx4G
set JAVA_OPTS=%JAVA_OPTS% -Xms4G
These are the default values used by the Tomcat server. To allocate more memory, increase each of the values proportionately.
Go up to
Setting up the application server