Skip to Content
0
Former Member
Nov 29, 2006 at 10:16 AM

JDBC Array fields

40 Views

<p>I&#39;m working with a database which has array fields. When I add those fields to a report, the output is just an exception, so I assume that that data type isn&#39;t supported. I&#39;ve been reading as much doc as I can find and I haven&#39;t come across any sort of callback that would let me read the data and return a formatted version to the report (but, you know, I&#39;d hoped).</p><p> At the moment I think that I&#39;ll need to retrieve the result set myself, copy it into a POJO, and use that for reporting. Does that seem right?</p><p>(A slightly more out there possibility is to add a pseudo-field to the view which returns the array as a string and use that in the report instead of the array field; we implemented the JDBC driver, so we could do that here.)<br /></p>