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
  • Comment • 2


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.

Ana Gonzalez
Ana Gonzalez May 18, 2018 2:04 AM
Correct Answer

Put in the url something like this:

JNDINAME/url=jdbc:postgresql://host:port/DB?stringtype=unspecified

Regards

See the reply in context
No one else had this question

Outcomes