any known issue with oracle and spring-ignite-data

classic Classic list List threaded Threaded
4 messages Options
himanshu himanshu
Reply | Threaded
Open this post in threaded view
|

any known issue with oracle and spring-ignite-data

Hi Team,

I was working on sample app for loading composite key, when I connect to
mysql everything works fine when I do the same with oracle, read through is
not working.

I am able to load cache but even after that when I do cache.get or
repository.findOne it is not fetching results. any help appreciated



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
himanshu himanshu
Reply | Threaded
Open this post in threaded view
|

Re: any known issue with oracle and spring-ignite-data

Additional Info.
When I do load cache it is loading all data, when I am doing to web console
to test queries I noticed

select  * from table where itemnId='abcdef' AND *storeId=0058*;

works while query below does not work

select  * from table where itemnId='abcdef' AND *storeId='0058'*;

I have same configuration for itemId and storeId so ideally it should work
for second case also, storeId and itemId both are string




--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
aealexsandrov aealexsandrov
Reply | Threaded
Open this post in threaded view
|

Re: any known issue with oracle and spring-ignite-data

Hi,

Can you attach your cache configuration for your table that contains the
itemId and storeId fields?

BR,
Andrei



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
himanshu himanshu
Reply | Threaded
Open this post in threaded view
|

Re: any known issue with oracle and spring-ignite-data

I am able to figure out the problem,

in DB my store id column is a char type and it is padded with 4 spaces since
data is only 4 chars. when it was loaded in cache somehow that padding was
removed and when I am querying it is not working. I was under assumption
ignite will handle this padding automatically.



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/