Pentaho

 View Only

 Issue with JNDI (SQL Server) after move from PDI 9.1 to 9.4

Jump to Best Answer
Adrian Guzy's profile image
Adrian Guzy posted 08-03-2023 08:18

Hi All,

After setting up PDI 9.4 and moving the jdbs.properties file from the old version to the new one we are facing this error: "Illegal node/branch...".

Using Native (JDBC) with the same settings as in the JNDI connection works fine.

Any help would be appreciated.

We are using OpenJDK 20.0.2.

Thanks.

Petr Prochazka's profile image
Petr Prochazka posted 08-04-2023 09:14 Best Answer

Hi Adrian,

this would be problem of JNDI configuration in properties file. Check jdbc.propeties file if all parameters have correct path key.

Juan Sierra Pons's profile image
Juan Sierra Pons posted 08-04-2023 08:40

I think your problem is with the java version as 20 is not supported

Components Reference - Hitachi Vantara Lumada and Pentaho Documentation

Adrian Guzy's profile image
Adrian Guzy posted 08-04-2023 09:05

@Juan Sierra Pons Thank you for the comment but using version 11 generates the same error.

Adrian Guzy's profile image
Adrian Guzy posted 08-05-2023 13:40

@Petr Prochazka Thank you very much.

All the parameters for this JNDIs were correct but it looks like someone was trying to use SQL comments and there were two "rogue" lines: "/*" and "*/".

After removing them the error disappeared. It's interesting that this .properties file is working fine in 9.1 but fails in 9.4. Handling of the .properties file must have changed.

Petr Prochazka's profile image
Petr Prochazka posted 08-06-2023 15:46

Hi Andrian,

comment in properties file starts with # or ;. Block comment /* ... */ is not supported.

Adrian Guzy's profile image
Adrian Guzy posted 08-06-2023 17:15

@Petr Prochazka Yes, we were using "#" in the past but I think on of the developers forgot to switch from an "html mode". Thanks Again.

Petr Prochazka's profile image
Petr Prochazka posted 08-07-2023 07:21

You're welcome. :-)

Related Content