Re: Error while writethrough operation in Ignite

[vkulichenko]

Dmitry,

I probably do not correctly understand what is wrong, but it feels like
something needs to be fixed anyway. If you agree, can you please move this
to dev list?

-Val



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/Error-while-writethrough-operation-in-Ignite-tp9696p9786.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Error while writethrough operation in Ignite

[dkarachentsev]

Val,

Of course it's possible, but why Ignite should restrict this case? Why not
to build such update request:
UPDATE table_name SET col1=1, col2=2, col3=3 WHERE (col1=1 AND col2=1 AND
col3=1) ?



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/Error-while-writethrough-operation-in-Ignite-tp9696p9773.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Error while writethrough operation in Ignite

[vkulichenko]

Dmitry,

Can this be detected and reported with a better exception? Sounds like a
usability issue to me.

-Val



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/Error-while-writethrough-operation-in-Ignite-tp9696p9760.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Error while writethrough operation in Ignite

[dkarachentsev]

That happens because key and value fields mapped to the same DB columns. You
should use at least one unique column for value mapping. 

Ignite throws away all fields from value that intersect with key fields.



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/Error-while-writethrough-operation-in-Ignite-tp9696p9735.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Error while writethrough operation in Ignite

[rishi007bansod]

Following are my files 
New_order_error.rar
 
 

I can read through from this new order database table but I am unable to
write to it



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/Error-while-writethrough-operation-in-Ignite-tp9696p9729.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Error while writethrough operation in Ignite

[dkarachentsev]

Could you please share a simple reproducer?



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/Error-while-writethrough-operation-in-Ignite-tp9696p9716.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Error while writethrough operation in Ignite

[rishi007bansod]

Ignite version 1.7
I am using Ojdbc version 7. 

Following is the cache config file I am using
CacheConfig.java
  



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/Error-while-writethrough-operation-in-Ignite-tp9696p9703.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Error while writethrough operation in Ignite

[Alexey Kuznetsov]

Hi!

1) What version of Ignite are you using?
2) Oracle version? Oracle JDBC driver version?
3) It is possible to share with us Table create script?
We will try to reproduce. I see in logs: Caused by:
java.sql.SQLSyntaxErrorException:
ORA-00927: missing equal sign
May be there a bug in OracleDialect.

On Thu, Dec 22, 2016 at 7:22 PM, rishi007bansod 
wrote:

> But I have used CacheConfig file generated by schema import, what might be
> problem
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/Error-while-writethrough-operation-
> in-Ignite-tp9696p9701.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>



-- 
Alexey Kuznetsov

Re: Error while writethrough operation in Ignite

[rishi007bansod]

But I have used CacheConfig file generated by schema import, what might be
problem



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/Error-while-writethrough-operation-in-Ignite-tp9696p9701.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.