You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by afedotov <al...@gmail.com> on 2017/05/27 07:30:50 UTC
Re: Unable to connect and load data from Oracle, using Ignite V2.0
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...@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.
<jd...@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+s70518n1h65@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.
Re: Unable to connect and load data from Oracle, using Ignite V2.0
Posted by afedotov <al...@gmail.com>.
Hi.
Just in case, please try calling Class.forName ("oracle.jdbc.OracleDriver")
or
DriverManager.registerDriver (new oracle.jdbc.OracleDriver())
Kind regards,
Alex.
On Sat, May 27, 2017 at 5:18 PM, Pratham Joshi [via Apache Ignite Users] <
ml+s70518n13182h76@n6.nabble.com> wrote:
> Thanks for your reply @afedotov.
> I already have required jdbc jar file in my project's classpath. But still
> the error occurs.
>
> ------------------------------
> 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-tp13171p13182.html
> To start a new topic under Apache Ignite Users, email
> ml+s70518n1h65@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-tp13171p13184.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
Re: Unable to connect and load data from Oracle, using Ignite V2.0
Posted by Pratham Joshi <pr...@vrhythmstech.com>.
Thanks for your reply @afedotov.
I already have required jdbc jar file in my project's classpath. But still
the error occurs.
--
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-tp13171p13182.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.