September 2020 - teiid-issues - Jboss List Archives

[teiid-issues] [JBoss JIRA] (TEIIDSB-227) Information about support for Hibernate-Spatial

by Fabian Knoll (Jira)

[ https://issues.redhat.com/browse/TEIIDSB-227?page=com.atlassian.jira.plug... ] Fabian Knoll commented on TEIIDSB-227: -------------------------------------- In my test project I am getting an Exception: {code:java} Caused by: org.teiid.deployers.VirtualDatabaseException: TEIID40095 TEIID31080 teiid.street validation error: TEIID30070 The function 'ST_GeomFromWKB(geom)' is a valid function form, but the arguments do not match a known type signature and cannot be converted using implicit type conversions. {code} I will now investigate on it and also I will try to extract an easy example to provide it here..... > Information about support for Hibernate-Spatial > ----------------------------------------------- > > Key: TEIIDSB-227 > URL: https://issues.redhat.com/browse/TEIIDSB-227 > Project: Teiid Spring Boot > Issue Type: Task > Components: datasource > Affects Versions: 1.6.0 > Reporter: Fabian Knoll > Priority: Major > Labels: hibernate, spatial, types > Fix For: 1.7.0 > > > Hi, > in our project we tried to use Teiid-Spring-Boot to connect to a PostGIS database. We want to use the so called [VDB-less Development|https://github.com/teiid/teiid-spring-boot/blob/master/docs/U...]. Therefore the hibernate spatial mapping for geometry-Types is needed. We tried different (datasource) configurations, but we couldn't get a running example. > Is the hibernate-spatial type mapping supported in Teiid-Spring-Boot and if so, can you provide us an example? > Hint: In our entities we use org.locationtech.jts.geom.Geometry (and subtypes) for the mapped fields. > -- This message was sent by Atlassian Jira (v7.13.8#713008)

6 years, 1 month

1
0
0 / 0

[teiid-issues] [JBoss JIRA] (TEIIDSB-227) Information about support for Hibernate-Spatial

by Fabian Knoll (Jira)

[ https://issues.redhat.com/browse/TEIIDSB-227?page=com.atlassian.jira.plug... ] Fabian Knoll commented on TEIIDSB-227: -------------------------------------- Thanks for the link, I will check that based on my own project. Sorry, I couldn't provide an example in meantime. > Information about support for Hibernate-Spatial > ----------------------------------------------- > > Key: TEIIDSB-227 > URL: https://issues.redhat.com/browse/TEIIDSB-227 > Project: Teiid Spring Boot > Issue Type: Task > Components: datasource > Affects Versions: 1.6.0 > Reporter: Fabian Knoll > Priority: Major > Labels: hibernate, spatial, types > Fix For: 1.7.0 > > > Hi, > in our project we tried to use Teiid-Spring-Boot to connect to a PostGIS database. We want to use the so called [VDB-less Development|https://github.com/teiid/teiid-spring-boot/blob/master/docs/U...]. Therefore the hibernate spatial mapping for geometry-Types is needed. We tried different (datasource) configurations, but we couldn't get a running example. > Is the hibernate-spatial type mapping supported in Teiid-Spring-Boot and if so, can you provide us an example? > Hint: In our entities we use org.locationtech.jts.geom.Geometry (and subtypes) for the mapped fields. > -- This message was sent by Atlassian Jira (v7.13.8#713008)

6 years, 1 month

1
0
0 / 0

[teiid-issues] [JBoss JIRA] (TEIIDSB-227) Information about support for Hibernate-Spatial

by Ramesh Reddy (Jira)

[ https://issues.redhat.com/browse/TEIIDSB-227?page=com.atlassian.jira.plug... ] Ramesh Reddy commented on TEIIDSB-227: -------------------------------------- example here https://github.com/teiid/teiid-spring-boot/blob/master/samples/rdbms... > Information about support for Hibernate-Spatial > ----------------------------------------------- > > Key: TEIIDSB-227 > URL: https://issues.redhat.com/browse/TEIIDSB-227 > Project: Teiid Spring Boot > Issue Type: Task > Components: datasource > Affects Versions: 1.6.0 > Reporter: Fabian Knoll > Priority: Major > Labels: hibernate, spatial, types > Fix For: 1.7.0 > > > Hi, > in our project we tried to use Teiid-Spring-Boot to connect to a PostGIS database. We want to use the so called [VDB-less Development|https://github.com/teiid/teiid-spring-boot/blob/master/docs/U...]. Therefore the hibernate spatial mapping for geometry-Types is needed. We tried different (datasource) configurations, but we couldn't get a running example. > Is the hibernate-spatial type mapping supported in Teiid-Spring-Boot and if so, can you provide us an example? > Hint: In our entities we use org.locationtech.jts.geom.Geometry (and subtypes) for the mapped fields. > -- This message was sent by Atlassian Jira (v7.13.8#713008)

6 years, 1 month

1
0
0 / 0

[teiid-issues] [JBoss JIRA] (TEIIDSB-227) Information about support for Hibernate-Spatial

by Ramesh Reddy (Jira)

[ https://issues.redhat.com/browse/TEIIDSB-227?page=com.atlassian.jira.plug... ] Ramesh Reddy resolved TEIIDSB-227. ---------------------------------- Fix Version/s: 1.7.0 Resolution: Done > Information about support for Hibernate-Spatial > ----------------------------------------------- > > Key: TEIIDSB-227 > URL: https://issues.redhat.com/browse/TEIIDSB-227 > Project: Teiid Spring Boot > Issue Type: Task > Components: datasource > Affects Versions: 1.6.0 > Reporter: Fabian Knoll > Priority: Major > Labels: hibernate, spatial, types > Fix For: 1.7.0 > > > Hi, > in our project we tried to use Teiid-Spring-Boot to connect to a PostGIS database. We want to use the so called [VDB-less Development|https://github.com/teiid/teiid-spring-boot/blob/master/docs/U...]. Therefore the hibernate spatial mapping for geometry-Types is needed. We tried different (datasource) configurations, but we couldn't get a running example. > Is the hibernate-spatial type mapping supported in Teiid-Spring-Boot and if so, can you provide us an example? > Hint: In our entities we use org.locationtech.jts.geom.Geometry (and subtypes) for the mapped fields. > -- This message was sent by Atlassian Jira (v7.13.8#713008)

6 years, 1 month

1
0
0 / 0

[teiid-issues] [JBoss JIRA] (TEIID-5906) Occasional test failure

by Bruno Alejos Gómez (Jira)

[ https://issues.redhat.com/browse/TEIID-5906?page=com.atlassian.jira.plugi... ] Bruno Alejos Gómez updated TEIID-5906: -------------------------------------- Sprint: (was: ) > Occasional test failure > ----------------------- > > Key: TEIID-5906 > URL: https://issues.redhat.com/browse/TEIID-5906 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Major > Fix For: 13.1 > > Original Estimate: 6 hours > Time Spent: 1 hour, 30 minutes > Remaining Estimate: 4 hours, 30 minutes > > TestWithClauseProcessing.testWithImplicitIndexing fails occasionally. Locally I have reproduced this after ~700 runs of the test. > I'm not sure at this point what is introducing the non-determinism. I'll check if we need a better bound or if there is something deeper failing. -- This message was sent by Atlassian Jira (v7.13.8#713008)

6 years, 1 month

1
0
0 / 0

[teiid-issues] [JBoss JIRA] (TEIID-5924) Salesforce: UPDATE doesn't work when setting null values

by Bruno Alejos Gómez (Jira)

[ https://issues.redhat.com/browse/TEIID-5924?page=com.atlassian.jira.plugi... ] Bruno Alejos Gómez updated TEIID-5924: -------------------------------------- Sprint: (was: ) > Salesforce: UPDATE doesn't work when setting null values > -------------------------------------------------------- > > Key: TEIID-5924 > URL: https://issues.redhat.com/browse/TEIID-5924 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 13.1 > Reporter: Dmitrii Pogorelov > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 14.0, 13.0.3, 13.1.1 > > Original Estimate: 4 hours > Time Spent: 4 hours > Remaining Estimate: 0 minutes > > UPDATE command doesn't work when setting null values: > {code:sql} > select w.* from (call sf34.native('update;type=Contact;attributes=id, OwnerId, LastName, Birthdate', '0031Y000062bY4aQAE', '005i0000002dtHTAAY', 'test_updates_null', null)) as w ;; > > update sf34.Contact set Birthdate = null where LastName = 'test_updates_null' ;; > {code} > queries do nothing. The query: > {code:sql} > select OwnerId, LastName, Birthdate from sf34.Contact where LastName = 'test_updates_null' ;; > {code} > will return the same result as before running these UPDATE commands. -- This message was sent by Atlassian Jira (v7.13.8#713008)

6 years, 1 month

1
0
0 / 0

[teiid-issues] [JBoss JIRA] (TEIIDSB-227) Information about support for Hibernate-Spatial

by Ramesh Reddy (Jira)

[ https://issues.redhat.com/browse/TEIIDSB-227?page=com.atlassian.jira.plug... ] Ramesh Reddy commented on TEIIDSB-227: -------------------------------------- Can you provide me with an example for this? > Information about support for Hibernate-Spatial > ----------------------------------------------- > > Key: TEIIDSB-227 > URL: https://issues.redhat.com/browse/TEIIDSB-227 > Project: Teiid Spring Boot > Issue Type: Task > Components: datasource > Affects Versions: 1.6.0 > Reporter: Fabian Knoll > Priority: Major > Labels: hibernate, spatial, types > > Hi, > in our project we tried to use Teiid-Spring-Boot to connect to a PostGIS database. We want to use the so called [VDB-less Development|https://github.com/teiid/teiid-spring-boot/blob/master/docs/U...]. Therefore the hibernate spatial mapping for geometry-Types is needed. We tried different (datasource) configurations, but we couldn't get a running example. > Is the hibernate-spatial type mapping supported in Teiid-Spring-Boot and if so, can you provide us an example? > Hint: In our entities we use org.locationtech.jts.geom.Geometry (and subtypes) for the mapped fields. > -- This message was sent by Atlassian Jira (v7.13.8#713008)

6 years, 1 month

1
0
0 / 0

[teiid-issues] [JBoss JIRA] (TEIIDSB-226) How to create dynamic datasources using Spring boot starter Teiid

by Ramesh Reddy (Jira)

[ https://issues.redhat.com/browse/TEIIDSB-226?page=com.atlassian.jira.plug... ] Ramesh Reddy resolved TEIIDSB-226. ---------------------------------- Resolution: Explained > How to create dynamic datasources using Spring boot starter Teiid > ----------------------------------------------------------------- > > Key: TEIIDSB-226 > URL: https://issues.redhat.com/browse/TEIIDSB-226 > Project: Teiid Spring Boot > Issue Type: Feature Request > Reporter: rahul gholap > Priority: Major > > We are trying to use Spring boot starter teiid in our application.We want to connect to any databases as per user input.User have to select database type and enter connection properties in user Interface of our application.so in that case how we can use Spring boot starter Teiid to specify connection properties runtime. because we are usually specifying all the datasource properties before runing application. -- This message was sent by Atlassian Jira (v7.13.8#713008)

6 years, 1 month

1
0
0 / 0

[teiid-issues] [JBoss JIRA] (TEIID-6034) Teiid - Queries Containing Both String Filters With Quotes and Timestamp Fail

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-6034?page=com.atlassian.jira.plugi... ] Steven Hawkins commented on TEIID-6034: --------------------------------------- Is this really against 8.6? Are these xml document model queries? What is the failure exactly? > Teiid - Queries Containing Both String Filters With Quotes and Timestamp Fail > ----------------------------------------------------------------------------- > > Key: TEIID-6034 > URL: https://issues.redhat.com/browse/TEIID-6034 > Project: Teiid > Issue Type: Bug > Components: XML Planner/Processor > Affects Versions: 8.6 > Reporter: John Cockson > Assignee: Steven Hawkins > Priority: Major > > Combining filter with quotes in strings and TimestampAdd causes query to fail: > -- This message was sent by Atlassian Jira (v7.13.8#713008)

6 years, 1 month

1
0
0 / 0

[teiid-issues] [JBoss JIRA] (TEIID-6034) Teiid - Queries Containing Both String Filters With Quotes and Timestamp Fail

by John Cockson (Jira)

[ https://issues.redhat.com/browse/TEIID-6034?page=com.atlassian.jira.plugi... ] John Cockson commented on TEIID-6034: ------------------------------------- [~shawkins] we have some users that are reliant on a fix for this. Please provide a timeline as soon as you are able. > Teiid - Queries Containing Both String Filters With Quotes and Timestamp Fail > ----------------------------------------------------------------------------- > > Key: TEIID-6034 > URL: https://issues.redhat.com/browse/TEIID-6034 > Project: Teiid > Issue Type: Bug > Components: XML Planner/Processor > Affects Versions: 8.6 > Reporter: John Cockson > Assignee: Steven Hawkins > Priority: Major > > Combining filter with quotes in strings and TimestampAdd causes query to fail: > -- This message was sent by Atlassian Jira (v7.13.8#713008)

6 years, 1 month

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues September 2020