data.WEB-INF.config.mssql.opencms.properties Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of opencms-test Show documentation
OpenCms is an enterprise-ready, easy to use website content management system based on Java and XML technology. Offering a complete set of features, OpenCms helps content managers worldwide to create and maintain beautiful websites fast and efficiently.
There is a newer version: 18.0
Show newest version
#
# Configuration of the driver manager
#################################################################################
driver.vfs=db
driver.project=db
driver.user=db
driver.subscription=db
driver.workflow=db
driver.history=db

#
# Database setup (used only in tests) 
#################################################################################

db.pool.setup.dbName=ocjutest
db.pool.setup.jdbcDriver=net.sourceforge.jtds.jdbc.Driver
db.pool.setup.jdbcUrl=jdbc:jtds:sqlserver://localhost
db.pool.setup.jdbcUrl.params=
db.pool.setup.user=sa
db.pool.setup.password=aBc!0x2yz?

#
# Declaration of database pools
#################################################################################
db.pools=default

#
# Configuration of the default database pool
#################################################################################

# name of the database (used only in tests)
db.pool.default.dbName=ocjutest

# name of the JDBC driver
db.pool.default.jdbcDriver=net.sourceforge.jtds.jdbc.Driver

# URL of the JDBC driver
db.pool.default.jdbcUrl=jdbc:jtds:sqlserver://localhost/ocjutest

# optional parameters for the URL of the JDBC driver
db.pool.default.jdbcUrl.params=

# user name to connect to the database
db.pool.default.user=sa

# password to connect to the database
db.pool.default.password=aBc!0x2yz?

# the URL to make the JDBC DriverManager return connections from the DBCP pool
db.pool.default.poolUrl=opencms:default

# the maximum number of objects that can be borrowed from the pool
db.pool.default.maxActive=25

# the maximum amount of time before throwing an exception when the pool is exhausted
db.pool.default.maxWait=2000

# the maximum number of objects that can sit idled in the pool
db.pool.default.maxIdle=10

# connections will be validated by evictor thread
db.pool.default.testWhileIdle=true

# number of milliseconds to sleep between runs of the evictor thread
# -1 means no idle connection evictor thread will be run
db.pool.default.timeBetweenEvictionRuns=3600000

# number of connections tested in a run of the evictor thread
db.pool.default.numTestsPerEvictionRun=3

# minimum amount of time in milliseconds a connection may be idle in the pool before it is eligable for eviction 
db.pool.default.minEvictableIdleTime=1800000

# the query to validate connections
db.pool.default.testQuery=SELECT STRUCTURE_ID FROM CMS_OFFLINE_STRUCTURE WHERE RESOURCE_PATH = '/'

# action to take when the pool is exhausted {grow|block|fail}
db.pool.default.whenExhaustedAction=block

# connections will be validated before they are borrowed from the pool
db.pool.default.testOnBorrow=false

# name of the data tablespace (used only in tests)
db.oracle.defaultTablespace=users

# name of the index tablespace (used only in tests)
db.oracle.indexTablespace=users

#name of the temporary tablespace (used only in tests)
db.oracle.temporaryTablespace=temp

#
# Configuration for statement pooling
#################################################################################
db.statements.default.pooling=true
db.statements.default.maxActive=200
db.statements.default.maxWait=2000
db.statements.default.maxIdle=100
db.statements.default.whenExhaustedAction=block

#
# Configuration of the database driver manager
#################################################################################
db.name=mssql

db.vfs.driver=org.opencms.db.mssql.CmsVfsDriver
db.vfs.pool=opencms:default
db.vfs.sqlmanager=org.opencms.db.mssql.CmsSqlManager

db.project.driver=org.opencms.db.mssql.CmsProjectDriver
db.project.pool=opencms:default
db.project.sqlmanager=org.opencms.db.mssql.CmsSqlManager

db.user.driver=org.opencms.db.mssql.CmsUserDriver
db.user.pool=opencms:default
db.user.sqlmanager=org.opencms.db.mssql.CmsSqlManager

db.subscription.driver=org.opencms.db.mssql.CmsSubscriptionDriver
db.subscription.pool=opencms:default
db.subscription.sqlmanager=org.opencms.db.mssql.CmsSqlManager

db.workflow.driver=org.opencms.db.mssql.CmsWorkflowDriver
db.workflow.pool=opencms:default
db.workflow.sqlmanager=org.opencms.db.mssql.CmsSqlManager

db.history.driver=org.opencms.db.mssql.CmsHistoryDriver
db.history.pool=opencms:default
db.history.sqlmanager=org.opencms.db.mssql.CmsSqlManager

db.cos.pool=opencms:default

#
# Ethernet address used for UUID generation
# Server name used for various messages
#################################################################################
server.ethernet.address=4b:60:ca:37:04:99
server.name=OpenCmsServer

#
# Enable/Disable OpenCms Setup Wizard
# The wizard sets the flag to false after the setup.
# To use the wizard again, reset it manually to true.
# By setting no value, wizard can always be used.
#################################################################################
wizard.enabled=false