I need to be able to query match against a UUID column in a classic SQL type jasper report. So instead of passing a foundset I am going the classic SQL route. I have been able to construct datasets inside the jasper reports for all types of lookups except against the most important one. Our primary keys are UUIDs. If I pass the relevant UUIDs as parameters and make them java strings I get a cast error. If I pass the UUIDs as parameters and make them type com.servoy.j2db.util.UUID then I get Parameter type not supported in query : topic_id class com.servoy.j2db.util.UUID . I also tried doing a cast of the field inside the SQL query and the plugin engine didnt like that either. There should be a way to use the classic SQL (not foundset) method inside jasper reports and query on UUID columns. I really need a way to do this as foundsets arent going to cut what we need to do. Any suggestions?
Pass the UUID as String using yourUUIDValue.toString()
The error in UUID comparision is happening in the jasper reports plugin. Passing the UUID to the report as a string doesnt help and as far as I know there is no UUID type support in jasper reports. So basically I am passing a string version of the UUID to the report but when it does its query against a column in the table that is of type UUID the jasper plug in throws the SQL comparison error. Any other suggestions?