I am using Kendo UI JSP. I tried Server paging and popup mode editing.
Kengo grid operates well in delete, update. But when I add record by popup editor and saves, Idx(Primary Key) field is not correctly updated.
idx PK field is generated by database trigger. It displays always "0" in grid, instead of server generated value.
How can I solve this problem. Idx must be updated by server generated value.
<kendo:grid name="grid" pageable="true" height="430px" culture="ko-KR" >
<kendo:grid-editable mode="popup" confirmation="true" />
<kendo:grid-toolbar>
<kendo:grid-toolbarItem name="create" />
</kendo:grid-toolbar>
<kendo:grid-columns>
<kendo:grid-column title="번호 " field="idx" width="20px" />
<kendo:grid-column title="제목" field="name" width="100px" />
<kendo:grid-column title="답변1" field="reply1" width="20px"/>
<kendo:grid-column title="답변2" field="reply2" width="20px"/>
<kendo:grid-column title="답변3" field="reply3" width="20px"/>
<kendo:grid-column title="답변4" field="reply4" width="20px"/>
<kendo:grid-column title="답변5" field="reply5" width="20px"/>
<kendo:grid-column title="답변6" field="reply6" width="20px"/>
<kendo:grid-column title=" " width="40px" >
<kendo:grid-column-command>
<kendo:grid-column-commandItem name="edit" />
<kendo:grid-column-commandItem name="destroy" />
</kendo:grid-column-command>
</kendo:grid-column>
</kendo:grid-columns>
<kendo:dataSource pageSize="20" serverPaging="true" serverFiltering="false" serverGrouping="false" serverSorting="false" >
<kendo:dataSource-transport>
<kendo:dataSource-transport-create url="${createUrl}" dataType="json" type="POST" contentType="application/json" />
<kendo:dataSource-transport-read url="${readUrl}" dataType="json" type="POST" contentType="application/json"/>
<kendo:dataSource-transport-update url="${updateUrl}" dataType="json" type="POST" contentType="application/json" />
<kendo:dataSource-transport-destroy url="${destroyUrl}" dataType="json" type="POST" contentType="application/json" />
<kendo:dataSource-transport-parameterMap>
function(options){return JSON.stringify(options);}
</kendo:dataSource-transport-parameterMap>
</kendo:dataSource-transport>
<kendo:dataSource-schema data="data" total="total" groups="data" >
<kendo:dataSource-schema-model id="idx">
<kendo:dataSource-schema-model-fields>
<kendo:dataSource-schema-model-field name="idx" type="number" editable="false" />
<kendo:dataSource-schema-model-field name="name" type="string" />
<kendo:dataSource-schema-model-field name="question1" type="string" />
<kendo:dataSource-schema-model-field name="question2" type="string" />
<kendo:dataSource-schema-model-field name="question3" type="string" />
<kendo:dataSource-schema-model-field name="question4" type="string" />
<kendo:dataSource-schema-model-field name="question5" type="string" />
<kendo:dataSource-schema-model-field name="question6" type="string" />
<kendo:dataSource-schema-model-field name="reply1" type="number" editable="false" />
<kendo:dataSource-schema-model-field name="reply2" type="number" editable="false" />
<kendo:dataSource-schema-model-field name="reply3" type="number" editable="false" />
<kendo:dataSource-schema-model-field name="reply4" type="number" editable="false" />
<kendo:dataSource-schema-model-field name="reply5" type="number" editable="false" />
<kendo:dataSource-schema-model-field name="reply6" type="number" editable="false" />
</kendo:dataSource-schema-model-fields>
</kendo:dataSource-schema-model>
</kendo:dataSource-schema>
</kendo:dataSource>
</kendo:grid>
Kengo grid operates well in delete, update. But when I add record by popup editor and saves, Idx(Primary Key) field is not correctly updated.
idx PK field is generated by database trigger. It displays always "0" in grid, instead of server generated value.
How can I solve this problem. Idx must be updated by server generated value.
<kendo:grid name="grid" pageable="true" height="430px" culture="ko-KR" >
<kendo:grid-editable mode="popup" confirmation="true" />
<kendo:grid-toolbar>
<kendo:grid-toolbarItem name="create" />
</kendo:grid-toolbar>
<kendo:grid-columns>
<kendo:grid-column title="번호 " field="idx" width="20px" />
<kendo:grid-column title="제목" field="name" width="100px" />
<kendo:grid-column title="답변1" field="reply1" width="20px"/>
<kendo:grid-column title="답변2" field="reply2" width="20px"/>
<kendo:grid-column title="답변3" field="reply3" width="20px"/>
<kendo:grid-column title="답변4" field="reply4" width="20px"/>
<kendo:grid-column title="답변5" field="reply5" width="20px"/>
<kendo:grid-column title="답변6" field="reply6" width="20px"/>
<kendo:grid-column title=" " width="40px" >
<kendo:grid-column-command>
<kendo:grid-column-commandItem name="edit" />
<kendo:grid-column-commandItem name="destroy" />
</kendo:grid-column-command>
</kendo:grid-column>
</kendo:grid-columns>
<kendo:dataSource pageSize="20" serverPaging="true" serverFiltering="false" serverGrouping="false" serverSorting="false" >
<kendo:dataSource-transport>
<kendo:dataSource-transport-create url="${createUrl}" dataType="json" type="POST" contentType="application/json" />
<kendo:dataSource-transport-read url="${readUrl}" dataType="json" type="POST" contentType="application/json"/>
<kendo:dataSource-transport-update url="${updateUrl}" dataType="json" type="POST" contentType="application/json" />
<kendo:dataSource-transport-destroy url="${destroyUrl}" dataType="json" type="POST" contentType="application/json" />
<kendo:dataSource-transport-parameterMap>
function(options){return JSON.stringify(options);}
</kendo:dataSource-transport-parameterMap>
</kendo:dataSource-transport>
<kendo:dataSource-schema data="data" total="total" groups="data" >
<kendo:dataSource-schema-model id="idx">
<kendo:dataSource-schema-model-fields>
<kendo:dataSource-schema-model-field name="idx" type="number" editable="false" />
<kendo:dataSource-schema-model-field name="name" type="string" />
<kendo:dataSource-schema-model-field name="question1" type="string" />
<kendo:dataSource-schema-model-field name="question2" type="string" />
<kendo:dataSource-schema-model-field name="question3" type="string" />
<kendo:dataSource-schema-model-field name="question4" type="string" />
<kendo:dataSource-schema-model-field name="question5" type="string" />
<kendo:dataSource-schema-model-field name="question6" type="string" />
<kendo:dataSource-schema-model-field name="reply1" type="number" editable="false" />
<kendo:dataSource-schema-model-field name="reply2" type="number" editable="false" />
<kendo:dataSource-schema-model-field name="reply3" type="number" editable="false" />
<kendo:dataSource-schema-model-field name="reply4" type="number" editable="false" />
<kendo:dataSource-schema-model-field name="reply5" type="number" editable="false" />
<kendo:dataSource-schema-model-field name="reply6" type="number" editable="false" />
</kendo:dataSource-schema-model-fields>
</kendo:dataSource-schema-model>
</kendo:dataSource-schema>
</kendo:dataSource>
</kendo:grid>