jOOQ binding insert values via bean

[Marcel Overdijk]

I'm currently using JDBI on a project with a DAO like:

@SqlBatch("insert_continent")
fun insertContinents(@BindBean continents: List<Continent>)

Note this uses the @BindBean to automatically bind bean properties to sql 
statements.

E.g. the insert_continent sql file contains:

INSERT INTO continent
( id
, code
, name
)
VALUES
( :id
, :code
, :name
);

and the bean is Java class like:

public class Continent implements Serializable {

    private String id;
    private String code;
    private String name;
    
*    // getters + setters*
*}*

Now with jOOQ I want to do something similar, e..g having an insert like:

val continent = .. // some continent
val query = ctx
    .insertInto(
        table("continent"),
        field("id"),
        field("code"))
        field("name"))
    .values(
        continent.id,
        continent.code,
        continent.name
    )

But then instead of access all properties by hand, just bind the bean.

Would that be possible with jOOQ?

Note: I do not want to use code generation for this.
Also the Continent class is provided and cannot be changed.


Thanks,
Marcel



-- 
You received this message because you are subscribed to the Google Groups "jOOQ 
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jooq-user+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jooq-user/6eca1697-beef-4c63-921a-757cdcf0d8a7n%40googlegroups.com.