[JBoss JIRA] (TEIID-2502) Oracle Struct Serialization Error
- First Post
- Replies
- Stats
-
Go to
- ----- 2025 -----
- January
- ----- 2024 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2023 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2022 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2021 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2020 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2019 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2018 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2017 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2016 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2015 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2014 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2013 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2012 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2011 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2010 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2009 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
[
https://issues.jboss.org/browse/TEIID-2502?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-2502.
-----------------------------------
Resolution: Done
Added the structretrieval translator property. It can be one of OBJECT (default), COPY,
ARRAY. In the thread linked to this issue, COPY mode would address the serialization
error. ARRAY mode can be used to retrieve a value that can be utilized by the Teiid array
logic (array_get, arraytable, etc.).
When additional handling is added for struct/array types in the engine we can revisit this
support.
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.4.1, 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
4228
days inactive
4228
days old
0 comments
1 participants
tags (0)
participants (1)
-
Steven Hawkins (JIRA)