OpenSpaces Persistency Scenarios - External Data Source

XAP/EDG 6.5

Documentation Home
Quick Start Guide
Release Notes
Offline Documentation

_{Current GA release}

Search Here

Other Versions

6.0 Documentation
5.X Documentation

General Resources

Screencasts
Examples
API Docs
Forum
Downloads
White Papers
gigaspaces.com

Summary: Using External Data Source with OpenSpaces.

Overview | Configuration

This page is specific to:
GigaSpaces 6.5

If you're interested in another version, click it below:
• GigaSpaces 6.0

Overview

GigaSpaces DataProvider/DataPersister interfaces (with a built in implementation using Hibernate) can be used to store data in an existing data source and in the space: Data is loaded from the data source during space initialization (DataProvider), and from then onwards the application works with the space directly. Meanwhile, the data source is constantly updated with all changes made in the space (DataPersister).

The difference between this persistency option and the Mirror is with how data is persisted back to the database. With the mirror, data is persisted in a reliable asynchronous manner using the mirror Space.

Configuration

GigaSpaces comes with a built in implementation of DataProvider and DataPersister called HibenrateDataSource. Here is how it can be configured with a simple Space connecting to a central data source:

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
    <property name="driverClassName" value="org.hsqldb.jdbcDriver"/>
    <property name="url" value="jdbc:hsqldb:hsql://localhost:9001"/>
    <property name="username" value="sa"/>
    <property name="password" value=""/>
</bean>

<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
    <property name="dataSource" ref="dataSource"/>
    <property name="mappingResources">
        <list>
            <value>Person.hbm.xml</value>
        </list>
    </property>
    <property name="hibernateProperties">
        <props>
            <prop key="hibernate.dialect">org.hibernate.dialect.HSQLDialect</prop>
            <prop key="hibernate.cache.provider_class">org.hibernate.cache.NoCacheProvider</prop>
            <prop key="hibernate.cache.use_second_level_cache">false</prop>
            <prop key="hibernate.cache.use_query_cache">false</prop>
            <prop key="hibernate.hbm2ddl.auto">update</prop>
        </props>
    </property>
</bean>

<bean id="hibernateDataSource" class="org.openspaces.persistency.hibernate.DefaultHibernateExternalDataSource">
    <property name="sessionFactory" ref="sessionFactory"/>
    <property name="initialLoadBatchSize" value="20000"/>    
</bean>

<os-core:space id="space" url="/./space" schema="persistent" external-data-source="hibernateDataSource">
    <os-core:properties>
        <props>
            <prop key="cluster-config.cache-loader.external-data-source">true</prop>
            <prop key="cluster-config.cache-loader.central-data-source">true</prop>
        </props>
    </os-core:properties>
</os-core:space>

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
    <property name="driverClassName" value="org.hsqldb.jdbcDriver"/>
    <property name="url" value="jdbc:hsqldb:hsql://localhost:9001"/>
    <property name="username" value="sa"/>
    <property name="password" value=""/>
</bean>

<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
    <property name="dataSource" ref="dataSource"/>
    <property name="mappingResources">
        <list>
            <value>Person.hbm.xml</value>
        </list>
    </property>
    <property name="hibernateProperties">
        <props>
            <prop key="hibernate.dialect">org.hibernate.dialect.HSQLDialect</prop>
            <prop key="hibernate.cache.provider_class">org.hibernate.cache.NoCacheProvider</prop>
            <prop key="hibernate.cache.use_second_level_cache">false</prop>
            <prop key="hibernate.cache.use_query_cache">false</prop>
            <prop key="hibernate.hbm2ddl.auto">update</prop>
        </props>
    </property>
</bean>

<bean id="hibernateDataSource" class="org.openspaces.persistency.hibernate.HibernateExternalDataSource">
    <property name="sessionFactory" ref="sessionFactory"/>
    <property name="initialLoadBatchSize" value="20000"/>
</bean>

<bean id="space" class="org.openspaces.core.space.UrlSpaceFactoryBean">
    <property name="url" value="/./space" />
    <property name="scheam" value="persistent" />
    <property name="externalDataSource" ref="hibernateDataSource" />
    <property name="properties">
        <props>
            <prop key="cluster-config.cache-loader.external-data-source">true</prop>
            <prop key="cluster-config.cache-loader.central-data-source">true</prop>
        </props>
    </property>
</bean>

The external-data-source element within the persistent schema allows for further configuration of the external data source. The values can be injected using the properties tag within the Space tag using the "xpath" notation.

GigaSpaces 6.5 Documentation Contents (Current Page in Bold)

Middleware Capabilities

Configuration and Management

Add GigaSpaces wiki search to your browser search engines!
_{(works on Firefox 2 and Internet Explorer 7)}

Labels

product-xap-65