[teiid-issues] [JBoss JIRA] (TEIID-2502) Oracle Struct Serialization Error

Thu May 23 16:30:06 EDT 2013

     [ https://issues.jboss.org/browse/TEIID-2502?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins updated TEIID-2502:
----------------------------------

          Summary: Oracle Struct Serialization Error  (was: org.teiid.net.socket.SingleInstanceCommunicationException)
       Issue Type: Enhancement  (was: Bug)
    Fix Version/s: 8.5
         Priority: Major  (was: Critical)

Given the number of workarounds (custom translator, udf, or even use of OBJECTTABLE with the javascript or other capable binding to wrap the values as a SerialClob) and this effectively being new type handling, marking this as a major enhancement rather than a critical bug.  

A related bug/quality risk would be to more gracefully handle these situations the data stream has not yet actually become compromised, we could trigger sending the client a very generic exception message that would be handled by the base communication layer.

Given the short time remaining for 8.4, putting into 8.4.1.

> Oracle Struct Serialization Error
> ---------------------------------
>
>                 Key: TEIID-2502
>                 URL: https://issues.jboss.org/browse/TEIID-2502
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Query Engine
>    Affects Versions: 8.2
>         Environment: centos 6.3
>            Reporter: luca gioppo
>            Assignee: Steven Hawkins
>             Fix For: 8.5
>
>         Attachments: ora.patch
>
>
> I'm issuing a query (a simple select * from table) on a VDB's table that contains a geometric column from oracle spatial.
> I'm getting the following error in SquirrelSQL
> Error: org.teiid.net.socket.SingleInstanceCommunicationException
> SQLState:  08S01
> ErrorCode: 0
> Afterwards the connection is broken and I cannot access any other table and have to reconnect since I get:
> Error: Error Code:TEIID20013 Message:Error Code:TEIID20013 Message:java.net.SocketException: Socket closed
> SQLState:  TEIID20013
> ErrorCode: 0
> I'm trying to access a SDO table and a geometry type column, but hoped that TEIID could read it as a BLOB without caring about the real type.
> Probably it doesn't like it too much.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira