here is my rmdbs integration server config
<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:util="http://www.springframework.org/schema/util" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util.xsd"> <bean id="placeholderConfig" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> <property name="location" value="classpath:secret.properties"/> </bean> <bean id="dsSQLServer_Sustainanalytics" class="com.microsoft.sqlserver.jdbc.SQLServerDataSource"> <property name="URL" value="${dsSQLServer_Sustainanalytics.jdbc.url}"/> <property name="user" value="${dsSQLServer_Sustainanalytics.jdbc.username}"/> <property name="password" value="${dsSQLServer_Sustainanalytics.jdbc.password}"/> </bean> <bean class="org.apache.ignite.configuration.IgniteConfiguration"> <property name="igniteInstanceName" value="stoxx"/> <property name="discoverySpi"> <bean class="org.apache.ignite.spi.discovery.tcp.TcpDiscoverySpi"> <property name="ipFinder"> <bean class="org.apache.ignite.spi.discovery.tcp.ipfinder.vm.TcpDiscoveryVmIpFinder"> <property name="addresses"> <list> <value>127.0.0.1:47500..47510</value> </list> </property> </bean> </property> </bean> </property> <property name="dataStorageConfiguration"> <bean class="org.apache.ignite.configuration.DataStorageConfiguration"> <property name="defaultDataRegionConfiguration"> <bean class="org.apache.ignite.configuration.DataRegionConfiguration"> <property name="maxSize" value="1048576000"/> </bean> </property> </bean> </property> <property name="cacheConfiguration"> <list> <bean class="org.apache.ignite.configuration.CacheConfiguration"> <property name="name" value="COMPLIANCESUMMARYCACHE"/> <property name="cacheMode" value="PARTITIONED"/> <property name="atomicityMode" value="ATOMIC"/> <property name="queryDetailMetricsSize" value="50"/> <property name="cacheStoreFactory"> <bean class="org.apache.ignite.cache.store.jdbc.CacheJdbcPojoStoreFactory"> <property name="dataSourceBean" value="dsSQLServer_Sustainanalytics"/> <property name="dialect"> <bean class="org.apache.ignite.cache.store.jdbc.dialect.SQLServerDialect"> </bean> </property> <property name="types"> <list> <bean class="org.apache.ignite.cache.store.jdbc.JdbcType"> <property name="cacheName" value="COMPLIANCESUMMARYCACHE"/> <property name="keyType" value="com.gmail.waynetheron.model.ComplianceSummaryKey"/> <property name="valueType" value="com.gmail.waynetheron.model.ComplianceSummary"/> <property name="databaseSchema" value="SustainAnalytics"/> <property name="databaseTable" value="Compliance_Summary"/> <property name="keyFields"> <list> <bean class="org.apache.ignite.cache.store.jdbc.JdbcTypeField"> <constructor-arg> <util:constant static-field="java.sql.Types.INTEGER"/> </constructor-arg> <constructor-arg value="companyId"/> <constructor-arg value="int"/> <constructor-arg value="companyId"/> </bean> </list> </property> <property name="valueFields"> <list> <bean class="org.apache.ignite.cache.store.jdbc.JdbcTypeField"> <constructor-arg> <util:constant static-field="java.sql.Types.INTEGER"/> </constructor-arg> <constructor-arg value="companyId"/> <constructor-arg value="int"/> <constructor-arg value="companyid"/> </bean> <bean class="org.apache.ignite.cache.store.jdbc.JdbcTypeField"> <constructor-arg> <util:constant static-field="java.sql.Types.VARCHAR"/> </constructor-arg> <constructor-arg value="Compliance_Summary_Item"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="complianceSummaryItem"/> </bean> <bean class="org.apache.ignite.cache.store.jdbc.JdbcTypeField"> <constructor-arg> <util:constant static-field="java.sql.Types.VARCHAR"/> </constructor-arg> <constructor-arg value="Compliance_Summary_Value"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="complianceSummaryValue"/> </bean> <bean class="org.apache.ignite.cache.store.jdbc.JdbcTypeField"> <constructor-arg> <util:constant static-field="java.sql.Types.DATE"/> </constructor-arg> <constructor-arg value="Record_Valid_From"/> <constructor-arg value="java.sql.Date"/> <constructor-arg value="recordValidFrom"/> </bean> <bean class="org.apache.ignite.cache.store.jdbc.JdbcTypeField"> <constructor-arg> <util:constant static-field="java.sql.Types.DATE"/> </constructor-arg> <constructor-arg value="Record_Valid_To"/> <constructor-arg value="java.sql.Date"/> <constructor-arg value="recordValidTo"/> </bean> </list> </property> </bean> </list> </property> </bean> </property> <property name="readThrough" value="true"/> <property name="writeThrough" value="true"/> <property name="queryEntities"> <list> <bean class="org.apache.ignite.cache.QueryEntity"> <property name="keyType" value="com.gmail.waynetheron.model.ComplianceSummaryKey"/> <property name="valueType" value="com.gmail.waynetheron.model.ComplianceSummary"/> <property name="fields"> <map> <entry key="companyid" value="java.lang.Integer"/> <entry key="complianceSummaryItem" value="java.lang.String"/> <entry key="complianceSummaryValue" value="java.lang.String"/> <entry key="recordValidFrom" value="java.sql.Date"/> <entry key="recordValidTo" value="java.sql.Date"/> </map> </property> <property name="indexes"> <list> <bean class="org.apache.ignite.cache.QueryIndex"> <property name="name" value="Cl_Compliance_Summary"/> <property name="indexType" value="SORTED"/> <property name="fields"> <map> <entry key="companyid" value="false"/> <entry key="complianceSummaryItem" value="false"/> <entry key="recordValidFrom" value="false"/> <entry key="recordValidTo" value="false"/> </map> </property> </bean> </list> </property> </bean> </list> </property> </bean> </list> </property> </bean> </beans> -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/