Update data failed with kettle.

2 posts / 0 new
Last post
HoytRen
HoytRen's picture
Offline
Last seen: 3 months 3 weeks ago
Joined: Apr 6 2014
Junior Boarder

Posts: 2

Hoyt Ren
Update data failed with kettle.

I have to turn on general log after creating new inifinidb tables, or I can't update data with kettle and the server return weird error message. Once the table start to work, It seems Ok that turn off the log.

 

What leading this wired problem?

 

Here is the details:

I start a new infinidb 4.5 instance, create a new db and a new table with infinidb engine. I can't use Pentaho Data Integration to update data in that table. I got a lot of weird error message when I try to insert or update. I believe the operation is correct because when I create the table with myisam engine, it works. When I tried update data with shell, the table works, but with kittle, the table doesn't. After I enable the genral log of mysql server, which log all of the mysql command and query, the error message is gone and everything works. Then I disabled the log, and the table still works. Then I create another new table, the thing happens again, and I have to repeat the solution.

 

 

HoytRen
HoytRen's picture
Offline
Last seen: 3 months 3 weeks ago
Joined: Apr 6 2014
Junior Boarder

Posts: 2

Hoyt Ren
The exception come out when

The exception come out when execute resultSet.next(). It seems relative to a the parameter 'useCursorFetch', kettle set it to true by default. After I delete the setting or set it to false. The problem is resolved. When I set it, I got the problem again. The differenc that I seem from infinidb server side, is that the sql really prepared in seperate step or not. But when I write a java class to test it, I can't represent the issue. no matter I set the useCursorFetch or not, here isn't any error, however it affect the execution as I said.