]
Steven Hawkins resolved TEIID-3497.
-----------------------------------
Resolution: Duplicate Issue
Duplicate of TEIID-3340
INSERT statement with Object value fails - Unsupported Types value:
2,000 [postgres]
------------------------------------------------------------------------------------
Key: TEIID-3497
URL:
https://issues.jboss.org/browse/TEIID-3497
Project: Teiid
Issue Type: Bug
Affects Versions: 8.7.1.6_2
Environment: OS: Fedora 20
arch: x86_64
java: oracle 1.8
Reporter: Juraj DurĂ¡ni
Assignee: Steven Hawkins
The INSERT query with Object value fails with the root exception:
Caused by: org.postgresql.util.PSQLException: Unsupported Types value: 2,000
at
org.postgresql.jdbc2.AbstractJdbc2Statement.setObject(AbstractJdbc2Statement.java:1858)
...
Insert query [1], source specific command [2], postgres table [3], teiid vdb[4].
[1] INSERT INTO smalla VALUES
(55,'0',NULL,'-24',-24.00,-24,-24.0,-128,{d'2000-01-01'},{t'00:00:00'},{ts'2000-01-01
00:00:00.0'},0,'1',-32768,-24,-24,'-24')
[2] INSERT INTO smalla (IntKey, StringKey, IntNum, StringNum, FloatNum, LongNum,
DoubleNum, ByteNum, DateValue, TimeValue, TimestampValue, BooleanValue, CharValue,
ShortValue, BigIntegerValue, BigDecimalValue, ObjectValue) VALUES (55, '0', NULL,
'-24', -24.0, -24, -24.0, -128, DATE '2000-01-01', TIME
'00:00:00', TIMESTAMP '2000-01-01 00:00:00.0', FALSE, '1', -32768,
-24, -24, ?)
[3]
create table SmallA (StringNum varchar(15),
IntNum integer,
DoubleNum double precision,
StringKey varchar(15),
BigDecimalValue numeric(15,5),
IntKey integer,
ByteNum smallint,
DateValue date,
TimeValue time,
TimestampValue timestamp,
BooleanValue boolean,
CharValue char(1),
ShortValue smallint,
FloatNum real,
LongNum bigint,
BigIntegerValue numeric(15,0),
ObjectValue text);
[4]
<vdb name="vdb-tmp" version="1">
<model name="Source">
<source name="local" translator-name="postgresql"
connection-jndi-name="java:/localPostgreSQL"/>
<metadata type="DDL"><![CDATA[
CREATE FOREIGN TABLE smalla(IntKey integer, StringKey string, IntNum integer, StringNum
string, FloatNum float, LongNum long, DoubleNum double, ByteNum byte, DateValue date,
TimeValue time, TimestampValue timestamp, BooleanValue boolean, CharValue char, ShortValue
short, BigIntegerValue biginteger, BigDecimalValue bigdecimal, ObjectValue object) OPTIONS
(UPDATABLE 'TRUE');
]]>
</metadata>
</model>
</vdb>