Hello. Make sure you have a proper jar containing the driver on the classpath. The jar probably is something like ojdbc8.jar depending on the Oracle version you are using.
Kind regards, Alex 26 мая 2017 г. 5:15 PM пользователь "Pratham Joshi [via Apache Ignite Users]" <ml+s70518n13171...@n6.nabble.com> написал: <html> I am trying to configure and read data from existing oracle tables However I get error message while calling *ignite.loadCache();* Meaasge as ==*Failed to start store session:javax.cache.integration.CacheWriterException: Failed to start store session [tx=null] Caused by: java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@192.168.2. <jdbc%3Aoracle%3Athin%3A@192.168.2.>218:1521:xe at org.h2.jdbcx.JdbcDataSource.getJdbcConnection(JdbcDataSource.java:190) at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:351) at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:383) at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:226) at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:198) at org.apache.ignite.cache.store.jdbc.CacheJdbcStoreSessionListener.onSessionStart(CacheJdbcStoreSessionListener.java:112)* I have configured CacheStore for TempClass also as shown in https://apacheignite.readme.io/docs/persistent-store#cachestore <http://apacheignite.readme.io/docs/persistent-store#cachestore> Any help will be highly appreciated Following is my configuration CacheConfiguration<String, TempClass> cacheCfg = new CacheConfiguration<String, TempClass>(); cacheCfg.setName("RevSenseTest_CacheConfig"); IgniteConfiguration igniteConfig = new IgniteConfiguration(); Factory factory = FactoryBuilder.factoryOf(TempClassCacheStore.class); cacheCfg.setReadThrough(true); cacheCfg.setWriteThrough(true); cacheCfg.setIndexedTypes(String.class, TempClass.class); cacheCfg.setCacheStoreFactory(factory); cacheCfg. setCacheStoreSessionListenerFactories(new Factory() { @Override public CacheStoreSessionListener create() { CacheJdbcStoreSessionListener lsnr = new CacheJdbcStoreSessionListener(); lsnr.setDataSource( JdbcConnectionPool.create("jdbc:oracle:thin:@192.168.2.218:1521:xe", "test", "test")); return lsnr; } }); Ignite ignite = Ignition.start(igniteConfig); IgniteCache<String, TempClass> cache = ignite.getOrCreateCache(cacheCfg); cache.loadCache(null); SqlFieldsQuery sql = new SqlFieldsQuery("SELECT ID_, NAME_ FROM ACT_HI_TASKINST"); QueryCursor<List<?>> cursor = cache.query(sql); </html> ------------------------------ If you reply to this email, your message will be added to the discussion below: http://apache-ignite-users.70518.x6.nabble.com/Unable-to- connect-and-load-data-from-Oracle-using-Ignite-V2-0-tp13171.html To start a new topic under Apache Ignite Users, email ml+s70518n1...@n6.nabble.com To unsubscribe from Apache Ignite Users, click here <http://apache-ignite-users.70518.x6.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=1&code=YWxleGFuZGVyLmZlZG90b2ZmQGdtYWlsLmNvbXwxfC0xMzYxNTU0NTg=> . NAML <http://apache-ignite-users.70518.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Unable-to-connect-and-load-data-from-Oracle-using-Ignite-V2-0-tp13171p13181.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.
