Hi Ryan, What does your chaining attribute look like in the mapping file? When does the error occur, when you make a request, or during startup? Can you also attach a stack trace? Maybe I can help.
Cheers Rini Ryan Zoerb wrote: > > 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 <ben.caradoc-dav...@csiro.au> >> 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 > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users > > -- View this message in context: http://old.nabble.com/App-schema-feature-chaining-issue-tp30118008p30128740.html Sent from the GeoServer - User mailing list archive at Nabble.com. ------------------------------------------------------------------------------ The Next 800 Companies to Lead America's Growth: New Video Whitepaper David G. Thomson, author of the best-selling book "Blueprint to a Billion" shares his insights and actions to help propel your business during the next growth cycle. Listen Now! http://p.sf.net/sfu/SAP-dev2dev _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
