ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Igor Sapego <isap...@gridgain.com>
Subject Re: Load data to cache
Date Tue, 28 Mar 2017 14:05:49 GMT
Seems like you have not set dataSource bean for your store
so it does not know how to establish connection to your database.

I believe, you need add dataSource bean (javax.sql.DataSource)
for your store.

Best Regards,
Igor

On Tue, Mar 28, 2017 at 3:43 PM, kavitha <kavithamrgsn@gmail.com> wrote:

> javax.cache.integration.CacheLoaderException: Failed to load cache:
> NORTHWND
>         at
> org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore.loadCache(
> CacheAbstractJdbcStore.java:848)
>         at
> org.apache.ignite.internal.processors.cache.store.
> GridCacheStoreManagerAdapter.loadCache(GridCacheStoreManagerAdapter.
> java:513)
>         at
> org.apache.ignite.internal.processors.cache.distributed.
> dht.GridDhtCacheAdapter.localLoadCache(GridDhtCacheAdapter.java:499)
>         at
> org.apache.ignite.internal.processors.cache.GridCacheProxyImpl.
> localLoadCache(GridCacheProxyImpl.java:228)
>         at
> org.apache.ignite.internal.processors.cache.GridCacheAdapter$LoadCacheJob.
> localExecute(GridCacheAdapter.java:5635)
>         at
> org.apache.ignite.internal.processors.cache.GridCacheAdapter$
> LoadCacheJobV2.localExecute(GridCacheAdapter.java:5684)
>         at
> org.apache.ignite.internal.processors.cache.GridCacheAdapter$
> TopologyVersionAwareJob.execute(GridCacheAdapter.java:6355)
>         at
> org.apache.ignite.compute.ComputeJobAdapter.call(
> ComputeJobAdapter.java:132)
>         at
> org.apache.ignite.internal.processors.closure.GridClosureProcessor$C2V2.
> execute(GridClosureProcessor.java:2056)
>         at
> org.apache.ignite.internal.processors.job.GridJobWorker$
> 2.call(GridJobWorker.java:560)
>         at
> org.apache.ignite.internal.util.IgniteUtils.wrapThreadLoader(IgniteUtils.
> java:6618)
>         at
> org.apache.ignite.internal.processors.job.GridJobWorker.
> execute0(GridJobWorker.java:554)
>         at
> org.apache.ignite.internal.processors.job.GridJobWorker.
> body(GridJobWorker.java:483)
>         at
> org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
>         at
> org.apache.ignite.internal.processors.job.GridJobProcessor.
> processJobExecuteRequest(GridJobProcessor.java:1114)
>         at
> org.apache.ignite.internal.processors.task.GridTaskWorker.sendRequest(
> GridTaskWorker.java:1382)
>         at
> org.apache.ignite.internal.processors.task.GridTaskWorker.
> processMappedJobs(GridTaskWorker.java:644)
>         at
> org.apache.ignite.internal.processors.task.GridTaskWorker.body(
> GridTaskWorker.java:536)
>         at
> org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
>         at
> org.apache.ignite.internal.processors.task.GridTaskProcessor.startTask(
> GridTaskProcessor.java:679)
>         at
> org.apache.ignite.internal.processors.task.GridTaskProcessor.execute(
> GridTaskProcessor.java:403)
>         at
> org.apache.ignite.internal.processors.closure.GridClosureProcessor.
> callAsync(GridClosureProcessor.java:418)
>         at
> org.apache.ignite.internal.processors.closure.GridClosureProcessor.
> callAsync(GridClosureProcessor.java:391)
>         at
> org.apache.ignite.internal.processors.cache.GridCacheAdapter.
> globalLoadCacheAsync(GridCacheAdapter.java:3674)
>         at
> org.apache.ignite.internal.processors.cache.GridCacheAdapter.
> globalLoadCache(GridCacheAdapter.java:3613)
>         at
> org.apache.ignite.internal.processors.cache.IgniteCacheProxy.loadCache(
> IgniteCacheProxy.java:390)
>         at
> org.apache.ignite.internal.processors.platform.cache.
> PlatformCache.loadCache0(PlatformCache.java:833)
>         at
> org.apache.ignite.internal.processors.platform.cache.PlatformCache.
> processInStreamOutLong(PlatformCache.java:456)
>         at
> org.apache.ignite.internal.processors.platform.PlatformTargetProxyImpl.
> inStreamOutLong(PlatformTargetProxyImpl.java:61)
> Caused by: class org.apache.ignite.IgniteCheckedException: Failed to load
> cache
>         at
> org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$1.
> call(CacheAbstractJdbcStore.java:467)
>         at
> org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$1.
> call(CacheAbstractJdbcStore.java:430)
>         at java.util.concurrent.FutureTask$Sync.innerRun(
> FutureTask.java:334)
>         at java.util.concurrent.FutureTask.run(FutureTask.java:166)
>         at
> java.util.concurrent.ThreadPoolExecutor.runWorker(
> ThreadPoolExecutor.java:1110)
>         at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(
> ThreadPoolExecutor.java:603)
>         at java.lang.Thread.run(Thread.java:722)
> Caused by: java.sql.SQLException: The url cannot be null
>         at java.sql.DriverManager.getConnection(DriverManager.java:564)
>         at java.sql.DriverManager.getConnection(DriverManager.java:190)
>         at
> org.springframework.jdbc.datasource.DriverManagerDataSource.
> getConnectionFromDriverManager(DriverManagerDataSource.java:153)
>         at
> org.springframework.jdbc.datasource.DriverManagerDataSource.
> getConnectionFromDriver(DriverManagerDataSource.java:144)
>         at
> org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.
> getConnectionFromDriver(AbstractDriverBasedDataSource.java:155)
>         at
> org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.
> getConnection(AbstractDriverBasedDataSource.java:120)
>         at
> org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore.openConnection(
> CacheAbstractJdbcStore.java:326)
>         at
> org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$1.
> call(CacheAbstractJdbcStore.java:437)
>         ... 6 more
>
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/Load-data-to-cache-tp11394p11500.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>

Mime
View raw message