[GeoNetwork-devel] [GeoNetwork opensource Developer website] #625: SQL / HarvestHistory table creation fail on Oracle

#625: SQL / HarvestHistory table creation fail on Oracle
---------------------+------------------------------------------------------
Reporter: Fxp | Owner: geonetwork-devel@…
     Type: defect | Status: new
Priority: major | Milestone: v2.7.0
Component: General | Version:
Keywords: |
---------------------+------------------------------------------------------
ORA-01754 a table may contain only one column of type LONG

--
Ticket URL: <http://trac.osgeo.org/geonetwork/ticket/625&gt;
GeoNetwork opensource Developer website <http://sourceforge.net/projects/geonetwork/&gt;
GeoNetwork opensource is a standards based, Free and Open Source catalog application to manage spatially referenced resources through the web. It provides powerful metadata editing and search functions as well as an embedded interactive web map viewer. This website contains information related to the development of the software.

#625: SQL / HarvestHistory table creation fail on Oracle
---------------------+------------------------------------------------------
Reporter: Fxp | Owner: geonetwork-devel@…
     Type: defect | Status: new
Priority: major | Milestone: v2.7.0
Component: General | Version:
Keywords: |
---------------------+------------------------------------------------------

Comment(by Fxp):

I propose to make the info column a varchar(2000) which should be enough
to store the harvester info.

--
Ticket URL: <http://trac.osgeo.org/geonetwork/ticket/625#comment:1&gt;
GeoNetwork opensource Developer website <http://sourceforge.net/projects/geonetwork/&gt;
GeoNetwork opensource is a standards based, Free and Open Source catalog application to manage spatially referenced resources through the web. It provides powerful metadata editing and search functions as well as an embedded interactive web map viewer. This website contains information related to the development of the software.

#625: SQL / HarvestHistory table creation fail on Oracle
---------------------+------------------------------------------------------
Reporter: Fxp | Owner: geonetwork-devel@…
     Type: defect | Status: new
Priority: major | Milestone: v2.7.0
Component: General | Version:
Keywords: |
---------------------+------------------------------------------------------

Comment(by Fxp):

Committed revision 8270.

--
Ticket URL: <http://trac.osgeo.org/geonetwork/ticket/625#comment:2&gt;
GeoNetwork opensource Developer website <http://sourceforge.net/projects/geonetwork/&gt;
GeoNetwork opensource is a standards based, Free and Open Source catalog application to manage spatially referenced resources through the web. It provides powerful metadata editing and search functions as well as an embedded interactive web map viewer. This website contains information related to the development of the software.

#625: SQL / HarvestHistory table creation fail on Oracle
----------------------+-----------------------------------------------------
  Reporter: Fxp | Owner: geonetwork-devel@…
      Type: defect | Status: closed
  Priority: major | Milestone: v2.7.0
Component: General | Version:
Resolution: fixed | Keywords:
----------------------+-----------------------------------------------------
Changes (by Fxp):

  * status: new => closed
  * resolution: => fixed

--
Ticket URL: <http://trac.osgeo.org/geonetwork/ticket/625#comment:3&gt;
GeoNetwork opensource Developer website <http://sourceforge.net/projects/geonetwork/&gt;
GeoNetwork opensource is a standards based, Free and Open Source catalog application to manage spatially referenced resources through the web. It provides powerful metadata editing and search functions as well as an embedded interactive web map viewer. This website contains information related to the development of the software.

#625: SQL / HarvestHistory table creation fail on Oracle
----------------------+-----------------------------------------------------
  Reporter: Fxp | Owner: geonetwork-devel@…
      Type: defect | Status: closed
  Priority: major | Milestone: v2.7.0
Component: General | Version:
Resolution: fixed | Keywords:
----------------------+-----------------------------------------------------

Comment(by Fxp):

Fix on migration script: Committed revision 8394.

--
Ticket URL: <http://trac.osgeo.org/geonetwork/ticket/625#comment:4&gt;
GeoNetwork opensource Developer website <http://sourceforge.net/projects/geonetwork/&gt;
GeoNetwork opensource is a standards based, Free and Open Source catalog application to manage spatially referenced resources through the web. It provides powerful metadata editing and search functions as well as an embedded interactive web map viewer. This website contains information related to the development of the software.