I’m having trouble adding records to an oracle database that has an Id column which gets it’s values from a sequence.
… I use form (myFrom) and a dataProcessor (myDP) like so…
myDP = new dataProcessor(“FormConnector.do”);
myDP.init(myForm);
… For addition of records I simply clear the form:
myForm.clear();
… When I hit save I run:
myForm.save();
… which sould cause the DP to run …
myDP.attachEvent(“onAfterUpdate”,function(sid,action,tid,xml_node){
if(action==“inserted”){
dpg.ignore(function(){
myGrid.addRow(tid,
[myForm.getItemValue(“DEFINIZIONE”)]
,0);
myGrid.selectRowById(tid,false,false,true);
});
} else {
myyGrid.cellById(sid, 0).setValue(myForm.getItemValue(“DEFINIZIONE”));
}
});
… My connector code is simply:
Connection conn = ( new DataBaseConnection()).getConnection();
FormConnector c = new FormConnector(conn, DBType.Oracle);
c.enable_log(“/logs/CnctTipiGiunteForm.log”, true);
DBDataWrapper sql = (DBDataWrapper)c.sql;
sql.sequence(“TIPOGIUNTA_SEQ.nextVal”);
c.render_table(“TIPI_GIUNTE”, “TIPOGIUNTA_ID”, “DEFINIZIONE”);
… But when I try to save I get the dreaded:
====================================
Log started, Fri Apr 12 16:31:48 CEST 2013
id parameter was missed
Done in : 60ms