[teiid-issues] [JBoss JIRA] (TEIID-2502) org.teiid.net.socket.SingleInstanceCommunicationException

Fri May 17 06:44:06 EDT 2013

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

Steven Hawkins commented on TEIID-2502:
---------------------------------------

> So maybe a struct could be better than object? Is something that can be tried on my part or a patch yuo need to address?

More than likely ResultSet.getObject is returning an Oracle STRUCT - however their STRUCT is not fully serializable as it has the connection as a member.  There are a couple of options:

- Use the STRUCT.getAttributes method to map the value to an Object[] (which presumably would be serializable).  A variant of this would be to use a SerialStruct to do effectively the same thing. These would not be specific to Oracle.
- Use the JGeometry representation.

Either way built-in handling will require some thought (how to formalize struct handling and/or the best approach to spatial support), but my initial thought would likely be to use the SerialStruct approach.

The quickest fix would be to extend the OracleExecutionFactory and add whatever handling you want in overriden retrieveValue methods.

> org.teiid.net.socket.SingleInstanceCommunicationException
> ---------------------------------------------------------
>
>                 Key: TEIID-2502
>                 URL: https://issues.jboss.org/browse/TEIID-2502
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 8.2
>         Environment: centos 6.3
>            Reporter: luca gioppo
>            Assignee: Steven Hawkins
>            Priority: Critical
>
> 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