GetFeature info truncated with gabarge characters from Oracle CLOB column
-------------------------------------------------------------------------
Key: GEOS-3692
URL: http://jira.codehaus.org/browse/GEOS-3692
Project: GeoServer
Issue Type: Bug
Components: ArcSDE
Affects Versions: 2.0.0
Environment: UNIX-Solaris, Java 1.6_0.17, ARCSDE data store - ESRI 9.3
Reporter: Andrew Walsh
Assignee: Andrea Aime
Priority: Blocker
Attachments: response.txt
When doing a GetFeatureInfo from a WMS accessing ARCSDE data store (Oracle 10G)
with long attribute field (CLOB column, e.g FLAGS attribute can have up to 12000
characters) part of column data display okay but it's truncated with garbage
non-ascii characters. Checked data with Oracle client and its OK. Perhaps
some size limit for html display reached?
Please see attached log file from fiddler showing request/response.
You can see this by going to http://www.metoc.gov.au/geoserver/,
,select the RAN.RAN_XBT layer Open Layers map, click on any point,
look at the GetFeature Info and scroll across to look at data from the
FLAGS column. Notice how shows the first part of this column OK but truncates
with non-ascii chars. Note also that columns after this one have no data
listed.
FYI here is Oracle table description:
SQL> describe ran_xbt;
Name Null? Type
----------------------------------------- -------- ----------------------------
OBJECTID NOT NULL NUMBER(38)
DATETIME DATE
PROBETYPE NVARCHAR2(50)
RAWFILENAME NVARCHAR2(50)
METADATA_QCSTATUS NUMBER(2)
PROFILE_QCSTATUS NUMBER(2)
DUPLICATESTATUS NUMBER(2)
TEMPPROFILE NCLOB
FLAGS NCLOB
EDITS NCLOB
QCSTATUS NUMBER(5)
PROJECTID NVARCHAR2(20)
SHIPNAME NVARCHAR2(30)
CALLSIGN NVARCHAR2(4)
TESTRESULTS NCLOB
SHAPE NUMBER(38)
Other info:
Using ARCSDE extension files for geoserver 2.0.0 + ESRI ones:
arcsde-2.0.0.jar
commons-pool-1.5.3.jar
gt-arcsde-2.6.0.jar
gt-arcsde-common-2.6.0.jar
icu4j-3.4.4.jar
jsqlparser-0.3.14.jar
jpe_sdk.jar (got from ESRI ARCSDE 9.3 DVD install disc)
jsde_sdk.jar (got from ESRI ARCSDE 9.3 DVD install disc)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira