Hi,
We are automating layer creation through the REST API and part of our design involves randomly generated layer names. We ran into an issue where it seems that GeoServer stores layer names in a 64 char length field which is too small for our current purposes. Is there a way to adjust the size of this field without hacking into the src?
···
…
[INFO] [talledLocalContainer] INSERT INTO TILESET select ?, ?, ?, ?, ?, 0 WHERE NOT EXISTS(SELECT 1 FROM TILESET WHERE KEY = ?) [90005-119]; nested exception is org.h2.jdbc.JdbcSQLException: Value too long for column LAYER_NAME VARCHAR(64): ‘geodashboard:lxshrv7h0g0izi49dviqtj1mjy4wrds6rscs9lsb4hx9m41yuvj3sz80midx6f7’ (76); SQL statement:
[INFO] [talledLocalContainer] INSERT INTO TILESET select ?, ?, ?, ?, ?, 0 WHERE NOT EXISTS(SELECT 1 FROM TILESET WHERE KEY = ?) [90005-119]
[
Justin
[INFO] [talledLocalContainer] Caused by: org.h2.jdbc.JdbcSQLException: Value too long for column LAYER_NAME VARCHAR(64): ‘geodashboard:lxshrv7h0g0izi49dviqtj1mjy4wrds6rscs9lsb4hx9m41yuvj3sz80midx6f7’ (76); SQL statement:
If you’re putting this into a PostGIS db, I’ve come across this and this may have to be something you update on the PostGIS side.
I saw someone else had this issue here: http://sourceforge.net/p/geowebcache/mailman/message/32453919/
__________________________ (╯°□°）╯︵ ┻━┻
Ivan Suftin - Applications Developer - isuftin@anonymised.com
Office: (608) 821-3825 - Cell : (608) 345-8963
Center for Integrated Data Analytics - http://cida.usgs.gov/
United States Geological Survey
8505 Research Way, Middleton, WI 53562
···
…
[INFO] [talledLocalContainer] INSERT INTO TILESET select ?, ?, ?, ?, ?, 0 WHERE NOT EXISTS(SELECT 1 FROM TILESET WHERE KEY = ?) [90005-119]; nested exception is org.h2.jdbc.JdbcSQLException: Value too long for column LAYER_NAME VARCHAR(64): ‘geodashboard:lxshrv7h0g0izi49dviqtj1mjy4wrds6rscs9lsb4hx9m41yuvj3sz80midx6f7’ (76); SQL statement:
[INFO] [talledLocalContainer] INSERT INTO TILESET select ?, ?, ?, ?, ?, 0 WHERE NOT EXISTS(SELECT 1 FROM TILESET WHERE KEY = ?) [90005-119]
[
Justin
[INFO] [talledLocalContainer] Caused by: org.h2.jdbc.JdbcSQLException: Value too long for column LAYER_NAME VARCHAR(64): ‘geodashboard:lxshrv7h0g0izi49dviqtj1mjy4wrds6rscs9lsb4hx9m41yuvj3sz80midx6f7’ (76); SQL statement:
Thanks Ivan. Looks like Andrea was keen on upping the length to 128. Does anyone know if that made it into any of the recent releases?
···
On Wed, Nov 19, 2014 at 1:45 PM, Ivan Suftin <isuftin@anonymised.com> wrote:
If you’re putting this into a PostGIS db, I’ve come across this and this may have to be something you update on the PostGIS side.
I saw someone else had this issue here: http://sourceforge.net/p/geowebcache/mailman/message/32453919/
__________________________ (╯°□°）╯︵ ┻━┻
Ivan Suftin - Applications Developer - isuftin@anonymised.com
Office: (608) 821-3825 - Cell : (608) 345-8963
Center for Integrated Data Analytics - http://cida.usgs.gov/
United States Geological Survey
8505 Research Way, Middleton, WI 53562
On Nov 19, 2014, at 11:54 AM, Justin Lewis <j.mapping@…84…> wrote:
Hi,
We are automating layer creation through the REST API and part of our design involves randomly generated layer names. We ran into an issue where it seems that GeoServer stores layer names in a 64 char length field which is too small for our current purposes. Is there a way to adjust the size of this field without hacking into the src?
[INFO] [talledLocalContainer] Caused by: org.h2.jdbc.JdbcSQLException: Value too long for column LAYER_NAME VARCHAR(64): ‘geodashboard:lxshrv7h0g0izi49dviqtj1mjy4wrds6rscs9lsb4hx9m41yuvj3sz80midx6f7’ (76); SQL statement:
…
[INFO] [talledLocalContainer] INSERT INTO TILESET select ?, ?, ?, ?, ?, 0 WHERE NOT EXISTS(SELECT 1 FROM TILESET WHERE KEY = ?) [90005-119]; nested exception is org.h2.jdbc.JdbcSQLException: Value too long for column LAYER_NAME VARCHAR(64): ‘geodashboard:lxshrv7h0g0izi49dviqtj1mjy4wrds6rscs9lsb4hx9m41yuvj3sz80midx6f7’ (76); SQL statement:
[INFO] [talledLocalContainer] INSERT INTO TILESET select ?, ?, ?, ?, ?, 0 WHERE NOT EXISTS(SELECT 1 FROM TILESET WHERE KEY = ?) [90005-119]
[
Justin
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk_______________________________________________
Geoserver-users mailing list
Geoserver-users@anonymised.com.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
Justin Lewis
J.mapping@anonymised.com
(360) 303-8930