Storage settings under cd_storage.conf file for XPM

Question

We have 2 CDA websites (publication targets), Preview and Live.

As per the question here, we should have single DB for XPM and Preview Broker. I have HTTPUpload WebService (deployed in IIS as a website) - for preview, where I have deployed odata.svc as well - to reduce the number of IIS web services.

Below is the storages configuration in cd_storage.conf file on my preview cum experience manager website/web-service:

<Storages>
<Wrappers>
    <Wrapper Name="SessionWrapper">
    <Storage Id="sessionDB" Class="com.tridion.storage.persistence.JPADAOFactory" Type="persistence" dialect="MSSQL">
    <Pool Type="jdbc" Size="5" MonitorInterval="60" IdleTimeout="120" CheckoutTimeout="120" />
    <DataSource Class="com.microsoft.sqlserver.jdbc.SQLServerDataSource">
        <Property Name="serverName" Value="MYDBSERVERNAME" />
        <Property Name="portNumber" Value="1433" />
        <Property Name="databaseName" Value="Tridion_ExperienceManager_Dev" />
        <Property Name="user" Value="adminUser" />
        <Property Name="password" Value="adminPass" />
    </DataSource>
    </Storage>
    </Wrapper>
    </Wrappers>
    <Storage Type="persistence" Id="defaultdb" dialect="MSSQL" Class="com.tridion.storage.persistence.JPADAOFactory">
    <Pool Type="jdbc" Size="5" MonitorInterval="60" IdleTimeout="120" CheckoutTimeout="120"/>
    <DataSource Class="com.microsoft.sqlserver.jdbc.SQLServerDataSource">
        <Property Name="serverName" Value="MYDBSERVERNAME"/>
        <Property Name="portNumber" Value="1433"/>
        <Property Name="databaseName" Value="Tridion_ExperienceManager_Dev"/>
        <Property Name="user" Value="adminUser"/>
        <Property Name="password" Value="adminPass"/>
    </DataSource>
    </Storage>  
</Storages>

Please let me know if this is correct.

However, XPM and publishing to preview is working fine.

Also let me know where do we use "sessionDB" - coz at present, its not being used anywhere.

Thanks.

Answer 1

Your "preview" (staging) site indeed requires two databases - one broker, one sessionDB. Your live site requires only one (just the broker). You should configure the sessionDB in the datasource inside of the sessionwrapper, the broker DB in its normal place below.

Answer 2

as i answered in your previous questions On Staging you need two Separate Databases.

• 1) Exclusively for odataService, (Session-db)
• 2) For Staging website.

So create a separate db. and update above give configuration. Is your preview working fine?

just want to give more clarifications.

There would be two different IIS application

• 1 for oData for
• 2 for your staging website. (there would be some setting in website's config as well)

you can refer documentation (require login)