« Return to Thread: null pointer exception in oracle WFS insert again

null pointer exception in oracle WFS insert again

by Balázs Bámer :: Rate this Message:

Reply to Author | View in Thread

Hi All,

I have exactly the same problem as Zerogeek here:
http://www.nabble.com/null-pointer-exception-in-oracle-WFS-insert-td15340163.html

I use Geoserver 1.7.2. I have 3 tables in the database, one point
type, one multipolygon type, which work fine in MapBender 2.5, even
WFS-T editing etc. However, the third one, which has 2 multipolygon
columns, of which I selected one in Mapbender, fails to insert new
features with the above symptoms.

In the above conversation I just don't understand where the capitals
can come into question, and wherever I looked, everything is
uppercase. Spatial column is KGEOM, which has spatial index:
CREATE INDEX "BALAZS"."IDX_BLOKK_A0_KGEOM" ON "BALAZS"."BLOKK_A0" ("KGEOM")
   INDEXTYPE IS "MDSYS"."SPATIAL_INDEX" PARAMETERS ('layer_gtype=MULTIPOLYGON');

My failing request with some other (not all) log output is

2009-02-19 11:42:08,608 ERROR [geoserver.ows] -
org.geoserver.platform.ServiceException: Could not determine geoserver request f
rom http request GET /geoserver/wfs? HTTP/1.1
User-Agent: Java/1.6.0_10
Host: att-it.homelinux.net:22880
Accept: text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2
Connection: keep-alive
        at org.geoserver.ows.Dispatcher.dispatch(Dispatcher.java:389)
        at org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:20
8)
....
2009-02-19 11:42:08,633 TRACE [geotools.xml] - startElement(http://www.opengis.n
et/wfs,Insert,wfs:Insert
2009-02-19 11:42:08,633 TRACE [geotools.xml] - startElement(http://www.openplans
.org/topp,BLOKK_A0,topp:BLOKK_A0
2009-02-19 11:42:08,634 TRACE [geotools.xml] - startElement(,TAJOL,TAJOL
2009-02-19 11:42:08,634 DEBUG [geotools.xml] - Could not find declaration for: {
http://www.opengis.net/wfs}TAJOL. Checking if containing type declares a single
particle.
[other column also]
2009-02-19 11:42:08,641 TRACE [geotools.xml] - startElement(,KGEOM,KGEOM
2009-02-19 11:42:08,641 DEBUG [geotools.xml] - Could not find declaration for: {
http://www.opengis.net/wfs}KGEOM. Checking if containing type declares a single
particle.
2009-02-19 11:42:08,641 DEBUG [geotools.xml] - Could not find declaration for: {
http://www.opengis.net/wfs}KGEOM. Performing lookup by ignoring namespace
2009-02-19 11:42:08,665 DEBUG [geoserver.wfs] - located FeatureType w/ typeRef '
OracleSpatialThin:BLOKK_A0' and elementName '{http://www.openplans.org/topp}BLOK
K_A0'
2009-02-19 11:42:08,665 DEBUG [geoserver.wfs] - Transasction Insert:net.opengis.
wfs.impl.InsertElementTypeImpl@5de82a (feature: [org.geotools.feature.simple.Sim
pleFeatureImpl@7e354e84], handle: null, idgen: <unset>, inputFormat:
<unset>, srsName: null)
2009-02-19 11:42:08,666 DEBUG [data.jdbc] - getting feature writer for BLOKK_A0:
 typeName = BLOKK_A0 schema: SimpleFeatureTypeImpl http://www.openplans.org/topp
BLOKK_A0 identified extends Feature(KGEOM:KGEOM,ORT2X:ORT2X,MERAR:MERAR,ORT2Y:OR
T2Y,ORT1Y:ORT1Y,TGEOM:TGEOM,ORT1X:ORT1X,BLOAZ:BLOAZ,TAJOL:TAJOL)srids: {KGEOM=23
700, TGEOM=23700}
2009-02-19 11:42:08,666 DEBUG [filter.SQLEncoderOracle] - SQLEncoderOracle: Geom
etric Column is: KGEOM
2009-02-19 11:42:08,669 DEBUG [data.jdbc] - About to execute query: SELECT "SORS
ZAM", "BLOAZ", "TAJOL", "MERAR", "ORT1X", "ORT1Y", "ORT2X", "ORT2Y", "KGEOM", "T
GEOM" FROM "BLOKK_A0" WHERE '1' = '0'
2009-02-19 11:42:08,701 INFO [geoserver.wfs] -
Request: transaction
        handle = null
        service = WFS
        version = 1.0.0
        baseUrl = http://att-it.homelinux.net:80/geoserver/
        providedVersion = 1.0.0
        lockId = null
        group =
[wfs:insert=net.opengis.wfs.impl.InsertElementTypeImpl@5de82a
(feature: [org.geotools.feature.simple.SimpleFeatureImpl@7e354e84],
handle: null, idgen: <unset>, inputFormat: <unset>, srsName: null)]
        insert = [net.opengis.wfs.impl.InsertElementTypeImpl@5de82a
(feature: [org.geotools.feature.simple.SimpleFeatureImpl@7e354e84],
handle: null, idgen: <unset>, inputFormat: <unset>, srsName: null)]
        update = []
        delete = []
        native = []
        releaseAction = ALL

What can be the problem?

Thank you in advance.
Best regards: Balázs Bámer

------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Geoserver-users mailing list
Geoserver-users@...
https://lists.sourceforge.net/lists/listinfo/geoserver-users

 « Return to Thread: null pointer exception in oracle WFS insert again