Torben - the origional link I provided shows an xpath function (so there is
"some" interaction"). But yeah I am sure it is out of scope for you initial
work.
SELECT xpath('/my:a/text()', '<my:a xmlns:my="http://example.com
">test</my:a>',
ARRAY[ARRAY['my', 'http://example.com']]);
Andrea's point of how to advertise the content is a bit more on point. I
wonder if it just shows up as an "any" in our DescribeFeatureType?
--
Jody Garnett
On 12 February 2015 at 16:01, Torben Barsballe <tbarsba...@boundlessgeo.com>
wrote:
> Jody - At least for Postgres, there is not any support for querying XML
> columns directly; see Section 8.13.3. Accessing XML Values
> <http://www.postgresql.org/docs/9.1/static/datatype-xml.html#AEN7067>.
> However, the functions you listed do provide some options for interacting
> with XML data. It seems that the main benifit of the XML type is built in
> check for well-formedness.
>
> Most of the other databases that support XML (eg. Oracle) do have direct
> query support for XML.
>
> Torben
>
> On Thu, Feb 12, 2015 at 12:53 PM, Andrea Aime <
> andrea.a...@geo-solutions.it> wrote:
>
>> Jody, if you think like that, the structre should be advertised (how do
>> you build the filter otherwise) and... basically you end up with a complex
>> feature store in Deegree style.
>>
>> Exposing as string has also consequences, those column will be escaped in
>> GML.... Which might be real ugly :-)
>>
>> Cheers
>> Andrea
>> Il 12/feb/2015 20:45 "Jody Garnett" <jody.garn...@gmail.com> ha scritto:
>>
>> Interesting bit of work Torben. Even if you end up using a String we can
>>> set up a Convertor allowing expression( feature, Document.class ) to work.
>>>
>>> For the XML columns is the result coming back like a blob? Or streaming?
>>> Is there any kind of xpath support for querying these columns? Apparently
>>> "yes" (http://www.postgresql.org/docs/9.1/static/functions-xml.html).
>>> That opens up the door to filters that can work against the XML column
>>> contents....
>>> --
>>> Jody
>>>
>>> --
>>> Jody Garnett
>>>
>>> On 12 February 2015 at 13:34, Torben Barsballe <
>>> tbarsba...@boundlessgeo.com> wrote:
>>>
>>>> I have encountered a feature request to add support for XML columns to
>>>> geoserver. This ultimately means upgrading the geotools JDBCDataStore,
>>>> specifically changing the
>>>> applicable SQLDialect classes to include Type and Class mappins for XML
>>>> data types.
>>>>
>>>> The critical question here is *what type do we want to map XML data to*?
>>>> The simple option would be to just map to a String. However, Java does
>>>> support various structured document types that may be more appropriate,
>>>> such as org.w3c.dom.Document
>>>> <http://docs.oracle.com/javase/7/docs/api/org/w3c/dom/Document.html>.
>>>>
>>>> Does anyone have any strong feelings one way or another? I am going to
>>>> start by mapping to a String for simplicities sake, but would be open to
>>>> using another type.
>>>>
>>>> While the request is specifically for Postgres XML support, it makes
>>>> sense to also add any databases that support XML types. The SQLDialects
>>>> that support XML columns are:
>>>>
>>>> - PostGIS
>>>> - Oracle
>>>> - DB2SQL
>>>> - SpatialLite
>>>> - SQLServer
>>>> - Teradata
>>>>
>>>> I will be starting with PostGIS, but intend to try to add XML support
>>>> to all of these databases. Properly testing this may be a bit difficult, as
>>>> I only have access to PostGIS and Oracle databases at this time.
>>>>
>>>> Torben
>>>>
>>>>
>>>> ------------------------------------------------------------------------------
>>>> Dive into the World of Parallel Programming. The Go Parallel Website,
>>>> sponsored by Intel and developed in partnership with Slashdot Media, is
>>>> your
>>>> hub for all things parallel software development, from weekly thought
>>>> leadership blogs to news, videos, case studies, tutorials and more.
>>>> Take a
>>>> look and join the conversation now. http://goparallel.sourceforge.net/
>>>> _______________________________________________
>>>> GeoTools-Devel mailing list
>>>> GeoTools-Devel@lists.sourceforge.net
>>>> https://lists.sourceforge.net/lists/listinfo/geotools-devel
>>>>
>>>>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Dive into the World of Parallel Programming. The Go Parallel Website,
>>> sponsored by Intel and developed in partnership with Slashdot Media, is
>>> your
>>> hub for all things parallel software development, from weekly thought
>>> leadership blogs to news, videos, case studies, tutorials and more. Take
>>> a
>>> look and join the conversation now. http://goparallel.sourceforge.net/
>>> _______________________________________________
>>> GeoTools-Devel mailing list
>>> GeoTools-Devel@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/geotools-devel
>>>
>>>
>
------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
_______________________________________________
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel
