January 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3274) Change archetypes to create independent projects

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3274?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3274: ------------------------------------------------ Juraj Duráni <jdurani(a)redhat.com> changed the Status of [bug 1178658|https://bugzilla.redhat.com/show_bug.cgi?id=1178658] from ON_QA to ASSIGNED > Change archetypes to create independent projects > ------------------------------------------------ > > Key: TEIID-3274 > URL: https://issues.jboss.org/browse/TEIID-3274 > Project: Teiid > Issue Type: Enhancement > Components: Tools > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 8.7.1 > > > The current archetypes were developed with the mindset of generating projects that are part of the Teiid build. However, they need to be changed so that they are generating projects that are independent, that can stand on their own without requiring Teiid jar's. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3269) Oracle pushdown time formatting incorrect

by Juraj Duráni (JIRA)

[ https://issues.jboss.org/browse/TEIID-3269?page=com.atlassian.jira.plugin... ] Juraj Duráni commented on TEIID-3269: ------------------------------------- What do you mean by "invalid matches"? According to the Teiid doc (*) and the oracle doc (*)(*) are F and u valid options. (*) (Date_Time Functions > Parsing Date Datatypes from Strings): "You can learn more about how this class defines date and time string formats by visiting the Javadocs for SimpleDateFormat." I expect that similar logic applies for formatting of the output. (*)(*)http://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html > Oracle pushdown time formatting incorrect > ----------------------------------------- > > Key: TEIID-3269 > URL: https://issues.jboss.org/browse/TEIID-3269 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 8.7.1, 8.9.1, 8.10 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.10 > > > Oracle formatting cannot control the number of digits displayed in the same way as Java formatting, needs to AM instead of PM, and needs better handling for ERA. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3305) Add system functions for GeoJSON

by Tom Arnold (JIRA)

[ https://issues.jboss.org/browse/TEIID-3305?page=com.atlassian.jira.plugin... ] Tom Arnold commented on TEIID-3305: ----------------------------------- Sent PR. The jts2geojson library uses Jackson 2.x which is already a module (for Olingo?), but I needed to bring in the databind & annotation modules as well. Also I batched the GML2 commits (TEIID-3309) into this since I did them at the same time. > Add system functions for GeoJSON > -------------------------------- > > Key: TEIID-3305 > URL: https://issues.jboss.org/browse/TEIID-3305 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Tom Arnold > Assignee: Steven Hawkins > Labels: spatial > > Add system functions to convert between GEOMETRY and GeoJSON. These will be helpful for sources that use GeoJSON (like MongoDB and RethinkDB). > Conversion will be GeometryType (WKB) ↔ JTS Geometry ↔ GeoJSON. > * https://github.com/bjornharrtell/jts2geojson > * http://geojson.org/geojson-spec.html > * http://wiki.geojson.org/GeoJSON_draft_version_5 > I don't believe these are part of the OGC spec, but it would probably be best to implement them similar to PostGIS. > * http://postgis.org/docs/ST_AsGeoJSON.html > * http://postgis.org/docs/ST_GeomFromGeoJSON.html -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3305) Add system functions for GeoJSON

by Tom Arnold (JIRA)

[ https://issues.jboss.org/browse/TEIID-3305?page=com.atlassian.jira.plugin... ] Tom Arnold updated TEIID-3305: ------------------------------ Git Pull Request: https://github.com/teiid/teiid/pull/397 > Add system functions for GeoJSON > -------------------------------- > > Key: TEIID-3305 > URL: https://issues.jboss.org/browse/TEIID-3305 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Tom Arnold > Assignee: Steven Hawkins > Labels: spatial > > Add system functions to convert between GEOMETRY and GeoJSON. These will be helpful for sources that use GeoJSON (like MongoDB and RethinkDB). > Conversion will be GeometryType (WKB) ↔ JTS Geometry ↔ GeoJSON. > * https://github.com/bjornharrtell/jts2geojson > * http://geojson.org/geojson-spec.html > * http://wiki.geojson.org/GeoJSON_draft_version_5 > I don't believe these are part of the OGC spec, but it would probably be best to implement them similar to PostGIS. > * http://postgis.org/docs/ST_AsGeoJSON.html > * http://postgis.org/docs/ST_GeomFromGeoJSON.html -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3302) Implement ST_Transform

by Tom Arnold (JIRA)

[ https://issues.jboss.org/browse/TEIID-3302?page=com.atlassian.jira.plugin... ] Tom Arnold updated TEIID-3302: ------------------------------ Description: Implement [ST_Transform|http://postgis.org/docs/ST_Transform.html] system function. This would be used to transform geometry between different coordinate systems. This needs SPATIAL_REF_SYS table and a supporting library. There are a couple of options for implementing this: * http://trac.osgeo.org/proj4j/ - Port of the C library used by PostGIS. Fewest dependencies and should keep us close to PostGIS in capabilities. There will be a little boilerplate to interface with JTS. * http://docs.geotools.org/latest/userguide/library/referencing/index.html - GeoTools referencing module. I think we would need to develop a simple plugin to interface with our SPATIAL_REF_SYS table. GeoTools is active and has good docs, but brings in a lot of dependencies. was: Implement [ST_Transform|http://postgis.org/docs/ST_Transform.html] system function. This would be used to transform geometry between different coordinate systems. This needs SPATIAL_REF_SYS table and a supporting library. There are a couple of options for implementing this: * http://trac.osgeo.org/proj4j/ - Port of the C library used by PostGIS. Fewest dependencies and should keep us close to PostGIS in capabilities, but the project looks dead for about a year. Also there would be a little boilerplate to interface with JTS types. * http://docs.geotools.org/latest/userguide/library/referencing/index.html - GeoTools referencing module. I think we would need to develop a simple plugin to interface with our SPATIAL_REF_SYS table. GeoTools is active and has good docs, but brings in a lot of dependencies. > Implement ST_Transform > ---------------------- > > Key: TEIID-3302 > URL: https://issues.jboss.org/browse/TEIID-3302 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Tom Arnold > Assignee: Steven Hawkins > Labels: spatial > > Implement [ST_Transform|http://postgis.org/docs/ST_Transform.html] system function. This would be used to transform geometry between different coordinate systems. This needs SPATIAL_REF_SYS table and a supporting library. > There are a couple of options for implementing this: > * http://trac.osgeo.org/proj4j/ - Port of the C library used by PostGIS. Fewest dependencies and should keep us close to PostGIS in capabilities. There will be a little boilerplate to interface with JTS. > * http://docs.geotools.org/latest/userguide/library/referencing/index.html - GeoTools referencing module. I think we would need to develop a simple plugin to interface with our SPATIAL_REF_SYS table. GeoTools is active and has good docs, but brings in a lot of dependencies. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3305) Add system functions for GeoJSON

by Tom Arnold (JIRA)

[ https://issues.jboss.org/browse/TEIID-3305?page=com.atlassian.jira.plugin... ] Tom Arnold updated TEIID-3305: ------------------------------ Description: Add system functions to convert between GEOMETRY and GeoJSON. These will be helpful for sources that use GeoJSON (like MongoDB and RethinkDB). Conversion will be GeometryType (WKB) ↔ JTS Geometry ↔ GeoJSON. * ~https://github.com/bjornharrtell/jts2geojson~ * http://geojson.org/geojson-spec.html * http://wiki.geojson.org/GeoJSON_draft_version_5 I don't believe these are part of the OGC spec, but it would probably be best to implement them similar to PostGIS. * http://postgis.org/docs/ST_AsGeoJSON.html * http://postgis.org/docs/ST_GeomFromGeoJSON.html was: Add system functions to convert between GEOMETRY and GeoJSON. These will be helpful for sources that use GeoJSON (like MongoDB and RethinkDB). Conversion will be GeometryType (WKB) ↔ JTS Geometry ↔ GeoJSON. * -https://github.com/bjornharrtell/jts2geojson- * http://geojson.org/geojson-spec.html * http://wiki.geojson.org/GeoJSON_draft_version_5 I don't believe these are part of the OGC spec, but it would probably be best to implement them similar to PostGIS. * http://postgis.org/docs/ST_AsGeoJSON.html * http://postgis.org/docs/ST_GeomFromGeoJSON.html > Add system functions for GeoJSON > -------------------------------- > > Key: TEIID-3305 > URL: https://issues.jboss.org/browse/TEIID-3305 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Tom Arnold > Assignee: Steven Hawkins > Labels: spatial > > Add system functions to convert between GEOMETRY and GeoJSON. These will be helpful for sources that use GeoJSON (like MongoDB and RethinkDB). > Conversion will be GeometryType (WKB) ↔ JTS Geometry ↔ GeoJSON. > * ~https://github.com/bjornharrtell/jts2geojson~ > * http://geojson.org/geojson-spec.html > * http://wiki.geojson.org/GeoJSON_draft_version_5 > I don't believe these are part of the OGC spec, but it would probably be best to implement them similar to PostGIS. > * http://postgis.org/docs/ST_AsGeoJSON.html > * http://postgis.org/docs/ST_GeomFromGeoJSON.html -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3305) Add system functions for GeoJSON

by Tom Arnold (JIRA)

[ https://issues.jboss.org/browse/TEIID-3305?page=com.atlassian.jira.plugin... ] Tom Arnold updated TEIID-3305: ------------------------------ Description: Add system functions to convert between GEOMETRY and GeoJSON. These will be helpful for sources that use GeoJSON (like MongoDB and RethinkDB). Conversion will be GeometryType (WKB) ↔ JTS Geometry ↔ GeoJSON. * https://github.com/bjornharrtell/jts2geojson * http://geojson.org/geojson-spec.html * http://wiki.geojson.org/GeoJSON_draft_version_5 I don't believe these are part of the OGC spec, but it would probably be best to implement them similar to PostGIS. * http://postgis.org/docs/ST_AsGeoJSON.html * http://postgis.org/docs/ST_GeomFromGeoJSON.html was: Add system functions to convert between GEOMETRY and GeoJSON. These will be helpful for sources that use GeoJSON (like MongoDB and RethinkDB). Conversion will be GeometryType (WKB) ↔ JTS Geometry ↔ GeoJSON. * ~https://github.com/bjornharrtell/jts2geojson~ * http://geojson.org/geojson-spec.html * http://wiki.geojson.org/GeoJSON_draft_version_5 I don't believe these are part of the OGC spec, but it would probably be best to implement them similar to PostGIS. * http://postgis.org/docs/ST_AsGeoJSON.html * http://postgis.org/docs/ST_GeomFromGeoJSON.html > Add system functions for GeoJSON > -------------------------------- > > Key: TEIID-3305 > URL: https://issues.jboss.org/browse/TEIID-3305 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Tom Arnold > Assignee: Steven Hawkins > Labels: spatial > > Add system functions to convert between GEOMETRY and GeoJSON. These will be helpful for sources that use GeoJSON (like MongoDB and RethinkDB). > Conversion will be GeometryType (WKB) ↔ JTS Geometry ↔ GeoJSON. > * https://github.com/bjornharrtell/jts2geojson > * http://geojson.org/geojson-spec.html > * http://wiki.geojson.org/GeoJSON_draft_version_5 > I don't believe these are part of the OGC spec, but it would probably be best to implement them similar to PostGIS. > * http://postgis.org/docs/ST_AsGeoJSON.html > * http://postgis.org/docs/ST_GeomFromGeoJSON.html -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3305) Add system functions for GeoJSON

by Tom Arnold (JIRA)

[ https://issues.jboss.org/browse/TEIID-3305?page=com.atlassian.jira.plugin... ] Tom Arnold updated TEIID-3305: ------------------------------ Description: Add system functions to convert between GEOMETRY and GeoJSON. These will be helpful for sources that use GeoJSON (like MongoDB and RethinkDB). Conversion will be GeometryType (WKB) ↔ JTS Geometry ↔ GeoJSON. * -https://github.com/bjornharrtell/jts2geojson- * http://geojson.org/geojson-spec.html * http://wiki.geojson.org/GeoJSON_draft_version_5 I don't believe these are part of the OGC spec, but it would probably be best to implement them similar to PostGIS. * http://postgis.org/docs/ST_AsGeoJSON.html * http://postgis.org/docs/ST_GeomFromGeoJSON.html was: Add system functions to convert between GEOMETRY and GeoJSON. These will be helpful for sources that use GeoJSON (like MongoDB and RethinkDB). Conversion will be GeometryType (WKB) ↔ JTS Geometry ↔ GeoJSON. * https://github.com/bjornharrtell/jts2geojson I don't believe these are part of the OGC spec, but it would probably be best to implement them similar to PostGIS. * http://postgis.org/docs/ST_AsGeoJSON.html * http://postgis.org/docs/ST_GeomFromGeoJSON.html > Add system functions for GeoJSON > -------------------------------- > > Key: TEIID-3305 > URL: https://issues.jboss.org/browse/TEIID-3305 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Tom Arnold > Assignee: Steven Hawkins > Labels: spatial > > Add system functions to convert between GEOMETRY and GeoJSON. These will be helpful for sources that use GeoJSON (like MongoDB and RethinkDB). > Conversion will be GeometryType (WKB) ↔ JTS Geometry ↔ GeoJSON. > * -https://github.com/bjornharrtell/jts2geojson- > * http://geojson.org/geojson-spec.html > * http://wiki.geojson.org/GeoJSON_draft_version_5 > I don't believe these are part of the OGC spec, but it would probably be best to implement them similar to PostGIS. > * http://postgis.org/docs/ST_AsGeoJSON.html > * http://postgis.org/docs/ST_GeomFromGeoJSON.html -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3309) Add system functions for GML2

by Tom Arnold (JIRA)

Tom Arnold created TEIID-3309: --------------------------------- Summary: Add system functions for GML2 Key: TEIID-3309 URL: https://issues.jboss.org/browse/TEIID-3309 Project: Teiid Issue Type: Feature Request Components: Query Engine Reporter: Tom Arnold Assignee: Steven Hawkins JTS has a reader/writer for GML2. * http://tsusiatsoftware.net/jts/javadoc/com/vividsolutions/jts/io/gml2/GML... * http://tsusiatsoftware.net/jts/javadoc/com/vividsolutions/jts/io/gml2/GML... We should expose this functionality as system functions (similar to PostGIS). * http://postgis.net/docs/ST_GeomFromGML.html * http://postgis.net/docs/ST_AsGML.html -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3302) Implement ST_Transform

by Tom Arnold (JIRA)

[ https://issues.jboss.org/browse/TEIID-3302?page=com.atlassian.jira.plugin... ] Tom Arnold updated TEIID-3302: ------------------------------ Description: Implement [ST_Transform|http://postgis.org/docs/ST_Transform.html] system function. This would be used to transform geometry between different coordinate systems. This needs SPATIAL_REF_SYS table and a supporting library. There are a couple of options for implementing this: * http://trac.osgeo.org/proj4j/ - Port of the C library used by PostGIS. Fewest dependencies and should keep us close to PostGIS in capabilities, but the project looks dead for about a year. Also there would be a little boilerplate to interface with JTS types. * http://docs.geotools.org/latest/userguide/library/referencing/index.html - GeoTools referencing module. I think we would need to develop a simple plugin to interface with our SPATIAL_REF_SYS table. GeoTools is active and has good docs, but brings in a lot of dependencies. was: Implement [ST_Transform|http://postgis.org/docs/ST_Transform.html] system function. This would be used to transform geometry between different coordinate systems. This needs SPATIAL_REF_SYS table and a supporting library. There are a couple of options for implementing this: * http://trac.osgeo.org/proj4j/ - Port of the C library used by PostGIS. * http://docs.geotools.org/latest/userguide/library/referencing/index.html - GeoTools referencing module. > Implement ST_Transform > ---------------------- > > Key: TEIID-3302 > URL: https://issues.jboss.org/browse/TEIID-3302 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Tom Arnold > Assignee: Steven Hawkins > Labels: spatial > > Implement [ST_Transform|http://postgis.org/docs/ST_Transform.html] system function. This would be used to transform geometry between different coordinate systems. This needs SPATIAL_REF_SYS table and a supporting library. > There are a couple of options for implementing this: > * http://trac.osgeo.org/proj4j/ - Port of the C library used by PostGIS. Fewest dependencies and should keep us close to PostGIS in capabilities, but the project looks dead for about a year. Also there would be a little boilerplate to interface with JTS types. > * http://docs.geotools.org/latest/userguide/library/referencing/index.html - GeoTools referencing module. I think we would need to develop a simple plugin to interface with our SPATIAL_REF_SYS table. GeoTools is active and has good docs, but brings in a lot of dependencies. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 2 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues January 2015