[
https://issues.jboss.org/browse/TEIID-2502?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-2502:
---------------------------------------
There is currently no special handling for oracle spatial type values. Assuming that you
have the column typed as object, we're just using the getObject method on the result
set to get the value. If there is a better representation, then a different getter or
post retrieval operation can be performed (for example if there a standard type
representation that is acceptable).
Otherwise the translator or the batch serialization logic needs to do more to handle these
values. Do you know what the java class representation is?
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