JasperServer Pro 3.0.0 Domain missing db columns

[techiebrandon]

 I am working with JasperServer Pro 3.0.0, working through my first Ad hoc reports. I have some tables specified in the database which the domain engine does not seem to see completely, and I cannot find any documentation to suggest why. My tables have many columns; two of which, NAME and DESCRIPTION, that are not visible or usable when creating the Domain component to be used during the creation of the ad hoc report. I tried to continue forward with the creation, assuming that these were special keyword columns in JasperServer and maybe a join on them was not acceptable, however when picking the measure and group during the final stages of ad hoc report creation they are still not accessible.

I can query the DB directly and get all my columns, and in other jrxml-based reports I can query using these fields. I am at a loss as to what I am doing wrong, any direction or references are welcome! 

 

[techiebrandon]

 Found this to be an issue with JasperServer 3.0 when table columns are of type varchar2. JasperServer does not understand this column type, must create custom view for JS to see columns.