java - JOOQ generated pojo missing GeneratedValue annotation -

-

i'm using jooq generate pojo h2 db table

create table public.abc (   id          bigint auto_increment primary key,   trade_date  date,   stk_code    varchar(63),   remarks     text,   timestamp   timestamp not null );

but generated code (below)

{      ...     @id     @column(name = "id", unique = true, nullable = false, precision = 19)     public long getid() {         return this.id;     }     ...  }

is missing @generatedvalue annotation makes impossible insert new record spring data rest repository since passed in object complain id field not being set.

what config/work around can jooq working properly?

below relevant pom file section used generate pojo @ compile time:

<plugin>     <groupid>org.jooq</groupid>     <artifactid>jooq-codegen-maven</artifactid>     <executions>         <execution>             <goals>                 <goal>generate</goal>             </goals>         </execution>     </executions>     <dependencies>         <dependency>             <groupid>com.h2database</groupid>             <artifactid>h2</artifactid>             <version>${h2.version}</version>         </dependency>     </dependencies>     <configuration>         <!-- jdbc connection parameters -->         <jdbc>             <driver>org.h2.driver</driver>             <url>jdbc:h2:${user.home}/</url>         </jdbc>         <!-- generator parameters -->         <generator>             <database>                 <name>org.jooq.util.h2.h2database</name>                 <includes>.*</includes>                 <schemata>                     <schema>                         <inputschema>public</inputschema>                     </schema>                 </schemata>             </database>             <target>                 <packagename>org.abc</packagename>                 <directory>target/generated-sources/jooq</directory>             </target>             <generate>                 <pojos>true</pojos>                 <jpaannotations>true</jpaannotations>             </generate>         </generator>     </configuration> </plugin>

workaround

end going replacer route, plugin code below running same issues before feature's added:

    <plugin>         <groupid>com.google.code.maven-replacer-plugin</groupid>         <artifactid>replacer</artifactid>         <version>1.5.3</version>         <executions>             <execution>                 <phase>prepare-package</phase>                 <goals>                     <goal>replace</goal>                 </goals>             </execution>         </executions>         <configuration>             <basedir>${project.basedir}/${jooq.gen.dir}</basedir>             <filestoinclude>tables/pojos/*.java</filestoinclude>             <replacements>                 <replacement>                     <token>@id</token>                     <value>@id @javax.persistence.generatedvalue</value>                 </replacement>             </replacements>         </configuration>     </plugin>

as of jooq 3.7, that's missing feature. see: https://github.com/jooq/jooq/issues/5009

you have several workaround options:

  1. patch generated code using search-replace maven plugin replacing @id @id @javax.persistence.generatedvalue(javax.persistence.generationtype.identity) (assuming primary keys auto_increment)
  2. patch jooq-codegen's javagenerator's org.jooq.util.javagenerator.printcolumnjpaannotation() method , add code yourself.

Comments

Post a Comment

Popular posts from this blog

Hatching array of circles in AutoCAD using c# -

-
i beginner in autocad plugins .i have created array of circle using following code. now, have hatch circles in array .how that??how hatch circles @ once? moreover, how can return hatch method , use hatch objects.sorry language.thanks in advance. [assembly: commandclass(typeof(beamsection.class1))] namespace beamsection { public class class1 { //class1 obj = new class1(); [commandmethod("beamatsupport")] public void addlightweightpolyline() { // current document , database document acdoc = application.documentmanager.mdiactivedocument; database accurdb = acdoc.database; promptpointresult ppr = acdoc.editor.getpoint("\nselect starting point "); var ucs = acdoc.editor.currentusercoordinatesystem; point3d startingpt = ppr.value.transformby(ucs); list<double> radius = new list<double>(); radius.add(0.5);
Read more

ios - UITEXTFIELD InputView Uipicker not working in swift -

-
hello trying pop uipickerview view programmatically when user clicks on textfield. have tried doesn't doing anything. isn't working. nothing happening when click textfield class userprofiletableviewcontroller: uitableviewcontroller,uitextfielddelegate,uipickerviewdelegate,uipickerviewdatasource { var itempicker: uipickerview! = uipickerview() @iboutlet weak var gendertxtfield: uitextfield! var gender = ["male","female"] override func viewdidload() { super.viewdidload() gendertxtfield.delegate = self itempicker!.delegate = self itempicker!.datasource = self itempicker!.backgroundcolor = uicolor.blackcolor() self.gendertxtfield.inputview = itempicker } func numberofcomponentsinpickerview(pickerview: uipickerview) -> int{ return 1 } // returns # of rows in each component.. func pickerview(pickerview: uipickerview, numberofrowsincomponent component:
Read more

Python Pig Latin Translator -

-
so have been working on @ codecademy.com while trying learn python. don't know if blind , can't see why won't work or what. here's code won't let me use. function print variable if had typed in , print "empty" if didn't type anything. print "welcome english pig latin translator!" original = raw_input("what's name?") if len(original) > 0 print original else print "empty" if len(original) > 0 else the above lines contains syntax errors. try: if len(original) > 0: else: note added colons, ( : ).
Read more