Fixing Unicode issues in Pentaho CDA

By -
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>


Comments

Post a Comment

Popular posts from this blog

Fixing Error "Failed to load VMMR0.r0 (VERR_SUPLIB_WORLD_WRITABLE)" in Virtualbox

By -
Recently I  to installed Oracle Virtualbox on my Ubuntu 12.04 computer to run Hortanworks sandbox. When I am trying to start the Sanbox it gave me an error like this. Failed to load VMMR0.r0 (VERR_SUPLIB_WORLD_WRITABLE). Unknown error creating VM (VERR_SUPLIB_WORLD_WRITABLE). What it says is /usr/bin forlder is world writable. Usually this is not world writable. But somehow I have unintentionally changed the permissions. I fixed this using the following command. chmod o-w /usr/bin
Read more

Create new Java Class files at runtime

By -
When we write programs usual method is to write all the code compile it and run. But when we try to complex things some times we may want to generate a new class and use it at runtime. As an example I wanted to create a class which parse a xml message and create a new Java object from that data. This is used in web server. So that result object varies according to the web service which is deployed. The solution was to inspect the service at deployment time and create a new parser class according to that in the service deployment time. It has to be noted that this parser had to be generated as a .class file and dynamically added to the classpath. So the result was to use a bytecode manupulation library. There are few bytecode manuplulation libraries available as ASM and JavaAssist . I used JavaAssist for this. The reason for using JavaAssist is it is simple to create a new class from the scratch using JavaAssit. When we create new class files using JavaAssit we have to create all t...
Read more

Using iReport plugin for Jasper Reports in Netbeans

By -
Image
Jasper reports is a very useful frame work for genarating reports, saving them as PDF,etc. iReport make it more easy because we can design reports using graphical methods from it. Also it is available as a plugin for NetBeans. You can download iReport Netbeans plugin from here . there are for files in the Zip folder. You can install them by at one by selecting all of them when you select the plugin to install from Netbeans (If you don't know how to install a plugin for Netbeans search for a tutorial). To use Jasper Reports in your application you have to add some libraries. But the problem is these libraries are heavily coupled with each other. So downloading each one is a very difficult task because there are problems like versions don't match, some libraries are outdated, etc.etc. There is a easy method. After installing the plugin Netbeans will automatically add the Jasper Reports library to its library collection. But it is missing one important...
Read more