...
If you are going to be using JNDI you must edit {WIZARD-ROOT}/ resources/solutions/system/simple-jndi/jdbc.properties. An example entry in this file would appear as follows.
| Code Block |
|---|
SampleData/type=javax.sql.DataSource |
...
SampleData/driver=org.hsqldb.jdbcDriver |
...
SampleData/url=jdbc:hsqldb:hsql://localhost/sampledata |
...
SampleData/user=pentaho_user |
...
SampleData/password=password |
SampleData is the name of the JNDI connection being setup, all of the name/value pairs configure the pertinent connection information. The */type setting tells JNDI what is being managed, in this case, a SQL datasource. The */driver setting is the JDBC driver class name for the database we're accessing. The */url is the JDBC connect string, the example shown here is for a Hypersonic database server running locally. The next two settings are the user's credentials for logging in to the database if required.
...