Thanks for the response Ben. GWSI_LEVELS is a table. Here is the output from
DESCRIBE GWSI_LEVELS:
DESCRIBE GW_DATA_PORTAL.GWSI_LEVELS
Name Null Type
------------------------------ --------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
AGENCY_CD NOT NULL VARCHAR2(5)
SITE_NO NOT NULL VARCHAR2(15)
DATES DATE
VALUE NUMBER
REMARK VARCHAR2(5)
REMARK_DS VARCHAR2(255)
SOURCE_CD VARCHAR2(5)
METHOD_CD VARCHAR2(5)
METHOD_DS VARCHAR2(255)
QW_ACCURACY VARCHAR2(5)
QW_ACCURACY_NM VARCHAR2(255)
HOST NOT NULL VARCHAR2(30)
DBNUM NOT NULL VARCHAR2(2)
DWH_INSERT DATE
LEV_CN VARCHAR2(8)
LEV_CR DATE
LEV_MN VARCHAR2(8)
LEV_MD NOT NULL DATE
GW_LEV_PK NOT NULL NUMBER
MP_LEV_VA VARCHAR2(7)
SL_LEV_VA VARCHAR2(8)
LEV_ENT_CD VARCHAR2(1)
LEV_STATISTICS_CD VARCHAR2(1)
LEV_STATISTICS_NM VARCHAR2(255)
DATE_ACY_CD VARCHAR2(1)
SL_DATUM_CD VARCHAR2(10)
LEV_PARTY_TX VARCHAR2(6)
LEV_WEB_CD VARCHAR2(1)
LEV_AGENCY_CD VARCHAR2(5)
LEV_MPNT_SEQ_NU NUMBER
LEV_RMK_TX VARCHAR2(256)
LEV_EQPID_TX VARCHAR2(20)
DWH_SITE_ID NOT NULL NUMBER
PARAMETER_CODE CHAR(5)
SOURCE VARCHAR2(10)
VALUE_ALL NUMBER
Thanks,
Ryan
On Nov 2, 2010, at 8:20 PM, Ben Caradoc-Davies wrote:
> Ryan,
>
> I do not think this is an app-schema problem as it is the inner feature type
> that is affected and this error will likely occur before any chaining takes
> place. My guess is this is either a subtle bug in the geotools oracle
> support, or an unintended interaction with your database configuration. I
> cannot find any hardcoded identifier "TIMES" in the code base.
>
> (1) Is GWSI_LEVELS a table, view, or materialized view?
>
> (2) What is the output of "DESCRIBE GWSI_LEVELS"?
>
> Kind regards,
> Ben.
>
>
> On 03/11/10 05:46, Ryan Zoerb wrote:
>> Hi everyone. I'm trying to get application schema with feature chaining
>> working, but I'm running into an issue. I've attached the two mapping files
>> I'm using. WaterWell is the top level element, which can have several
>> nested logElement's. I've been able to successfully get GeoServer to return
>> a correct response without feature chaining, but when I added the chaining,
>> I get this Oracle error: 'ORA-00904: "TIMES": invalid identifier'. Here's
>> the query that GeoServer is doing that returns the error:
>>
>> SELECT
>> GW_LEV_PK,AGENCY_CD,SITE_NO,DATES,VALUE,REMARK,REMARK_DS,SOURCE_CD,METHOD_CD,METHOD_DS,QW_ACCURACY,QW_ACCURACY_NM,HOST,DBNUM,DWH_INSERT,LEV_CN,LEV_CR,LEV_MN,LEV_MD,MP_LEV_VA,SL_LEV_VA,LEV_ENT_CD,LEV_STATISTICS_CD,LEV_STATISTICS_NM,DATE_ACY_CD,SL_DATUM_CD,LEV_PARTY_TX,LEV_WEB_CD,LEV_AGENCY_CD,LEV_MPNT_SEQ_NU,LEV_RMK_TX,LEV_EQPID_TX,DWH_SITE_ID,PARAMETER_CODE,SOURCE,VALUE_ALL,AGENCY_CD,SITE_NO,DATES,VALUE,STATUS_CD,STATUS_DS,SOURCE_CD,METHOD_CD,METHOD_DS,QW_ACCURACY,QW_ACCURACY_NM,HOST,DBNUM,DWH_INSERT,LEV_CN,LEV_CR,LEV_MN,LEV_MD,TIMES,MP_LEV_VA,SL_LEV_VA,LEV_ENT_CD,LEV_STATISTICS_CD,LEV_STATISTICS_NM,DATE_ACY_CD,SL_DATUM_CD,LEV_PARTY_TX,LEV_WEB_CD,LEV_AGENCY_CD,LEV_MPNT_SEQ_NU,LEV_RMK_TX,LEV_EQPID_TX,DWH_SITE_ID
>> FROM GWSI_LEVELS WHERE SITE_NO = ?
>>
>> The problem is that the GWSI_LEVELS table doesn't have a column called
>> TIMES. All of the other columns are correct (even though most of them are
>> in that list twice). The pattern I see is that the primary key, GW_LEV_PK,
>> is first in the list, then all of the columns are listed in the same order
>> they are in the db (except for GW_LEV_PK). Then, all the columns except the
>> last three are listed again, but TIMES is put in GW_LEV_PK's column
>> position. Can anyone see what could be causing this, or is it a bug?
>>
>> Thanks for any help,
>> Ryan
>>
>>
>
>
> --
> Ben Caradoc-Davies <[email protected]>
> Software Engineering Team Leader
> CSIRO Earth Science and Resource Engineering
> Australian Resources Research Centre
------------------------------------------------------------------------------
Achieve Improved Network Security with IP and DNS Reputation.
Defend against bad network traffic, including botnets, malware,
phishing sites, and compromised hosts - saving your company time,
money, and embarrassment. Learn More!
http://p.sf.net/sfu/hpdev2dev-nov
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
