AnsweredAssumed Answered

How to specify additional driver options when using JNDI

Question asked by Brian Hoover on May 17, 2018
Latest reply on May 18, 2018 by Brian Hoover


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.

 

Screen Shot 2018-05-17 at 1.58.51 PM.png

Any help is greatly appreciated, thanks in advance.

Outcomes