[teiid-issues] [JBoss JIRA] (TEIID-1892) Support the get/setArray methods of JDBC resultsets/statements

[Steven Hawkins (Commented) (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-1892?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12654365#comment-12654365 ] 

Steven Hawkins commented on TEIID-1892:
---------------------------------------

Yes, Java arrays are serializable.  However JDBC uses java.sql.Array to represent arrays, which adds complexity.  We currently provide no concrete implementation of that interface.  If you need to use the Array interface, you could do so without additional built-in Teiid support by just supplying an implementation that is also serializable via setObject.  If you just want to pass an array object, then it would be even simpler to just pass it directly via setObject.

The full enchantment is to make the type system aware of array types (with additional language support for array value constructors, comparison, etc.).  You would need to choose a runtime representation which would be a subclass of Array.  And yes designer would be affected as well - as the system vdb (since it contains the built-in types) and a significant amount of type logic would need to be updated.  The Array type would need additional serialization support, such as the logic used with the lob types to perform a memory safe bulk transfer.  Of course a subset of that feature may make sense on an incremental basis.
                
> Support the get/setArray methods of JDBC resultsets/statements
> --------------------------------------------------------------
>
>                 Key: TEIID-1892
>                 URL: https://issues.jboss.org/browse/TEIID-1892
>             Project: Teiid
>          Issue Type: Sub-task
>          Components: JDBC Driver
>            Reporter: Mark Addleman
>            Assignee: Steven Hawkins
>
> We'd like the array related JDBC methods supported.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira