Hi Henning,
that's a good point, if my memory serves me well, if an array
reaches features-templating it will work as described (this is
used for some advanced integrations with features-templating),
but I don't think that App-Schema and Smart Data Loader can
produce array attributes.
So summarizing:
* Features-templating support arrays,
* but you cannot produce array attributes with App-Schema or
Smart Data Loader,
* hence you can't use arrays unless you create them
programmatically.
@Marco Volpini <mailto:marco.volp...@geosolutionsgroup.com> did I
miss something?
Kind regards,
Nuno Oliveira
On Fri, Sep 9, 2022 at 12:27 PM Henning Lorenz
<henning.lor...@geo.uu.se> wrote:
Dear Nuno,
Thanks for the quick reply. However, for the Feature
Templating plugin, it contradicts the documentation where
Array Type support for json output is explicitly mentioned:
https://docs.geoserver.org/stable/en/user/community/features-templating/directives.html#array-based-properties-json-based-templates-only
Is the documentation wrong and needs to be updated?
Best wishes,
Henning
On 2022-09-09 11:42, Nuno Oliveira wrote:
Dear Henning,
those modules do not support array column types, this would
be a nice feature to have.
A pull request contributing it would be very welcomed, you
may also want to check the GeoServer Support
<https://geoserver.org/support/> in case you want to fund it.
Kind regards,
Nuno Oliveira
On Fri, Sep 9, 2022 at 10:13 AM Henning Lorenz
<henning.lor...@geo.uu.se> wrote:
geoserver 2.21, app schema/smart data loader/ogc
api/feature templating plugins (Tomcat 9 on Ubuntu
22.04; openjdk 11.0.16)
Hello,
I appreciate any help on the following two (related?)
problems (further explained below):
1. The "Smart Data Loader" plugin fails in case Array
Type is present in one of the tables (error unknown
data type)
2. The "Feature Templating" plugin does not handle data
from columns with Array Type correctly
("[Ljava.lang.String;@..."
<mailto:[Ljava.lang.String;@...>)
Of particular importance to me is to solve problem 2, as
this directly affects geoserver output.
Many thanks in advance,
Henning
-----
Problem 1:
* I create two tables, one without and one without a
column of Array Type (called here "noarray_table"
and "array_table"; only for explanation instead of
my more complex setup):
CREATE TABLE test.noarray_table (
id SERIAL PRIMARY KEY,
geometry geometry(point, 4326),
attribute1 varchar,
attribute2 varchar
);
CREATE TABLE test.array_table (
id SERIAL PRIMARY KEY,
geometry geometry(point, 4326),
attribute1 varchar,
attribute2 varchar[]
);
* After adding some data, I create a PostGIS data
store for database that contains the tables.
* When this is done, I add a new data store and select
"Smart Data Loader".
o When I select the noarray_table as root entity,
I get the expected preview and can add the data
store.
o However, when I select the array_table, I get an
error message over the entire page. As far as I
can tell, the critical line is "Caused by:
java.lang.RuntimeException: Attribute type
'_varchar' is unknown.". _varchar is the same as
varchar[] as far as I can tell.
Is this a bug or does Smart Data Loader not support
Array Types ("missing feature")?
Problem 2:
The Feature Templating plugin explicitly supports Array
Types
(see
https://docs.geoserver.org/stable/en/user/community/features-templating/directives.html#array-based-properties-json-based-templates-only)
* With the Smart Data Loader, I create an app schema
mapping and schema of tables without Array Type
* I configure feature templating and I get valid output.
* However, one of the columns should actually be of
array type. Thus, I replace this varchar-column by a
varchar[]-column, including type casting of the
content.
o According to the documentation, I expect that
the Array Type of the column is recognised by
the plugin and the data are expanded accordingly.
o However, I see "[Ljava.lang.String;@..."
<mailto:[Ljava.lang.String;@...> instead of
data. According to what I could find out, this
indicates the presence of array data where no
array data are expected.
This leaves two options:
A) It is not sufficient to just change the Data Type in
the database, something in the configuration has to be
changed as well (App Schema mapping file, schema -
although Array Type is not supported for XML according
to the documentation, which would suggest that this is
not the case).
B) The Feature Templating plugin doesn't work as
expected, i.e. it's a bug.
När du har kontakt med oss på Uppsala universitet med
e-post så innebär det att vi behandlar dina
personuppgifter. För att läsa mer om hur vi gör det kan
du läsa här:
http://www.uu.se/om-uu/dataskydd-personuppgifter/
E-mailing Uppsala University means that we will process
your personal data. For more information on how this is
performed, please read here:
http://www.uu.se/en/about-uu/data-protection-policy
_______________________________________________
Geoserver-users mailing list
Please make sure you read the following two resources
before posting to this list:
- Earning your support instead of buying it, but Ian
Turton: http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
If you want to request a feature or an improvement, also
see this:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Regards,
Nuno Oliveira
==GeoServer Professional Services from the experts!
Visit http://bit.ly/gs-services-us
<http://bit.ly/gs-services-us>for more information.==Nuno
Miguel Carvalho Oliveira@nmcoliveiraTechnical Lead / Project
Manager
GeoSolutions Groupphone: +39 0584 962313fax: +39 0584
1660272https://www.geosolutionsgroup.com/
<https://www.geosolutionsgroup.com/>http://twitter.com/geosolutions_it
<http://twitter.com/geosolutions_it>-------------------------------------------------------
Con riferimento alla normativa sul trattamento dei dati
personali (Reg. UE 2016/679 - Regolamento generale sulla
protezione dei dati “GDPR”), si precisa che ogni circostanza
inerente alla presente email (il suo contenuto, gli
eventuali allegati, etc.) è un dato la cui conoscenza è
riservata al/i solo/i destinatario/i indicati dallo
scrivente. Se il messaggio Le è giunto per errore, è
tenuta/o a cancellarlo, ogni altra operazione è illecita. Le
sarei comunque grato se potesse darmene notizia.This email
is intended only for the person or entity to which it is
addressed and may contain information that is privileged,
confidential or otherwise protected from disclosure. We
remind that - as provided by European Regulation 2016/679
“GDPR” - copying, dissemination or use of this e-mail or the
information herein by anyone other than the intended
recipient is prohibited. If you have received this email by
mistake, please notify us immediately by telephone or e-mail.
--
Henning Lorenz
The Swedish Scientific Drilling Program (www.ssdp.se
<http://www.ssdp.se>), scientific coordinator
EPOS-Sweden (Swedish participation in EPOS-ERIC;www.epos-se.se
<http://www.epos-se.se>), infrastructure manager
Uppsala University
Department of Earth Sciences
Villavägen 16
752 36 Uppsala
Sweden
mobile: +46 (0) 701 679 320
e-mail:henning.lor...@geo.uu.se
GnuPG-key:
http://pgp.mit.edu:11371/pks/lookup?search=0x484D3AF03B32FD38&op=index
<http://pgp.mit.edu:11371/pks/lookup?search=0x484D3AF03B32FD38&op=index>
_______________________________________________
Geoserver-users mailing list
Please make sure you read the following two resources before
posting to this list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
If you want to request a feature or an improvement, also see
this:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Regards,
Nuno Oliveira
==GeoServer Professional Services from the experts!
Visit http://bit.ly/gs-services-us
<http://bit.ly/gs-services-us>for more information.==Nuno Miguel
Carvalho Oliveira@nmcoliveiraTechnical Lead / Project Manager
GeoSolutions Groupphone: +39 0584 962313fax: +39 0584
1660272https://www.geosolutionsgroup.com/
<https://www.geosolutionsgroup.com/>http://twitter.com/geosolutions_it
<http://twitter.com/geosolutions_it>-------------------------------------------------------
Con riferimento alla normativa sul trattamento dei dati personali
(Reg. UE 2016/679 - Regolamento generale sulla protezione dei
dati “GDPR”), si precisa che ogni circostanza inerente alla
presente email (il suo contenuto, gli eventuali allegati, etc.) è
un dato la cui conoscenza è riservata al/i solo/i destinatario/i
indicati dallo scrivente. Se il messaggio Le è giunto per errore,
è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le
sarei comunque grato se potesse darmene notizia.This email is
intended only for the person or entity to which it is addressed
and may contain information that is privileged, confidential or
otherwise protected from disclosure. We remind that - as provided
by European Regulation 2016/679 “GDPR” - copying, dissemination
or use of this e-mail or the information herein by anyone other
than the intended recipient is prohibited. If you have received
this email by mistake, please notify us immediately by telephone
or e-mail.