Hum... OGC indeed used XS:any in a few places, but almost always under the
assumption that the response contains extra namespace and links to schemas,
enough to have the actual full schema of the document.
Cheers
Andrea
Il 12/feb/2015 22:09 "Jody Garnett" <jody.garn...@gmail.com> ha scritto:
> 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
