[Geoserver-devel] Re: [Geotools-gt2-users] Update Problem

Chris_Holmes1 · October 7, 2004, 1:43pm

Hmmm... I just made the exact same table in postgis and could not
replicate the error. What version of postgresql/postgis are you using?
And what version of GeoServer? And what operating system? The logs are
very odd, it seems to half way through go from encoding it correctly to
sending junk to the sql.

Oh wait, looking at it more, it looks like a problem with the featureids.
I believe you can fix this problem by creating a primary key on the table,
such as 'ALTER TABLE linetable ADD PRIMARY KEY (id);' The only thing is
that you won't be able to change the id with GeoServer, since it will
become the FeatureID, which must remain static, according to the OGC spec.
You could add a column called 'gid' and use that as the primary key. You
also may just try upgrading your version of GeoServer, since I just tested
a table very similar to yours, with no primary key, and it worked fine.

best regards,

Chris

On Thu, 7 Oct 2004, Sambasivarao Mandadi wrote:

Dear Cholmes,

Thank You for your mail. here is the log

11121272 [INFO] org.vfny.geoserver.requests.readers.DispatcherXmlReader - getting request type from org.vfny.geoserver.requests.DispatcherHandle

@14af9f7

11121282 [FEIN] org.vfny.geoserver.servlets.wfs.WfsDispatcher - post got request 4

11121292 [INFO] org.vfny.geoserver.servlets.wfs.WfsDispatcher - req_type is 4

11121292 [INFO] org.vfny.geoserver.servlets.AbstractService - Looking for configured service responses' strategy

11121292 [INFO] org.vfny.geoserver.servlets.AbstractService - Looking for configured service strategy SPEED

11121292 [FEIN] org.vfny.geoserver.servlets.AbstractService - verifying configured strategy

11121302 [INFO] org.vfny.geoserver.servlets.AbstractService - Using service strategy class org.vfny.geoserver.servlets.SpeedStrategy

11121322 [FEIN] org.vfny.geoserver.requests.wfs.TransactionFeatureHandler - we are inside attribute: false, curAttType is null curFeatureT: null

attName

11121332 [FEIN] org.vfny.geoserver.requests.wfs.TransactionFeatureHandler - we are inside attribute: false, curAttType is null curFeatureT: null

attName

11121332 [FEIN] org.vfny.geoserver.requests.wfs.TransactionFeatureHandler - we are inside attribute: false, curAttType is null curFeatureT: null

attName

11121332 [FEIN] org.vfny.geoserver.requests.wfs.TransactionFeatureHandler - we are inside attribute: false, curAttType is null curFeatureT: null

attName

11121332 [FEIN] org.vfny.geoserver.requests.wfs.TransactionFeatureHandler - we are inside attribute: false, curAttType is null curFeatureT: null

attName

11121352 [FEIN] org.vfny.geoserver.requests.wfs.TransactionFeatureHandler - we are inside attribute: false, curAttType is null curFeatureT: null

attName

11121352 [FEIN] org.vfny.geoserver.requests.wfs.TransactionFeatureHandler - we are inside attribute: false, curAttType is null curFeatureT: null

attName

11121352 [FEIN] org.vfny.geoserver.requests.wfs.TransactionFeatureHandler - we are inside attribute: false, curAttType is null curFeatureT: null

attName

11121352 [FEIN] org.vfny.geoserver.requests.wfs.TransactionFeatureHandler - we are inside attribute: false, curAttType is null curFeatureT: null

attName

11121352 [FEIN] org.vfny.geoserver.requests.wfs.TransactionFeatureHandler - we are inside attribute: false, curAttType is null curFeatureT: null

attName

11121362 [FEIN] org.vfny.geoserver.requests.wfs.TransactionFeatureHandler - we are inside attribute: false, curAttType is null curFeatureT: null

attName

11121362 [FEIN] org.vfny.geoserver.requests.wfs.TransactionFeatureHandler - we are inside attribute: false, curAttType is null curFeatureT: null

attName

11121362 [FEIN] org.vfny.geoserver.requests.wfs.TransactionFeatureHandler - we are inside attribute: false, curAttType is null curFeatureT: null

attName

11121372 [FEIN] org.vfny.geoserver.requests.wfs.TransactionFeatureHandler - we are inside attribute: false, curAttType is null curFeatureT: null

attName

11121372 [FEIN] org.vfny.geoserver.requests.wfs.TransactionFeatureHandler - we are inside attribute: false, curAttType is null curFeatureT: null

attName

11121372 [FEIN] org.vfny.geoserver.requests.wfs.TransactionFeatureHandler - we are inside attribute: false, curAttType is null curFeatureT: null

attName

11121372 [FEIN] org.vfny.geoserver.requests.wfs.TransactionFeatureHandler - we are inside attribute: false, curAttType is null curFeatureT: null

attName

11121372 [FEIN] org.vfny.geoserver.requests.wfs.TransactionFeatureHandler - we are inside attribute: false, curAttType is null curFeatureT: null

attName

11121392 [FEIN] org.vfny.geoserver.requests.wfs.TransactionFeatureHandler - we are inside attribute: false, curAttType is null curFeatureT: null

attName

11121392 [FEIN] org.vfny.geoserver.requests.wfs.TransactionFeatureHandler - we are inside attribute: false, curAttType is null curFeatureT: null

attName

11121392 [FEIN] org.vfny.geoserver.requests.wfs.TransactionFeatureHandler - we are inside attribute: false, curAttType is null curFeatureT: null

attName

11121402 [FEIN] org.vfny.geoserver.requests.wfs.TransactionFeatureHandler - we are inside attribute: false, curAttType is null curFeatureT: null

attName

11121402 [FEIN] org.vfny.geoserver.requests.wfs.TransactionFeatureHandler - we are inside attribute: false, curAttType is null curFeatureT: null

attName

11121402 [FEIN] org.vfny.geoserver.requests.wfs.TransactionFeatureHandler - we are inside attribute: false, curAttType is null curFeatureT: null

attName

11121412 [FEIN] org.vfny.geoserver.requests.wfs.TransactionFeatureHandler - we are inside attribute: false, curAttType is null curFeatureT: null

attName

11121412 [FEIN] org.vfny.geoserver.requests.wfs.TransactionFeatureHandler - we are inside attribute: false, curAttType is null curFeatureT: null

attName

11121432 [FEIN] org.vfny.geoserver.requests.wfs.TransactionFeatureHandler - we are inside attribute: false, curAttType is null curFeatureT: null

attName

11121432 [FEIN] org.vfny.geoserver.requests.wfs.TransactionFeatureHandler - we are inside attribute: false, curAttType is null curFeatureT: null

attName

11121432 [FEIN] org.vfny.geoserver.requests.wfs.TransactionFeatureHandler - we are inside attribute: false, curAttType is null curFeatureT: null

attName

11121442 [FEIN] org.vfny.geoserver.requests.wfs.TransactionFeatureHandler - we are inside attribute: false, curAttType is null curFeatureT: null

attName

11121442 [INFO] org.vfny.geoserver.servlets.AbstractService - handling request: Lock Id: null

eleaseAction: ALL

andle: null

ypeName: topp:linetable

andle: null topp:linetable 1

eleaseAll: true

ilter: [ name = test ]

roperty - Name: id, Value: 2

11121462 [FEIN] org.vfny.geoserver.servlets.AbstractService - strategy is: org.vfny.geoserver.servlets.FileStrategy@anonymised.com

11121462 [FEIN] org.vfny.geoserver.responses.wfs.TransactionResponse - request is Lock Id: null

eleaseAction: ALL

andle: null

ypeName: topp:linetable

andle: null topp:linetable 1

eleaseAll: true

ilter: [ name = test ]

roperty - Name: id, Value: 2

11121472 [FEIN] org.vfny.geoserver.responses.wfs.TransactionResponse - Locating FeatureSource 'topp:linetable'...

11121472 [FEIN] org.vfny.geoserver.global.Data - getting type topp:linetable

11121472 [FEIN] org.vfny.geoserver.responses.wfs.TransactionResponse - located FeatureType w/ typeRef 'localPostgis:linetable' and elementName '

opp:linetable'

11121472 [FEIN] org.geotools.data.postgis.PostgisDataStore - get Feature source called on linetable

11121482 [FEIN] org.geotools.data.postgis.PostgisDataStore - returning pg feature locking

11121482 [FEIN] org.geotools.data.jdbc.JDBCDataStore - calling sql builder with filter [ name = test ]

11121482 [FEIN] org.geotools.data.jdbc.JDBCDataStore - sql is SELECT "id", AsText(force_2d("line")), "width", "color", "name", "comment" FROM "l

netable" WHERE "name" = 'test'

11121492 [FEIN] org.geotools.data.jdbc.JDBCDataStore - About to execure query: SELECT "id", AsText(force_2d("line")), "width", "color", "name",

comment" FROM "linetable" WHERE "name" = 'test'

11121492 [FEIN] org.geotools.data.jdbc.ConnectionPool - Getting available connection.

11121532 [INFO] org.geotools.data.postgis.PostgisFeatureStore - asserting filter [ name = test ]

11121532 [FEIN] org.geotools.data.jdbc.JDBCDataStore - calling sql builder with filter [ name = test ]

11121542 [FEIN] org.geotools.data.jdbc.JDBCDataStore - sql is SELECT "id", AsText(force_2d("line")), "width", "color", "name", "comment" FROM "l

netable" WHERE "name" = 'test'

11121542 [FEIN] org.geotools.data.jdbc.JDBCDataStore - About to execure query: SELECT "id", AsText(force_2d("line")), "width", "color", "name",

comment" FROM "linetable" WHERE "name" = 'test'

11121652 [FEIN] org.geotools.data.jdbc.JDBCDataStore - calling sql builder with filter [ linetable.952905:ff72748d13:-7c5a, linetable.952905:ff7

748d13:-7c59 ]

11121652 [FEIN] org.geotools.data.jdbc.JDBCDataStore - sql is SELECT "id", AsText(force_2d("line")), "width", "color", "name", "comment" FROM "l

netable" WHERE () OR ()

11121652 [FEIN] org.geotools.data.jdbc.JDBCDataStore - About to execure query: SELECT "id", AsText(force_2d("line")), "width", "color", "name",

comment" FROM "linetable" WHERE () OR ()

11121662 [SCHWERWIEGEND] org.geotools.data.jdbc.JDBCDataStore - Error Performing SQL query

11121662 [WARNUNG] org.vfny.geoserver.servlets.AbstractService - service exception while executing request: org.geotools.data.DataSourceExceptio

: Error Performing SQL query

11121672 [FEIN] org.geotools.data.jdbc.ConnectionPool$ConnectionListManager - Connection closed - adding to available connections.

Thanking You,

Samba

cholmes@anonymised.com wrote:
I'm switching to geoserver-users, as this is a geoserver question.

Could you get at the logs? I need to see the stack trace to see what
might have went wrong...

Chris

Quoting Sambasivarao Mandadi :

> Hello All,
> when I am trying to update a feature using
>
>
> > xmlns:topp="http://www.openplans.org/topp"
> xmlns:ogc="http://www.opengis.net/ogc"
> xmlns:wfs="http://www.opengis.net/wfs"
> xmlns:gml="http://www.opengis.net/gml" >
>
>
>
>
>
> topp:id
>
> 2
>
>
>
>
>
>
>
> topp:name
>
> test
>
>
>
>
>
>
>
>
>
> it's giving an error like this
>
> >
> version="1.0.0"
>
> xmlns:wfs="http://www.opengis.net/wfs"
>
> xmlns:ogc="http://www.opengis.net/ogc"
>
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>
> xsi:schemaLocation="http://www.opengis.net/wfs
> http://schemas.opengis.net/wfs/1.0.0/WFS-transaction.xsd">
>
>
>
>
>
>
>
>
>
> null topp:linetable 1:
> org.geotools.data.DataSourceException: Error Performing SQL
> query
>
>
>
>
>
> anybody can help me to solve this problem.
>
> Thanking You,
>
>
>
>
> Sambasivarao Mandadi
> Klauprecht Str 10,
> Karlsruhe - 76137,
> Germany
>
> Mobile : 00491797469612
>
>
>
> Yahoo! India Matrimony: Find your life partneronline.

----------------------------------------------------------
This mail sent through IMP: https://webmail.limegroup.com/

Sambasivarao Mandadi
Klauprecht Str 10,
Karlsruhe - 76137,
Germany

Mobile : 00491797469612

Yahoo! India Matrimony: Find your life partneronline.

--