Cannot insert varchar[] column value using jooq about jooq HOT 2 OPEN

Tried Using DSL.val(array, SQLDataType.VARCHAR.getArrayDataType())

Same error

from jooq.

Thanks for your message. I'm not aware of any such limitation, though all of the versions you've shown are very dated. You probably have your reasons for sticking to outdated libraries...

But to help you, I'll have to see at least:

• The complete stack trace
• A complete reproducer (that ensures all the outdated stuff is linked properly, it's impossible to find your specific configuration by trial and error on my side). We have a template for Minimal, Complete, Verifiable Examples here to help reproducing such issues: https://github.com/jOOQ/jOOQ-mcve

The main hint I'm seeing is "Data type not supported: 1111", where 1111 corresponds to java.sql.Types.OTHER, clearly something that jOOQ normally doesn't use when binding arrays to pgjdbc.

from jooq.