#293: Jeeves Dbms class uses wrong result set metadata item.
--------------------------+-------------------------------------------------
Reporter: justinrowles | Owner: geonetwork-devel@…
Type: defect | Status: new
Priority: major | Milestone: v2.5.1
Component: General | Version: v2.5.0
Keywords: |
--------------------------+-------------------------------------------------
(Line 43)
The column name attribute for a result set represents the original name of
a column, and ignores any 'as' clause.
This means that on correctly written drivers (mysql in this case), the 'as
id' clause from line 45 of org.fao.geonet.services.user.List is ignored,
meaning that Admin cannot see any users but himself.
The correct attribute would be column label.
--
Ticket URL: <http://trac.osgeo.org/geonetwork/ticket/293>
GeoNetwork opensource Developer website <http://trac.osgeo.org/geonetwork>
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.
#293: Jeeves Dbms class uses wrong result set metadata item.
--------------------------+-------------------------------------------------
Reporter: justinrowles | Owner: geonetwork-devel@…
Type: defect | Status: new
Priority: major | Milestone: v2.5.1
Component: General | Version: v2.5.0
Keywords: |
--------------------------+-------------------------------------------------
Comment(by justinrowles):
It appears that the McKoi driver returns the 'as' clause value as column
name. I /think/ this is actually wrong behaviour, which makes GeoNetwork
work correctly in McKoi!
--
Ticket URL: <http://trac.osgeo.org/geonetwork/ticket/293#comment:1>
GeoNetwork opensource Developer website <http://trac.osgeo.org/geonetwork>
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.
#293: Jeeves Dbms class uses wrong result set metadata item.
--------------------------+-------------------------------------------------
Reporter: justinrowles | Owner: geonetwork-devel@…
Type: defect | Status: new
Priority: major | Milestone: v2.6.0 RC2
Component: General | Version: v2.6.0RC0
Keywords: |
--------------------------+-------------------------------------------------
Changes (by justinrowles):
* version: v2.5.0 => v2.6.0RC0
* milestone: v2.5.1 => v2.6.0 RC2
--
Ticket URL: <http://trac.osgeo.org/geonetwork/ticket/293#comment:2>
GeoNetwork opensource Developer website <http://trac.osgeo.org/geonetwork>
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.
#293: Jeeves Dbms class uses wrong result set metadata item.
---------------------------+------------------------------------------------
Reporter: justinrowles | Owner: geonetwork-devel@…
Type: defect | Status: closed
Priority: major | Milestone: v2.6.0
Component: General | Version: v2.6.0RC0
Resolution: fixed | Keywords:
---------------------------+------------------------------------------------
Changes (by josegar74):
* status: new => closed
* resolution: => fixed
Comment:
For a query like SELECT groupId AS id...
Postgres and Mckoi drivers are returning ColumName and ColumnLabel = id
MySql driver returns different values. ColumnName = groupId, ColumnLabel =
id
With the fix seem working ok in all three: Mysql, Mckoi and Postgres
--
Ticket URL: <http://trac.osgeo.org/geonetwork/ticket/293#comment:3>
GeoNetwork opensource Developer website <http://trac.osgeo.org/geonetwork>
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.