[Geoserver-devel] [jira] Created: (GEOS-4075) Geos Web UI hangs when adding a new Layer from Oracle DS

Geos Web UI hangs when adding a new Layer from Oracle DS
--------------------------------------------------------

                 Key: GEOS-4075
                 URL: http://jira.codehaus.org/browse/GEOS-4075
             Project: GeoServer
          Issue Type: Bug
          Components: Oracle
    Affects Versions: 2.0.1
         Environment: Win2003, Tomcat 6.0.18, Geos 2.0.1, Orcl 10.2 (on amazon EC2)
            Reporter: Chris Hughes
            Assignee: Andrea Aime
         Attachments: errortrace.txt

when attempting to add a new Layer from am Oracle Datastore the system hangs and then crashes (see attachment for stack). The layer is a polygon layer gtype 2003 with about 1.5M records. It is spatially indexed. The DDL for the table is here:

drop table structures_geo;

CREATE OR REPLACE TYPE ainxref AS VARRAY(300) OF NUMBER;
CREATE OR REPLACE TYPE pinxref AS VARRAY(50) OF VARCHAR2(20);
CREATE OR REPLACE TYPE addrxref AS VARRAY(300) OF NUMBER;

create table structures_geo (
  SGID NUMBER, --sequence
  CODE VARCHAR2(50),
  BLD_ID VARCHAR2(20),
  HEIGHT NUMBER,
  ELEV NUMBER,
  AREA NUMBER,
  GEOMETRY SDO_GEOMETRY,
  SOURCE_FILE VARCHAR2(128),
  SOURCE_FILE_DATE VARCHAR2(50),
  AIN_LIST ainxref,
  PIN_LIST pinxref,
  ADDR_LIST addrxref
);

the varrays are dropped from the feature as expected

--
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