[Geoserver-users] WFS-T

I'm trying to execute a wfs transaction, but i always get an exception:

<?xml version="1.0" encoding="UTF-8"?>
<ows:ExceptionReport version="1.0.0" xsi:schemaLocation="http://www.opengis.net/ows http://wka-wn-flogx:8080/geoserver/schemas/ows/1.0.0/owsExceptionReport.xsd&quot; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance&quot; xmlns:ows="http://www.opengis.net/ows&quot;&gt;
  <ows:Exception exceptionCode="NoApplicableCode">
    <ows:ExceptionText>{http://rtjuette.de}bb_karlsruhe_wfst is read-only</ows:ExceptionText>
  </ows:Exception>
</ows:ExceptionReport>

Here's the transaction:

<wfs:transaction xmlns:wfs="http://www.opengis.net/wfs&quot; service="WFS" version="1.1.0" xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.1.0/wfs.xsd&quot; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance&quot;&gt;
  <wfs:insert>
    <feature:bb_karlsruhe_wfst xmlns:feature="http://rtjuette.de">
      <feature:way>
        <gml:multicurve xmlns:gml="http://www.opengis.net/gml&quot; srsName="EPSG:4326">
          <gml:curvemember>
            <gml:linestring>
              <gml:poslist>8.3866882324218 49.011753124757 8.3908081054687 49.0315656227 8.4251403808594 49.020759783397 8.4175872802735 49.009951597471 8.4011077880859 49.018508271515 8.3976745605469 49.001393452634 8.3612823486328 49.008150004997 8.3592224121093 49.037417805904 8.407974243164 49.046419820376 8.4203338623047 49.042369115505</gml:poslist>
            </gml:linestring>
          </gml:curvemember>
        </gml:multicurve>
      </feature:way>
    </feature:bb_karlsruhe_wfst>
  </wfs:insert>
</wfs:transaction>

I can't find any setting that enables write protection for this layer. The user who is defined in the store's settings has r/w access to the table. The table is empty at the moment, but i was able to read and display elements that were stored there before. I used the GS webui to define a "Data security" rule that reads "*.*.w" for role "*" (in addition to "*.*.r" "*").

I'm running Geoserver 2.0.2 on Debian lenny x86 with Java 1.6.20. The Datastore is a PostGIS 1.5 DB.
I can remember working with WFS-T before, but i don't know if i used PostGIS back then. Am i missing anything?

Regards,
Lennart

hi Lennart,

The case of this is usually a database table that does not have a primary key associated with it. Because there is no primary key geoserver can not assign persistent identifiers to features and has to make the source read only.

-Justin

On 10-05-27 8:22 AM, Lennart Jütte wrote:

I'm trying to execute a wfs transaction, but i always get an exception:

<?xml version="1.0" encoding="UTF-8"?>
<ows:ExceptionReport version="1.0.0" xsi:schemaLocation="http://www.opengis.net/ows http://wka-wn-flogx:8080/geoserver/schemas/ows/1.0.0/owsExceptionReport.xsd&quot; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance&quot; xmlns:ows="http://www.opengis.net/ows&quot;&gt;
   <ows:Exception exceptionCode="NoApplicableCode">
     <ows:ExceptionText>{http://rtjuette.de}bb_karlsruhe_wfst is read-only</ows:ExceptionText>
   </ows:Exception>
</ows:ExceptionReport>

Here's the transaction:

<wfs:transaction xmlns:wfs="http://www.opengis.net/wfs&quot; service="WFS" version="1.1.0" xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.1.0/wfs.xsd&quot; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance&quot;&gt;
   <wfs:insert>
     <feature:bb_karlsruhe_wfst xmlns:feature="http://rtjuette.de">
       <feature:way>
         <gml:multicurve xmlns:gml="http://www.opengis.net/gml&quot; srsName="EPSG:4326">
           <gml:curvemember>
             <gml:linestring>
               <gml:poslist>8.3866882324218 49.011753124757 8.3908081054687 49.0315656227 8.4251403808594 49.020759783397 8.4175872802735 49.009951597471 8.4011077880859 49.018508271515 8.3976745605469 49.001393452634 8.3612823486328 49.008150004997 8.3592224121093 49.037417805904 8.407974243164 49.046419820376 8.4203338623047 49.042369115505</gml:poslist>
             </gml:linestring>
           </gml:curvemember>
         </gml:multicurve>
       </feature:way>
     </feature:bb_karlsruhe_wfst>
   </wfs:insert>
</wfs:transaction>

I can't find any setting that enables write protection for this layer. The user who is defined in the store's settings has r/w access to the table. The table is empty at the moment, but i was able to read and display elements that were stored there before. I used the GS webui to define a "Data security" rule that reads "*.*.w" for role "*" (in addition to "*.*.r" "*").

I'm running Geoserver 2.0.2 on Debian lenny x86 with Java 1.6.20. The Datastore is a PostGIS 1.5 DB.
I can remember working with WFS-T before, but i don't know if i used PostGIS back then. Am i missing anything?

Regards,
Lennart
------------------------------------------------------------------------------

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.

I forgot to mention that the WFS service level is set to "full" (my german geoserver shows "völlständig"). Setting it to "transactional" doesn't help.

Am 27.05.2010 um 16:22 schrieb Lennart Jütte:

I'm trying to execute a wfs transaction, but i always get an exception:

<?xml version="1.0" encoding="UTF-8"?>
<ows:ExceptionReport version="1.0.0" xsi:schemaLocation="http://www.opengis.net/ows http://wka-wn-flogx:8080/geoserver/schemas/ows/1.0.0/owsExceptionReport.xsd&quot; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance&quot; xmlns:ows="http://www.opengis.net/ows&quot;&gt;
<ows:Exception exceptionCode="NoApplicableCode">
   <ows:ExceptionText>{http://rtjuette.de}bb_karlsruhe_wfst is read-only</ows:ExceptionText>
</ows:Exception>
</ows:ExceptionReport>

Here's the transaction:

<wfs:transaction xmlns:wfs="http://www.opengis.net/wfs&quot; service="WFS" version="1.1.0" xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.1.0/wfs.xsd&quot; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance&quot;&gt;
<wfs:insert>
   <feature:bb_karlsruhe_wfst xmlns:feature="http://rtjuette.de">
     <feature:way>
       <gml:multicurve xmlns:gml="http://www.opengis.net/gml&quot; srsName="EPSG:4326">
         <gml:curvemember>
           <gml:linestring>
             <gml:poslist>8.3866882324218 49.011753124757 8.3908081054687 49.0315656227 8.4251403808594 49.020759783397 8.4175872802735 49.009951597471 8.4011077880859 49.018508271515 8.3976745605469 49.001393452634 8.3612823486328 49.008150004997 8.3592224121093 49.037417805904 8.407974243164 49.046419820376 8.4203338623047 49.042369115505</gml:poslist>
           </gml:linestring>
         </gml:curvemember>
       </gml:multicurve>
     </feature:way>
   </feature:bb_karlsruhe_wfst>
</wfs:insert>
</wfs:transaction>

I can't find any setting that enables write protection for this layer. The user who is defined in the store's settings has r/w access to the table. The table is empty at the moment, but i was able to read and display elements that were stored there before. I used the GS webui to define a "Data security" rule that reads "*.*.w" for role "*" (in addition to "*.*.r" "*").

I'm running Geoserver 2.0.2 on Debian lenny x86 with Java 1.6.20. The Datastore is a PostGIS 1.5 DB.
I can remember working with WFS-T before, but i don't know if i used PostGIS back then. Am i missing anything?

Regards,
Lennart
------------------------------------------------------------------------------

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Hi Justin,

good to know that. I fixed this problem an got another exception. here's the DEBUG output of geoserver.

2010-05-27 17:06:04,761 DEBUG [geoserver.wfs] - Locating FeatureSource uri:'http://rtjuette.de' name:'bb_karlsruhe_wfst'
2010-05-27 17:06:04,762 DEBUG [geoserver.wfs] - located FeatureType w/ typeRef 'osm_bb_karlsruhe_wfst:bb_karlsruhe_wfst' and elementName '{http://rtjuette.de}bb_karlsruhe_wfst'
2010-05-27 17:06:04,762 DEBUG [geotools.jdbc] - CREATE CONNECTION
2010-05-27 17:06:04,768 DEBUG [geotools.jdbc] - CLOSE CONNECTION
2010-05-27 17:06:04,784 DEBUG [geoserver.wfs] - Transasction Insert:net.opengis.wfs.impl.InsertElementTypeImpl@anonymised.com (feature: [SimpleFeatureImpl:bb_karlsruhe_wfst=[SimpleFeatureImpl.Attribute: access<access id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: addr:flats<addr:flats id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: addr:housenumber<addr:housenumber id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: addr:interpolation<addr:interpolation id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: admin_level<admin_level id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: aerialway<aerialway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: aeroway<aeroway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: amenity<amenity id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: area<area id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: barrier<barrier id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: bicycle<bicycle id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: bridge<bridge id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: boundary<boundary id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: building<building id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: construction<construction id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: cutting<cutting id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: disused<disused id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: embankment<embankment id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: foot<foot id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: highway<highway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: historic<historic id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: horse<horse id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: junction<junction id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: landuse<landuse id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: layer<layer id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: learning<learning id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: leisure<leisure id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: lock<lock id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: man_made<man_made id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: military<military id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: motorcar<motorcar id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: name<name id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: natural<natural id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: oneway<oneway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: operator<operator id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: power<power id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: power_source<power_source id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: place<place id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: railway<railway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: ref<ref id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: religion<religion id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: residence<residence id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: route<route id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: service<service id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: shop<shop id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: sport<sport id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: tourism<tourism id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: tracktype<tracktype id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: tunnel<tunnel id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: waterway<waterway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: width<width id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: wood<wood id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: z_order<z_order id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: way_area<way_area id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: way<way id=fid-f917647_128da4c798f_-8000>=]], handle: null, idgen: <unset>, inputFormat: <unset>, srsName: null)
2010-05-27 17:06:04,826 INFO [geotools.factory] - Factory implementations for category CoordinateOperationFactory:
  org.geotools.referencing.operation.DefaultCoordinateOperationFactory
  org.geotools.referencing.operation.AuthorityBackedFactory
  org.geotools.referencing.operation.BufferedCoordinateOperationFactory
2010-05-27 17:06:04,952 DEBUG [geoserver.wfs] - Use featureValidation to check contents of insert
2010-05-27 17:06:04,964 INFO [gwc.GWCCleanser] - Deleting GWC cache for leju:bb_karlsruhe_wfst
2010-05-27 17:06:04,965 DEBUG [geotools.jdbc] - CREATE CONNECTION
2010-05-27 17:06:04,994 TRACE [geotools.core] - ENTRY -12,345
2010-05-27 17:06:04,995 DEBUG [geotools.jdbc] - SELECT "osm_id","access","addr:flats","addr:housenumber","addr:interpolation","admin_level","aerialway","aeroway","amenity","area","barrier","bicycle","bridge","boundary","building","construction","cutting","disused","embankment","foot","highway","historic","horse","junction","landuse","layer","learning","leisure","lock","man_made","military","motorcar","name","natural","oneway","operator","power","power_source","place","railway","ref","religion","residence","route","service","shop","sport","tourism","tracktype","tunnel","waterway","width","wood","z_order","way_area",encode(asBinary(force_2d("way"),'XDR'),'base64') as "way" FROM "public"."planet_osm_roads" WHERE 0 = 1
2010-05-27 17:06:05,007 INFO [file.FileBlobStore] - /home/geoserver/data_dir/gwc/leju_bb_karlsruhe_wfst does not exist or is not writable
2010-05-27 17:06:05,007 INFO [gwc.GWCCleanser] - GWC cache for leju:bb_karlsruhe_wfst deleted successfully
2010-05-27 17:06:05,044 DEBUG [geotools.jdbc] - Setting access to null
2010-05-27 17:06:05,045 DEBUG [geotools.jdbc] - Setting 0 to null
2010-05-27 17:06:05,045 DEBUG [geotools.jdbc] - Setting addr:flats to null
2010-05-27 17:06:05,045 DEBUG [geotools.jdbc] - Setting 1 to null
2010-05-27 17:06:05,045 DEBUG [geotools.jdbc] - Setting addr:housenumber to null
2010-05-27 17:06:05,045 DEBUG [geotools.jdbc] - Setting 2 to null
2010-05-27 17:06:05,045 DEBUG [geotools.jdbc] - Setting addr:interpolation to null
2010-05-27 17:06:05,045 DEBUG [geotools.jdbc] - Setting 3 to null
2010-05-27 17:06:05,045 DEBUG [geotools.jdbc] - Setting admin_level to null
2010-05-27 17:06:05,045 DEBUG [geotools.jdbc] - Setting 4 to null
2010-05-27 17:06:05,045 DEBUG [geotools.jdbc] - Setting aerialway to null
2010-05-27 17:06:05,045 DEBUG [geotools.jdbc] - Setting 5 to null
2010-05-27 17:06:05,045 DEBUG [geotools.jdbc] - Setting aeroway to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting 6 to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting amenity to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting 7 to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting area to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting 8 to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting barrier to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting 9 to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting bicycle to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting 10 to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting bridge to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting 11 to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting boundary to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting 12 to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting building to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting 13 to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting construction to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting 14 to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting cutting to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting 15 to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting disused to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting 16 to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting embankment to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting 17 to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting foot to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting 18 to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting highway to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting 19 to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting historic to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting 20 to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting horse to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting 21 to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting junction to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting 22 to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting landuse to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting 23 to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting layer to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting 24 to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting learning to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting 25 to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting leisure to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting 26 to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting lock to null
2010-05-27 17:06:05,048 DEBUG [geotools.jdbc] - Setting 27 to null
2010-05-27 17:06:05,048 DEBUG [geotools.jdbc] - Setting man_made to null
2010-05-27 17:06:05,048 DEBUG [geotools.jdbc] - Setting 28 to null
2010-05-27 17:06:05,048 DEBUG [geotools.jdbc] - Setting military to null
2010-05-27 17:06:05,048 DEBUG [geotools.jdbc] - Setting 29 to null
2010-05-27 17:06:05,048 DEBUG [geotools.jdbc] - Setting motorcar to null
2010-05-27 17:06:05,048 DEBUG [geotools.jdbc] - Setting 30 to null
2010-05-27 17:06:05,048 DEBUG [geotools.jdbc] - Setting name to null
2010-05-27 17:06:05,048 DEBUG [geotools.jdbc] - Setting 31 to null
2010-05-27 17:06:05,048 DEBUG [geotools.jdbc] - Setting natural to null
2010-05-27 17:06:05,048 DEBUG [geotools.jdbc] - Setting 32 to null
2010-05-27 17:06:05,048 DEBUG [geotools.jdbc] - Setting oneway to null
2010-05-27 17:06:05,048 DEBUG [geotools.jdbc] - Setting 33 to null
2010-05-27 17:06:05,048 DEBUG [geotools.jdbc] - Setting operator to null
2010-05-27 17:06:05,048 DEBUG [geotools.jdbc] - Setting 34 to null
2010-05-27 17:06:05,048 DEBUG [geotools.jdbc] - Setting power to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting 35 to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting power_source to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting 36 to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting place to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting 37 to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting railway to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting 38 to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting ref to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting 39 to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting religion to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting 40 to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting residence to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting 41 to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting route to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting 42 to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting service to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting 43 to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting shop to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting 44 to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting sport to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting 45 to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting tourism to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting 46 to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting tracktype to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting 47 to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting tunnel to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting 48 to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting waterway to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting 49 to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting width to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting 50 to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting wood to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting 51 to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting z_order to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting 52 to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting way_area to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting 53 to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting way to
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting 54 to
2010-05-27 17:06:05,051 DEBUG [geotools.jdbc] - Getting next FID: SELECT MAX("osm_id") + 1 FROM "public"."planet_osm_roads"
2010-05-27 17:06:05,055 ERROR [geoserver.wfs] - Transaction failed
org.geoserver.wfs.WFSTransactionException: Error performing insert
  at org.geoserver.wfs.InsertElementHandler.execute(InsertElementHandler.java:204)
  at org.geoserver.wfs.Transaction.execute(Transaction.java:334)
  at org.geoserver.wfs.Transaction.transaction(Transaction.java:109)
  at org.geoserver.wfs.DefaultWebFeatureService.transaction(DefaultWebFeatureService.java:163)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  at java.lang.reflect.Method.invoke(Method.java:597)
  at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
  at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
  at org.geoserver.ows.util.EMFLogger.invoke(EMFLogger.java:51)
  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
  at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
  at $Proxy16.transaction(Unknown Source)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  at java.lang.reflect.Method.invoke(Method.java:597)
  at org.geoserver.ows.Dispatcher.execute(Dispatcher.java:599)
  at org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:230)
  at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
  at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
  at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
  at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)
  at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
  at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
  at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
  at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1093)
  at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
  at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
  at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
  at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
  at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
  at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
  at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
  at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
  at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
  at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
  at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174)
  at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
  at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
  at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
  at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
  at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
  at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
  at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:73)
  at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
  at org.geoserver.filters.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:183)
  at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
  at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:41)
  at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
  at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
  at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
  at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
  at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:726)
  at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
  at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:206)
  at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
  at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
  at org.mortbay.jetty.Server.handle(Server.java:324)
  at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)
  at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:842)
  at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:648)
  at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
  at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
  at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)
  at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:450)
Caused by: java.lang.ClassCastException: java.lang.String cannot be cast to com.vividsolutions.jts.geom.Geometry
  at org.geotools.jdbc.JDBCDataStore.insertSQL(JDBCDataStore.java:3245)
  at org.geotools.jdbc.JDBCDataStore.insert(JDBCDataStore.java:1249)
  at org.geotools.jdbc.JDBCDataStore.insert(JDBCDataStore.java:1207)
  at org.geotools.jdbc.JDBCInsertFeatureWriter.write(JDBCInsertFeatureWriter.java:73)
  at org.geotools.data.InProcessLockingManager$1.write(InProcessLockingManager.java:335)
  at org.geotools.data.store.ContentFeatureStore.addFeatures(ContentFeatureStore.java:255)
  at org.geoserver.feature.retype.RetypingFeatureStore.addFeatures(RetypingFeatureStore.java:87)
  at org.vfny.geoserver.global.GeoServerFeatureStore.addFeatures(GeoServerFeatureStore.java:81)
  at org.geoserver.wfs.InsertElementHandler.execute(InsertElementHandler.java:173)
  ... 69 more
2010-05-27 17:06:05,063 INFO [geoserver.wfs] -
Request: transaction
  handle = null
  service = WFS
  version = 1.1.0
  baseUrl = http://wka-wn-flogx:8080/geoserver/
  providedVersion = null
  lockId = null
  group = [wfs:insert=net.opengis.wfs.impl.InsertElementTypeImpl@anonymised.com... (feature: [SimpleFeatureImpl:bb_karlsruhe_wfst=[SimpleFeatureImpl.Attribute: access<access id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: addr:flats<addr:flats id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: addr:housenumber<addr:housenumber id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: addr:interpolation<addr:interpolation id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: admin_level<admin_level id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: aerialway<aerialway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: aeroway<aeroway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: amenity<amenity id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: area<area id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: barrier<barrier id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: bicycle<bicycle id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: bridge<bridge id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: boundary<boundary id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: building<building id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: construction<construction id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: cutting<cutting id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: disused<disused id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: embankment<embankment id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: foot<foot id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: highway<highway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: historic<historic id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: horse<horse id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: junction<junction id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: landuse<landuse id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: layer<layer id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: learning<learning id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: leisure<leisure id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: lock<lock id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: man_made<man_made id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: military<military id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: motorcar<motorcar id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: name<name id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: natural<natural id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: oneway<oneway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: operator<operator id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: power<power id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: power_source<power_source id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: place<place id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: railway<railway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: ref<ref id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: religion<religion id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: residence<residence id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: route<route id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: service<service id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: shop<shop id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: sport<sport id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: tourism<tourism id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: tracktype<tracktype id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: tunnel<tunnel id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: waterway<waterway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: width<width id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: wood<wood id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: z_order<z_order id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: way_area<way_area id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: way<way id=fid-f917647_128da4c798f_-8000>=]], handle: null, idgen: <unset>, inputFormat: <unset>, srsName: null)]
  insert = [net.opengis.wfs.impl.InsertElementTypeImpl@anonymised.com (feature: [SimpleFeatureImpl:bb_karlsruhe_wfst=[SimpleFeatureImpl.Attribute: access<access id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: addr:flats<addr:flats id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: addr:housenumber<addr:housenumber id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: addr:interpolation<addr:interpolation id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: admin_level<admin_level id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: aerialway<aerialway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: aeroway<aeroway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: amenity<amenity id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: area<area id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: barrier<barrier id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: bicycle<bicycle id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: bridge<bridge id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: boundary<boundary id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: building<building id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: construction<construction id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: cutting<cutting id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: disused<disused id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: embankment<embankment id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: foot<foot id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: highway<highway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: historic<historic id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: horse<horse id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: junction<junction id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: landuse<landuse id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: layer<layer id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: learning<learning id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: leisure<leisure id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: lock<lock id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: man_made<man_made id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: military<military id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: motorcar<motorcar id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: name<name id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: natural<natural id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: oneway<oneway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: operator<operator id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: power<power id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: power_source<power_source id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: place<place id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: railway<railway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: ref<ref id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: religion<religion id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: residence<residence id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: route<route id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: service<service id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: shop<shop id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: sport<sport id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: tourism<tourism id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: tracktype<tracktype id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: tunnel<tunnel id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: waterway<waterway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: width<width id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: wood<wood id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: z_order<z_order id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: way_area<way_area id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: way<way id=fid-f917647_128da4c798f_-8000>=]], handle: null, idgen: <unset>, inputFormat: <unset>, srsName: null)]
  update =
  delete =
  native =
  releaseAction = ALL
2010-05-27 17:06:05,070 ERROR [geoserver.ows] -
org.geoserver.wfs.WFSException: Error performing insert
  at org.geoserver.wfs.response.TransactionResponse.v_1_1(TransactionResponse.java:197)
  at org.geoserver.wfs.response.TransactionResponse.write(TransactionResponse.java:67)
  at org.geoserver.ows.Dispatcher.response(Dispatcher.java:726)
  at org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:234)
  at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
  at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
  at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
  at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)
  at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
  at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
  at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
  at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1093)
  at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
  at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
  at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
  at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
  at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
  at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
  at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
  at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
  at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
  at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
  at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174)
  at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
  at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
  at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
  at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
  at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
  at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
  at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:73)
  at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
  at org.geoserver.filters.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:183)
  at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
  at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:41)
  at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
  at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
  at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
  at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
  at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:726)
  at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
  at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:206)
  at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
  at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
  at org.mortbay.jetty.Server.handle(Server.java:324)
  at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)
  at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:842)
  at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:648)
  at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
  at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
  at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)
  at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:450)

Am 27.05.2010 um 16:31 schrieb Justin Deoliveira:

hi Lennart,

The case of this is usually a database table that does not have a
primary key associated with it. Because there is no primary key
geoserver can not assign persistent identifiers to features and has to
make the source read only.

-Justin

On 10-05-27 8:22 AM, Lennart Jütte wrote:

I'm trying to execute a wfs transaction, but i always get an exception:

<?xml version="1.0" encoding="UTF-8"?>
<ows:ExceptionReport version="1.0.0" xsi:schemaLocation="http://www.opengis.net/ows http://wka-wn-flogx:8080/geoserver/schemas/ows/1.0.0/owsExceptionReport.xsd&quot; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance&quot; xmlns:ows="http://www.opengis.net/ows&quot;&gt;
  <ows:Exception exceptionCode="NoApplicableCode">
    <ows:ExceptionText>{http://rtjuette.de}bb_karlsruhe_wfst is read-only</ows:ExceptionText>
  </ows:Exception>
</ows:ExceptionReport>

Here's the transaction:

<wfs:transaction xmlns:wfs="http://www.opengis.net/wfs&quot; service="WFS" version="1.1.0" xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.1.0/wfs.xsd&quot; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance&quot;&gt;
  <wfs:insert>
    <feature:bb_karlsruhe_wfst xmlns:feature="http://rtjuette.de">
      <feature:way>
        <gml:multicurve xmlns:gml="http://www.opengis.net/gml&quot; srsName="EPSG:4326">
          <gml:curvemember>
            <gml:linestring>
              <gml:poslist>8.3866882324218 49.011753124757 8.3908081054687 49.0315656227 8.4251403808594 49.020759783397 8.4175872802735 49.009951597471 8.4011077880859 49.018508271515 8.3976745605469 49.001393452634 8.3612823486328 49.008150004997 8.3592224121093 49.037417805904 8.407974243164 49.046419820376 8.4203338623047 49.042369115505</gml:poslist>
            </gml:linestring>
          </gml:curvemember>
        </gml:multicurve>
      </feature:way>
    </feature:bb_karlsruhe_wfst>
  </wfs:insert>
</wfs:transaction>

I can't find any setting that enables write protection for this layer. The user who is defined in the store's settings has r/w access to the table. The table is empty at the moment, but i was able to read and display elements that were stored there before. I used the GS webui to define a "Data security" rule that reads "*.*.w" for role "*" (in addition to "*.*.r" "*").

I'm running Geoserver 2.0.2 on Debian lenny x86 with Java 1.6.20. The Datastore is a PostGIS 1.5 DB.
I can remember working with WFS-T before, but i don't know if i used PostGIS back then. Am i missing anything?

Regards,
Lennart
------------------------------------------------------------------------------

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.

------------------------------------------------------------------------------

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Hi Lennart,

LOoking at the original request I see a number of spelling mistakes in the geometry:

multicurve -> MultiCurve
curvemember -> curveMember
lineString -> LineString
etc...

Case matters in gml. What is happening is the geometry is not being parsed as a geometry because geoserver does not recognize it.

-Justin

On 10-05-27 9:13 AM, Lennart Jütte wrote:

Hi Justin,

good to know that. I fixed this problem an got another exception. here's the DEBUG output of geoserver.

2010-05-27 17:06:04,761 DEBUG [geoserver.wfs] - Locating FeatureSource uri:'http://rtjuette.de' name:'bb_karlsruhe_wfst'
2010-05-27 17:06:04,762 DEBUG [geoserver.wfs] - located FeatureType w/ typeRef 'osm_bb_karlsruhe_wfst:bb_karlsruhe_wfst' and elementName '{http://rtjuette.de}bb_karlsruhe_wfst'
2010-05-27 17:06:04,762 DEBUG [geotools.jdbc] - CREATE CONNECTION
2010-05-27 17:06:04,768 DEBUG [geotools.jdbc] - CLOSE CONNECTION
2010-05-27 17:06:04,784 DEBUG [geoserver.wfs] - Transasction Insert:net.opengis.wfs.impl.InsertElementTypeImpl@anonymised.com (feature: [SimpleFeatureImpl:bb_karlsruhe_wfst=[SimpleFeatureImpl.Attribute: access<access id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: addr:flats<addr:flats id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: addr:housenumber<addr:housenumber id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: addr:interpolation<addr:interpolation id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: admin_level<admin_level id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: aerialway<aerialway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: aeroway<aeroway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: amenity<amenity id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: area<area id=fid-f917647_128da4c798f_-8000>=null, Simple

FeatureImpl.Attribute: barrier<barrier id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: bicycle<bicycle id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: bridge<bridge id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: boundary<boundary id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: building<building id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: construction<construction id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: cutting<cutting id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: disused<disused id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: embankment<embankment id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: foot<foot id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: highway<highway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: historic<historic id
=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: horse<horse id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: junction<junction id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: landuse<landuse id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: layer<layer id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: learning<learning id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: leisure<leisure id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: lock<lock id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: man_made<man_made id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: military<military id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: motorcar<motorcar id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: name<name id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute
: natural<natural id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: oneway<oneway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: operator<operator id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: power<power id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: power_source<power_source id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: place<place id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: railway<railway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: ref<ref id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: religion<religion id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: residence<residence id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: route<route id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: service<service id=fid-f917647_128da4c798f_-8000>=null, S
impleFeatureImpl.Attribute: shop<shop id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: sport<sport id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: tourism<tourism id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: tracktype<tracktype id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: tunnel<tunnel id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: waterway<waterway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: width<width id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: wood<wood id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: z_order<z_order id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: way_area<way_area id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: way<way id=fid-f917647_128da4c798f_-8000>=]], handle: null, idgen:<unset>, inputFormat:<unset>, srsName: null)

2010-05-27 17:06:04,826 INFO [geotools.factory] - Factory implementations for category CoordinateOperationFactory:
   org.geotools.referencing.operation.DefaultCoordinateOperationFactory
   org.geotools.referencing.operation.AuthorityBackedFactory
   org.geotools.referencing.operation.BufferedCoordinateOperationFactory
2010-05-27 17:06:04,952 DEBUG [geoserver.wfs] - Use featureValidation to check contents of insert
2010-05-27 17:06:04,964 INFO [gwc.GWCCleanser] - Deleting GWC cache for leju:bb_karlsruhe_wfst
2010-05-27 17:06:04,965 DEBUG [geotools.jdbc] - CREATE CONNECTION
2010-05-27 17:06:04,994 TRACE [geotools.core] - ENTRY -12,345
2010-05-27 17:06:04,995 DEBUG [geotools.jdbc] - SELECT "osm_id","access","addr:flats","addr:housenumber","addr:interpolation","admin_level","aerialway","aeroway","amenity","area","barrier","bicycle","bridge","boundary","building","construction","cutting","disused","embankment","foot","highway","historic","horse","junction","landuse","layer","learning","leisure","lock","man_made","military","motorcar","name","natural","oneway","operator","power","power_source","place","railway","ref","religion","residence","route","service","shop","sport","tourism","tracktype","tunnel","waterway","width","wood","z_order","way_area",encode(asBinary(force_2d("way"),'XDR'),'base64') as "way" FROM "public"."planet_osm_roads" WHERE 0 = 1
2010-05-27 17:06:05,007 INFO [file.FileBlobStore] - /home/geoserver/data_dir/gwc/leju_bb_karlsruhe_wfst does not exist or is not writable
2010-05-27 17:06:05,007 INFO [gwc.GWCCleanser] - GWC cache for leju:bb_karlsruhe_wfst deleted successfully
2010-05-27 17:06:05,044 DEBUG [geotools.jdbc] - Setting access to null
2010-05-27 17:06:05,045 DEBUG [geotools.jdbc] - Setting 0 to null
2010-05-27 17:06:05,045 DEBUG [geotools.jdbc] - Setting addr:flats to null
2010-05-27 17:06:05,045 DEBUG [geotools.jdbc] - Setting 1 to null
2010-05-27 17:06:05,045 DEBUG [geotools.jdbc] - Setting addr:housenumber to null
2010-05-27 17:06:05,045 DEBUG [geotools.jdbc] - Setting 2 to null
2010-05-27 17:06:05,045 DEBUG [geotools.jdbc] - Setting addr:interpolation to null
2010-05-27 17:06:05,045 DEBUG [geotools.jdbc] - Setting 3 to null
2010-05-27 17:06:05,045 DEBUG [geotools.jdbc] - Setting admin_level to null
2010-05-27 17:06:05,045 DEBUG [geotools.jdbc] - Setting 4 to null
2010-05-27 17:06:05,045 DEBUG [geotools.jdbc] - Setting aerialway to null
2010-05-27 17:06:05,045 DEBUG [geotools.jdbc] - Setting 5 to null
2010-05-27 17:06:05,045 DEBUG [geotools.jdbc] - Setting aeroway to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting 6 to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting amenity to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting 7 to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting area to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting 8 to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting barrier to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting 9 to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting bicycle to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting 10 to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting bridge to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting 11 to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting boundary to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting 12 to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting building to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting 13 to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting construction to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting 14 to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting cutting to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting 15 to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting disused to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting 16 to null
2010-05-27 17:06:05,046 DEBUG [geotools.jdbc] - Setting embankment to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting 17 to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting foot to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting 18 to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting highway to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting 19 to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting historic to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting 20 to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting horse to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting 21 to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting junction to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting 22 to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting landuse to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting 23 to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting layer to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting 24 to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting learning to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting 25 to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting leisure to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting 26 to null
2010-05-27 17:06:05,047 DEBUG [geotools.jdbc] - Setting lock to null
2010-05-27 17:06:05,048 DEBUG [geotools.jdbc] - Setting 27 to null
2010-05-27 17:06:05,048 DEBUG [geotools.jdbc] - Setting man_made to null
2010-05-27 17:06:05,048 DEBUG [geotools.jdbc] - Setting 28 to null
2010-05-27 17:06:05,048 DEBUG [geotools.jdbc] - Setting military to null
2010-05-27 17:06:05,048 DEBUG [geotools.jdbc] - Setting 29 to null
2010-05-27 17:06:05,048 DEBUG [geotools.jdbc] - Setting motorcar to null
2010-05-27 17:06:05,048 DEBUG [geotools.jdbc] - Setting 30 to null
2010-05-27 17:06:05,048 DEBUG [geotools.jdbc] - Setting name to null
2010-05-27 17:06:05,048 DEBUG [geotools.jdbc] - Setting 31 to null
2010-05-27 17:06:05,048 DEBUG [geotools.jdbc] - Setting natural to null
2010-05-27 17:06:05,048 DEBUG [geotools.jdbc] - Setting 32 to null
2010-05-27 17:06:05,048 DEBUG [geotools.jdbc] - Setting oneway to null
2010-05-27 17:06:05,048 DEBUG [geotools.jdbc] - Setting 33 to null
2010-05-27 17:06:05,048 DEBUG [geotools.jdbc] - Setting operator to null
2010-05-27 17:06:05,048 DEBUG [geotools.jdbc] - Setting 34 to null
2010-05-27 17:06:05,048 DEBUG [geotools.jdbc] - Setting power to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting 35 to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting power_source to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting 36 to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting place to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting 37 to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting railway to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting 38 to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting ref to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting 39 to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting religion to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting 40 to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting residence to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting 41 to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting route to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting 42 to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting service to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting 43 to null
2010-05-27 17:06:05,049 DEBUG [geotools.jdbc] - Setting shop to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting 44 to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting sport to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting 45 to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting tourism to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting 46 to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting tracktype to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting 47 to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting tunnel to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting 48 to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting waterway to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting 49 to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting width to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting 50 to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting wood to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting 51 to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting z_order to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting 52 to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting way_area to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting 53 to null
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting way to
2010-05-27 17:06:05,050 DEBUG [geotools.jdbc] - Setting 54 to
2010-05-27 17:06:05,051 DEBUG [geotools.jdbc] - Getting next FID: SELECT MAX("osm_id") + 1 FROM "public"."planet_osm_roads"
2010-05-27 17:06:05,055 ERROR [geoserver.wfs] - Transaction failed
org.geoserver.wfs.WFSTransactionException: Error performing insert
  at org.geoserver.wfs.InsertElementHandler.execute(InsertElementHandler.java:204)
  at org.geoserver.wfs.Transaction.execute(Transaction.java:334)
  at org.geoserver.wfs.Transaction.transaction(Transaction.java:109)
  at org.geoserver.wfs.DefaultWebFeatureService.transaction(DefaultWebFeatureService.java:163)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  at java.lang.reflect.Method.invoke(Method.java:597)
  at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
  at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
  at org.geoserver.ows.util.EMFLogger.invoke(EMFLogger.java:51)
  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
  at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
  at $Proxy16.transaction(Unknown Source)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  at java.lang.reflect.Method.invoke(Method.java:597)
  at org.geoserver.ows.Dispatcher.execute(Dispatcher.java:599)
  at org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:230)
  at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
  at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
  at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
  at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)
  at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
  at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
  at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
  at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1093)
  at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
  at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
  at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
  at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
  at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
  at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
  at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
  at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
  at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
  at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
  at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174)
  at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
  at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
  at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
  at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
  at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
  at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
  at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:73)
  at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
  at org.geoserver.filters.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:183)
  at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
  at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:41)
  at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
  at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
  at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
  at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
  at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:726)
  at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
  at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:206)
  at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
  at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
  at org.mortbay.jetty.Server.handle(Server.java:324)
  at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)
  at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:842)
  at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:648)
  at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
  at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
  at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)
  at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:450)
Caused by: java.lang.ClassCastException: java.lang.String cannot be cast to com.vividsolutions.jts.geom.Geometry
  at org.geotools.jdbc.JDBCDataStore.insertSQL(JDBCDataStore.java:3245)
  at org.geotools.jdbc.JDBCDataStore.insert(JDBCDataStore.java:1249)
  at org.geotools.jdbc.JDBCDataStore.insert(JDBCDataStore.java:1207)
  at org.geotools.jdbc.JDBCInsertFeatureWriter.write(JDBCInsertFeatureWriter.java:73)
  at org.geotools.data.InProcessLockingManager$1.write(InProcessLockingManager.java:335)
  at org.geotools.data.store.ContentFeatureStore.addFeatures(ContentFeatureStore.java:255)
  at org.geoserver.feature.retype.RetypingFeatureStore.addFeatures(RetypingFeatureStore.java:87)
  at org.vfny.geoserver.global.GeoServerFeatureStore.addFeatures(GeoServerFeatureStore.java:81)
  at org.geoserver.wfs.InsertElementHandler.execute(InsertElementHandler.java:173)
  ... 69 more
2010-05-27 17:06:05,063 INFO [geoserver.wfs] -
Request: transaction
  handle = null
  service = WFS
  version = 1.1.0
  baseUrl = http://wka-wn-flogx:8080/geoserver/
  providedVersion = null
  lockId = null
  group = [wfs:insert=net.opengis.wfs.impl.InsertElementTypeImpl@anonymised.com77... (feature: [SimpleFeatureImpl:bb_karlsruhe_wfst=[SimpleFeatureImpl.Attribute: access<access id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: addr:flats<addr:flats id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: addr:housenumber<addr:housenumber id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: addr:interpolation<addr:interpolation id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: admin_level<admin_level id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: aerialway<aerialway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: aeroway<aeroway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: amenity<amenity id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: area<area id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: barrier<barrier id=fid-f

917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: bicycle<bicycle id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: bridge<bridge id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: boundary<boundary id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: building<building id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: construction<construction id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: cutting<cutting id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: disused<disused id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: embankment<embankment id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: foot<foot id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: highway<highway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: historic<historic id=fid-f917647_128da4c798f_-8000>=null, SimpleFea
tureImpl.Attribute: horse<horse id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: junction<junction id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: landuse<landuse id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: layer<layer id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: learning<learning id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: leisure<leisure id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: lock<lock id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: man_made<man_made id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: military<military id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: motorcar<motorcar id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: name<name id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: natural<natural id=fid-f917647_128da4c798f_-8
000>=null, SimpleFeatureImpl.Attribute: oneway<oneway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: operator<operator id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: power<power id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: power_source<power_source id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: place<place id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: railway<railway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: ref<ref id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: religion<religion id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: residence<residence id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: route<route id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: service<service id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: shop<shop id=fid-f9
17647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: sport<sport id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: tourism<tourism id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: tracktype<tracktype id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: tunnel<tunnel id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: waterway<waterway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: width<width id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: wood<wood id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: z_order<z_order id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: way_area<way_area id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: way<way id=fid-f917647_128da4c798f_-8000>=]], handle: null, idgen:<unset>, inputFormat:<unset>, srsName: null)]

  insert = [net.opengis.wfs.impl.InsertElementTypeImpl@anonymised.com (feature: [SimpleFeatureImpl:bb_karlsruhe_wfst=[SimpleFeatureImpl.Attribute: access<access id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: addr:flats<addr:flats id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: addr:housenumber<addr:housenumber id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: addr:interpolation<addr:interpolation id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: admin_level<admin_level id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: aerialway<aerialway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: aeroway<aeroway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: amenity<amenity id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: area<area id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: barrier<barrier id=fid-f917647_128

da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: bicycle<bicycle id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: bridge<bridge id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: boundary<boundary id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: building<building id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: construction<construction id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: cutting<cutting id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: disused<disused id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: embankment<embankment id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: foot<foot id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: highway<highway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: historic<historic id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.A
ttribute: horse<horse id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: junction<junction id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: landuse<landuse id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: layer<layer id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: learning<learning id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: leisure<leisure id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: lock<lock id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: man_made<man_made id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: military<military id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: motorcar<motorcar id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: name<name id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: natural<natural id=fid-f917647_128da4c798f_-8000>=null,
SimpleFeatureImpl.Attribute: oneway<oneway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: operator<operator id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: power<power id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: power_source<power_source id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: place<place id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: railway<railway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: ref<ref id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: religion<religion id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: residence<residence id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: route<route id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: service<service id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: shop<shop id=fid-f917647_128d
a4c798f_-8000>=null, SimpleFeatureImpl.Attribute: sport<sport id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: tourism<tourism id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: tracktype<tracktype id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: tunnel<tunnel id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: waterway<waterway id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: width<width id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: wood<wood id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: z_order<z_order id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: way_area<way_area id=fid-f917647_128da4c798f_-8000>=null, SimpleFeatureImpl.Attribute: way<way id=fid-f917647_128da4c798f_-8000>=]], handle: null, idgen:<unset>, inputFormat:<unset>, srsName: null)]

  update =
  delete =
  native =
  releaseAction = ALL
2010-05-27 17:06:05,070 ERROR [geoserver.ows] -
org.geoserver.wfs.WFSException: Error performing insert
  at org.geoserver.wfs.response.TransactionResponse.v_1_1(TransactionResponse.java:197)
  at org.geoserver.wfs.response.TransactionResponse.write(TransactionResponse.java:67)
  at org.geoserver.ows.Dispatcher.response(Dispatcher.java:726)
  at org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:234)
  at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
  at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
  at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
  at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)
  at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
  at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
  at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
  at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1093)
  at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
  at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
  at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
  at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
  at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
  at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
  at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
  at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
  at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
  at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
  at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174)
  at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
  at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
  at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
  at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
  at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
  at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
  at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:73)
  at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
  at org.geoserver.filters.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:183)
  at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
  at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:41)
  at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
  at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
  at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
  at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
  at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:726)
  at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
  at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:206)
  at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
  at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
  at org.mortbay.jetty.Server.handle(Server.java:324)
  at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)
  at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:842)
  at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:648)
  at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
  at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
  at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)
  at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:450)

Am 27.05.2010 um 16:31 schrieb Justin Deoliveira:

hi Lennart,

The case of this is usually a database table that does not have a
primary key associated with it. Because there is no primary key
geoserver can not assign persistent identifiers to features and has to
make the source read only.

-Justin

On 10-05-27 8:22 AM, Lennart Jütte wrote:

I'm trying to execute a wfs transaction, but i always get an exception:

<?xml version="1.0" encoding="UTF-8"?>
<ows:ExceptionReport version="1.0.0" xsi:schemaLocation="http://www.opengis.net/ows http://wka-wn-flogx:8080/geoserver/schemas/ows/1.0.0/owsExceptionReport.xsd&quot; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance&quot; xmlns:ows="http://www.opengis.net/ows&quot;&gt;
   <ows:Exception exceptionCode="NoApplicableCode">
     <ows:ExceptionText>{http://rtjuette.de}bb_karlsruhe_wfst is read-only</ows:ExceptionText>
   </ows:Exception>
</ows:ExceptionReport>

Here's the transaction:

<wfs:transaction xmlns:wfs="http://www.opengis.net/wfs&quot; service="WFS" version="1.1.0" xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.1.0/wfs.xsd&quot; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance&quot;&gt;
   <wfs:insert>
     <feature:bb_karlsruhe_wfst xmlns:feature="http://rtjuette.de">
       <feature:way>
         <gml:multicurve xmlns:gml="http://www.opengis.net/gml&quot; srsName="EPSG:4326">
           <gml:curvemember>
             <gml:linestring>
               <gml:poslist>8.3866882324218 49.011753124757 8.3908081054687 49.0315656227 8.4251403808594 49.020759783397 8.4175872802735 49.009951597471 8.4011077880859 49.018508271515 8.3976745605469 49.001393452634 8.3612823486328 49.008150004997 8.3592224121093 49.037417805904 8.407974243164 49.046419820376 8.4203338623047 49.042369115505</gml:poslist>
             </gml:linestring>
           </gml:curvemember>
         </gml:multicurve>
       </feature:way>
     </feature:bb_karlsruhe_wfst>
   </wfs:insert>
</wfs:transaction>

I can't find any setting that enables write protection for this layer. The user who is defined in the store's settings has r/w access to the table. The table is empty at the moment, but i was able to read and display elements that were stored there before. I used the GS webui to define a "Data security" rule that reads "*.*.w" for role "*" (in addition to "*.*.r" "*").

I'm running Geoserver 2.0.2 on Debian lenny x86 with Java 1.6.20. The Datastore is a PostGIS 1.5 DB.
I can remember working with WFS-T before, but i don't know if i used PostGIS back then. Am i missing anything?

Regards,
Lennart
------------------------------------------------------------------------------

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.

------------------------------------------------------------------------------

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.

Lennart Jütte <lists <at> rtjuette.de> writes:

I forgot to mention that the WFS service level is set to "full" (my german

geoserver shows

"völlständig"). Setting it to "transactional" doesn't help.
Often this problem come when you don't have primary key in your

table(bb_karlsruhe_wfst), create one and expose primary key in geo-server.

Am 27.05.2010 um 16:22 schrieb Lennart Jütte:

> I'm trying to execute a wfs transaction, but i always get an exception:
>
> <?xml version="1.0" encoding="UTF-8"?>
> <ows:ExceptionReport version="1.0.0"

xsi:schemaLocation="http://www.opengis.net/ows

http://wka-wn-

flogx:8080/geoserver/schemas/ows/1.0.0/owsExceptionReport.xsd"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance&quot;

xmlns:ows="http://www.opengis.net/ows&quot;&gt;

> <ows:Exception exceptionCode="NoApplicableCode">
> <ows:ExceptionText>{http://rtjuette.de}bb_karlsruhe_wfst is read-

only</ows:ExceptionText>

> </ows:Exception>
> </ows:ExceptionReport>
>
>
> Here's the transaction:
>
> <wfs:transaction xmlns:wfs="http://www.opengis.net/wfs&quot; service="WFS"

version="1.1.0"

xsi:schemaLocation="http://www.opengis.net/wfs
http://schemas.opengis.net/wfs/1.1.0/wfs.xsd&quot;

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance&quot;&gt;

> <wfs:insert>
> <feature:bb_karlsruhe_wfst xmlns:feature="http://rtjuette.de">
> <feature:way>
> <gml:multicurve xmlns:gml="http://www.opengis.net/gml&quot;

srsName="EPSG:4326">

> <gml:curvemember>
> <gml:linestring>
> <gml:poslist>8.3866882324218 49.011753124757

8.3908081054687 49.0315656227 8.4251403808594

49.020759783397 8.4175872802735 49.009951597471 8.4011077880859

49.018508271515

8.3976745605469 49.001393452634 8.3612823486328 49.008150004997

8.3592224121093

49.037417805904 8.407974243164 49.046419820376 8.4203338623047

49.042369115505</gml:poslist>

> </gml:linestring>
> </gml:curvemember>
> </gml:multicurve>
> </feature:way>
> </feature:bb_karlsruhe_wfst>
> </wfs:insert>
> </wfs:transaction>
>
> I can't find any setting that enables write protection for this layer.

The user who is defined in the

store's settings has r/w access to the table. The table is empty at the

moment, but i was able to read and

display elements that were stored there before. I used the GS webui to

define a "Data security" rule that

reads "*.*.w" for role "*" (in addition to "*.*.r" "*").
>
> I'm running Geoserver 2.0.2 on Debian lenny x86 with Java 1.6.20. The

Datastore is a PostGIS 1.5 DB.

> I can remember working with WFS-T before, but i don't know if i used

PostGIS back then. Am i missing anything?

>
> Regards,
> Lennart
> ------------------------------------------------------------------------

------

>
> _______________________________________________
> Geoserver-users mailing list
> Geoserver-users <at> lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users

--------------------------------------------------------------------------

----