Posts

Showing posts from May, 2015

Fixing Unicode issues in Pentaho CDA

Recently I encountered problem when sending a query parameter with unicode text to Pentaho CDA. For these type of queries CDA returns an empty result set although there are matching items. After some research I fixed this issue by adding an additional parameter to the JDBC connection url. Now JDBC connection is like below. <DataSources>         <Connection id="1" type="sql.jdbc">             <Driver>com.mysql.jdbc.Driver</Driver>             <Url>jdbc:mysql://host:3306/DB?useUnicode=true&amp;characterEncoding=UTF-8</Url>             <User>user</User>             <Pass>pass</Pass>         </Connection>  </DataSources>