...
The MQL Preview button allows the user to preview the data that will be returned from the MQL Query. In order for the preview to function properly, your Pentaho BI Server must be running. Prior to release 1.6.M5 preview was not functional. A preliminary fix, requiring manual configuration of JNDI connections, has been made in version 1.6.M5 that corrects this issue. To enable MQL Preview functionality create the following directory <workspace-dir>/.metadata/.For preview to work, the JDBC driver jar file for the database you are trying to use must be in the plugin classpath. To add a new JDBC driver to your plugin classpath, follow these steps:
- The driver jar for your RDBMS should be dropped into the <eclipse_install_directory>/plugins/org.pentaho.designstudio.editors.actionsequence_x.x.x/lib directory.
- Next edit, <eclipse_install_directory>/plugins/org.pentaho.designstudio.editors.actionsequence
...
SampleData/type=javax.sql.DataSource
SampleData/driver=org.hsqldb.jdbcDriver
SampleData/url=jdbc:hsqldb:hsql://localhost/sampledata
SampleData/user=pentaho_user
SampleData/password=password
...
- _x.x.x/META-INF/MANIFEST.MF and add your driver jar name and location to the bundle classpath. The entry may look like this: lib/mydriver.jar,
- Note that if you are modifying an existing Pentaho action sequence plugin already deployed and used in Eclipse, you may need to remove the plugin, start and stop Eclipse, re-deploy the plugin and make the necessary driver changes BEFORE starting Eclipse again. It seems there are some caching issues in Eclipse that prevents Eclipse from recognizing the MANIFEST file changes if the action sequence plugin was used previously.
If the metadata model that the query is run against uses a JNDI connection definition (a named JNDI datasource), then you must modify the simple-jndi settings in your pentaho-solutions project to include the JNDI name that your model references.
- Navigate in your pentaho-solutions to the pentaho-solutions/system/simple-jndi/jdbc.properties.
- Open this file, and following the format you see there for a database connection definition, add your JNDI connection information.
Once this is done MQL queries can be previewed.Future releases of the design studio will enable the user to define their JNDI connections using the Pentaho preferences dialog (Refer to JIRA case #PDS-277).