java - 将 JOOQ 与 postgresql citext 结合使用-6ren

java - 将 JOOQ 与 postgresql citext 结合使用

转载作者：行者123 更新时间：2023-12-02 13:08:16

我无法使 JOOQ (3.9.2) 与 PostgreSQL citext 扩展一起使用。在生成表时，我遇到以下异常:

    [WARNING] Ambiguous type name      : The object public.regexp_matches generates a type pl.nombritech.neurogenweb.generated.tables.RegexpMatches which conflicts with the existing type pl.nombritech.neurogenweb.generated.tables.RegexpMatches on some operating systems. Use a custom generator strategy to disambiguate the types.
[WARNING] Ambiguous type name      : The object public.regexp_split_to_table generates a type pl.nombritech.neurogenweb.generated.tables.RegexpSplitToTable which conflicts with the existing type pl.nombritech.neurogenweb.generated.tables.RegexpSplitToTable on some operating systems. Use a custom generator strategy to disambiguate the types.
[INFO] Tables fetched           : 8 (6 included, 2 excluded)
[INFO] Missing name             : Object regexp_matches holds a column without a name at position 1
[INFO] Missing name             : Object regexp_matches holds a column without a name at position 2
[INFO] UDTs fetched             : 0 (0 included, 0 excluded)
[INFO] Missing name             : Object regexp_split_to_table holds a column without a name at position 1
[INFO] Missing name             : Object regexp_split_to_table holds a column without a name at position 2
[INFO] Missing name             : Object regexp_split_to_table holds a column without a name at position 3
[INFO] Sequences fetched        : 4 (4 included, 0 excluded)
[INFO] Generating sequences     
[INFO] Sequences generated      : Total: 1.099s
[INFO] Generating tables        
[INFO] Adding foreign key       : sample_item__sample_item_category_id_fk (public.sample_item.category_id) referencing category_id_pk
[INFO] Adding foreign key       : sample_item__sample_item_size_id_fk (public.sample_item.size_id) referencing size_id_pk
[INFO] Adding foreign key       : sample_item__sample_item_unit_fk (public.sample_item.unit_id) referencing unit_id_pk
[INFO] Synthetic primary keys   : 0 (0 included, 0 excluded)
[INFO] Overriding primary keys  : 6 (0 included, 6 excluded)
[INFO] Generating table         : Category.java [input=category, output=category, pk=category_id_pk]
[INFO] Generating table         : RegexpMatches.java [input=regexp_matches, output=regexp_matches, pk=N/A]
[ERROR] Error while generating table public.regexp_matches
java.lang.NullPointerException
        at org.jooq.util.GenerationUtil.getArrayBaseType(GenerationUtil.java:370)
        at org.jooq.util.JavaGenerator.getType(JavaGenerator.java:5209)
        at org.jooq.util.JavaGenerator.getJavaType(JavaGenerator.java:5165)
        at org.jooq.util.JavaGenerator.getJavaType(JavaGenerator.java:5161)
        at org.jooq.util.JavaGenerator.generateTable(JavaGenerator.java:3328)
        at org.jooq.util.JavaGenerator.generateTable(JavaGenerator.java:3278)
        at org.jooq.util.JavaGenerator.generateTables(JavaGenerator.java:3265)
        at org.jooq.util.JavaGenerator.generate(JavaGenerator.java:422)
        at org.jooq.util.JavaGenerator.generate(JavaGenerator.java:376)
        at org.jooq.util.JavaGenerator.generate(JavaGenerator.java:298)
        at org.jooq.util.GenerationTool.run(GenerationTool.java:610)
        at org.jooq.util.GenerationTool.generate(GenerationTool.java:199)
        at org.jooq.util.maven.Plugin.execute(Plugin.java:188)
        at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:134)
        at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:207)
        at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153)
        at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145)
        at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:116)
        at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:80)
        at org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build(SingleThreadedBuilder.java:51)
        at org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:128)
        at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:307)
        at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:193)
        at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:106)
        at org.apache.maven.cli.MavenCli.execute(MavenCli.java:863)
        at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:288)
        at org.apache.maven.cli.MavenCli.main(MavenCli.java:199)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:289)
        at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:229)
        at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:415)
        at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:356)
[INFO] Generating table         : RegexpSplitToTable.java [input=regexp_split_to_table, output=regexp_split_to_table, pk=N/A]
[INFO] Generating table         : SampleItem.java [input=sample_item, output=sample_item, pk=sample_item_id_pk]
[INFO] Generating table         : Size.java [input=size, output=size, pk=size_id_pk]
[INFO] Generating table         : Unit.java [input=unit, output=unit, pk=unit_id_pk]
[INFO] Tables generated         : Total: 1.819s, +720.025ms
[INFO] Generating table references
[INFO] Table refs generated     : Total: 1.827s, +8.209ms
[INFO] Generating Keys          
[INFO] Keys generated           : Total: 1.852s, +24.873ms
[INFO] Generating table records 
[INFO] Generating record        : CategoryRecord.java
[INFO] Generating record        : RegexpMatchesRecord.java
[ERROR] Error while generating table record public.regexp_matches
java.lang.NullPointerException
        at org.jooq.util.GenerationUtil.getArrayBaseType(GenerationUtil.java:370)
        at org.jooq.util.JavaGenerator.getType(JavaGenerator.java:5209)
        at org.jooq.util.JavaGenerator.getJavaType(JavaGenerator.java:5165)
        at org.jooq.util.JavaGenerator.getJavaType(JavaGenerator.java:5161)
        at org.jooq.util.JavaGenerator.refRowType(JavaGenerator.java:1407)
        at org.jooq.util.JavaGenerator.generateRecord0(JavaGenerator.java:958)
        at org.jooq.util.JavaGenerator.generateRecord(JavaGenerator.java:917)
        at org.jooq.util.JavaGenerator.generateRecord(JavaGenerator.java:905)
        at org.jooq.util.JavaGenerator.generateRecords(JavaGenerator.java:892)
        at org.jooq.util.JavaGenerator.generate(JavaGenerator.java:442)
        at org.jooq.util.JavaGenerator.generate(JavaGenerator.java:376)
        at org.jooq.util.JavaGenerator.generate(JavaGenerator.java:298)
        at org.jooq.util.GenerationTool.run(GenerationTool.java:610)
        at org.jooq.util.GenerationTool.generate(GenerationTool.java:199)
        at org.jooq.util.maven.Plugin.execute(Plugin.java:188)
        at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:134)
        at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:207)
        at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153)
        at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145)
        at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:116)
        at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:80)
        at org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build(SingleThreadedBuilder.java:51)
        at org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:128)
        at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:307)
        at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:193)
        at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:106)
        at org.apache.maven.cli.MavenCli.execute(MavenCli.java:863)
        at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:288)
        at org.apache.maven.cli.MavenCli.main(MavenCli.java:199)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:289)
        at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:229)
        at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:415)
        at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:356)
[INFO] Generating record        : RegexpSplitToTableRecord.java
[INFO] Generating record        : SampleItemRecord.java
[INFO] Generating record        : SizeRecord.java
[INFO] Generating record        : UnitRecord.java
[INFO] Table records generated  : Total: 1.947s, +95.574ms
[INFO] Domains fetched          : 0 (0 included, 0 excluded)
[INFO] Generating routines and table-valued functions
[INFO] Missing name             : Object citext holds a column without a name at position 1
[INFO] Missing name             : Object citext holds a column without a name at position 1
[INFO] Missing name             : Object citext holds a column without a name at position 1
[INFO] Missing name             : Object citext_cmp holds a column without a name at position 1
[INFO] Missing name             : Object citext_cmp holds a column without a name at position 2
[INFO] Missing name             : Object citext_eq holds a column without a name at position 1
[INFO] Missing name             : Object citext_eq holds a column without a name at position 2
[INFO] Missing name             : Object citext_ge holds a column without a name at position 1
[INFO] Missing name             : Object citext_ge holds a column without a name at position 2
[INFO] Missing name             : Object citext_gt holds a column without a name at position 1
[INFO] Missing name             : Object citext_gt holds a column without a name at position 2
[INFO] Missing name             : Object citext_hash holds a column without a name at position 1
[INFO] Missing name             : Object citextin holds a column without a name at position 1
[INFO] Missing name             : Object citext_larger holds a column without a name at position 1
[INFO] Missing name             : Object citext_larger holds a column without a name at position 2
[INFO] Missing name             : Object citext_le holds a column without a name at position 1
[INFO] Missing name             : Object citext_le holds a column without a name at position 2
[INFO] Missing name             : Object citext_lt holds a column without a name at position 1
[INFO] Missing name             : Object citext_lt holds a column without a name at position 2
[INFO] Missing name             : Object citext_ne holds a column without a name at position 1
[INFO] Missing name             : Object citext_ne holds a column without a name at position 2
[INFO] Missing name             : Object citextout holds a column without a name at position 1
[INFO] Missing name             : Object citextrecv holds a column without a name at position 1
[INFO] Missing name             : Object citextsend holds a column without a name at position 1
[INFO] Missing name             : Object citext_smaller holds a column without a name at position 1
[INFO] Missing name             : Object citext_smaller holds a column without a name at position 2
[INFO] Missing name             : Object max holds a column without a name at position 1
[INFO] Missing name             : Object min holds a column without a name at position 1
[INFO] Missing name             : Object regexp_replace holds a column without a name at position 1
[INFO] Missing name             : Object regexp_replace holds a column without a name at position 2
[INFO] Missing name             : Object regexp_replace holds a column without a name at position 3
[INFO] Missing name             : Object regexp_replace holds a column without a name at position 1
[INFO] Missing name             : Object regexp_replace holds a column without a name at position 2
[INFO] Missing name             : Object regexp_replace holds a column without a name at position 3
[INFO] Missing name             : Object regexp_replace holds a column without a name at position 4
[INFO] Missing name             : Object regexp_split_to_array holds a column without a name at position 1
[INFO] Missing name             : Object regexp_split_to_array holds a column without a name at position 2
[INFO] Missing name             : Object regexp_split_to_array holds a column without a name at position 1
[INFO] Missing name             : Object regexp_split_to_array holds a column without a name at position 2
[INFO] Missing name             : Object regexp_split_to_array holds a column without a name at position 3
[INFO] Missing name             : Object replace holds a column without a name at position 1
[INFO] Missing name             : Object replace holds a column without a name at position 2
[INFO] Missing name             : Object replace holds a column without a name at position 3
[INFO] Missing name             : Object split_part holds a column without a name at position 1
[INFO] Missing name             : Object split_part holds a column without a name at position 2
[INFO] Missing name             : Object split_part holds a column without a name at position 3
[INFO] Missing name             : Object strpos holds a column without a name at position 1
[INFO] Missing name             : Object strpos holds a column without a name at position 2
[INFO] Missing name             : Object texticlike holds a column without a name at position 1
[INFO] Missing name             : Object texticlike holds a column without a name at position 2
[INFO] Missing name             : Object texticlike holds a column without a name at position 1
[INFO] Missing name             : Object texticlike holds a column without a name at position 2
[INFO] Missing name             : Object texticnlike holds a column without a name at position 1
[INFO] Missing name             : Object texticnlike holds a column without a name at position 2
[INFO] Missing name             : Object texticnlike holds a column without a name at position 1
[INFO] Missing name             : Object texticnlike holds a column without a name at position 2
[INFO] Missing name             : Object texticregexeq holds a column without a name at position 1
[INFO] Missing name             : Object texticregexeq holds a column without a name at position 2
[INFO] Missing name             : Object texticregexeq holds a column without a name at position 1
[INFO] Missing name             : Object texticregexeq holds a column without a name at position 2
[INFO] Missing name             : Object texticregexne holds a column without a name at position 1
[INFO] Missing name             : Object texticregexne holds a column without a name at position 2
[INFO] Missing name             : Object texticregexne holds a column without a name at position 1
[INFO] Missing name             : Object texticregexne holds a column without a name at position 2
[INFO] Missing name             : Object translate holds a column without a name at position 1
[INFO] Missing name             : Object translate holds a column without a name at position 2
[INFO] Missing name             : Object translate holds a column without a name at position 3
[INFO] Generating routine       : Citext1.java
[INFO] Generating routine       : Citext2.java
[INFO] Generating routine       : Citext3.java
[INFO] Generating routine       : CitextCmp.java
[INFO] Generating routine       : CitextEq.java
[INFO] Generating routine       : CitextGe.java
[INFO] Generating routine       : CitextGt.java
[INFO] Generating routine       : CitextHash.java
[INFO] Generating routine       : Citextin.java
[INFO] Generating routine       : CitextLarger.java
[INFO] Generating routine       : CitextLe.java
[INFO] Generating routine       : CitextLt.java
[INFO] Generating routine       : CitextNe.java
[INFO] Generating routine       : Citextout.java
[INFO] Generating routine       : Citextrecv.java
[INFO] Generating routine       : Citextsend.java
[INFO] Generating routine       : CitextSmaller.java
[INFO] Generating routine       : Max.java
[INFO] Generating routine       : Min.java
[INFO] Generating routine       : RegexpReplace1.java
[INFO] Generating routine       : RegexpReplace2.java
[INFO] Generating routine       : RegexpSplitToArray1.java
[INFO] Generating routine       : RegexpSplitToArray2.java
[INFO] Generating routine       : Replace.java
[INFO] Generating routine       : SplitPart.java
[INFO] Generating routine       : Strpos.java
[INFO] Generating routine       : Texticlike1.java
[INFO] Generating routine       : Texticlike2.java
[INFO] Generating routine       : Texticnlike1.java
[INFO] Generating routine       : Texticnlike2.java
[INFO] Generating routine       : Texticregexeq1.java
[INFO] Generating routine       : Texticregexeq2.java
[INFO] Generating routine       : Texticregexne1.java
[INFO] Generating routine       : Texticregexne2.java
[INFO] Generating routine       : Translate.java
[INFO] Routines generated       : Total: 3.35s, +1.402s
[INFO] Generation finished: public: Total: 3.35s, +0.082ms
[INFO]                          
[INFO] Removing excess files    
[INFO] 
[INFO] --- maven-resources-plugin:2.6:resources (default-resources) @ NeuroGenWeb ---
[INFO] Using 'UTF-8' encoding to copy filtered resources.
[INFO] Copying 1 resource
[INFO] Copying 1 resource
[INFO] 
[INFO] --- maven-compiler-plugin:3.1:compile (default-compile) @ NeuroGenWeb ---
[INFO] Changes detected - recompiling the module!
[INFO] Compiling 94 source files to /home/kuba/IdeaProjects/NeuroGenWeb/target/classes
[INFO] -------------------------------------------------------------
[WARNING] COMPILATION WARNING : 
[INFO] -------------------------------------------------------------
[WARNING] Some messages have been simplified; recompile with -Xdiags:verbose to get full output
[INFO] 1 warning
[INFO] -------------------------------------------------------------
[INFO] -------------------------------------------------------------
[ERROR] COMPILATION ERROR : 
[INFO] -------------------------------------------------------------
[ERROR] /home/kuba/IdeaProjects/NeuroGenWeb/src/main/java/pl/nombritech/neurogenweb/generated/Public.java:[23,50] cannot find symbol
  symbol:   class RegexpMatches
  location: package pl.nombritech.neurogenweb.generated.tables
[ERROR] /home/kuba/IdeaProjects/NeuroGenWeb/src/main/java/pl/nombritech/neurogenweb/generated/Public.java:[28,58] cannot find symbol
  symbol:   class RegexpMatchesRecord
  location: package pl.nombritech.neurogenweb.generated.tables.records
[ERROR] /home/kuba/IdeaProjects/NeuroGenWeb/src/main/java/pl/nombritech/neurogenweb/generated/Public.java:[60,18] cannot find symbol
  symbol:   class RegexpMatches
  location: class pl.nombritech.neurogenweb.generated.Public
[ERROR] /home/kuba/IdeaProjects/NeuroGenWeb/src/main/java/pl/nombritech/neurogenweb/generated/Public.java:[65,26] cannot find symbol
  symbol:   class RegexpMatchesRecord
  location: class pl.nombritech.neurogenweb.generated.Public
[ERROR] /home/kuba/IdeaProjects/NeuroGenWeb/src/main/java/pl/nombritech/neurogenweb/generated/Public.java:[72,19] cannot find symbol
  symbol:   class RegexpMatches
  location: class pl.nombritech.neurogenweb.generated.Public
[ERROR] /home/kuba/IdeaProjects/NeuroGenWeb/src/main/java/pl/nombritech/neurogenweb/generated/Public.java:[79,19] cannot find symbol
  symbol:   class RegexpMatches
  location: class pl.nombritech.neurogenweb.generated.Public
[ERROR] /home/kuba/IdeaProjects/NeuroGenWeb/src/main/java/pl/nombritech/neurogenweb/generated/Routines.java:[50,50] cannot find symbol
  symbol:   class RegexpMatches
  location: package pl.nombritech.neurogenweb.generated.tables
[ERROR] /home/kuba/IdeaProjects/NeuroGenWeb/src/main/java/pl/nombritech/neurogenweb/generated/Routines.java:[52,58] cannot find symbol
  symbol:   class RegexpMatchesRecord
  location: package pl.nombritech.neurogenweb.generated.tables.records
[ERROR] /home/kuba/IdeaProjects/NeuroGenWeb/src/main/java/pl/nombritech/neurogenweb/generated/Routines.java:[1231,26] cannot find symbol
  symbol:   class RegexpMatchesRecord
  location: class pl.nombritech.neurogenweb.generated.Routines
[ERROR] /home/kuba/IdeaProjects/NeuroGenWeb/src/main/java/pl/nombritech/neurogenweb/generated/Routines.java:[1238,19] cannot find symbol
  symbol:   class RegexpMatches
  location: class pl.nombritech.neurogenweb.generated.Routines
[ERROR] /home/kuba/IdeaProjects/NeuroGenWeb/src/main/java/pl/nombritech/neurogenweb/generated/Routines.java:[1245,19] cannot find symbol
  symbol:   class RegexpMatches
  location: class pl.nombritech.neurogenweb.generated.Routines
[ERROR] /home/kuba/IdeaProjects/NeuroGenWeb/src/main/java/pl/nombritech/neurogenweb/generated/Tables.java:[15,50] cannot find symbol
  symbol:   class RegexpMatches
  location: package pl.nombritech.neurogenweb.generated.tables
[ERROR] /home/kuba/IdeaProjects/NeuroGenWeb/src/main/java/pl/nombritech/neurogenweb/generated/Tables.java:[20,58] cannot find symbol
  symbol:   class RegexpMatchesRecord
  location: package pl.nombritech.neurogenweb.generated.tables.records
[ERROR] /home/kuba/IdeaProjects/NeuroGenWeb/src/main/java/pl/nombritech/neurogenweb/generated/Tables.java:[45,25] cannot find symbol
  symbol:   class RegexpMatches
  location: class pl.nombritech.neurogenweb.generated.Tables
[ERROR] /home/kuba/IdeaProjects/NeuroGenWeb/src/main/java/pl/nombritech/neurogenweb/generated/Tables.java:[50,26] cannot find symbol
  symbol:   class RegexpMatchesRecord
  location: class pl.nombritech.neurogenweb.generated.Tables
[ERROR] /home/kuba/IdeaProjects/NeuroGenWeb/src/main/java/pl/nombritech/neurogenweb/generated/Tables.java:[57,19] cannot find symbol
  symbol:   class RegexpMatches
  location: class pl.nombritech.neurogenweb.generated.Tables
[ERROR] /home/kuba/IdeaProjects/NeuroGenWeb/src/main/java/pl/nombritech/neurogenweb/generated/Tables.java:[64,19] cannot find symbol
  symbol:   class RegexpMatches
  location: class pl.nombritech.neurogenweb.generated.Tables
[ERROR] /home/kuba/IdeaProjects/NeuroGenWeb/src/main/java/pl/nombritech/neurogenweb/generated/Public.java:[60,91] cannot find symbol
  symbol:   class RegexpMatches
  location: package pl.nombritech.neurogenweb.generated.tables
[ERROR] /home/kuba/IdeaProjects/NeuroGenWeb/src/main/java/pl/nombritech/neurogenweb/generated/Public.java:[66,65] package RegexpMatches does not exist
[ERROR] /home/kuba/IdeaProjects/NeuroGenWeb/src/main/java/pl/nombritech/neurogenweb/generated/Public.java:[73,29] package RegexpMatches does not exist
[ERROR] /home/kuba/IdeaProjects/NeuroGenWeb/src/main/java/pl/nombritech/neurogenweb/generated/Public.java:[80,29] package RegexpMatches does not exist
[ERROR] /home/kuba/IdeaProjects/NeuroGenWeb/src/main/java/pl/nombritech/neurogenweb/generated/Public.java:[165,13] cannot find symbol
  symbol:   variable RegexpMatches
  location: class pl.nombritech.neurogenweb.generated.Public
[ERROR] /home/kuba/IdeaProjects/NeuroGenWeb/src/main/java/pl/nombritech/neurogenweb/repository/UnitRepository.java:[22,31] incompatible types: inference variable E has incompatible bounds
    equality constraints: java.lang.String
    lower bounds: java.lang.Object
[ERROR] /home/kuba/IdeaProjects/NeuroGenWeb/src/main/java/pl/nombritech/neurogenweb/repository/UnitRepository.java:[33,35] incompatible types: inference variable T has incompatible bounds
    equality constraints: java.lang.String
    lower bounds: java.lang.Object,E
[ERROR] /home/kuba/IdeaProjects/NeuroGenWeb/src/main/java/pl/nombritech/neurogenweb/repository/CategoryRepository.java:[17,23] incompatible types: inference variable E has incompatible bounds
    equality constraints: java.lang.String
    lower bounds: java.lang.Object
[ERROR] /home/kuba/IdeaProjects/NeuroGenWeb/src/main/java/pl/nombritech/neurogenweb/repository/CategoryRepository.java:[29,35] incompatible types: inference variable T has incompatible bounds
    equality constraints: java.lang.String
    lower bounds: java.lang.Object,E
[ERROR] /home/kuba/IdeaProjects/NeuroGenWeb/src/main/java/pl/nombritech/neurogenweb/repository/GeneratorRepository.java:[40,17] no suitable method found for fetch(SampleItem[...]slate)
    method org.jooq.ResultQuery.<T>fetch(org.jooq.Field<T>) is not applicable
      (cannot infer type-variable(s) T
        (argument mismatch; org.jooq.Field is not a functional interface
          multiple non-overriding abstract methods found in interface org.jooq.Field))
    method org.jooq.ResultQuery.<T>fetch(org.jooq.Field<?>,java.lang.Class<? extends T>) is not applicable
      (cannot infer type-variable(s) T
        (actual and formal argument lists differ in length))
    method org.jooq.ResultQuery.<T,U>fetch(org.jooq.Field<T>,org.jooq.Converter<? super T,? extends U>) is not applicable
      (cannot infer type-variable(s) T,U
        (actual and formal argument lists differ in length))
    method org.jooq.ResultQuery.fetch(int) is not applicable
      (argument mismatch; int is not a functional interface)
    method org.jooq.ResultQuery.<T>fetch(int,java.lang.Class<? extends T>) is not applicable

这是我的 pom.xml 中的 JOOQ 生成配置:

            <generator>
                <database>
                    <name>org.jooq.util.postgres.PostgresDatabase</name>
                    <includes>.*</includes>
                    <excludes/>
                    <inputSchema>public</inputSchema>
                </database>
                <target>
                    <packageName>pl.nombritech.neurogenweb.generated</packageName>
                    <directory>src/main/java</directory>
                </target>
            </generator>

有可能实现这个功能吗？我已经搜索过解决方案，但还没有找到任何对我有帮助的东西。

对于此事的任何提示，我将非常感激。

最佳答案

这是一个已知问题 ( https://github.com/jOOQ/jOOQ/issues/6078 )，将在 jOOQ 3.9.3 中修复

关于java - 将 JOOQ 与 postgresql citext 结合使用，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/44065918/

文章推荐： java - 无法用Java解析JSON文件

文章推荐： java - 将控制台数据输出写入文本文件

postgresql - 将旧表从已删除的 postgresql 导入到新安装的 postgresql
我的 postgresql 有问题，我复制了所有文件，然后将其删除。然后，我安装了新的，问题就解决了。现在可以将旧文件和文件导入新文件吗？最佳答案如果它们是相同的主要版本(即 9.0 到 9.0.
postgresql - postgresql 服务器启动时，postgresql 中是否有任何系统表自动更新？
我想使用 Postgresql 9.2.2 来存储我的应用程序的数据。我不得不构建一个应该基于数据库级别的触发器(当数据库启动时，这个触发器将被触发并执行。)，当 postgresql 服务器启动时是
postgresql - 如何从 Postgresql 目录表中检索 Postgresql 序列缓存值？
我已经使用下面的查询从 Postgresql 目录表中获取 Sequence 对象的完整信息 select s.sequence_name, s.start_value, s.minimum_valu
postgresql - 执行函数从本地 PostgreSQL 数据库返回远程 PostgreSQL 数据库中的数据
Postgres 版本:9.3.4 我需要执行驻留在远程数据库中的函数。该函数根据给定的参数返回一个统计数据表。我实际上只是在我的本地数据库中镜像该函数，以使用我的数据库角色和授权来锁定对该函数的访
postgresql - 在没有 postgresql-server 的情况下重启 PostgreSQL
我在 CentOS 7 上，我正在尝试解决“PG::ConnectionBad: FATAL: Peer authentication failed for user”错误。所以我已经想出我应该更改
postgresql - Postgresql - 使用动态列名触发
我写了一个触发器函数，在触发器表列名上循环，我从具有不同列的不同表调用该函数。该函数将列名插入到数组中并在它们上循环，以便将值插入到另一个模式和表中。函数和触发器创建脚本: DROP TRIGGER
postgresql - PostgreSQL 的默认空闲连接超时值是多少
PostgreSQL 的默认空闲连接超时是多少，我运行了 show idle_in_transaction_session_timeout 查询并返回了 0，但是值 0 表示此选项被禁用，但我想知道默
postgresql - Postgresql 中十六进制值的适当数据类型？
我需要将十六进制值存储到数据库表中，谁能推荐我需要用于属性的数据类型？提前致谢最佳答案您可以使用bytea 来存储十六进制格式。更多信息 can be found in the postgres
postgresql - Postgresql 中是否需要对复合主键的一部分进行索引？
我有一个具有复合主键的(大)表，由 5 列(a、b、c、d、e)组成。我想高效地选择具有其中两列 (a + e) 的所有行到给定值。在 PostgreSQL 中，我需要索引吗？或者数据库会使用主键
postgresql - PostgreSQL 如何在内部存储日期时间类型
在阅读 PostreSQL (13) 文档时，我遇到了 this页面，其中列出了不同日期时间类型的存储大小。除其他外，它指出: Name Storag
postgresql - PostgreSQL 中批量插入的最佳大小
我有两个大整数的巨大表(500 000 000 行)。两列都被单独索引。我正在使用语法批量插入此表: INSERT into table (col1, col2) VALUES(x0, y0), (x
postgresql - 无法启动 PostgreSQL
有一台 CentOS7 Linux 机器正在运行(不是由我管理；拥有有限的权限)。请求在其中设置 PostgreSQL。刚刚从 CentOS 存储库安装了 PostgreSQL: sudo yum
postgresql - 是否可以在不破坏现有数据库的情况下安装 Postgresql？
我在 Ubuntu 18.04 上安装了 Postgresql 10，但不知何故坏了，不会重新启动。我可以重新安装它而不破坏它的数据库，以便我可以再次访问数据库吗？ pg_dump 不起作用。最佳答
postgresql - postgresql 中的自动备份创建空备份
我想在 UNIX 中使用 crontab 自动备份 PostgreSQL 数据库。我已经尝试过，但它会创建 0 字节备份。我的 crontab 条目是: 24 * * * * /home/desk
postgresql - 允许远程连接 postgresql
我已经完成了PG服务器的安装。我希望能够使用 pgAdmin 远程连接到它，但不断收到服务器不听错误。 could not connect to server: Connection refused
PostgreSQL:PostgreSQL 支持波斯历吗？
Oracle 支持波斯历但需要知道 PostgreSQL 是否支持波斯历？如果是，那么我们如何在 PostgreSQL 中将默认日历类型设置为 Persian 而不是 Gregorian(在 Ora
postgresql - PostgreSQL 模式的命名空间版本以实现向后兼容性？
假设我们有一个带有表的 SQL 数据库 Person以及访问它的几个应用程序。出于某种原因，我们想修改 Person表以向后不兼容的方式。保持兼容性的一种潜在解决方案是将表重命名为 User并创建一
postgresql - PostgreSQL 中的模式是物理对象吗？
我使用 PostgreSQL 中的模式来组织我庞大的会计数据库。每年年底，我都会通过为下一年创建一个新模式来进行协调过程。新模式的文件是否与旧模式物理分离？或者所有模式一起存储在硬盘上？这对我来说
postgresql - PostgreSQL autovacuum中的autovacuum_vacuum_cost_delay是什么？
我正在尝试使用配置文件中的以下配置参数调整 PostgreSQL 服务器: autovacuum_freeze_max_age = 500000000 autovacuum_max_workers =
postgresql - 如何仅查询具有表情符号的数据(postgresql)
我的数据包含数据库列中的表情符号，即 message_text ------- 🙂 😀 Hi 😀 我只想查询包含表情符号的数据的行。在 postgres 中是否有一种简单的方法可以做到这一点？

行者123

个人简介

我是一名优秀的程序员,十分优秀！

作者热门文章

滴滴打车优惠券免费领取

全站热门文章

首页

博学

6Ren·AI

商城

java - 将 JOOQ 与 postgresql citext 结合使用