Specifically - PDI 8.0 CE using PostgreSQL and driver version 42.2.2, I need to specify the option of `stringtype=unspecified`. This is used to avoid casting issues from varchar to uuid.
Related background: ERROR: column "guid" is of type uuid but expression is of type character varying
If I switch from JNDI to JDBC in my connection type this option is used. I do not think it is when using JNDI.
Any help is greatly appreciated, thanks in advance.
Put in the url something like this:
JNDINAME/url=jdbc:postgresql://host:port/DB?stringtype=unspecified
Regards