AnsweredAssumed Answered

Metadata Editor is not seeing JNDI connections even though Report Designer does

Question asked by Sam Alexander on Mar 28, 2019
Latest reply on Apr 3, 2019 by Sam Alexander


Hello.  I've setup my SQL connections in c:\users\[home folder]\.pentaho\simple-jndi\default.properties and I can connect to them without issue from Report Designer, but when I try to add a Connection through Metadata Editor it reports back that the JNDI connection can't be found.

 

Error connecting to database [DevHR] : org.pentaho.di.core.exception.KettleDatabaseException:

Error occurred while trying to connect to the database

 

javax.naming.NamingException: Invalid data source:'DevHR'

Invalid data source:'DevHR'

 

org.pentaho.di.core.exception.KettleDatabaseException:

Error occurred while trying to connect to the database

 

And here's what the JNDI connection looks like in default.properties with some changes for security:

DevHR/type=javax.sql.DataSource

DevHR/driver=com.microsoft.sqlserver.jdbc.SQLServerDriver

DevHR/user=testuser

DevHR/password=123456

DevHR/url=jdbc:sqlserver://192.168.1.120;port=1433;databaseName=TestingHR;sendStringParametersAsUnicode=false

 

I figure it's setup correctly since I can use the JNDI connection without issue in Report Designer, but Metadata Editor just isn't seeing it.  I noticed there's also a folder at c:\users\[home folder]\.pentaho-meta\ but there's no default.properties here.  Should there be anything here? 

 

Thanks for any advise.

Sam

Outcomes