Configuration Values
The configuration values are located in the <FSI_HOME>/config/ConfigValues_FSI.xml file.
The configuration values are as follows:
| Property Name | Description | Default Value | Comments |
|---|---|---|---|
| com.tibco.fos.fsi.pooledDataSource.driverClassName | Pooled Data Source Driver Class Name | For Oracle database:
oracle.jdbc.driver.OracleDriver
For PostgreSQL database: org.postgresql.Driver |
|
| com.tibco.fos.fsi.pooledDataSource.host | Pooled Data Source Host | localhost | |
| com.tibco.fos.fsi.pooledDataSource.port | Pooled Data Source Port | For Oracle database:
1521
For PostgreSQL database: 5432 |
|
| com.tibco.fos.fsi.pooledDataSource.database | Pooled Data Source Database | For Oracle database:
orcl
For PostgreSQL database: fsidb |
|
| com.tibco.fos.fsi.pooledDataSource.username | Pooled Data Source Username | For Oracle database:
aff_inv For PostgreSQL database: fsiuser |
|
| com.tibco.fos.fsi.hibernate.default_catalog | Hibernate Default Catalog | For Oracle database:
aff_inv For PostgreSQL database: fsiuser |
Should be the same as the pooled data source Username. |
| com.tibco.fos.fsi.pooledDataSource.password | Pooled Data Source Password | For Oracle database:
aff_inv For PostgreSQL database: fsipassword |
|
| com.tibco.fos.fsi.pooledDataSource.url | Pooled Data Source URL |
For Oracle database:
jdbc:oracle:thin:@// ${com.tibco.fos.inv.pooledDataSource.host}: ${com.tibco.fos.inv.pooledDataSource.port}/ ${com.tibco.fos.inv.pooledDataSource.database} For PostgreSQL database: jdbc:pastgresql:// ${com.tibco.fos.fsi.pooledDataSource.host}: ${com.tibco.fos.fsi.pooledDataSource.port}/ ${com.tibco.fos.fsi.pooledDataSource.database} ?currentSchema=fsischema |
|
| com.tibco.fos.fsi.pooledDataSource.initializeSize | Pooled Data Source Initialize Size | 2 | |
| com.tibco.fos.fsi.pooledDataSource.maxIdle | Pooled Data Source Max Idle | 11 | |
| com.tibco.fos.fsi.pooledDataSource.maxActive | Pooled Data Source Max Active | 12 | |
| com.tibco.fos.fsi.pooledDataSource.maxWait | Pooled Data Source Max Wait | 10000 | |
| com.tibco.fos.fsi.pooledDataSource.validationQuery | Pooled Data Source Validation Query | select 1 from dual | |
| com.tibco.fos.fsi.pooledDataSource.testOnBorrow | Pooled Data Source Test OnBorrow | FALSE | |
| com.tibco.fos.fsi.pooledDataSource.testWhileIdle | Pooled Data Source Test WhileIdle | TRUE | |
| com.tibco.fos.fsi.pooledDataSource.timeBetweenEvictionRunsMillis | Pooled Data Source Eviction Interval | 5000 | |
| com.tibco.fos.fsi.pooledDataSource.minEvictableIdleTimeMillis | Pooled Data Source Minimum Evictable Idle Time | 5000 | |
| com.tibco.fos.fsi.pooledDataSource.numTestsPerEvictionRun | Pooled Data Source Tests Per Eviction Run | 5 | |
| com.tibco.fos.fsi.hibernate.dialect | Hibernate dialect | For Oracle database:
org.hibernate.dialect.Oracle10gDialect For PostgreSQL database: org.hibernate.dialect.PostgreSQLDialect |
|
| com.tibco.fos.fsi.hibernate.cache.use_second_level_cache | Hibernate Second Level Cache Usage | FALSE | |
| com.tibco.fos.fsi.hibernate.cache.provider_class | Hibernate Cache Provider Class | org.hibernate.cache.NoCacheProvider | |
| com.tibco.fos.fsi.hibernate.jdbc.batch_size | Hibernate JDBC Batch size | 30 | |
| com.tibco.fos.fsi.hibernate.show_sql | Hibernate Show SQL | FALSE | |
| com.tibco.fos.fsi.jms.jndi.url | JNDI URL for JMS Service | tibjmsnaming://localhost:7222 | Used for lock notification or JMS SOAP API. |
| com.tibco.fos.fsi.jms.jndi.security.principal | JNDI Username | admin | |
| com.tibco.fos.fsi.jms.jndi.security.credentials | JNDI Password | admin | |
| com.tibco.fos.fsi.soapService.jms.targetDestination | JMS Queue to process incoming SOAP API requests | com.tibco.inventory.soap.api.jms.queue | |
| com.tibco.fos.fsi.soapService.jms.concurrentConsumers | Initial count of consuners that process the incoming SOAP request | 5 | |
| com.tibco.fos.fsi.soapService.jms.maxConcurrentConsumers | Max count of consuners that process the incoming SOAP request | 10 | |
| com.tibco.fos.fsi.expiry.check.delay | Number of milliseconds between 2 expiry checks | 60000 | |
| com.tibco.fos.fsi.bulk.configuration | Bulk load configuration file path (on the inventory server machine) | /tmp/bulkconfig.json | |
| com.tibco.fos.fsi.jwt.rest.token.validity | Number of seconds for which JWT token is valid for REST API | 3600 | |
| com.tibco.fos.fsi.jwt.soap.token.validity | Number of seconds for which JWT token is valid for SOAP API | 3600 |