Hello David, > Q: > ============================== > While using plainSQLTable(), is that mandatory to provide all the > fields? (as I found the follows works:
Yes, this is a known limitation of plainSQLTable (or table() as of jOOQ version 1.6.2). With the original design of jOOQ, when selecting all fields from a table, the outer select retrieves the formal field definitions from the inner select. If the inner select uses a plain SQL table, then an internal DescribeQuery is executed to find out about the field names and types directly in the database. In principle, this DescribeQuery should not be necessary. I hope to resolve this in the future: https://sourceforge.net/apps/trac/jooq/ticket/271 Right now, your workaround is the only valid way to achieve what you're doing. Cheers Lukas
