Hello! At this point I recommend debugging which statements are ran on Oracle and why they take long.
Also I have noticed: appDataSource - is it behind some kind of connection pool? I am afraid it is possible that this data source is single-threaded in the absense of connection pool, hence you might see contention. Regards, -- Ilya Kasnacheev 2018-07-18 20:48 GMT+03:00 Shailendrasinh Gohil < [email protected]>: > Here you go... > > <bean class="org.apache.ignite.configuration.CacheConfiguration"> > <property name="name" value="GeneratedProdIdCache" /> > <property name="cacheMode" value="PARTITIONED" /> > <property name="atomicityMode" value="TRANSACTIONAL" /> > <property name="partitionLossPolicy" value="READ_WRITE_SAFE"/> > > <property name="cacheStoreFactory"> > <bean > class="org.apache.ignite.cache.store.jdbc. > CacheJdbcPojoStoreFactory"> > <property name="dataSourceBean" > value="appDataSource" /> > <property name="dialect"> > <bean class="org.apache.ignite. > cache.store.jdbc.dialect.OracleDialect"> > </bean> > </property> > > <property name="types"> > <list> > <bean class="org.apache.ignite. > cache.store.jdbc.JdbcType"> > <property name="cacheName" > value="GeneratedProdIdCache" /> > <property name="keyType" > value="java.lang.String" /> > <property name="valueType" > > value="ignite.model.GeneratedProdId" /> > <property > name="databaseSchema" value="APPSCHEMA" /> > <property > name="databaseTable" value="GENERATED_PROD_ID" /> > > <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="PROD_ID" /> > > <constructor-arg value="java.lang.String" /> > > <constructor-arg value="prodId" /> > </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="PROD_ID" /> > > <constructor-arg value="java.lang.String" /> > > <constructor-arg value="prodId" /> > </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="PROD_ID_KEY" /> > > <constructor-arg value="java.lang.String" /> > > <constructor-arg value="prodIdKey" /> > </bean> > > </list> > </property> > </bean> > </list> > </property> > </bean> > </property> > > <property name="readThrough" value="true" /> > <property name="writeThrough" value="true" /> > <property name="writeBehindEnabled" value="true" /> > <property name="writeBehindFlushSize" value="2048" /> > <property name="writeBehindFlushFrequency" value="0" /> > <property name="writeBehindFlushThreadCount" value="1" /> > <property name="writeBehindBatchSize" value="512" /> > > <property name="queryEntities"> > <list> > <bean class="org.apache.ignite.cache.QueryEntity"> > <property name="keyType" > value="java.lang.String" /> > <property name="valueType" > value="ignite.model.GeneratedProdId" > /> > <property name="tableName" > value="GENERATED_PROD_ID" /> > <property name="keyFieldName" > value="prodId" /> > > <property name="keyFields"> > <list> > <value>prodId</value> > </list> > </property> > > <property name="fields"> > <map> > <entry key="prodId" > value="java.lang.String" /> > <entry key="prodIdKey" > value="java.lang.String" /> > </map> > </property> > > <property name="aliases"> > <map> > <entry key="prodId" > value="PROD_ID" /> > <entry key="prodIdKey" > value="PROD_ID_KEY" /> > </map> > </property> > > <property name="indexes"> > <list> > <bean > class="org.apache.ignite.cache.QueryIndex"> > <property > name="name" value="INDX_GNRTD_PROD_ID" /> > <property > name="indexType" value="FULLTEXT" /> > > <property > name="fields"> > <map> > > <entry key="prodId" value="true" /> > </map> > </property> > </bean> > </list> > </property> > </bean> > </list> > </property> > </bean> > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
