Hi,
When updating a feature with this request:
<?xml version='1.0'?>
<wfs:Transaction
version='1.0.0'
service='WFS'
xmlns='http://localhost:8080/geoserver/’
xmlns:wfs='http://www.opengis.net/wfs’
xmlns:ogc='http://www.opengis.net/ogc’
xmlns:gml='http://www.opengis.net/gml’
xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance’
xsi:schemaLocation='http://www.opengis.net/wfs
../wfs/1.0.0/WFS-transaction.xsd'>
<wfs:Update typeName='test_boundary'>
<wfs:Property>
<wfs:Name>SOURCE</wfs:Name>
<wfs:Value>TT</wfs:Value>
</wfs:Property>
<ogc:Filter>
<ogc:FeatureID fid='TEST_BOUNDARY.1590'/>
</ogc:Filter>
</wfs:Update>
</wfs:Transaction>
the Transaction is reported to be succesfull, but when I check it in my
Oracle database, no changes have been made. In the logfile I found that
there is "... - Transaction connection not open or set to manual commit",
see below. Should Oracle been set to autocommit (which is not preferable,
since there are users that need the manual commit) or can I somehow tell
Geoserver to set it to autocommit only for its "Transaction session"? And if
so, how? I've read something on setAutoCommit and Postgresql, but can't
figure out how to actually use that, especially for Oracle. Or could there
be an entirely other problem, e.g. with JDBC?
For those interested in the logfile, please see below for the possibly
relevant parts of it. For those not interested, sorry for filling up your
mailboxes... Nevertheless, I hope to read some suggestion(s). Thanks!
Thijs Brentjens
------------------------
begin logfile
------------------------
....
11516391 [FINER] org.vfny.geoserver.responses.TransactionResponse - doing
transaction response
11516391 [FINER] org.vfny.geoserver.responses.TransactionResponse - got
lockId: null
11516391 [FINER] org.vfny.geoserver.config.TypeRepository - checking
isLocked on: test_boundary, null, null
11516391 [FINER] org.vfny.geoserver.config.TypeInfo - params is
{table=TEST_BOUNDARY, user=user, instance=gisbase, passwd=****, host=host,
port=1521, dbtype=oracle}
11516391 [FINER] org.geotools.data.DataSourceFinder - Available Data
Sources:
11516407 [FINER] org.geotools.data.DataSourceFinder - PostGIS spatial
database
11516407 [FINER] org.geotools.data.DataSourceFinder - ESRI(tm) Shapefiles
(*.shp)
11516407 [FINER] org.geotools.data.DataSourceFinder - Oracle Spatial
Database
11516407 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting available
connection.
11516625 [FINE] org.geotools.data.oracle.OracleDataSource - Column Name =
FID; Column Type = NUMBER
11516625 [FINE] org.geotools.data.oracle.OracleDataSource - Column Name =
SHAPE; Column Type = SDO_GEOMETRY
Getting geometryAttribute
11516625 [FINER] org.geotools.data.oracle.OracleDataSource - Checking
geometry using: SELECT SHAPE FROM TEST_BOUNDARY WHERE ROWNUM = 1
geom class class com.vividsolutions.jts.geom.MultiLineString
best geom class class com.vividsolutions.jts.geom.MultiLineString
11516657 [FINE] org.geotools.data.oracle.OracleDataSource - Column Name =
OBJECT_ID; Column Type = NUMBER
....
11516688 [FINE] org.geotools.data.oracle.OracleDataSource - Column Name =
SOURCE; Column Type = VARCHAR2
11516719 [FINE]
org.geotools.data.jdbc.ConnectionPool$ConnectionListManager - Connection
closed - adding to available connections.
11516719 [FINER] org.vfny.geoserver.config.TypeInfo - data source is null
11516719 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting available
connection.
11516719 [FINER] org.geotools.data.oracle.SqlStatementEncoder - Creating
sql for Query: mf=100000000 filter=null useMax=true
11516719 [FINER] org.geotools.data.oracle.SqlStatementEncoder - sqlString =
SELECT FID FROM TEST_BOUNDARY WHERE ROWNUM <= 100000000
11516735 [FINE] org.geotools.data.oracle.OracleDataSource - Adding feature:
TEST_BOUNDARY.1590
11516735 [FINE] org.geotools.data.oracle.OracleDataSource - Adding feature:
TEST_BOUNDARY.1591
....
....
....
11517500 [FINE] org.geotools.data.oracle.OracleDataSource - Adding feature:
TEST_BOUNDARY.1738
11517500 [FINE] org.geotools.data.oracle.OracleDataSource - Adding feature:
TEST_BOUNDARY.1739
11518579 [FINE]
org.geotools.data.jdbc.ConnectionPool$ConnectionListManager - Connection
closed - adding to available connections.
11518579 [FINER] org.vfny.geoserver.responses.TransactionResponse - sub
request is TypeName: test_boundary
handle: null
ReleaseAll: true
filter: null
Property - Name: SOURCE, Value: TT
11518594 [FINER] org.geotools.data.DataSourceFinder - Available Data
Sources:
11518594 [FINER] org.geotools.data.DataSourceFinder - PostGIS spatial
database
11518594 [FINER] org.geotools.data.DataSourceFinder - ESRI(tm) Shapefiles
(*.shp)
11518594 [FINER] org.geotools.data.DataSourceFinder - Oracle Spatial
Database
11518594 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting available
connection.
11518782 [FINE] org.geotools.data.oracle.OracleDataSource - Column Name =
FID; Column Type = NUMBER
11518797 [FINE] org.geotools.data.oracle.OracleDataSource - Column Name =
SHAPE; Column Type = SDO_GEOMETRY
Getting geometryAttribute
11518797 [FINER] org.geotools.data.oracle.OracleDataSource - Checking
geometry using: SELECT SHAPE FROM TEST_BOUNDARY WHERE ROWNUM = 1
geom class class com.vividsolutions.jts.geom.MultiLineString
best geom class class com.vividsolutions.jts.geom.MultiLineString
11518813 [FINE] org.geotools.data.oracle.OracleDataSource - Column Name =
OBJECT_ID; Column Type = NUMBER
....
11518829 [FINE] org.geotools.data.oracle.OracleDataSource - Column Name =
SOURCE; Column Type = VARCHAR2
11518844 [FINE]
org.geotools.data.jdbc.ConnectionPool$ConnectionListManager - Connection
closed - adding to available connections.
11518844 [FINER] org.vfny.geoserver.config.TypeInfo - data source is
org.geotools.data.oracle.OracleDataSource@anonymised.com
11518860 [FINER] org.vfny.geoserver.responses.TransactionResponse - metad
is supportsAdd: true
supportsRemove: true
supportsModify: true
supportsSetFeatures: true
supportsRollbacks: true
supportsAbort: false
supportsGetBbox: true
hasFastBbox: true
11518860 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting available
connection.
11518860 [FINE] org.geotools.data.oracle.OracleDataSource - Transaction
connection not open or set to manual commit
11518860 [FINE] org.vfny.geoserver.responses.TransactionResponse - attribut
type is DefaultAttributeType [name=SOURCE , type=class java.lang.String ,
nillable=true], values is TT
11518860 [FINE] org.geotools.data.oracle.OracleDataSource - Transaction
connection not open or set to manual commit
11518860 [FINE] org.geotools.data.oracle.OracleDataSource - Transaction
connection not open or set to manual commit
11518860 [FINE] org.geotools.data.oracle.OracleDataSource - Transaction
connection not open or set to manual commit
11518860 [FINE] org.vfny.geoserver.responses.TransactionResponse -
committing Lock Id: null
release all: true
handle: null
TypeName: test_boundary
handle: null
ReleaseAll: true
filter: null
Property - Name: SOURCE, Value: TT
11518860 [FINE] org.geotools.data.oracle.OracleDataSource - Transaction
connection not open or set to manual commit
11518860 [FINE] org.geotools.data.oracle.OracleDataSource - Closing
Transaction Connection
11518875 [FINE]
org.geotools.data.jdbc.ConnectionPool$ConnectionListManager - Connection
closed - adding to available connections.
11518875 [FINER] org.vfny.geoserver.responses.WfsTransResponse - returning
xml <?xml version="1.0" encoding="UTF-8"?>
<wfs:WFS_TransactionResponse
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://localhost:8080/geoserver/data/capabilities/wfs/1.0.0/WFS-transaction.
xsd">
<wfs:TransactionResult>
<wfs:Status>
<wfs:SUCCESS/>
</wfs:Status>
</wfs:TransactionResult>
</wfs:WFS_TransactionResponse>
----------------------------
end logfile
----------------------------