On Wed, May 11, 2011 at 11:22 AM, Simon Payne <[email protected]> wrote: > Hi Andrea > > Many thanks for your prompt responses and for adding these documents which > makes things clearer. > > Unfortunately... I am probably missing something very obvious, but I can't > get this to work. What I have done is as follows: - > > 1. Installed GeoServer 2.0.2 as a web app deployed in JBoss 5.0.1.GA, and > installed the Oracle database plugin 2.0.2. > 2. In my Oracle database, ran some simple spatial SQL statements to create a > table - I used the well-known Oracle COLA_MARKETS example (see > http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14255/sdo_objrelschema.htm) > where the table DDL is > > CREATE TABLE cola_markets ( > mkt_id NUMBER PRIMARY KEY, > name VARCHAR2(32), > shape SDO_GEOMETRY); > > 3. I created an Oracle Store using JNDI, created a layer pointed at my table, > and checked it all worked fine by pushing a WFS-T Insert through and seeing > that a new row appeared in the COLA_MARKETS table. (However, the fid for the > new record is auto-generated, I'm not sure where it comes from as it seems to > behave the same even if I disable or drop the primary key from the table. I > assume GeoServer is generating this value from somewhere other than the > database...) > > 4. Created a sequence called SEQUENCE1 to use for returning the feature ids. > 5. Ran the SQL you have documented to create the gt_pk_metadata_table, and > inserted a row with the following data: > > TABLE_SCHEMA: {MY SCHEMA} > TABLE_NAME: COLA_MARKETS > PK_COLUMN: MKT_ID > PK_COLUMN_IDX: NULL > PK_POLICY: sequence > PK_SEQUENCE: SEQUENCE1 > > 6. Ran the WFS-T Insert again, but this time it still gave a sequence number > from the same series as at step 3. I was expecting to get the next value > from SEQUENCE1. > > Have I missed a step in the configuration? Do you have any suggestions?
Hmmm... that GS version is actually very old, I don't recall if it contains support for the metadata table or not. Second, you should reset GS after creating that table in order to make it notice its presence. There should be a "reload" button in the geoserver status page that the admin might use to reset the GS state (again, don't remember if it was already there in 2.0.2) Cheers Andrea > > thanks > > Simon > > > --- On Tue, 10/5/11, Andrea Aime <[email protected]> wrote: > >> From: Andrea Aime <[email protected]> >> Subject: Re: [Geoserver-users] How to customise GeoServer WFT-S >> Transactionhandling >> To: "Rahkonen Jukka" <[email protected]> >> Cc: "Simon Payne" <[email protected]>, >> [email protected] >> Date: Tuesday, 10 May, 2011, 19:30 >> On Tue, May 10, 2011 at 4:50 PM, >> Rahkonen Jukka >> <[email protected]> >> wrote: >> > Hi, >> > >> > You can configure it by creating a special table, >> perhaps GEOSERVER_METADATA by default, into Oracle and >> pointing Geoserver to use it. Reading this old thread should >> guide you into right direction. I am not sure where the >> official documentation is. >> > >> > http://sourceforge.net/mailarchive/forum.php?thread_name=29621032.post%40talk.nabble.com&forum_name=geoserver-users >> >> Here we go with some official docs :-p : >> >> http://docs.geoserver.org/stable/en/user/data/primarykey.html >> >> Cheers >> Andrea >> >> -- >> ------------------------------------------------------- >> Ing. Andrea Aime >> GeoSolutions S.A.S. >> Tech lead >> >> Via Poggio alle Viti 1187 >> 55054 Massarosa (LU) >> Italy >> >> phone: +39 0584 962313 >> fax: +39 0584 962313 >> >> http://www.geo-solutions.it >> http://geo-solutions.blogspot.com/ >> http://www.youtube.com/user/GeoSolutionsIT >> http://www.linkedin.com/in/andreaaime >> http://twitter.com/geowolf >> >> ------------------------------------------------------- >> > > -- ------------------------------------------------------- Ing. Andrea Aime GeoSolutions S.A.S. Tech lead Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 962313 http://www.geo-solutions.it http://geo-solutions.blogspot.com/ http://www.youtube.com/user/GeoSolutionsIT http://www.linkedin.com/in/andreaaime http://twitter.com/geowolf ------------------------------------------------------- ------------------------------------------------------------------------------ Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
