Hi Denis, Thanks for taking time to reply and sharing those links. I can confirm to you that I've read through them before and have been following them as well.
However as I read them again, I realised that it was anyway necessary to load the cache before executing the SELECT sql queries on top of a cache, now, would this hold true in the case of Spring Data as well ? (Very likely yes, but want to get the confirmation) If so, then are we expected to preload the cache on start up and only after that will the read-through property kick in to add the entries into the cache for the ones which are missing ? If my above understanding is correct then that explains why I was getting null results from the queries executed once the Spring boot is instantiated as the cache load on startup was not complete yet. Regards, Srikanta On Fri, Aug 21, 2020 at 6:47 PM Denis Magda <dma...@apache.org> wrote: > Hi Srikanta, > > You forgot to share the configuration. Anyway, I think it's clear what you > are looking for. > > Check this example showing how to configure CacheJdbcPojoStoreFactory > programmatically (click on the "Java" tab, by default the example shows the > XML version): > > https://www.gridgain.com/docs/latest/developers-guide/persistence/external-storage#cachejdbcpojostore > > Also, if you need to import an existing schema of a relational database > and turn it into the CacheJdbcPojoStore config, then this feature of Web > Console can be helpful: > > https://www.gridgain.com/docs/web-console/latest/automatic-rdbms-integration > > Finally, keep an eye on this Spring Data + Ignite tutorial that covers > other areas of the integration. You might have other questions and issue > going forward and the tutorial can help to address them quickly: > https://www.gridgain.com/docs/tutorials/spring/spring-ignite-tutorial > > - > Denis > > > On Fri, Aug 21, 2020 at 9:09 AM Srikanta Patanjali <p.srika...@gmail.com> > wrote: > >> I'm trying to integrate a Spring data project (without JPA) with Ignite >> and struggling to understand some basic traits. Would be very helpful if >> you can share some insights on the issue I'm facing. >> >> Currently the cache has been defined as below with the client node, this >> config is not present in the server node, gets created when the client node >> joins the cluster. The repositories are detected during the instantiation >> of the Spring Boot application. >> >> All the documentation including the official example repo of the Apache >> Ignite does not pass in the data source but instead cachConfig is set with >> the IndexedTypes. >> >> Question: Where should I pass on the DataSource object ? Should I create >> a CacheJdbcPojoStoreFactory and pass on the dataSource ? >> >> >> Thanks, >> Srikanta >> >
