123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340
<?xml version="1.0" encoding="UTF-8"?>
<Configuration Version="7.1"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="schemas/cd_storage_conf.xsd">
<Global>
<!--Optional:-->
<ObjectCache Enabled="false">
<!--Optional:-->
<Policy Type="LRU" Class="com.tridion.cache.LRUPolicy">
<!--
The maximum size of memory used by the cache. The string must consist a number
followed by units: "k" or "kb" for kilobytes; "m" or "mb" for megabytes (case insensitive)
-->
<Param Name="MemSize" Value="16mb"/>
</Policy>
<!--Optional:-->
<!-- The Features element specifies classes that add additional functionality to the cache. -->
<Features>
<Feature Type="DependencyTracker" Class="com.tridion.cache.DependencyTracker"/>
</Features>
<!--Optional:-->
<!--
The optional RemoteSynchronization element specifies a remote Cache Channel Service.
The remote Cache Channel Service is used to send messages between caches that are running
on separate virtual machines. (For example, if the Broker and the Deployer run on separate
virtual machines.)
The Cache Channel Service must be running and listening on the configured host and port for
remote synchronization to function.
If this element is omitted, the cache does not use any inter-virtual machine cache communication.
You must use the RemoteSynchronization element in conjunction with the Cache Channel service in
order for objects to be updated or removed from the Broker's object cache when they are published
or unpublished using the Deployer.
-->
<!-- RMI CacheChannel Connector example
<RemoteSynchronization Queuesize="128" ServiceMonitorInterval="10000" FlushCacheDuringDisconnectInterval="20000">
<Connector Class="com.tridion.cache.RMICacheChannelConnector" Host="127.0.0.1" Port="1099" />
</RemoteSynchronization>
-->
<!-- JMS CacheChannel Connector example
<RemoteSynchronization Queuesize="128" ServiceMonitorInterval="10000" FlushCacheDuringDisconnectInterval="20000">
<Connector Class="com.tridion.cache.JMSCacheChannelConnector" Topic="topicName" TopicConnectionFactory="jndiNameOfConnectionFactory"/>
</RemoteSynchronization>
-->
</ObjectCache>
<!--Optional:-->
<!-- The optional MetaQueryConstants section allows setting of some advanced properties.
FindByURLCaseSensitivity overrides the default behaviour of the findByURL methods
for retrieving BinaryMeta and PageMeta data.
<MetaQueryConstants>
<FindByURLCaseSensitivity Value="false"/>
<CategoryQuerySeparator Value="/"/>
</MetaQueryConstants>
-->
<!--
Specify RMI listening port
-->
<!--
<RMIChannel ListenerPort="1050"/>
-->
<Storages>
<!--
Optional
Overriding default Tridion dao bundles.
-->
<StorageBindings>
<Bundle src="preview_dao_bundle.xml"/>
<!-- <Bundle src="myDAO.xml"/>
<Bundle src="mybindings.xml"/>
-->
</StorageBindings>
<Wrappers>
<!--
In order to allow storing of the session data a mechanism should be in place to support storing and
retrieving data in a specific user session.
-->
<Wrapper Name="SessionWrapper">
<!--
Optional:
Timeout - The session timeout expressed in milliseconds.
<Timeout>60000</Timeout>
-->
<!--
Optional:
Machine name - The name of the machine where this instance is run
<MachineName>MachineName</MachineName>
-->
<!--
Optional: Definition of session storage.
-->
<Storage Type="persistence" Id="sessionDb" dialect="MSSQL" Class="com.tridion.storage.persistence.JPADAOFactory">
<Pool Type="jdbc" Size="10" MonitorInterval="60" IdleTimeout="120" CheckoutTimeout="120" />
<DataSource Class="com.microsoft.sqlserver.jdbc.SQLServerDataSource">
<Property Name="serverName" Value="MyServerNameComesHere" />
<Property Name="portNumber" Value="1198" />
<Property Name="databaseName" Value="Tridion_Broker_Session"/>
<Property Name="user" Value="TridionBrokerUser"/>
<Property Name="password" Value="CpS$!@%4125ab"/>
</DataSource>
</Storage>
</Wrapper>
</Wrappers>
<!--
For Database elements of type sql, you can specify the pooling that
should be used with a Pool element. This pooling is independent of the selected database driver.
This element has the following attributes:
Type The type should be either jdbc or tridion.
Size Maximum number of connections to open.
MonitorInterval Number of seconds between checks on the pool.
IdleTimeout Number of seconds a connection can be idle before it is closed.
CheckoutTimeout Number of seconds a connection can be checked out before it is returned to pool.
-->
<!--
Configuration example for MS SQL Server 2008 R2 SP1 & 2012 SP1, using the MSSQL JDBC driver.
The DataSource element specifies the class name of the DataSource to use and properties specific to the datasource.
For the MSSQL JDBC driver the minimum set of properties to set are:
serverName: name of the server that hosts the database
portNumber: configuration of the port used for TCP/IP connections to the database. 1433 is the default port.
databaseName: name of the database to access
userName: username used to access the database
password: password used to access the database
-->
<Storage Type="persistence" Id="defaultdb" dialect="MSSQL" Class="com.tridion.storage.persistence.JPADAOFactory">
<Pool Type="jdbc" Size="10" MonitorInterval="60" IdleTimeout="120" CheckoutTimeout="120" />
<DataSource Class="com.microsoft.sqlserver.jdbc.SQLServerDataSource">
<Property Name="serverName" Value="MyServerNameComesHere" />
<Property Name="portNumber" Value="1198" />
<Property Name="databaseName" Value="Tridion_Broker_Staging" />
<Property Name="user" Value="TridionBrokerUser" />
<Property Name="password" Value="CpS$!@%4125ab" />
</DataSource>
</Storage>
<!--
Configuration example for DB2 Version 9.7
The DataSource element specifies the class name of the DataSource to use and properties specific to the datasource.
For the DB2 Version 9.7 driver the minimum set of properties to set are:
serverName: name of the server that hosts the database
portNumber: configuration of the port used for TCP/IP connections to the database. 50000 is the default port.
databaseName: name of the database to access
userName: username used to access the database
password: password used to access the database
driverType: set to "4" to indicate a pure java driver so no client installations of the driver are required.
<Storage Type="persistence" Id="defaultdb1" dialect="DB2" Class="com.tridion.storage.persistence.JPADAOFactory">
<Pool Type="jdbc" Size="10" MonitorInterval="60" IdleTimeout="120" CheckoutTimeout="120" />
<DataSource Class="com.ibm.db2.jcc.DB2SimpleDataSource">
<Property Name="serverName" Value="SERVER_NAME"/>
<Property Name="portNumber" Value="50000"/>
<Property Name="databaseName" Value="DATABASE_NAME"/>
<Property Name="user" Value="USER_NAME"/>
<Property Name="password" Value="PASSWORD"/>
<Property Name="driverType" Value="4"/>
</DataSource>
</Storage>
-->
<!--
Configuration example for Oracle 10 and Oracle 11.
The DataSource element specifies the class name of the DataSource to use and properties specific to the datasource.
For the Oracle 10 driver the minimum set of properties to set are:
driverType: set to value "thin". Indicates the type of driver to use, by using "thin" no oracle client installation is required.
networkProtocol: "tcp". Indicates TCP/IP will be used for connectivity.
serverName: name of the server that hosts the database
portNumber: configuration of the port used for TCP/IP connections to the database. 1521 is the default port.
databaseName: name of the database to access
userName: username used to access the database
password: password used to access the database
<Storage Type="persistence" Id="defaultdb2" dialect="ORACLESQL" Class="com.tridion.storage.persistence.JPADAOFactory">
<Pool Type="jdbc" Size="10" MonitorInterval="60" IdleTimeout="120" CheckoutTimeout="120" />
<DataSource Class="oracle.jdbc.pool.OracleDataSource">
<Property Name="driverType" Value="thin"/>
<Property Name="networkProtocol" Value="tcp"/>
<Property Name="serverName" Value="SERVER_NAME"/>
<Property Name="portNumber" Value="1521"/>
<Property Name="databaseName" Value="DATABASE_NAME"/>
<Property Name="user" Value="USER_NAME"/>
<Property Name="password" Value="PASSWORD"/>
</DataSource>
</Storage>
-->
<!--
Configuration example for using a old style compatible JDBC Driver datasources.
<Storage Type="persistence" Class="com.tridion.storage.persistence.JPADAOFactory" dialect="MSSQL" Id="defaultdb3" Url="JDBC_URL_CONNECTION_STRING" Username="USERNAME" Password="PASSWORD" Driver="DRIVER_CLASS">
<Pool Type="jdbc2" Size="10" MonitorInterval="60" IdleTimeout="120" CheckoutTimeout="120"/>
</Storage>
-->
<!--
Configuration example for using an Oracle based JNDI datasource.
<Storage Type="persistence" Class="com.tridion.storage.persistence.JPADAOFactory" dialect="ORACLESQL" Id="defaultdb4" JNDIName="java:comp/env/jdbc/DATA_SOURCE_NAME"/>
-->
<!--
Configuration example for using a MS SQL based JNDI datasource.
<Storage Type="persistence" Class="com.tridion.storage.persistence.JPADAOFactory" dialect="MSSQL" Id="defaultdb5" JNDIName="java:comp/env/jdbc/DATA_SOURCE_NAME"/>
-->
<!--
Configuration example for using a DB2 based JNDI datasource.
<Storage Type="persistence" Class="com.tridion.storage.persistence.JPADAOFactory" dialect="DB2" Id="defaultdb6" JNDIName="java:comp/env/jdbc/DATA_SOURCE_NAME"/>
-->
<!--
Configuration example for using filesystem as data storage.
-->
<Storage Type="filesystem" Class="com.tridion.storage.filesystem.FSDAOFactory" Id="defaultFile" defaultFilesystem="false">
<Root Path="D:\websites\staging" />
</Storage>
<!--
<Storage Type="filesystem" Class="com.tridion.storage.filesystem.FSDAOFactory" Id="defaultDataFile" defaultFilesystem="true" defaultStorage="true">
<Root Path="c:\temp\data" />
</Storage>
-->
<!--
Configuration Example for SearchFilter home used by the SearchFilter Query API
<SearchFilter Name="SearchFilter" Class="com.tridion.broker.components.meta.OracleSearchFilterHome" defaultStorageId="defaultdb2"/>
-->
<!--
<SearchFilter Name="SearchFilter" Class="com.tridion.broker.components.meta.DB2SearchFilterHome" defaultStorageId="defaultdb1"/>
-->
<!--
<SearchFilter Name="SearchFilter" Class="com.tridion.broker.components.meta.MsSqlSearchFilterHome" defaultStorageId="defaultdb"/>
-->
</Storages>
<!-- This configures the taxonomy reference count for keywords, if CountEnabled is
set to False the reference count for keywords will not get updated. The default setting is keyword counts are enabled. -->
<!--<Taxonomies CountEnabled="false"/>-->
<!-- Configures transaction storage settings, how long before a transaction gets rolledback and on which interval to monitor for
outstanding transactions. Default timeout is 120000 ms. (2 minutes) and Default interval is 5000ms. (5 seconds) -->
<!-- <Transaction Timeout="120000" MonitorInterval="5000"/> -->
</Global>
<!-- If no item type mappings are defined within ItemTypes or if storages on a lower level do not exist then the storage defined by defaultStorageId attribute will be used.
If storage defined by defaultStorageId does not exist then exception will be thrown. -->
<ItemTypes defaultStorageId="defaultdb" cached="false">
<!-- Query type mapping is replacement for Query gnenerator. If there was query generator defined in a Broker configuration then Query type mapping should be binded to default DB. -->
<!--
<Item typeMapping="Query" storageId="defaultdb"/>
-->
<!--Optional:-->
<!-- If the item type mapping is defined and storage defined by storageId is the existing one then that one will be used.
If storage defined by storageId does not exist then default storage defined by ItemTypes element will be used. -->
<!--
<Item typeMapping="Binary" itemExtension=".pdf" storageId="defaultFile" cached="true"/>
<Item typeMapping="Binary" itemExtension=".iso" storageId="defaultFile" cached="false"/>
<Item typeMapping="ComponentLinkClick" cached="true" storageId="defaultFile"/>
<Item typeMapping="Metadata" cached="true" storageId="defaultFile"/>
<Item typeMapping="ComponentVisit" cached="true" storageId="defaultFile"/>
<Item typeMapping="DynamicLinkInfo" cached="true" storageId="defaultFile"/>
-->
<Item typeMapping="Page" cached="false" storageId="defaultdb"/>
<Item typeMapping="Binary" cached="false" storageId="defaultdb"/>
<!--
<Item typeMapping="Personalization" cached="true" storageId="defaultdb"/>
<Item typeMapping="Taxonomy" cached="true" storageId="defaultdb"/>
<Item typeMapping="Timeframe" cached="true" storageId="defaultFile"/>
<Item typeMapping="TrackedPage" cached="true" storageId="defaultFile"/>
<Item typeMapping="XSLT" cached="true" storageId="defaultFile"/>
<Item typeMapping="ExtensionData" cached="true" storageId="defaultdb"/>
-->
<!-- UGC -->
<!--
<Item typeMapping="Comment" storageId="ugcdb"/>
<Item typeMapping="Rating" storageId="ugcdb"/>
<Item typeMapping="UGCUser" storageId="ugcdb"/>
<Item typeMapping="UGCItemStats" storageId="ugcdb"/>
-->
<!--Optional:-->
<!-- If the publication is defined and storage defined by defaultStorageId is the existing one then that one will be used for that publication unless it is overwriten on a lower level.
If storage defined by storageId does not exist then default storage defined by ItemTypes element will be used unless lower level type mappings are not matched. -->
<!--
<Publication Id="1" defaultStorageId="defaultFile" cached="false">
-->
<!--Optional:-->
<!-- If there is a type mapping match and storage is defined for storageId then that storage will be used.
Otherwise; first storage defined within publication element will be referenced, and if that one does not exist then the storage from Item elements will be referenced.
and at the end storage defined within ItemTypes will be used.-->
<!--
<Item typeMapping="ComponentPresentation" itemExtension=".Jsp" storageId="defaultFile"/>
<Item typeMapping="ComponentPresentation" itemExtension=".Asp" storageId="defaultFile"/>
<Item typeMapping="ComponentPresentation" itemExtension=".Xml" storageId="defaultFile"/>
<Item typeMapping="ComponentPresentation" itemExtension=".Txt" storageId="defaultFile"/>
<Item typeMapping="Metadata" cached="true" storageId="defaultFile"/>
<Item typeMapping="Binary" itemExtension=".pdf" storageId="defaultFile" cached="true"/>
<Item typeMapping="Binary" itemExtension=".iso" storageId="defaultFile" cached="false"/>
<Item typeMapping="ComponentLinkClick" cached="true" storageId="defaultFile"/>
<Item typeMapping="ComponentVisit" cached="true" storageId="defaultFile"/>
<Item typeMapping="DynamicLinkInfo" cached="true" storageId="defaultFile"/>
<Item typeMapping="Page" cached="true" storageId="defaultFile"/>
<Item typeMapping="Personalization" cached="true" storageId="defaultdb"/>
<Item typeMapping="Taxonomy" cached="true" storageId="defaultdb"/>
<Item typeMapping="Timeframe" cached="true" storageId="defaultFile"/>
<Item typeMapping="TrackedPage" cached="true" storageId="defaultFile"/>
<Item typeMapping="XSLT" cached="true" storageId="defaultFile"/>
<Item typeMapping="ExtensionData" cached="true" storageId="defaultdb"/>
-->
<!-- UGC -->
<!--
<Item typeMapping="Comment" storageId="ugcdb"/>
<Item typeMapping="Rating" storageId="ugcdb"/>
<Item typeMapping="UGCUser" storageId="ugcdb"/>
<Item typeMapping="UGCItemStats" storageId="ugcdb"/>
-->
<!--
</Publication>
-->
</ItemTypes>
<!-- Specifies the location of the license file. -->
<License Location="C:\DevLicenceForSdl\cd_licenses.xml"/>
</Configuration>