Hello! So I have found this 'sqlEscapeAll' flag that you can try and set, with hopes that your problem will go away: <property name="sqlEscapeAll" value="true"/>
I have attached config file with this property already set, can you replace your own with this one, try again? Regards, -- Ilya Kasnacheev 2018-08-20 15:41 GMT+03:00 wt <waynethe...@gmail.com>: > That column with the : is also an issue but in SQL server you can either > quote columns in quotes or square braces. I would have expected Ignite to > generate code with quoted columns because even a simple space in the name > is > a problem in the current statement regardless of the column with : in it. > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
<?xml version="1.0" encoding="UTF-8"?> <!-- This file was generated by Ignite Web Console (08/20/2018, 10:32) --> <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"> <!-- Load external properties file. --> <bean id="placeholderConfig" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> <property name="location" value="classpath:secret.properties"/> </bean> <!-- Data source beans will be initialized from external properties file. --> <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="clientMode" value="true"/> <property name="igniteInstanceName" value="POC"/> <property name="discoverySpi"> <bean class="org.apache.ignite.spi.discovery.tcp.TcpDiscoverySpi"> <property name="ipFinder"> <bean class="org.apache.ignite.spi.discovery.tcp.ipfinder.multicast.TcpDiscoveryMulticastIpFinder"> <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="524288000"/> <property name="persistenceEnabled" value="true"/> </bean> </property> </bean> </property> <property name="cacheConfiguration"> <list> <bean class="org.apache.ignite.configuration.CacheConfiguration"> <property name="name" value="CompanyCache"/> <property name="cacheMode" value="PARTITIONED"/> <property name="atomicityMode" value="ATOMIC"/> <property name="cacheStoreFactory"> <bean class="org.apache.ignite.cache.store.jdbc.CacheJdbcPojoStoreFactory"> <property name="sqlEscapeAll" value="true"/> <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="CompanyCache"/> <property name="keyType" value="CompanyKey"/> <property name="valueType" value="Company"/> <property name="databaseSchema" value="SustainAnalytics"/> <property name="databaseTable" value="Company"/> <property name="keyFields"> <list> <bean class="org.apache.ignite.cache.store.jdbc.JdbcTypeField"> <constructor-arg> <util:constant static-field="java.sql.Types.VARCHAR"/> </constructor-arg> <constructor-arg value="CompanyId"/> <constructor-arg value="java.lang.String"/> <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.VARCHAR"/> </constructor-arg> <constructor-arg value="CompanyId"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="companyid"/> </bean> <bean class="org.apache.ignite.cache.store.jdbc.JdbcTypeField"> <constructor-arg> <util:constant static-field="java.sql.Types.NVARCHAR"/> </constructor-arg> <constructor-arg value="CompanyName"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="companyname"/> </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="Country"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="country"/> </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="Region"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="region"/> </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="Peer Group"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="peerGroup"/> </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="Company Type"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="companyType"/> </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="ExtractionDate"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="extractiondate"/> </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="Exchange:Ticker"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="fieldExchange:ticker"/> </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="Exchange"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="exchange"/> </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="Ticker"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="ticker"/> </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="Legal Entity Identifier"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="legalEntityIdentifier"/> </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="Bloomberg Ticker"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="bloombergTicker"/> </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="Bloomberg Global Composite ID"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="bloombergGlobalCompositeId"/> </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="Bloomberg Global ID"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="bloombergGlobalId"/> </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="Bloomberg Share Class BBGID"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="bloombergShareClassBbgid"/> </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="Bloomberg Unique ID"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="bloombergUniqueId"/> </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="ISIN"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="isin"/> </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="CUSIP"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="cusip"/> </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="Entity Type"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="entityType"/> </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="Research Entity ID"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="researchEntityId"/> </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="Research Entity Name"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="researchEntityName"/> </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="Research type"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="researchType"/> </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="CompanyKey"/> <property name="valueType" value="Company"/> <property name="fields"> <map> <entry key="companyid" value="java.lang.String"/> <entry key="companyname" value="java.lang.String"/> <entry key="country" value="java.lang.String"/> <entry key="region" value="java.lang.String"/> <entry key="peerGroup" value="java.lang.String"/> <entry key="companyType" value="java.lang.String"/> <entry key="extractiondate" value="java.lang.String"/> <entry key="fieldExchange:ticker" value="java.lang.String"/> <entry key="exchange" value="java.lang.String"/> <entry key="ticker" value="java.lang.String"/> <entry key="legalEntityIdentifier" value="java.lang.String"/> <entry key="bloombergTicker" value="java.lang.String"/> <entry key="bloombergGlobalCompositeId" value="java.lang.String"/> <entry key="bloombergGlobalId" value="java.lang.String"/> <entry key="bloombergShareClassBbgid" value="java.lang.String"/> <entry key="bloombergUniqueId" value="java.lang.String"/> <entry key="isin" value="java.lang.String"/> <entry key="cusip" value="java.lang.String"/> <entry key="entityType" value="java.lang.String"/> <entry key="researchEntityId" value="java.lang.String"/> <entry key="researchEntityName" value="java.lang.String"/> <entry key="researchType" 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_Company"/> <property name="indexType" value="SORTED"/> <property name="fields"> <map> <entry key="companyid" 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>
<?xml version="1.0" encoding="UTF-8"?> <!-- This file was generated by Ignite Web Console (08/20/2018, 10:32) --> <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"> <!-- Load external properties file. --> <bean id="placeholderConfig" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> <property name="location" value="classpath:secret.properties"/> </bean> <!-- Data source beans will be initialized from external properties file. --> <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="POC"/> <property name="discoverySpi"> <bean class="org.apache.ignite.spi.discovery.tcp.TcpDiscoverySpi"> <property name="ipFinder"> <bean class="org.apache.ignite.spi.discovery.tcp.ipfinder.multicast.TcpDiscoveryMulticastIpFinder"> <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="524288000"/> <property name="persistenceEnabled" value="true"/> </bean> </property> </bean> </property> <property name="cacheConfiguration"> <list> <bean class="org.apache.ignite.configuration.CacheConfiguration"> <property name="name" value="CompanyCache"/> <property name="cacheMode" value="PARTITIONED"/> <property name="atomicityMode" value="ATOMIC"/> <property name="cacheStoreFactory"> <bean class="org.apache.ignite.cache.store.jdbc.CacheJdbcPojoStoreFactory"> <property name="sqlEscapeAll" value="true"/> <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="CompanyCache"/> <property name="keyType" value="CompanyKey"/> <property name="valueType" value="Company"/> <property name="databaseSchema" value="SustainAnalytics"/> <property name="databaseTable" value="Company"/> <property name="keyFields"> <list> <bean class="org.apache.ignite.cache.store.jdbc.JdbcTypeField"> <constructor-arg> <util:constant static-field="java.sql.Types.VARCHAR"/> </constructor-arg> <constructor-arg value="CompanyId"/> <constructor-arg value="java.lang.String"/> <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.VARCHAR"/> </constructor-arg> <constructor-arg value="CompanyId"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="companyid"/> </bean> <bean class="org.apache.ignite.cache.store.jdbc.JdbcTypeField"> <constructor-arg> <util:constant static-field="java.sql.Types.NVARCHAR"/> </constructor-arg> <constructor-arg value="CompanyName"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="companyname"/> </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="Country"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="country"/> </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="Region"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="region"/> </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="Peer Group"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="peerGroup"/> </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="Company Type"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="companyType"/> </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="ExtractionDate"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="extractiondate"/> </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="Exchange:Ticker"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="fieldExchange:ticker"/> </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="Exchange"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="exchange"/> </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="Ticker"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="ticker"/> </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="Legal Entity Identifier"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="legalEntityIdentifier"/> </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="Bloomberg Ticker"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="bloombergTicker"/> </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="Bloomberg Global Composite ID"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="bloombergGlobalCompositeId"/> </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="Bloomberg Global ID"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="bloombergGlobalId"/> </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="Bloomberg Share Class BBGID"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="bloombergShareClassBbgid"/> </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="Bloomberg Unique ID"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="bloombergUniqueId"/> </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="ISIN"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="isin"/> </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="CUSIP"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="cusip"/> </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="Entity Type"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="entityType"/> </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="Research Entity ID"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="researchEntityId"/> </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="Research Entity Name"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="researchEntityName"/> </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="Research type"/> <constructor-arg value="java.lang.String"/> <constructor-arg value="researchType"/> </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="CompanyKey"/> <property name="valueType" value="Company"/> <property name="fields"> <map> <entry key="companyid" value="java.lang.String"/> <entry key="companyname" value="java.lang.String"/> <entry key="country" value="java.lang.String"/> <entry key="region" value="java.lang.String"/> <entry key="peerGroup" value="java.lang.String"/> <entry key="companyType" value="java.lang.String"/> <entry key="extractiondate" value="java.lang.String"/> <entry key="fieldExchange:ticker" value="java.lang.String"/> <entry key="exchange" value="java.lang.String"/> <entry key="ticker" value="java.lang.String"/> <entry key="legalEntityIdentifier" value="java.lang.String"/> <entry key="bloombergTicker" value="java.lang.String"/> <entry key="bloombergGlobalCompositeId" value="java.lang.String"/> <entry key="bloombergGlobalId" value="java.lang.String"/> <entry key="bloombergShareClassBbgid" value="java.lang.String"/> <entry key="bloombergUniqueId" value="java.lang.String"/> <entry key="isin" value="java.lang.String"/> <entry key="cusip" value="java.lang.String"/> <entry key="entityType" value="java.lang.String"/> <entry key="researchEntityId" value="java.lang.String"/> <entry key="researchEntityName" value="java.lang.String"/> <entry key="researchType" 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_Company"/> <property name="indexType" value="SORTED"/> <property name="fields"> <map> <entry key="companyid" 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>