java - How to insertInto() without setting values and return the newly created ID? -

-

how can insert record without specifying values ans return newly created id? if this:

private long createoffer() {      return this.ctx.insertinto(storeoffer.store_offer, storeoffer.store_offer.id)             .returning(storeoffer.store_offer.id)             .fetchone().getvalue(storeoffer.store_offer.id); }

i getting java.lang.nullpointerexception. if set null not-null-constraint gets triggered..

private long createoffer() {      return this.ctx.insertinto(storeoffer.store_offer, storeoffer.store_offer.id)             .values((long)null)             .returning(storeoffer.store_offer.id)             .fetchone().getvalue(storeoffer.store_offer.id); }

i tried this:

private long createoffer() {     storeofferrecord storeofferrecord = this.ctx.newrecord(storeoffer.store_offer);     storeofferrecord.store();     return storeofferrecord.getid(); }

but id null.

the table store_offer looking this:

create table store_offer (      -- primary key      id bigserial primary key );

using insert .. default values

jooq supports sql standard default values clause on insert statements use-case:

return this.ctx.insertinto(storeoffer.store_offer)                .defaultvalues()                .returning(storeoffer.store_offer.id)                .fetchone().getvalue(storeoffer.store_offer.id);

see also: http://www.jooq.org/doc/latest/manual/sql-building/sql-statements/insert-statement/insert-default-values/

why got nullpointerexception

you able write following query because of api flaw (#3771). following not supposed compile:

return this.ctx.insertinto(storeoffer.store_offer, storeoffer.store_offer.id)                .returning(storeoffer.store_offer.id)                .fetchone().getvalue(storeoffer.store_offer.id);

why record.store() didn't work:

jooq records have internal per-column changed flag. there no record-level changed flag indicate whole record needs sent database, without changes. specifically, wouldn't make sense if update statement need issued.


Comments

Post a Comment

Popular posts from this blog

multithreading - Exception in Application constructor -

-
i wanna write snake game javafx , there exception don't know , want know how fix it. ( know it's not complete yet ) and want know , class extends application ( start override ) main in other programs? see , here not static void main bc didn't need, if want add main shoud do? it's exeption... exception in application constructor exception in thread "main" java.lang.nosuchmethodexception: main_snake.main([ljava.lang.string;) @ java.lang.class.getmethod(class.java:1819) @ com.intellij.rt.execution.application.appmain.main(appmain.java:125) and code : import javafx.animation.animationtimer; import javafx.application.application; import javafx.event.eventhandler; import javafx.scene.scene; import javafx.scene.canvas.canvas; import javafx.scene.canvas.graphicscontext; import javafx.scene.input.keyevent; import javafx.scene.layout.borderpane; import javafx.scene.paint.color; import javafx.stage.stage; import java.util.arraylist; /** * creat...
Read more

React Native allow user to reorder elements in a scrollview list -

-
i'm trying let user reorder elements in scrollview list long-pressing on 1 of elements. we're trying let user use long press pick element of scrollview list, , put element somewhere else in list. have working using animated view, issue it's difficult integrate scrolling , swipe-to-delete animated view. we're hoping add "pick , reorder" scrollview. is there preferred method accomplishing this? touchablewithoutfeedback has onlongpress method, can implement this: _onlongpress() { // perform sort }, <touchablewithoutfeedback onlongpress={ () => this._onlongpress() }> <text>click , hold call onlongpress</text> </touchablewithoutfeedback> as far sorting, can use type of library such lodash or underscore, plus there ways sort using vanilla javascript. check out this thread. i've set basic project using sort function on listview here . https://rnplay.org/apps/mpbktg 'use strict'; var react = requ...
Read more

windows - CertCreateCertificateContext returns CRYPT_E_ASN1_BADTAG / 8009310b -

-
i realize similar post others (e.g. this one ), there details missing posts might significant case. to start with, here's simplified program: #include "stdafx.h" #include <windows.h> #include <wincrypt.h> int _tmain(int argc, _tchar* argv[]) { // usage: certextract certpath char keyfile[] = "c:\\certificates\\public.crt"; byte lp[65536]; security_attributes sa; handle hkeyfile; dword bytes; pccert_context certcontext; sa.nlength = sizeof(sa); sa.lpsecuritydescriptor = null; sa.binherithandle = false; hkeyfile = createfile(keyfile, generic_read, file_share_read, &sa, open_existing, file_attribute_normal, null); if (hkeyfile) { if (readfile(hkeyfile, lp, getfilesize(hkeyfile, null), &bytes, null) && bytes > 0) { certcontext = certcreatecertificatecontext(x509_asn_encoding, lp, bytes); if (certcontext) { printf("yay...
Read more