Bug 1226323
| Summary: | INSERT statement with Object value fails - Unsupported Types value: 2,000 [postgres] | ||
|---|---|---|---|
| Product: | [JBoss] JBoss Data Virtualization 6 | Reporter: | Juraj Duráni <jdurani> |
| Component: | Teiid | Assignee: | Van Halbert <vhalbert> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | |
| Severity: | unspecified | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | 6.2.0 | CC: | atangrin, dlesage, vhalbert |
| Target Milestone: | ER1 | ||
| Target Release: | 6.3.0 | ||
| Hardware: | x86_64 | ||
| OS: | Linux | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: |
OS: Fedora 20
arch: x86_64
java: oracle 1.8
|
|
| Last Closed: | 2016-08-24 11:42:22 UTC | Type: | Bug |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
Steven Hawkins <shawkins> updated the status of jira TEIID-3497 to Resolved |
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> Document URL: Section Number and Name: Describe the issue: Suggestions for improvement: Additional information: