by cakins » Sat Sep 27, 2014 7:47 pm
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?