The JDBC Client

The JDBC driver uses the following class:

org.pentaho.di.core.jdbc.ThinDriver  (Note: This is the class for Pentaho version 5.4.x or earlier.)

The URL is in the following format:

...

• Strings have single quotes around them, escaping quotes is done by doubling the single quote.
• Dates have square brackets around them and the following formats are supported: [yyyy/MM/dd HH:mm:ss.SSS], [yyyy/MM/dd HH:mm:ss] and [yyyy/MM/dd]
• Number and BigNumber should have no grouping symbol and the decimal is . (example 123.45)
• Integers contain only digits
• Boolean values can be TRUE or FALSE

...