[GeoNetwork-devel] MySql create script issue

GeoNetwork GeoNetwork Developer
,
1

Hi

I created this issue https://github.com/geonetwork/core-geonetwork/issues/241 as get a report about the username field in users table with length 256 and seem until 5.0.3 this type only supports 255 chars.

I see other problematic fields like harvestUri (512) and others even in the table services some with 1048.

Are these lengths required? I guess maybe we should use other type for these fields or add in the documentation that we don’t support versions previous to MySql 5.0.3.

Regards,
Jose García

–

GeoCat Bridge for ArcGIS allows instant publishing of data and metadata on GeoServer and GeoNetwork. Visit http://geocat.net for details.

Jose García
GeoCat bv
Veenderweg 13
6721 WD Bennekom
The Netherlands
http://GeoCat.net

2

Hi,

A good question. I think in some cases the sizes are needed. But others like the username changing the size a little is probably ok. For the large ones you might be able to use CLOB types or something depending on how they need to be searched.

Jesse

···

On Tue, Sep 3, 2013 at 12:06 PM, Jose Garcia <jose.garcia@anonymised.com> wrote:

Hi

I created this issue https://github.com/geonetwork/core-geonetwork/issues/241 as get a report about the username field in users table with length 256 and seem until 5.0.3 this type only supports 255 chars.

I see other problematic fields like harvestUri (512) and others even in the table services some with 1048.

Are these lengths required? I guess maybe we should use other type for these fields or add in the documentation that we don’t support versions previous to MySql 5.0.3.

Regards,
Jose García

–

GeoCat Bridge for ArcGIS allows instant publishing of data and metadata on GeoServer and GeoNetwork. Visit http://geocat.net for details.

Jose García
GeoCat bv
Veenderweg 13
6721 WD Bennekom
The Netherlands
http://GeoCat.net

Learn the latest–Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk

GeoNetwork-devel mailing list
GeoNetwork-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

3

Hi Jose,

···

2013/9/3 Jose Garcia <jose.garcia@anonymised.com>

Hi

I created this issue https://github.com/geonetwork/core-geonetwork/issues/241 as get a report about the username field in users table with length 256 and seem until 5.0.3 this type only supports 255 chars.

I see other problematic fields like harvestUri (512)

Not sure for this one.

and others even in the table services some with 1048.

Those columns may contain long strings eg. Virtual CSW Lucene query for ServiceParameters value. Maybe better to switch to CLOB.

Cheers.

Francois

Are these lengths required? I guess maybe we should use other type for these fields or add in the documentation that we don’t support versions previous to MySql 5.0.3.

Regards,
Jose García

–

GeoCat Bridge for ArcGIS allows instant publishing of data and metadata on GeoServer and GeoNetwork. Visit http://geocat.net for details.

Jose García
GeoCat bv
Veenderweg 13
6721 WD Bennekom
The Netherlands
http://GeoCat.net

Learn the latest–Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk

GeoNetwork-devel mailing list
GeoNetwork-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork