INSERT INTO table without specifying columns

[Max Kremer]

Hello 

  I'm trying to insert into a table without specifying table's columns 
names which perfectly valid SQL:

INSERT INTO FOO VALUES ('A', 'B', 500)

The above will execute without error when the values line up with the 
columns in the table.

How can I accomplish the above with JOOQ? My attempt below doesnt compile 
to a cryptic generic error

InsertValuesStepN<Record> sql = dsl.insertInto(dsl.table("foo"));

for (...){
    
   List<Field<?>> values = Lists.newArrayList();       

   for ( ... ) {
     values.add(val("someval", type));
   }
   
   sql = sql.values(values);
}

sql.execute();




-- 
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.
For more options, visit https://groups.google.com/d/optout.