General issues

Resolve common issues with the Pentaho suite.

In this topic

• JDBC driver issues

• Data conversion issues with MySQL driver 5.0.8

• Fixing JTDS varchar(Max) limitations in MSSQL 2005

JDBC driver issues

Make sure the correct JDBC driver JARs are installed. Remove conflicting driver versions.

If you use the JDBC Distribution Tool, it can place drivers correctly. For more details, see Install Pentaho Data Integration and Analytics.

To install a JDBC driver for the Pentaho Server:

1. Stop the Pentaho Server.

2. Copy the driver JAR to <pentaho-install-directory>/server/pentaho-server/tomcat/lib.

3. Start the Pentaho Server.

Data conversion issues with MySQL driver 5.0.8

MySQL JDBC driver version 5.0.8 can cause data conversion errors. Numeric-to-string conversions may return a byte array instead of a string.

Replace mysql-connector-java-5.0.8.jar with mysql-connector-java-5.0.7.jar. Restart your client tool or application server.

Fixing JTDS varchar(Max) limitations in MSSQL 2005

Reports that use varchar(MAX) can return a net.sourceforge.jtds.jdbc.ClobImpl@... error. This is a known limitation in older JTDS drivers.

Upgrade to Microsoft SQL Server JDBC driver version 1.0.809.102 or later. Download the driver from Microsoft. Restart SQL Server.