FNH Mappings with DB2 GeneratedBy Identity -

-

i trying map table identity key field. when try save error sql0803 duplicate key value specified

insert libpjk/audit (auditid, auditdate, userid, keys, valbefore, valafter, fieldid) values (default, ?, ?, ?, ?, ?, ?)

i'm thinking auditid should not appear in field list , value of default should not there either. don't know how this.

sql table creation:

create table libpjk.audit ( auditid integer not null generated identity     (start 1, increment 1), auditdate timestamp not null, userid char(10)    not null, fieldid integer    not null, keys varchar(50)   not null, valbefore varchar(50), valafter  varchar(50), constraint libpjk.pk_audit primary key(fieldid))

here's how auditid defined in audit class:

<required()> public overridable property auditid integer

here's mappings:

mybase.new() table("libpjk/audit") lazyload() id(function(x) x.auditid).column("auditid").generatedby.identity() references(function(x) x.auditfield).column("fieldid") map(function(x) x.timestamp).column("auditdate").not.nullable() map(function(x) x.userid).column("userid").not.nullable() map(function(x) x.keys).column("keys").not.nullable() map(function(x) x.value_before).column("valbefore") map(function(x) x.value_after).column("valafter")

thanks help


Comments

Post a Comment

Popular posts from this blog

shader - OpenGL Shadow Map -

-
i trying basic shadow map reason doesn't render properly. video of problem i render house using flat shader: int shadowmapwidth = window_size_x * (int)shadow_map_ratio; int shadowmapheight = window_size_y * (int)shadow_map_ratio; // rendering shadow texture. glactivetexture(gl_texture0); call_gl(glbindtexture(gl_texture_2d, shadowtexture)); // bind framebuffer. call_gl(glbindframebuffer(gl_framebuffer, shadowfbo)); //clear call_gl(glclear(gl_depth_buffer_bit)); call_gl(glviewport(0, 0, shadowmapwidth, shadowmapheight)); call_gl(glcolormask(gl_false, gl_false, gl_false, gl_false)); //render stuff flatshader.use(); flatshader["basecolor"] = glm::vec4(1.0f,1.0f,1.0f,1.0f); flatshader["pvm"] = projectionmatrix*pointlight.viewmatrix*cursor.modelmatrix; cursor.draw(); //binds vao , draws // revert scene. call_gl(glbindframebuffer(gl_framebuffer, 0)); call_gl(glcolormask(gl_true, gl_true, gl_true, gl_true)); call_gl(glviewport(0, 0, window_size_x, window_s
Read more

stringtemplate - StringTemplate4 if conditional with length -

-
i need generate following kinds of code stringtemplate4: methodfoo0(connection conn); methodfoo1(connection conn, int arg1); methodfoo2(connection conn, int arg1, int arg2); etc. the "connection conn" part present passing method name , rest of arguments st template. template looks follows: <methodname>(connection conn, <args; separator=", ">); this works produces comma when there no arguments @ (except conn): methodfoo0(connection conn,); to eliminate comma tried using if conditional , length st4 function couldn't work although tried various combos following: <methodname>(connection conn <if (length(fieldsinfind) \> 0)>,<else><endif><fieldsinfind; separator=", ">) ... , others failed parsing-related error ( mismatched input ). in end, gave , resorted passing comma parameter template either "," or empty string "" based on pre-rendering logic. you check p
Read more