Accessing Column of type “Java Object” in a Birt report with cascaded queries?

From past experience, I think the answer is that BIRT can only represent relatively simple datatypes - essentially characters, dates and numbers (it does seem to be able to cope with CLOBs, but then they are essentially long character strings).

From past experience, I think the answer is that BIRT can only represent relatively simple datatypes - essentially characters, dates and numbers (it does seem to be able to cope with CLOBs, but then they are essentially long character strings). Since it is unable to represent object fields, these are presented as NULLs in the report. If you set the datatype of an object field to be string, it will display the binary contents of the object as a string of hexadecimal digits.(At least, this has been my experience when inadvertently returning objects from MySQL queries.).

It is not quite correct. If I output a "Java Object" field on Level 1 or 2 it is output by calling "toString" on the object and I get a string representation of my object. In Level 3 it's simply null and I don't know why.

– chrisdutz Dec 1 at 10:41 @Chris: As I said, this was from my past experience reporting object types from databases - since you are not reporting from a SQL database, my experience is probably not very useful to you. – Mark Bannister Dec 1 at 10:45.

If the Java Object is being stored as a blob in your database, then BIRT won't be able to interpret it directly as far as I know. Are you using an oracle database? If you were to connect through an alternate client (not your java application), would you be able to query the field and get meaningful data?(As in, is it serialized data, or stored in a blob format)?

I am not using a Database at all ... I have created my own DataSource that queries a remote BlazeDS server unsing AMF3. So my reports model consists of a POJO model. – chrisdutz Dec 1 at 10:40.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.