Oracle Example

When using an Oracle ID (SID), you must append the Oracle SID to the catalog.url parameter, using the following syntax:

catalog.url=oracle\://host\:port\:OracleSID

When using an Oracle Service Name, you must append the Oracle Service Name to the catalog.url parameter, using the following syntax:

catalog.url=oracle\://host\:port/OracleServiceName

The following is an example configuration for the server.properties file using an Oracle database with an Oracle SID:

catalog.url=oracle\://sequoia.xyzco.com\:1521\:bpm
server.css.URL=http\://spruce.xyzco.com\:28080/interop/framework/getCSSConfigFile
catalog.db=esbstudio
catalog.username=root
catalog.password=A627FC9A6DEA834C1FA777217871D09E
server.hss.bpmApplication=BPM\:29696
server.datafile.dir=./data/flatfiles
server.essbase.streamingCubeBuilding=true 
server.timeoutPeriod=7200
server.queueSize=250
server.threadCount=40
server.resourceCount=30
server.sql.fetchSize=100
server.tempDir=C:/Windows/Temp
server.charset=windows-1251
server.readLockTimeOut=90
server.writeLockTimeOut=150
oracle.pool.maxsize=20
oracle.cache.size=15
server.essbase.uniqueMemberFromCaptionBinding=true