Check a series of videos "Ignite Web Console - Automatic RDBMS Integration" showing how to import an RDBMS schema and generate code/configuration templates with Web Console: https://ignite.apache.org/screencasts.html
- Denis On Sun, Feb 2, 2020 at 11:30 AM nithin91 < nithinbharadwaj.govindar...@franklintempleton.com> wrote: > Hi , > > We are doing a POC on using the Ignite in-memory capabilities for our > application and as a part of this > we are trying to load the data from one of the Oracle Tables to ignite > cache using > CacheJdbcPojoStoreFactory. > > > Steps followed to load the data from Oracle to Ignite cache: > > 1. We have installed the Ignite ( with Version 2.7.6) in Unix Server and > started the ignite node > by executing the ignite.sh file in UNIX. > > 2. Now i have written a java code using eclipse as my IDE in my local > windows system and trying to > connect to the Ignite node running on UNIX by specifying the UNIX > Server IP details in the > "discoveryspi" property corresponding to Ignite Configuration in the > bean file. > > 3. In addition to the server details, bean file has details related to > cache configuration,cache store > factory,data source bean,Query Entities and JDBC Types and has client > mode set to "true". > > 4. Now we are trying to load the cache by executing the below code > > public class ProductLoadCache { > > public static void main(String[] args) throws Exception { > try (Ignite ignite = Ignition.start("Ignite-Client.xml")) { > System.out.println(">>> Loading caches..."); > > System.out.println(">>> Loading cache: ProductLoadCache"); > ignite.cache("ProductLoadCache").loadCache(null); > > System.out.println(">>> ProductLoadCacheis loaded"); > > > } > } > > > 5. Upon execution of the above code i get an error like "Failed to load > bean in application context > [beanName=dataSource] in ignite.Spring bean doesn't exist". > > 6. I encountered similar error while running the same code in local > mode(i.e by specifying the local > IP address details in the "discoveryspi" property corresponding to > Ignite Configuration in the bean > file) but later identified that Oracle jdbc driver is missing and > added the Oracle Jdbc Jar which is > available in my local system as an "external jar" to my project in > eclipse.After doing this the issue > got resolved and i am to load the data into ignite cache by running > ignite in local mode. > > Now after starting the node in unix, i am again facing the same > error. > > Can you please let me know is anything additional needed to run the > code in unix or is it because it is > not able to find the Oracle JDBC jar in unix. If this is the issue > please let me know , what are available > approaches to fix the issue. > > > > > > > > > > > > > > > > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >