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
