[Geoserver-devel] [jira] (GEOS-5668) Cannot recalculate Oracle layer coordinates bounds from the layer web admin interface when a custom SQL start session request is set on the datastore

GeoServer GeoServer Developer
1

Philippe POUYET created BugGEOS-5668
Cannot recalculate Oracle layer coordinates bounds from the layer web admin interface when a custom SQL start session request is set on the datastore

Issue Type:

BugBug

Affects Versions:

2.2.5

Assignee:

Andrea Aime

Attachments:

trace.txt

Components:

Oracle

Created:

28/Feb/13 5:29 AM

Description:

cannot recalculate Oracle layer coordinates bounds from the layer web admin interface when a custom SQL start session request is seton the datastore.
The custom SQL start session request is the following :
SELECT “set_userappname”('$

{GSUSER,geoserver}

') from dual
This request works pretty well in any other situation with geoserver.(this is a great improvement for efficient data filtering according to user profile)

Problem occurs with both versions 2.2.5 and 2.2.4

Workaround : discard the custom SQL start session request, validate, recompute the layer geo bounds, validate, set the SQL start session request again, validate, OK

Environment:

Windows 7, Geoserver 2.2.5, Oracle plugin 8.7.

Project:

GeoServer

Priority:

MinorMinor

Reporter:

Philippe POUYET
This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: [http://www.atlassian.com/software/jira](http://www.atlassian.com/software/jira)