Re: Scheduling Cache Refresh

Thanks for the inputs.It is really helpful. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Scheduling Cache Refresh

Hello! You will need to write your own code for that and expose it via compute tasks or service. Then you can invoke these via REST. Regards, -- Ilya Kasnacheev вт, 19 мая 2020 г. в 20:52, nithin91 < nithinbharadwaj.govindar...@franklintempleton.com>: > Hi > > Thanks For the inputs. > > To th

Re: Scheduling Cache Refresh

Hi Can anyone please help me with your inputs -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Scheduling Cache Refresh

Hi Thanks For the inputs. To the question is this way of refreshing the cache is efficient, i mean refreshing the cache using the following process. We have created a REST-API using Spring Boot which refreshes a particular cache when a GET Request is triggered. *Sample REST-API Url :* http:/

Re: Scheduling Cache Refresh

Hello! See below inline: пт, 15 мая 2020 г. в 23:59, nithin91 < nithinbharadwaj.govindar...@franklintempleton.com>: > Hi > > Although this seems to be working. > I have following queries with this approach.Can you please > provide your inputs/suggestions. > > > > We are g

Re: Scheduling Cache Refresh

Hi Can anyone help me by providing inputs to the questions posted in my previous message. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Scheduling Cache Refresh

Hi Issue got resolved after doing the following changes. Attached you the updated code,client.xml(will be in src/resources folder) and pom.xml file. srcandpomupdated.zip 1. Removed the following dependenc

Re: Scheduling Cache Refresh

org.apache.ignite.IgniteException: Spring application context resource is not injected. at org.apache.ignite.cache.store.jdbc.CacheJdbcPojoStoreFactory.create(CacheJdbcPojoStoreFactory.java:171) Take a look at the source: https://github.com/apache/ignite/blob/feace547f83181853ca6db8626ab9

Re: Scheduling Cache Refresh

Please find below the log info . ___ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' || .__|_| |_|_| |_\__, | / / / / =|_|==|___/=/_/_/_/ :: Spring Boot

Re: Scheduling Cache Refresh

can you share the server logs. turn on debug for the appropriate package: org/apache/ignite/cache/store/jdbc https://apacheignite.readme.io/docs/logging What is the behavior you are getting? No logs related to this at all. you should be getting the following: Start loading entries from db us

Re: Scheduling Cache Refresh

Hi Actually the Bean File which contains the Cache Store Factory Details and Cache Configuration Details is deployed in Linux Server on which the Ignite Instance is running.I am try to connect to the ignite instance running on the Linux Server from my local machine. PFA for the bean file that

Re: Scheduling Cache Refresh

Hi, loadCache(..) is designed to load the cache from a 3rd party store. you are not setting the cache factory in your app. See: https://apacheignite.readme.io/docs/3rd-party-store#rdbms-integration example: https://github.com/apache/ignite/blob/master/examples/src/main/java/org/apa

Re: Scheduling Cache Refresh

Hi Attached link is at the end of post.However i am attaching it again here. srcandpom.zip Please let me know in case of any difficulties while opening the attachment. -- Sent from: http://apache-ignite-users.70518.x6

Re: Scheduling Cache Refresh

Hello! Unfortunately I don't see any attachment to your message. Can you please share a link? Regards, -- Ilya Kasnacheev чт, 14 мая 2020 г. в 10:09, nithin91 < nithinbharadwaj.govindar...@franklintempleton.com>: > Hi > > Attached the Sample Spring Boot Application that i am running in my loc

Re: Scheduling Cache Refresh

Hi Attached the Sample Spring Boot Application that i am running in my local machine to connect to ignite cluster deployed in Unix as a client node and refreshes the cache when ever a GET Request is made. Facing the following error.Can you please help me in resolving the errors *org.apache.igni

Re: Scheduling Cache Refresh

* But this apprach isn't working because JDBC POJO method ignite.cache("CacheName").loadCache(null,"java.lang.String","CustomSql") is not available from Spring Boot.* ignite.cache("cacheName").loadCache is located here: https://ignite.apache.org/releases/latest/javadoc/org/apache/ignite/I

Scheduling Cache Refresh

Hi , We are using Ignite as a caching layer and loading the data from Oracle to Ignite using JDBC POJO method ignite.cache("CacheName").loadCache(null,"java.lang.String","CustomSql"). Now we want to schedule the refresh in such a way that whenever the job that updates the Oracle Table has complet

Re: Scheduling Cache Refresh using Ignite

Hi Nithin, You face current message because your client lost the connection to the server. It tries to get the acknowledge message on some operation (I guess it should be some cache operation). You can see that IgniteClientDisconnectedException was thrown. In this case, you can get the recon

Re: Scheduling Cache Refresh using Ignite

Hi I am unable to attach any file as a result of which i pasted the code and bean file in my previous messages. Following is error i get. Feb 13, 2020 11:34:40 AM org.apache.ignite.logger.java.JavaLogger error SEVERE: Failed to send message: null java.io.IOException: Failed to get acknowledge f

Re: Scheduling Cache Refresh using Ignite

Hi, Can you please attach the full logs with the mentioned exception? BTW I don't see any attaches in the previous message (probably user list can't do it). BR, Andrei 2/13/2020 3:44 PM, nithin91 пишет: Attached the bean file used -- Sent from: http://apache-ignite-users.70518.x6.nabble.

Re: Scheduling Cache Refresh using Ignite

Following is the java code that loads the cache. package Load; import java.sql.Types; import org.apache.ignite.Ignite; import org.apache.ignite.IgniteCache; import org.apache.ignite.Ignition; import org.apache.ignite.cache.CacheAtomicityMode; import org.apache.ignite.cache.store.

Re: Scheduling Cache Refresh using Ignite

Attached the bean file used -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Scheduling Cache Refresh using Ignite

Thanks aealexsandrov. This information is very useful. Also i have one more query. Currently as a part of POC, installed Ignite in UNIX and trying to load the data from Oracle DB to Ignite Cache using Cache JDBC Pojo Store. As a part of this process, bean file is custom configured

Re: Scheduling Cache Refresh using Ignite

Hi, Please read my comments: 1)Ignite generally doesn't support changing of the cache configuration without re-creation of the the cache. But for SQL caches that were created via QueryEntity or CREATE TABLE you can add and remove the columns using ALTER TABLE commands: https://apacheignite-

Scheduling Cache Refresh using Ignite

Hi We are doing a a POC on exploring the Ignite in memory capabilities and building a rest api on top of it using node express. Currently as a part of POC, installed Ignite in UNIX and trying to load the data from Oracle DB to Ignite Cache using Cache JDBC Pojo Store.