Re: insert/update/delete issue in Version 1.8

[Andrey Novikov]

Denis,

Ticket https://issues.apache.org/jira/browse/IGNITE-4622 was fixed in master
branch.



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/insert-update-delete-issue-in-Version-1-8-tp10244p10280.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: insert/update/delete issue in Version 1.8

[Denis Magda]

Please see below 

> On Jan 26, 2017, at 8:56 AM, minisoft_rm  wrote:
> 
> Hi Denis, thank you. it works.
> 
> I manually... added these line... something like "
> 
> Set keyFlds = new HashSet<>();
> keyFlds.add("pk");
> qryEntity.setKeyFields(keyFlds);
> 
> "
> 
> after that , no more exception there. I am wondering... so I reviewed the
> "model" section of web console. it generates everything for us, right? and I
> found it is a little strange...  
> 
> in WEB CONSOLE:
> the auto generated code is "
> qryEntity.setKeyFields(new JdbcTypeField(Types.BIGINT, "PK",
> long.class, "pk"));
> "
> in DOWNLOADED zip file, code is "
> type.setKeyFields(new JdbcTypeField(Types.BIGINT, "PK", long.class,
> "pk"));
> " the type is "JdbcType"... not the "qryEntity"
> 
> so is it a minor bug?
> 
> 
Yes, this is a bug. Thanks for reporting. The ticket is ready:
https://issues.apache.org/jira/browse/IGNITE-4622 


Andrey N, Alex K, please take a look at it.

> 
> after that, May I ask one more question the update sql returns no more
> exception, it is good. But, the data doesn't be udpatedin ignite and
> Db... do you have any comments? thanks :-)
> 
> 

This sounds weird and unbelievable :) Please share the code snippet that does 
the update and that validates that the data has been updated.

—
Denis

> 
> 
> --
> View this message in context: 
> http://apache-ignite-users.70518.x6.nabble.com/insert-update-delete-issue-in-Version-1-8-tp10244p10260.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: insert/update/delete issue in Version 1.8

[minisoft_rm]

Hi Denis, thank you. it works.

I manually... added these line... something like "

Set keyFlds = new HashSet<>();
keyFlds.add("pk");
qryEntity.setKeyFields(keyFlds);

"

after that , no more exception there. I am wondering... so I reviewed the
"model" section of web console. it generates everything for us, right? and I
found it is a little strange...  

in WEB CONSOLE:
 the auto generated code is "
 qryEntity.setKeyFields(new JdbcTypeField(Types.BIGINT, "PK",
long.class, "pk"));
"
in DOWNLOADED zip file, code is "
 type.setKeyFields(new JdbcTypeField(Types.BIGINT, "PK", long.class,
"pk"));
" the type is "JdbcType"... not the "qryEntity"

so is it a minor bug?



after that, May I ask one more question the update sql returns no more
exception, it is good. But, the data doesn't be udpatedin ignite and
Db... do you have any comments? thanks :-)




--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/insert-update-delete-issue-in-Version-1-8-tp10244p10260.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: insert/update/delete issue in Version 1.8

[Denis Magda]

Please double check this documentation section
https://apacheignite.readme.io/docs/dml#advanced-configuration 


If you have your custom key with multiple fields then key’s fields must be 
separated from value’s fields at the configuration level. The documentation 
section provides examples for this.

—
Denis

> On Jan 25, 2017, at 4:21 AM, minisoft_rm  wrote:
> 
> dear experts:
> I got exception - "Caused by: java.lang.IllegalStateException: Ownership
> flag not set for binary property. Have you set 'keyFields' property of
> QueryEntity in programmatic or XML configuration?
> "
> 
> when my code is following link of
> "https://apacheignite.readme.io/docs/jdbc-driver;.
> 
> part of my code like below"
> ...
> Class.forName("org.apache.ignite.IgniteJdbcDriver");
> this.conn =
> DriverManager.getConnection("jdbc:ignite:cfg://cache=CartentriesCache@file:///Users/i306576/hybris.xxx/hybris.6200.ignite18/hybris/bin/custom/ucs/resources/ignite-jdbc.xml");
>   
> final PreparedStatement stmt =getConn().prepareStatement("update cartentries
> set  p_quantity=21 where pk=8796093054977");
> stmt.executeUpdate();
> "
> 
> 
> I feel I followed the instructions... but why not successful? please advise.
> 
> 
> 
> --
> View this message in context: 
> http://apache-ignite-users.70518.x6.nabble.com/insert-update-delete-issue-in-Version-1-8-tp10244.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: insert/update/delete issue in Version 1.8

[Alexander Paschenko]

Hi,

Please show your configuration file (at least the section with
QueryEntities) or how you configure your cache programmatically.

- Alex

2017-01-25 15:21 GMT+03:00 minisoft_rm :
> dear experts:
> I got exception - "Caused by: java.lang.IllegalStateException: Ownership
> flag not set for binary property. Have you set 'keyFields' property of
> QueryEntity in programmatic or XML configuration?
> "
>
> when my code is following link of
> "https://apacheignite.readme.io/docs/jdbc-driver;.
>
> part of my code like below"
> ...
> Class.forName("org.apache.ignite.IgniteJdbcDriver");
> this.conn =
> DriverManager.getConnection("jdbc:ignite:cfg://cache=CartentriesCache@file:///Users/i306576/hybris.xxx/hybris.6200.ignite18/hybris/bin/custom/ucs/resources/ignite-jdbc.xml");
>
> final PreparedStatement stmt =getConn().prepareStatement("update cartentries
> set  p_quantity=21 where pk=8796093054977");
> stmt.executeUpdate();
> "
>
>
> I feel I followed the instructions... but why not successful? please advise.
>
>
>
> --
> View this message in context: 
> http://apache-ignite-users.70518.x6.nabble.com/insert-update-delete-issue-in-Version-1-8-tp10244.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.